Systems Analyst 3

at  Bickham Services Unlimited LLC

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.

• 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