Systems Analyst 3

Job Title: Systems Analyst 3 Location: Austin, TX (Hybrid - 4 days remote, 1 day on-site on Tuesdays) Type: Full-Time Contract Duration: December 2, 2024 - August 29, 2025 Schedule: Monday to Friday, 8:00 AM - 5:00 PM Position Overview: Our client seeks an experienced Systems Analyst 3 to lead the design, development, and implementation of a data integration hub. This role involves working within an agile environment to support ETL processes, data warehousing, and business intelligence solutions, with a significant focus on automation, cloud infrastructure, and performance metric validation. Key Responsibilities: Lead the implementation and configuration of infrastructure for the data integration hub. Participate in all phases of the Software Development Lifecycle (SDLC), including: Performance metric validation. Epic/User Story/Task creation. Data acquisition automation from various sources. Complex SQL script development. Testing, including integration, load, and stress testing. Internal and external data deployment. Support ongoing operations and enhancements for the data integration hub, including: ETL administration focused on data warehousing and business intelligence. Informatica IICS Administration (installation, upgrades, maintenance). Power Exchange Change Data Capture (CDC) on PowerCenter and IICS. CI/CD tools (GitHub, Jenkins). Automation in administration using Python and shell scripting. Triage and resolve production issues. Design, develop, and deploy ETL pipelines using Informatica and IICS. Handle various data sources (relational databases, flat files, cloud platforms). Manage data quality, validation, and data migration projects. Qualifications: Required Experience 8 years: ETL administration, Informatica IICS, Power Exchange CDC, cloud-based CI/CD tools (GitHub, Jenkins), and automation using Python and shell scripting. 8 years: Analytical skills for production issue resolution. 8 years: ETL pipeline design, development, and deployment with Informatica and IICS. 8 years: Experience with relational databases (Oracle, SQL Server, MySQL, Snowflake), flat files, cloud platforms (AWS S3, Azure Blob), and data quality/migration projects. 8 years: Linux/Unix experience, technical writing and diagramming (Visio, Erwin), Microsoft Office Suite, and MS Project. 8 years: Agile methodology, experience with JIRA, team collaboration, and prioritization. 8 years: Proficiency in SQL, Python, Bash, data warehousing, data quality frameworks, and cloud ecosystems (AWS, Azure, GCP). Preferred Experience 6 years: Software development using best practices. 4 years: Understanding of security principles for healthcare data, data visualization/business intelligence. 4 years: Communication skills, multi-responsibility management. Bachelor's degree in Computer Science, Information Systems, Business, or equivalent experience. 3 years: Healthcare industry experience. 2 years: HHS agency experience, PII/PHI data handling, and Azure familiarity.