The Texas Department of Family and Protective Services (DFPS) is seeking a Data Analyst IV to perform highly complex database development work, involving the planning, development, maintenance, and monitoring of integrated database systems, evaluation of database policies, and maintenance of data integrity to support the agency's mission of protecting vulnerable populations.
Requirements
- Knowledge of relational and non-relational database systems, data modeling, and SQL programming.
- Knowledge of Databricks architecture and notebook-based analytics workflows.
- Knowledge of MDM concepts and tools for managing golden records and enterprise reference data.
- Knowledge of ETL/ELT tools (e.g., Informatica, Talend, Azure Data Factory, SSIS) and cloud-based data integration platforms.
- Skill in building, maintaining, and troubleshooting data pipelines.
- Skill in creating dashboards and visualizations using tools such as Tableau or Power BI.
- Ability to identify and define data requirements and transform them into actionable technical solutions.
Responsibilities
- Works with stakeholders to understand their technological needs and issues in performing their day-to-day work.
- Collect, clean, and integrate data from disparate sources using ETL processes and modern data engineering tools.
- Build, manage, and optimize data pipelines using Databricks and cloud-based big data environments.
- Apply Master Data Management (MDM) practices to ensure data consistency, quality, and governance across domains.
- Analyze large datasets to identify patterns, trends, and actionable insights; prepare reports, dashboards, and visualizations for stakeholders.
- Work closely with IT and business teams to define, document, and implement data architecture standards and integration processes.
- Collaborate on the development and maintenance of data models, both logical and physical, that support analytics and operational needs.
Other
- Works under the supervision of the IT Operations Data Management Team.
- This position is 100% teleworking within the state of Texas and requires that the candidate maintain personal wi-fi and webcam capabilities during work hours to perform their duties.
- This position often works outside normal business hours, nights, and weekends.
- This position may require occasional onsite work as needed.
- Graduation from an accredited College or University with a degree in computer science, computer information systems, management information systems, or a related field. Work experience may be substituted for education on a year-for-year basis.
