Application Developer (SQL/AWS) - Apex Systems

Job#: 2033454

Job Description:

Apex has an opportunity based in BOSTON . This is a 6+ month contract position and the pay rate is flexible depending on experience. Here are the details:                        
 For applicants who are interested in the Applications Developer Opportunity; please send a Word resume to Fred OBrien, Technical Recruiter, at[email protected]
Title: Senior Applications Developer  
Location: On site / Hybrid in Boston
Apex Job ID: 2033454
Rate: Negotiable based upon experience
Duration: 6+ month contract
APPLICATIONS DEVELOPER
PROGRAM OVERVIEW:
The Executive Office of Health and Human Services (EOHHS) provides services that directly touch the lives of slightly more than 1 in 4 residents in the Commonwealth. Some of our most vulnerable citizens, including children, youth, adults, and the elderly are served by The Executive Office of Health and Human Services. EOHHS is the largest secretariat in state government and is comprised of 12 agencies, in addition to 2 soldiers’ homes and the MassHealth program. The Commonwealth of Massachusetts’ Executive Office of Health and Human Services is currently seeking an exceptional individual to join the EHS IT team. This is an exciting opportunity to join a highly skilled team and contribute to critical and highly visible projects and processes within the Executive Office of Health and Human Services.
JOB OVERVIEW:
As a member of the Executive Office of Health and Human Services Enterprise Data Management & Engineering, the Applications Developer will be responsible for providing analytical support for conceptualization, development, and implementation of complex systems of multiple inter-linked programs. In-depth knowledge of all phases of client/server applications technology. Responsible for the analysis, design, coding, debugging, testing and documentation of computer programs. Broad experience in programming graphical user interfaces (GUI). Extensive knowledge and skill with object-oriented programming, relational database structures and cloud engineering. May also act as team or project leader on major applications projects. The ideal candidate must demonstrate confidence, creativity, and keen problem-solving abilities. The primary work location for this role will be 100 Hancock Street, Quincy, Massachusetts 02171. The work schedule for this position is Monday through Friday, 8:00AM to 4:00PM EST. This position would be expected to follow a hybrid model of reporting to work that combines inoffice workdays and work from home days as needed.
DETAILED LIST OF JOB DUTIES AND RESPONSIBILITIES:
 

• Understand and translate business requirements into Data Warehouse solutions.
• Create data models and designs to meet specific business needs that require sourcing data from multiple source systems.
• Has the ability to mentor other technical staff in cloud technologies at all levels of understanding and can adjust the message accordingly.
• Assists in identifying, planning, and migration of on-premises data solutions suitable for migration to the cloud.
• Code Oracle, Snowflake or IICS ETL scripts that will transform data from an operational database and populate to various targets.
• Document design using industry standards.
• Capable of monitoring and optimizing data processing and storage performance with cloud environments. This includes identifying bottlenecks, tuning and optimizing queries, and recommending architectural changes to improve efficiency.
• Provide query writing support and tuning expertise to analysts and end users.
• Develop shell/Python scripts for production job automation.
• Work in a 24x7 environment which requires on-call rotation.

Preferred Knowledge, Skills & Abilities:
 

• 5+ years of experience in database development including analyzing, designing, documenting, coding, testing, and implementing primarily SQL code.
• Thorough knowledge of Data Warehouse applications on AWS.
• Experience working with Airflow.
• Exceptional Oracle/Snowflake SQL skills
• Hands on experience with Cloud architectures.
• Strong problem solving and analytical skills.
• Proficiency in Informatica IICS
• Understand the concepts of version control and use of GitHub.
• Experience working with a large, multi-terabyte data warehouse.
• BS in Computer Science or related degree, or equivalent experience
• Medicaid or other healthcare or claims processing experience
• Experienced in Oracle SQL skills and PL/SQL skills.
• Experience with Perl, system administration, database administration, storage architectures, backup & recovery, and networking.

Education and Certifications:
 

