.. the largest community health care system between Worcester and Boston. MetroWest Medical Center is committed to providing high quality, comprehensive care, at a location close to home. The 307-bed regional healthcare system includes Framingham Union Hospital, Leonard Morse Hospital in Natick and the .. read more
Position: ETL Developer
Location: Remote
Term: 6 Mo.
Job Description:
The Application Developer develops and implements technical solutions. This role leverages technical expertise in database applications, ETL processes, and automation in support of internal and external customer's data exchange and integration needs.
Responsibilities:
Develop complex data extracts, applications, and ad-hoc queries as requested by internal and external customers using SQL, SSIS, Informatica, and .NET technologies.
Requests include custom flat files, EDI, user applications, and a significant focus on healthcare encounters and HIPAA X12 transactions: 837, 999, 277, 835.
Maintain the production Business Intelligence products and solutions, including resolving production issues and responding quickly to priority problems.
Research, troubleshoot, and resolve data issues impacting extract delivery.
Work closely with Business Systems Analysts to understand requirements regarding solutions, ensure data quality and match-back to core systems transaction results.
Collaborate on the definition, development, and maintenance of standards and processes.
Drive continuous improvement and automation in BI solutions and processes.
Serve as mentoring resource for other developers.
Support our goals and objectives by working closely with management team to deliver value to the business.
Other duties as needed or required.
Required:
BS degree in Business, Computer Science, Engineering, Information Systems or related field (or equivalent experience).
4 years as a Developer, Data Analyst, or equivalent implementing technical solutions (extracts, middleware, stored procedures, EDI, ETL packages).
Experience with SQL Server,
Transact SQL and SQL Server Integration Services (SSIS), C#, XML, and Informatica.
Managed file transfer automation experience: FTP, SFTP, PGP.
Expert knowledge of relational database applications and data query protocols (MS Access, SQL Server, Structured Query Language, SQL Reporting Services).
Demonstrated ability to drive to deadlines, balancing multiple priorities, and ensuring quality standards.
Excellent analytical, problem-solving, and innovative thinking skills.
Required Skills : ETL Developer SQL / TSQL / SSIS FTP/SFTP RDB applications and data query
Basic Qualification :
Additional Skills :
Background Check :Yes
Drug Screen :Yes
Notes :
Selling points for candidate :
Project Verification Info :
Candidate must be your W2 Employee :No
Exclusive to Apex :No
Face to face interview required :No
Candidate must be local :No
Candidate must be authorized to work without sponsorship ::No
Interview times set : :No
Type of project :Development/Engineering
Master Job Title :Dev: SQL Server Database
Branch Code :Boston
Location: Remote
Term: 6 Mo.
Job Description:
The Application Developer develops and implements technical solutions. This role leverages technical expertise in database applications, ETL processes, and automation in support of internal and external customer's data exchange and integration needs.
Responsibilities:
Develop complex data extracts, applications, and ad-hoc queries as requested by internal and external customers using SQL, SSIS, Informatica, and .NET technologies.
Requests include custom flat files, EDI, user applications, and a significant focus on healthcare encounters and HIPAA X12 transactions: 837, 999, 277, 835.
Maintain the production Business Intelligence products and solutions, including resolving production issues and responding quickly to priority problems.
Research, troubleshoot, and resolve data issues impacting extract delivery.
Work closely with Business Systems Analysts to understand requirements regarding solutions, ensure data quality and match-back to core systems transaction results.
Collaborate on the definition, development, and maintenance of standards and processes.
Drive continuous improvement and automation in BI solutions and processes.
Serve as mentoring resource for other developers.
Support our goals and objectives by working closely with management team to deliver value to the business.
Other duties as needed or required.
Required:
BS degree in Business, Computer Science, Engineering, Information Systems or related field (or equivalent experience).
4 years as a Developer, Data Analyst, or equivalent implementing technical solutions (extracts, middleware, stored procedures, EDI, ETL packages).
Experience with SQL Server,
Transact SQL and SQL Server Integration Services (SSIS), C#, XML, and Informatica.
Managed file transfer automation experience: FTP, SFTP, PGP.
Expert knowledge of relational database applications and data query protocols (MS Access, SQL Server, Structured Query Language, SQL Reporting Services).
Demonstrated ability to drive to deadlines, balancing multiple priorities, and ensuring quality standards.
Excellent analytical, problem-solving, and innovative thinking skills.
Required Skills : ETL Developer SQL / TSQL / SSIS FTP/SFTP RDB applications and data query
Basic Qualification :
Additional Skills :
Background Check :Yes
Drug Screen :Yes
Notes :
Selling points for candidate :
Project Verification Info :
Candidate must be your W2 Employee :No
Exclusive to Apex :No
Face to face interview required :No
Candidate must be local :No
Candidate must be authorized to work without sponsorship ::No
Interview times set : :No
Type of project :Development/Engineering
Master Job Title :Dev: SQL Server Database
Branch Code :Boston