Job Description
Job Description
Position : Applications Developer
Duration : 6 months
Location : Hybrid - Local candidates only (QUINCY, MA)
JOB OVERVIEW :
The Applications Developer will be responsible for providing analytical support for the conceptualization, development, and implementation of complex systems of multiple inter-linked programs.
This role requires in-depth knowledge of all phases of client / server applications technology, including analysis, design, coding, debugging, testing, and documentation of computer programs.
The ideal candidate will have broad experience in programming graphical user interfaces (GUI), extensive knowledge and skill with object-oriented programming, relational database structures, and cloud engineering.
Additionally, the Applications Developer may act as a team or project leader on major applications projects, demonstrating confidence, creativity, and keen problem-solving abilities.
Work Location : Quincy, Massachusetts 02171
Work Schedule : Monday through Friday, 8 : 00 AM to 4 : 00 PM EST
Work Model : Hybrid (combining in-office 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.
- Mentor other technical staff in cloud technologies at all levels of understanding and adjust the message accordingly.
- Assist in identifying, planning, and migration of on-premises data solutions suitable for migration to the cloud.
- Code Oracle, Snowflake, or IICS ETL scripts to transform data from an operational database and populate various targets.
- Document design using industry standards.
- Monitor and optimize data processing and storage performance within cloud environments, including 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.
- Understanding of 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.
- 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 Architect preferred.
- Snowflake Certification preferred.
- Informatica IICS Certification preferred.