Build, develop, and manage a SQL Server relational database using data
warehousing best practices.
Provide
onsite development including responsibility for the day-to-day performance,
maintenance, and monitoring of the Data Warehouse system and its technical
interfaces.
Design architecture,
map business rules and processes into technical solutions.
Designing and leading the development of
production SQL and database changes as well as assistance with the design of
efficient database and storage structures.
Perform analysis, development, and
evaluation of data mining in a data warehouse environment that includes data
design, database architecture, metadata, and repository creation.
Hands-on ETL development and Review ETL
load jobs for consistency and quality.
Provide ETL design, development and
testing estimations based business
requirements and research into data that
is currently sourced.
Design of
views, data mart solutions , and cubes.
Implement Data Management strategies
which include validation of source data and the use of data in management
reporting.
Develop design
specifications, unit test plans, and troubleshoot client issues. Work with a
diverse project team with an emphasis on repeatable processes and technical
documentation
Perform hands-on
design, development and testing within the ETL tool environment using a mixture
of GUI driven tools and hands-on SQL Analyze, design and implement User
Interface (reports and dashboards)
Educate client management and business
users on business value and capabilities of data warehousing and business
intelligence Provide advice and guidance on data warehousing approaches and
solutions,
and use of data
warehousing methodology Assist in identifying and prioritizing business
information needs, and defining business benefit of data warehousing Assist in
evaluating and selecting data warehousing tools for business
intelligence, data population, data
management, metadata management, and warehouse administration Responsible for
supporting the architecture and design of the data warehouse, data marts and BI
reports which will support various data
initiatives Performs table and interface
design, development of logical and physical data model/database, ETL processes,
BI reporting/OLAP cubes/OLAP reporting, and population and tuning of
databases/ETL processes/BI reports/queries
while meeting business/user
requirements
Requirements:
SQL Server 2008
R2 (2008 is acceptable)
Experience
with healthcare claims system (mainframe preferred)
Experience with SSIS
Language C would be nice to have
Self-Starter a must
Ability to work alone and in a team
(collaborative) capacity a must
Agile