Systems Analyst with Business Intelligence ETL exp for HHSC, Austin, Tx

Title/Level: Systems Analyst 3 Agency:Texas Health and Human Services Commission  Location: 4601 W Gudalupe St Austin, TX 78751 Solicitation Reference Number: 529701754  Category: Applications/Software Development    Job Details: Texas Health and Human Services Commission requires the services of 2 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.Required/Preferred:

• 8 years, Required- Knowledge of and ability to interpret Texas Vital Statistics laws, policies, procedures and regulations.
• 8 years, Required- Knowledge of MS Office Suite (Word, Excel, PowerPoint, Project, and Visio)
• 8 years, Required- Skill in project planning and organization
• 8 years, Required- Skill in business analysis methodologies
• 8 years, Required- Skill in analyzing and evaluating complex information technology applications, policies, and issues
• 8 years, Required- Skill in developing creative and workable solutions to complex problems and issues
• 8 years, Required- Skill in communicating effectively both verbally and in writing with individuals and groups
• 8 years, Required- Skill in using initiative and independent judgment and managing time effectively to establish priorities, organize tasks, and assign and direct the work of others
• 8 years, Required- Skill in establishing and maintaining effective working relationships, including the ability to work with people under pressure, negotiating with multiple parties and resolving conflicts
• 8 years, Required- Skill in reading, interpreting and understanding material to prepare concise reports or appropriate responses for the review and/or signature of section managers and/or directors
• 8 years, Required- Skill in gathering, organizing and analyzing facts, recommending solutions and resolving work-related problems
• 8 years, Required- Skill in maintaining statistical and accounting records and producing data summaries
• 8 years, Required- Ability to manage small to medium sized projects when needed
• 8 years, Required- Ability to create project work plans
• 8 years, Required- Ability to produce accurate work estimates and monitor progress

8 years, Required- Experience in IT, supporting the design, development, deployment, or delivery of technology solutions. 8 years, Required- Experience with Databricks, including building and optimizing ETL/ELT data pipelines using Apache Spark. 8 years, Required- Experience in data warehousing and dimensional data modeling (star/snowflake schemas). 8 years, Required- Proficiency in SQL and Python (or Scala) for large-scale data processing. 8 years, Required- Experience designing and developing dashboards and applications natively within Databricks (e.g., Databricks SQL dashboards, Databricks Apps). 8 years, Required- Experience implementing data governance, data quality, and data security practices. 8 years, Required- Experience implementing Lakeflow Declarative Pipelines (formerly Delta Live Tables/DLT) for building and managing production data pipelines. 8 years, Required- Experience with Delta Lake, medallion architecture (bronze/silver/gold layers), data lakehouse design, and creating and scheduling offline jobs using Lakeflow Jobs (formerly Databricks Workflows) or similar orchestration tools (e.g., Airflow). 8 years, Required- Excellent communication skills, both verbal and written, including presenting insights to technical and business stakeholders. 1 year, Preferred- Experience working in public sector or state government environments. 1 year, Preferred- Databricks certification (e.g., Databricks Certified Data Engineer Associate/Professional). 1 year, Preferred- Experience with CI/CD practices for data pipelines (DevOps, Git-based workflows). 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). 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. 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.The Databricks Engineer should design, develop, and optimize scalable data solutions on Databricks, leveraging PySpark or Scala for large-scale data processing. Build and maintain ingestion pipelines, Declarative Pipelines (DLT), and Medallion Architecture (Bronze, Silver, Gold) to support enterprise analytics and reporting. Develop robust data models and implement data quality, validation, and governance frameworks. Create dynamic dashboards, Databricks Apps, and analytical solutions to deliver actionable business insights. Optimize workloads, monitoring, and operational processes to ensure scalability, security, and cost efficiency.