ETL Developer (SQL Server) HealthHelp, Inc.
At HealthHelp, you?ll find a fast-paced, technically challenging work environment. We are seeking a hands-on (SQL Server) Senior ETL developer to be personally responsible for the day-to-day operations of loading the data files received from our clients to operational system and to ensure that the routine data loads are occurring on schedule and also responsible for detailed technical analysis to assure the availability and accuracy of data processed by ETL. You will work within our data team to help maintain and enhance our ETL architecture, operational systems environment, and will assist in the implementation of cutting-edge database technologies within the development and support of HealthHelp Data Warehouse, and operational system. You will also be responsible for meeting with other department staffs and data team members to assist with, and define, the data and SSIS package requirements for new clients.
The right candidate will have strong SQL Server 2012/2008 programming experience with 5+ years of extensive experience in SSIS/ETL development and maintenance. OLAP development (cube design, fact, dimension structure, Data Mart development, etc) experience will be a big plus. The candidate must also be willing to perform after-hours and weekend work as many data loads can not be performed during business hours.
Ability to build, test, and maintain ETL architecture and processes using strong modular system design skills
Create, modify, document, and enhance data specifications including identifying and mapping data elements from source systems into the dimensional data warehouse and operational system; Validate that the operational system and data warehouse meets specified requirements
Work with other members of the team and make sure that routine data loads are completed properly without any issues and report weekly load status to supervisor.
Ability to work independently on routine data loads with a minimal amount of supervision.
Analyze and QA data from different sources and ensure that it is properly loaded into our systems
Investigate data quality issues and implement appropriate solutions
Responsible for performance tuning of database functions, SQL queries, stored procedures and SSIS packages to ensure scalability demands are satisfied and will be responsible for monitoring the production jobs, and other database activities (Backups, recovery, etc),
Ability to manage individual priorities and tasks and coordinates with other team members and supervisor to meet such timelines and actively contributes to project status reporting processes to identify and mitigate risks.
Knowledge of health system functions, terminology and standard coding systems preferred.
Provide after business hours and weekend data operations support as needed.
Experience with relational database systems in an operational environment and particularly with Microsoft SQL Server.
Strong experience in extraction, transformation, and load processes from multiple source format files and systems into operational systems into the data warehouse.
Knowledge of dimensional data modeling, star schemas & cube development using SQL Server Analysis Services is a big plus, not must.
Excellent work ethic, organizational, analytical, planning, problem solving, and communication skills are must
Must be authorized to work in the United States on a full-time basis for any employer
Minimum 5 + years of extensive experience in SQL Server Integration Services (SSIS) and ETL design and development & T-SQL programming using SQL Server 2012/2008/2005.
Houston, Texas, United States
||Houston, TX |