Systems Analyst 3
Summary:
Join our team as a Systems Analyst to lead enterprise data integration and cloud-based analytics initiatives using Informatica Intelligent Cloud Services (IICS) and Snowflake. This role supports end-to-end design, development, and optimization of high-transaction systems with a focus on data governance, quality, and compliance with HIPAA standards. You'll collaborate with cross-functional teams to deliver scalable ETL solutions, optimize SQL queries, and enhance cloud data infrastructure on Azure. Ideal for experienced professionals skilled in Informatica PowerCenter, Python, and data modeling, this hybrid role combines technical leadership, system analysis, and solution delivery in a highly collaborative healthcare data environment.
 
DESCRIPTION OF SERVICES
Texas Health and Human Services Commission requires the services of 1 Systems Analyst 3, hereafter referred to as Candidate(s), who meets the general qualifications of Systems Analyst 3, Applications/Software Development and the specifications outlined in this document for the Texas Health and Human Services Commission.

All work products resulting from the project shall be considered "works made for hire" and are the property of the Texas Health and Human Services Commission  and may include pre-selection requirements that potential Vendors (and their Candidates) submit to and satisfy criminal background checks as authorized by Texas law. Texas Health and Human Services Commission will pay no fees for interviews or discussions, which occur during the process of selecting a Candidate(s).

 

Level Description

8 or more years of experience, relies on experience and judgment to plan and accomplish goals, independently performs a variety of complicated tasks, a wide degree of creativity and latitude is expected.

 

Job Description

Understands business objectives and problems, identifies alternative solutions, performs studies and cost/benefit analysis of alternatives. Analyzes user requirements, procedures, and problems to automate processing or to improve existing computer system: Confers with personnel of organizational units involved to analyze current operational procedures, identify problems, and learn specific input and output requirements, such as forms of data input, how data is to be; summarized, and formats for reports. Writes detailed description of user needs, program functions, and steps required to develop or modify computer program. Reviews computer system capabilities, specifications, and scheduling limitations to determine if requested program or program change is possible within existing system.

 

Additional job details and special considerations

We are seeking a highly experienced and motivated individual who specializes in Informatica Cloud Services (IICS). The ideal candidate will have deep technical expertise in multi-domain environments, enabling them to lead and deliver complex IICS implementations for our clients. This role requires a strong understanding of the Informatica toolset, including IICS and relevant business processes, along with excellent communication and client management skills.

II.  CANDIDATE SKILLS AND QUALIFICATIONS
 
Minimum Requirements:
Candidates that do not meet or exceed the minimum stated requirements (skills/experience) will be displayed to customers but may not be chosen for this opportunity.
Years Required/Preferred Experience
8 Required Extensive experience in designing, implementing, and managing Informatica IICS/snowflake solutions.
8 Required E2E implementation experience involving phases from design, realization, testing, to go-live
8 Required Deep understanding of Informatica data modeling, workflow, and integration capabilities and technologies, APIs, web services, and Informatica ETL tools.
8 Required Strong knowledge of data governance, data quality, and data integration principles.
8 Required Expertise in Azure Cloud and Snowflake Cloud Datawarehouse
8 Required Strong knowledge in SQL Queries and Query optimization
8 Required Ability to interact at a technical and non-technical level with Infrastructure, Network, Development, BA and QA
8 Required Development experience in high transaction/high availability systems.
8 Required Experience with analyzing and recommending solutions for Production issues short-term and long term.
8 Required Must have informatica PowerCenter/IICS development experience.
8 Required Knowledge and experience of managing reference data systems
8 Required Provide technical mentorship to junior ETL developers; establish coding standards, templates, and best practices.
8 Required Experience in Python with data science libraries
8 Required Experience in SQL programming and writing stored procedures, functions, views, SQL queries
8 Required Experience working with HIPAA regulations and handling protected health information (PHI) and personally identifiable information (PII).
8 Required