Impress employers and recruiters.
Choose from hundreds of resume examples.
Impress employers and recruiters.
Choose from hundreds of resume examples.
Target Resume Now
Tailor your resume to this Data Analyst V role.
Rezi rewrites your resume against TX-HHSC-DSHS-DFPS's job description. Free.
Tailor your resume to this Data Analyst V role.
Rezi rewrites your resume against TX-HHSC-DSHS-DFPS's job description. Free.
Don't guess if your resume is good enough.
See how it scores against the Data Analyst V posting at TX-HHSC-DSHS-DFPS — free, in seconds.
Don't guess if your resume is good enough.
See how it scores against the Data Analyst V posting at TX-HHSC-DSHS-DFPS — free, in seconds.
About the Role
The Data Analyst V reports to the Data Management (DM) Unit Director and performs highly complex data analysis, research, integration, visualization, and analytical solution development. This role supports the mission to provide reliable, high-quality, secure, well-governed, and accessible data assets for data-informed decisions and program performance improvement.
Responsibilities
- Designs, develops, maintains, and enhances data integration and ETL/ELT solutions supporting data warehouses, data marts, analytics, and reporting.
- Conducts highly complex data research and analysis to identify trends, patterns, relationships, anomalies, and emerging issues.
- Develops, implements, and monitors data-quality measures and analytical validation processes.
- Designs, develops, enhances, and maintains interactive dashboards, reports, visualizations, and analytical products.
- Serves as a senior analytical and technical resource for the DM Unit, developing and maintaining standard operating procedures, technical documentation, and user guidance.
- Provides technical guidance and mentoring to DM Unit and DAP staff.
- Evaluates emerging data, cloud, analytics, automation, and visualization technologies and recommends solutions.
- Promotes reusable solutions, automation, knowledge sharing, cross-training, and continuous improvement.
Requirements
- Graduation from an accredited four-year college or university with major coursework in data analytics, statistics, computer science, information systems, mathematics, public health, or business analytics.
- May substitute direct work experience in a technical field on a year-for-year basis in lieu of education for up to four years.
- Experience conducting complex data analysis, data research, data profiling, trend analysis, or statistical analysis using large and/or complex datasets.
- Experience developing and executing complex SQL queries for data extraction, transformation, validation, analysis, and reporting.
- Experience working with relational databases, enterprise data warehouses, data marts, or cloud data platforms such as Snowflake, SQL Server, Oracle, or comparable technologies.
- Experience developing, maintaining, troubleshooting, or supporting ETL/ELT processes and data pipelines using Informatica/IICS or comparable data integration technologies.
- Experience developing reports, dashboards, visualizations, or other analytical products using Tableau, SAS Viya, Power BI, or comparable BI/analytics tools.
- Experience performing data profiling, validation, cleansing, reconciliation, or identifying and resolving data-quality issues.
- Experience documenting analytical processes, data workflows, business/technical requirements, methodologies, SOPs, or technical procedures.
- Experience communicating analytical findings to stakeholders.
Skills
- Advanced data analysis, data research, statistical analysis, data interpretation, and analytical methodologies.
- Relational databases, cloud data platforms, enterprise data warehouses, data marts, and analytical data environments.
- Snowflake architecture, databases, schemas, tables, views, stages, tasks, streams, stored procedures, security roles, and performance optimization concepts.
- ETL/ELT principles, data integration patterns, data pipelines, and workflow development using Informatica PowerCenter, Informatica Intelligent Cloud Services (IICS), or comparable tools.
- Advanced SQL, including complex queries, joins, subqueries, common table expressions, window functions, stored procedures, query optimization, and data validation.
- Data visualization, dashboard design, KPI development, reporting standards, and visual communication best practices using Tableau, SAS Viya, or comparable tools.
- Statistical programming, exploratory data analysis, trend analysis, anomaly detection, and descriptive and inferential statistical methods.
- Data profiling, cleansing, standardization, reconciliation, validation, and data-quality measurement.
- Data governance principles, including metadata management, data lineage, data stewardship, data ownership, data classification, and data lifecycle management.
- Logical and physical data models, dimensional modeling, database design, and analytical dataset development.
- Automation methods and programming or scripting languages such as Python, SAS, SQL, or comparable technologies.
- Information security, role-based access, confidentiality, privacy, and protection of sensitive health and human services data.
- Federal and state laws, regulations, and policies applicable to data management, including HIPAA and HHSC security, privacy, records-management, and data-governance requirements.
- Systems development lifecycle, change management, testing, version control, incident management, and production implementation practices.
- Technical documentation standards, standard operating procedures, data dictionaries, business rules, and training-material development.
- Emerging developments and best practices in cloud computing, data engineering, analytics, artificial intelligence, automation, and business intelligence.
- Using Snowflake to query, integrate, transform, organize, and optimize large and complex datasets for analysis and reporting.
- Developing and maintaining ETL/ELT workflows using Informatica PowerCenter, IICS, or comparable data-integration technologies.
- Writing, reviewing, troubleshooting, and optimizing advanced SQL queries.
- Using SAS Viya, Tableau, or comparable analytical and visualization tools to analyze data and develop dashboards, reports, and visualizations.
- Designing dashboards that present accurate, meaningful, accessible, and actionable information to program, technical, and executive audiences.
- Collecting, acquiring, profiling, cleaning, standardizing, integrating, validating, and reconciling data from multiple sources.
- Conducting complex data analysis to identify trends, patterns, relationships, anomalies, risks, and opportunities for operational improvement.
- Developing data-quality measures, validation rules, exception reports, scorecards, and monitoring processes.
- Translating business questions and program objectives into data requirements, metrics, KPIs, analytical methods, and technical solutions.
- Developing analysis-ready datasets, semantic layers, reusable data products, and optimized structures supporting analytics and dashboards.
- Troubleshooting data pipelines, analytical applications, dashboard calculations, data discrepancies, and performance problems.
- Automating repetitive data acquisition, validation, reporting, monitoring, and documentation processes.
- Using statistical, programming, and scripting tools such as SAS, Python, SQL, or comparable technologies.
- Data modeling, source-to-target mapping, metadata documentation, and data-lineage analysis.
- Testing and validating ETL workflows, analytical datasets, business rules, statistical results, dashboards, and reports.
- Developing clear technical documentation, standard operating procedures, data dictionaries, workflow diagrams, user guides, and training materials.
- Presenting analytical findings, technical issues, risks, and recommendations clearly to technical and nontechnical audiences.
- Consulting, stakeholder engagement, requirements gathering, facilitation, collaboration, and customer service.
- Organizing and prioritizing multiple complex assignments, projects, deliverables, and competing deadlines.
- Mentoring staff, reviewing technical work, sharing knowledge, and supporting cross-training.
- Using sound judgment, critical thinking, root-cause analysis, and structured problem-solving.
Location
- AUSTIN
Work Type
- Eligible for Telework
- Full time
Experience Level
- Senior-level
Education Level
- Bachelor's degree in data analytics, statistics, computer science, information systems, mathematics, public health, or business analytics
- Equivalent experience in a technical field
Salary/Compensations
- $84,000.00 - $102,720.00
Benefits
- 100% paid employee health insurance for full-time eligible employees
- Defined benefit pension plan
- Generous time off benefits
- Numerous opportunities for career advancement
About the Company
- Join the Texas Health and Human Services Commission (HHSC) and be part of a team committed to creating a positive impact in the lives of fellow Texans.
- At HHSC, your contributions matter, and we support you at each stage of your life and work journey.
Equal Opportunity
- In compliance with the Americans with Disabilities Act (ADA), HHSC and DSHS agencies will provide reasonable accommodation during the hiring and selection process for qualified individuals with a disability.
- Depending on the program area and position requirements, applicants selected for hire may be required to pass background and other due diligence checks.
- HHSC uses E-Verify. You must bring your I-9 documentation with you on your first day of work.