Description

You will design and automate ETL processes and data workflows to support analytics and visualization platforms.

This role is on-site.

Responsibilities

• Develop mappings and workflows using Informatica Power Center or IICS to automate ETL processes.
• Acquire and integrate data from Oracle, SQL Server, Excel, Access, and Adobe PDF sources for Tableau visualization.
• Design and write efficient, complex Snowflake SQL scripts for data warehousing and performance management.
• Create technical diagrams and documentation using Visio, Erwin, and the Microsoft Office Suite.
• Plan and deliver software platforms across multiple organizational units using Agile sprint practices.

Required Skills

• 5+ years of experience as a Systems Analyst in data warehousing or analytics projects.
• Proficiency in Informatica Power Center or IICS for ETL development.
• Strong Snowflake SQL scripting skills for high-performance queries.
• Experience with data integration from Oracle, SQL Server, and file-based sources.
• Technical writing and diagramming skills using Visio, Erwin, MS Project, and Office.
• Understanding of security principles, specifically regarding PII/PHI data.

Preferred Skills

• Hands-on experience with Java, JavaScript, Python, and Web Services (REST/SOAP).
• Familiarity with CI/CD pipelines using GitHub Actions and JIRA.
• Experience with MuleSoft, AI tools (Snowflake Cortex/Informatica Claire), or healthcare/HHS agency domains.

Key Skills

Education

Bachelor's degree