Apply on Employer Site

Texas Health and Human Services · 2 days ago

CFO Data Architect

Austin, TX

Full-time

Hybrid

Mid Level

$7,716.66/mo - $13,051/mo

3+ years exp

Texas Health and Human Services Commission (HHSC) is committed to creating a positive impact in the lives of fellow Texans. The CFO Data Architect I will perform advanced data migration activities, focusing on designing and leading the migration of data from legacy systems to new platforms while ensuring data accuracy, accessibility, and security.

Health Care

Responsibilities

Data Load and ETL Monitoring, including monitoring scheduled data loads and ETL jobs, troubleshooting failed or slow data loads, and coordinating with ETL developers for issue resolution; Performance Monitoring and Optimization, including monitoring warehouse performance and query execution, identifying and resolving bottlenecks (e.g., long-running queries), and recommending and implementing warehouse scaling or clustering; Maintenance and Housekeeping, including managing storage usage and retention policies, archiving or purging old/unnecessary data, and applying best practices for cost control; Incident and Problem Management, including responding to incidents, alerts, and service requests, documenting and escalating issues as needed, and maintaining knowledge base articles for common issues; and Data Analysis & Ad hoc Data Requests, including working on Data Analysis requests, providing data extracts on demand based on the program team and automating common Data Requests

Monitor daily/weekly/monthly ETL job runs

Investigate and resolve job failures or performance issues

Restart failed jobs and communicate status to stakeholders

Set up and maintain connections to source/target systems (databases, cloud apps, etc.)

Troubleshoot connectivity issues

Deploy new or updated mappings, workflows, and tasks

Validate and test changes in lower environments before promoting to production

Respond to tickets and service requests

Provide root cause analysis for recurring issues

Document solutions and update runbooks

Maintain up-to-date documentation for processes, runbooks, and troubleshooting guides

Provide regular status reports on incidents, job status, and platform health

Coordinates with internal CFO division data users regarding data needs and system performance, communicates changes to CFO division users, and serves as liaison to the Information Technology division and other HHSC business areas regarding data needs and system performance

Drafts and submits reports, responds to inquiries, and participates in briefings, meetings, presentations, and other activities to ensure CFO division leadership are aware of data needs and system performance; develops and recommends solutions to data related problems and concerns; and advises on training needs for CFO division staff to optimize user experience and expertise related to data

Qualification

Data Migration (ETL)Data ArchitectureData ModelingSAS ProgrammingInformaticaSnowflakeData WarehousingAdvanced AnalyticsProject ManagementCommunication SkillsProblem-SolvingLeadershipTime Management

Required

Bachelor's degree from a 4-year university in Information Technology, Computer Science, or a related field or equivalent work experience (experience may be substituted for education on a year to year basis)

At least 3 years of experience in developing, deploying, and managing applications and data storage

At least 2 years of experience developing and maintaining enterprise data models, data warehouses, and data lakes to support analytics and reporting

At least 2 years of experience working closely with data engineers, developers, and analysts to ensure seamless data accessibility and usability

Preferred

5 years of experience as a Data Center Migration Consultant or in a similar role, with expertise in data center infrastructure and migration processes

Experience in data architecture, data modeling, and data warehousing

Experience evaluating and integrating emerging technologies such as AI, machine learning, and big data analytics

Experience in data center architectures, data replication, and disaster recovery strategies

Experience using analytical skills to develop effective migration plans and solutions

4 or more years of experience handling Data Analytics projects with on the job experience in Snowflake and Informatica

Preferred certifications: Snowflake - Snow-pro; ITIL; or Informatica