Systems Analyst 3 - Data Integration / ETL / Analytics - 26-06253
Navitas, Inc.
Round Rock, United States of America
3 days ago
Role details
Contract type
Temporary contract Employment type
Full-time (> 32 hours) Working hours
Regular working hours Languages
English Experience level
SeniorJob location
Round Rock, United States of America
Tech stack
Microsoft Access
Java
JavaScript
Microsoft Excel
Adobe Acrobat
Agile Methodologies
Artificial Intelligence
Data analysis
Computing Platforms
ARM
JIRA
Health Informatics
Continuous Integration
Information Engineering
Data Integration
ETL
Data Warehousing
Dimensional Modeling
Github
Systems Analysis
Microsoft Visio
Microsoft SQL Server
Oracle Applications
Scrum
Scripting (Bash/Python/Go/Ruby)
Enterprise Software Applications
Snowflake
SOAPAPI
Mulesoft
Job description
The client is seeking an experienced Systems Analyst / Data Engineering professional to support the continued development of a Data Integration Hub within the Performance Management & Analytics System (PMAS) environment.
This role focuses heavily on:
- ETL development using Informatica Power Center / IICS
- Advanced Snowflake SQL
- Data integration and dimensional modeling
- Agile-based data engineering initiatives
- Healthcare analytics and performance management systems
The consultant will collaborate closely with architects, data engineers, and business stakeholders to design, build, test, and support scalable analytics solutions.
Core Responsibilities
- Build and maintain ETL mappings/workflows using Informatica Power Center or IICS
- Develop advanced Snowflake SQL scripts, views, and materialized views
- Integrate data from:
- Oracle
- SQL Server
- Excel
- Access
- Adobe PDF
- Support data warehouse and dimensional model development
- Participate in Agile sprint ceremonies
- Create epics, user stories, and technical documentation
- Perform integration, load, and stress testing
- Develop automation for validation and verification
- Collaborate on data acquisition and architecture strategies
- Support deployments and ongoing operational enhancements
- Produce mockups and technical specifications, * Agile/Scrum experience
- Healthcare/HHS experience
- Experience with PHI/PII data
- Python scripting
- JIRA
- REST/SOAP web services
- Java / JavaScript
- GitHub Actions / CI-CD pipelines
- MuleSoft
- AI tools such as:
- Snowflake Cortex
- Informatica Claire
Requirements
Do you have experience in Technical writing within technology?, * Informatica Power Center or IICS ETL development
- Data integration from multiple source systems
- Snowflake SQL development
- Systems analysis for analytics/data warehousing projects
- Technical documentation and diagramming (Visio, Erwin)
- Software platform delivery across enterprise systems
- Writing efficient, testable code