The following job description is for the 6 12 months contract position of MS SQL Server ETL Developer - Senior for the Department of Public Health - Office of Data Management and Outcomes Assessment.
The project involves rebuilding a large, complex clinical and administrative database. This database holds the Center for Health Information and Analysis (CHIA) Case Mix data, which includes all hospitalizations (HDD), outpatient observations (OP), and emergency department (ED) visits across Massachusetts from the late 1980s to present. This database needs to be restructured to align with business needs.
Database Security and Minimal Access: Ensuring the database limits access and complies with state, federal, and MDPH guidelines, regulations, and laws are essential. In addition, this will involve the creation of user-based access levels within MDPH.
Functional Title: MS SQL Server ETL Developer Senior
The Senior ETL Developer shall work closely with the DPH IT and Business teams and will be responsible for the proper re-design, development, documentation, support, maintenance and enhancements to the current database and application environments. The Senior ETL developer is also responsible for ensuring high availability of all related business applications through the strict adherence to all processes, ensuring proper confidentiality of data, security, quality assurance, change management, organizational management and release management practices.
Review the current database architecture, re-design & develop the new database to improve the efficiency, usability and streamline the data import and export processes.
Develop advanced T-SQL code for implementing application business logic using stored procedures, views, and functions.
Document specific requirements for data integration, including file format, fields, etc.
Develop ETL processes for the import and export of data between the DPH internal systems using SQL Server Integration Services and advanced T-SQL to include stored procedures, user-defined functions, views, etc.
Assist in the Creation and Analysis of optimized stored procedures for data pulls for reports/exports.
Develop data warehouse objects and processes for the purpose of supporting business intelligence, including ETL, fact/dimension tables, and cubes.
Experience and Skills:
Experience with SQL Server databases and their native utilities (Query Analyzer, Analytical Workbench, Etc.)
Advanced SQL query-writing skills, Linux/Unix scripting, and automated job scheduling.
Experience in ETL Development using standard tools like SSIS, SSAS, or other open source ETL tools.
Knowledge of file and file transmission protocols (SFTP, Web Services, etc.).
Strong knowledge of networking protocols and ODBC, JDBC connectivity as it relates to user based connectivity.
Knowledge of applications security including authentication and role based access control within the DB.
Robust data modeling and database design experience.
Minimum 8 years of experience in developing TSQL code, and install/implement on production environments.
5 years of experience in database architecture and administration, SQL tuning, expdp/impdp, SQL loader, Erwin/Data modeler, OEM and ADDM/AWR generation.
5 Years of experience in implementing complex ETL processes.
3 years of experience in database parameter tuning, data guard and golden gate.
Bachelors degree or equivalent work experience is required.
Experience in developing MySQL, Oracle, NoSQL (MongoDB, Cassandra etc.) database is a plus.
Experis is an Equal Opportunity Employer (EOE/AA)