Senior Data Engineer

Job Description

Job Description

ASSYST is seeking a Senior Data Engineer to support our client project in Austin, TX.

Work mode: Hybrid

Position will be 2 days remote with 3 days (Tues & Wed & Fri) required to be onsite.

Project Overview:

Implementation and configuration of the infrastructure for the data integration hub

Design, development, and implementation (DD&I) of the hub using Agile methodology across all SDLC phases, including:

• Validation of performance metric requirements
• Creation of Epics, User Stories, and Tasks
• Automation of data acquisition from multiple data sources
• Development of complex SQL scripts
• Integration, load, and stress testing
• Deployment and publication internally and externally
• Ongoing operations support and enhancements for the data integration hub
• This effort will follow the Agile methodology currently used by the client for PMAS development.

Responsibilities:

• Serve as a technical leader guiding an Agile development team through project delivery.
• Acquire and integrate data from multiple data sources for analytics and reporting purposes.
• Develop complex and optimized SQL scripts to transform source data into dimensional models, including creation of Oracle views and materialized views.
• Develop ETL mappings and workflows using Informatica PowerCenter/IICS for data extraction, transformation, and loading.
• Collaborate with Architects and Data Engineering teams to design and implement optimal data solutions and acquisition strategies.
• Validate and verify SQL scripts, ETL workflows, and database objects through automated testing approaches.
• Participate in sprint ceremonies, requirements gathering, and design sessions.
• Develop mockups and collaborate with stakeholders for validation and feedback.
• Troubleshoot and resolve technical issues with cross-functional teams.
• Assist with implementation and configuration of development tools.
• Produce and maintain technical documentation, specifications, and diagrams to support DD&I efforts.
• Analyze changing business requirements and recommend enhancements to meet evolving needs.

Required Experience:

• Experience developing ETL mappings and workflows using Informatica PowerCenter or Informatica Intelligent Cloud Services (IICS).
• Experience integrating data from multiple source systems including Oracle, SQL Server, Excel, Access, and Adobe PDF for Tableau reporting and analytics solutions.
• Strong experience designing and developing efficient Snowflake SQL scripts.
• Strong analytical and problem-solving skills with experience supporting data analytics, performance management, or data warehousing projects.
• Experience with technical documentation, data modeling, and diagramming tools such as Visio and Erwin.
• Proficiency with Microsoft Office Suite and MS Project.
• Experience planning and delivering software platforms across multiple organizational units.
• Proven ability to develop efficient, testable, and maintainable code using software development best practices.

Preferred Experience:

• Strong verbal and written communication skills.
• Experience working in Agile sprint teams.
• Knowledge of security principles related to healthcare, PII, and PHI data.
• Experience with business intelligence and performance metrics visualization environments.
• Prior experience in healthcare.
• Experience developing scripts using Python.
• Experience with JIRA.
• Knowledge of REST/SOAP web services.
• Experience with Java and JavaScript development.
• Experience building CI/CD pipelines using GitHub and GitHub Actions.
• Experience with MuleSoft development.
• Experience using AI-enabled tools such as Snowflake Cortex/Intelligence or Informatica Claire.
• Bachelor's degree in Computer Science, Information Systems, Business, or equivalent experience.

ASSYST is an Equal Opportunity Employer. Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, disability, military status, national origin or any other characteristic protected under federal, state, or applicable local law