13982 - Data Integration Analyst (onsite) – Austin, TX
Start Date: ASAP
Type: Temporary Project
Estimated Duration: 12 months with possible extensions
Work Setting: 100% of the time at the Client’s site. No telecommuting or remote work. This is a non-negotiable requirement from the client.
Required:
• Availability to work 100% of the time at the Client’s site in Austin, TX (required);
• Experience developing mappings and workflows to automate ETL processes using Informatica Power Center or IICS (8 years);
• Experience acquiring and integrating data from multiple data sources/technologies using Informatica Power Center or IICS for use by a Tableau data visualization object, including Oracle, SQL Server, Excel, Access and Adobe PDF (8 years);
• Experience designing and developing complex Oracle and/or Snowflake SQL scripts that are fast and efficient (8 years);
• Experience as a system analyst for a data analytics, performance management system, or data warehousing project (8 years);
• Experience in Technical writing and diagraming, including proficiency with modeling and mapping tools (e.g., Visio, Erwin), and the Microsoft Office Suite (Word, Excel, and PowerPoint) and MS Project (8 years);
• Experience in planning and delivering software platforms used across multiple products and organizational units (8 years);
• Experience writing well designed, testable, efficient code by using best software development practices (8 years).
Preferred:
• Excellent oral and written communication skills (6 years);
• Experience managing multiple responsibilities, prioritize conflicting assignments, and switch quickly between assignments, as required (6 years);
• Experience on an agile sprint team (4 years);
• Experience with security principles and how they apply to healthcare data (4 years);
• Experience with state of the art software components for a performance metrics data visualization or business intelligence environment (4 years);
• Bachelor’s degree in Computer Science, Information Systems, or Business or equivalent experience (4 years);
• Experience in the Healthcare Industry (4 years);
• Experience with an HHS agency (4 years);
• Experience working with PII or PHI data (4 years);
• Experience designing and developing scripts using Python (4 years);
• Experience with JIRA software (4 years);
• Hands-on design experience with Web Services (REST, SOAP, etc.) (2 years);
• Experience designing and developing code using Java and JavaScript (2 years);
• Experience developing CI/CD pipelines with GitHub and Git Actions (2 years);
• Experience as a Mulesoft developer (2 years);
• Experience developing code in C# (2 years).
Responsibilities:
• Understand business objectives, evaluate alternative solutions through cost/benefit analysis, and assess system capabilities to recommend feasible improvements or automation strategies;
• Collaborate with organizational personnel to analyze current procedures, identify system issues, and document user needs and functional requirements for system development or modification;
• Serve as a technical leader within an Agile team, guiding project execution and participating in sprint ceremonies to ensure alignment with business goals;
• Collect data from various internal and external sources to support diverse analytical and operational needs;
• Create complex SQL scripts to transform data into dimensional models, and build Oracle views and materialized views for efficient data access;
• Use Informatica PowerCenter/IICS to automate data extraction, transformation, and loading processes tailored to dimensional modeling requirements;
• Verify and validate SQL scripts and automation workflows; develop automated methods to maintain high data quality and process reliability.