Job added in hotlist
Applied job
Contract job
Recruiter job
Employer job
Expanded search
Apply online not available
View more jobs in Boston, MA
View more jobs in Massachusetts
View Similar Jobs

Job Details

ETL Developer

Boston, MA

Apply for this job


Job Description
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.
Key Responsibilities:
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)

Company info

Sign Up Now -

Similar Jobs:
Data Modeler
Location : Boston, MA
Job Description: JOB DESCRIPTION The Data Modeler builds data models that describe data and its relationships in a consistent way to support business and technical objectives. MAJOR RESPONSIBILITIES * Develop conceptual/subject ar...
Reporting Analyst
Location : Boston, MA
(30302) Reporting Analyst; 6 months; Boston MA We are seeking an experienced SQL Server Data Reporting Analyst to utilize program development series or other technical tools (SQL; business objects). Duties include: Workin...
Software developer
Location : Waltham, MA
Job Title Software developer Location(s) Waltham PerkinElmer is hiring! Overview PerkinElmer is a global technology leader driving growth and innovation in the Human and Environmental Health markets to improve...
I found a new job! Thanks for your help.
Thomas B - ,
  • All we do is research jobs.
  • Our team of researchers, programmers, and analysts find you jobs from over 1,000 career pages and other sources
  • Our members get more interviews and jobs than people who use "public job boards"
Shoot for the moon. Even if you miss it, you will land among the stars.
SQLCrossing - #1 Job Aggregation and Private Job-Opening Research Service — The Most Quality Jobs Anywhere
SQLCrossing is the first job consolidation service in the employment industry to seek to include every job that exists in the world.
Copyright © 2018 SQLCrossing - All rights reserved. 21