• BS in Computer Science, Information Technology or an equivalent combination of education and work experience required.
• Amazon Web Services (AWS) Cloud Certification and AWS Certified Solutions Preferred
• Snowflake Certification Preferred
• Informatica IICS Certification Preferred

APPLICATIONS DEVELOPER
PROGRAM OVERVIEW:
The Executive Office of Health and Human Services (EOHHS) provides services that directly touch the lives of slightly more than 1 in 4 residents in the Commonwealth. Some of our most vulnerable citizens, including children, youth, adults, and the elderly are served by The Executive Office of Health and Human Services. EOHHS is the largest secretariat in state government and is comprised of 12 agencies, in addition to 2 soldiers’ homes and the MassHealth program. The Commonwealth of Massachusetts’ Executive Office of Health and Human Services is currently seeking an exceptional individual to join the EHS IT team. This is an exciting opportunity to join a highly skilled team and contribute to critical and highly visible projects and processes within the Executive Office of Health and Human Services.
JOB OVERVIEW:
As a member of the Executive Office of Health and Human Services Enterprise Data Management & Engineering, the Applications Developer will be responsible for providing analytical support for conceptualization, development, and implementation of complex systems of multiple inter-linked programs. In-depth knowledge of all phases of client/server applications technology. Responsible for the analysis, design, coding, debugging, testing and documentation of computer programs. Broad experience in programming graphical user interfaces (GUI). Extensive knowledge and skill with object-oriented programming, relational database structures and cloud engineering. May also act as team or project leader on major applications projects. The ideal candidate must demonstrate confidence, creativity, and keen problem-solving abilities. The primary work location for this role will be 100 Hancock Street, Quincy, Massachusetts 02171. The work schedule for this position is Monday through Friday, 8:00AM to 4:00PM EST. This position would be expected to follow a hybrid model of reporting to work that combines inoffice workdays and work from home days as needed.
DETAILED LIST OF JOB DUTIES AND RESPONSIBILITIES:
 

• Understand and translate business requirements into Data Warehouse solutions.
• Create data models and designs to meet specific business needs that require sourcing data from multiple source systems.
• Has the ability to mentor other technical staff in cloud technologies at all levels of understanding and can adjust the message accordingly.
• Assists in identifying, planning, and migration of on-premises data solutions suitable for migration to the cloud.
• Code Oracle, Snowflake or IICS ETL scripts that will transform data from an operational database and populate to various targets.
• Document design using industry standards.
• Capable of monitoring and optimizing data processing and storage performance with cloud environments. This includes identifying bottlenecks, tuning and optimizing queries, and recommending architectural changes to improve efficiency.
• Provide query writing support and tuning expertise to analysts and end users.
• Develop shell/Python scripts for production job automation.
• Work in a 24x7 environment which requires on-call rotation.

Preferred Knowledge, Skills & Abilities:
 

• 5+ years of experience in database development including analyzing, designing, documenting, coding, testing, and implementing primarily SQL code.
• Thorough knowledge of Data Warehouse applications on AWS.
• Experience working with Airflow.
• Exceptional Oracle/Snowflake SQL skills
• Hands on experience with Cloud architectures.
• Strong problem solving and analytical skills.
• Proficiency in Informatica IICS
• Understand the concepts of version control and use of GitHub.
• Experience working with a large, multi-terabyte data warehouse.
• BS in Computer Science or related degree, or equivalent experience
• Medicaid or other healthcare or claims processing experience
• Experienced in Oracle SQL skills and PL/SQL skills.
• Experience with Perl, system administration, database administration, storage architectures, backup & recovery, and networking.

Education and Certifications:
 

• BS in Computer Science, Information Technology or an equivalent combination of education and work experience required.
• Amazon Web Services (AWS) Cloud Certification and AWS Certified Solutions Preferred
• Snowflake Certification Preferred
• Informatica IICS Certification Preferred

 

 

 

 

 

 

 

 

EEO Employer

Apex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at [email protected] or 844-463-6178.