OAG - Information Technology Services | Data Scientist I-II | 26-0089

GENERAL DESCRIPTION
The Office of the Attorney General (OAG) is a mission-driven organization with over 4,000 employees across Texas. We provide legal services to state agencies, combat human trafficking, support victims of crime, and operate one of the most effective Child Support Enforcement programs in the nation.

This Data Engineer role is focused on enabling data-informed decision-making across administrative and legal teams by designing and developing interactive Tableau dashboards, building semantic data models, writing SQL queries, and constructing ETL pipelines. The position emphasizes strong analytical skills, data storytelling, and the ability to translate complex datasets into actionable insights. This role will ideally additionally help serve as a key enabler for artificial intelligence integration into analytics and business operations.

The ideal candidate will have experience working with financial, operational, and legal datasets, and a passion for building scalable, self-service reporting solutions that promote transparency, efficiency, and data literacy across the agency. This role is highly collaborative, working in Agile teams to deliver value-driven, data-informed solutions that promote transparency, efficiency, and data literacy across the agency.

The OAG is committed to providing innovative, modern, and value-driven IT services to the agency. We believe that having talented people in the right place while effectively utilizing new tools and technologies enables us to empower the agency to best serve the people of Texas. OAG employees enjoy excellent benefits along with tremendous opportunities to do important work at a large, dynamic state agency making a positive difference in the lives of Texans.

• ESSENTIAL POSITION FUNCTIONS
• Analytics & Visualization Development
• •    Design and deliver dynamic Tableau dashboards and visualizations that provide actionable insights to support budgeting, financial planning, and legal operations.
• •    Collaborate with stakeholders to gather requirements, define KPIs, and translate business needs into intuitive, data-driven solutions.
• •    Build and maintain semantic layers and data models to support self-service analytics and consistent reporting.
• Data Preparation & Analysis
• •    Perform data wrangling, cleansing, and transformation using SQL and Python to prepare datasets for analysis and visualization.
• •    Analyze large, complex datasets to uncover trends, anomalies, and actionable insights that inform agency decision-making.
• •    Ensure data accuracy, consistency, and integrity across all reporting assets.
• ETL Development, Data Modeling, & AI Enablement
• •    Develop and maintain ETL pipelines to automate data ingestion and transformation processes.
• •    Design and optimize data models that support efficient querying and reporting across multiple systems and domains
• •    Support the integration of AI-powered tools into analytics workflows, such as natural language querying, automated insights, and document summarization.
• Collaboration & Agile Delivery
• •    Collaborate with cross-functional teams in an Agile environment to deliver high-impact, data-driven solutions aligned with business goals.
• •    Promote best practices in data science, including reproducibility, model validation, documentation, and ethical data use.
• •    Contribute to a culture of data literacy and democratization by enabling intuitive access to insights through well-structured semantic layers and visualizations.
• •    Collaborate with IT and business teams to identify opportunities where AI tools can enhance reporting, data access, and decision-making.
• Risk Management
• •    Identify and mitigate potential risks associated with technology programs and projects, ensuring compliance with security and regulatory standards.
• •    Assist in the risk management of data across the organization.
• •    Proactively address issues and challenges that may impact project timelines or objectives.
• •    Stay informed on emerging AI technologies and contribute to the agency’s roadmap for responsible AI adoption.
• May lead, mentor and train others
• Performs related work as assigned
• Maintains relevant knowledge necessary to perform essential job functions
• Attends work regularly in compliance with agreed-upon work schedule. Telework schedules are permitted for employees based on the agency’s approved Telework Plan (if schedule does not adversely affect operations and service levels, and standard hours of operation are maintained).
• Ensures security and confidentiality of sensitive and/or protected information
• Complies with all agency policies and procedures, including those pertaining to ethics and integrity

Minimum Qualificationsdata Scientist I:

• Education: Graduation from high school or equivalent
• Education: Bachelor’s degree from an accredited four-year college/university; experience in the following (or closely related) fields may be substituted for the required education on a year-for-year basis: computer science, data engineering, information systems, mathematics, statistics, economics, or a related field
• Experience: Four years of full-time experience in the following (or closely related) fields: computer science, data engineering, information systems, mathematics, statistics, economics, or a related field
• Experience with developing in two or more of the following technologies: Tableau, Azure, SQL, R, Python, relational databases, ETL/ELT pipeline development, data modeling, semantic layer design, dashboard creation (e.g., Power BI), self-service reporting, REST APIs, or workflow automation
• Knowledge of data quality principles, data validation techniques, and data governance best practices, including experience working with sensitive or regulated data and an understanding of data privacy, confidentiality, and security standards.
• Skill in effective oral and written communication, including preparing and delivering technical presentations, status reports, and program-related updates to diverse audiences such as executive management, program staff, and external stakeholders; skill in exercising sound judgment, effective decision-making, and responding positively to constructive feedback
• Skill in managing multiple priorities, meeting deadlines, and adapting to evolving requirements; ability to collaborate in a professional environment with cross-functional teams to ensure data quality, integrity, and alignment with agile-at-scale practices at the Office of the Attorney General
• Ability to adapt to new technologies and learn quickly
• Ability to meet position requirements, including on-site work at OAG locations, business-related travel, occasional extended hours in compliance with FLSA, and the physical ability to lift and relocate up to 10 lbs
• Ability to travel  up to 5%     

Data Scientist II – All of the above qualifications for a Data Scientist I, plus: 

• Experience: One additional year of full-time experience in the following (or closely related) fields: computer science, data engineering, information systems, mathematics, statistics, economics, or a related field

Preferred Qualifications

• Education: Major coursework in business intelligence, data engineering, data science, business analytics, computer science, management information systems, accounting, finance, mathematics, statistics, economics, or a related field is generally preferred
• Experience: Strong expertise in Tableau and working with financial or legal datasets
• Experience: Specialized training in Business Intelligence, Data Science, AI Development or Integration, or related technologies is a plus
• Knowledge: Working knowledge of Scrum agile methodologies, lean engineering principles, and software development tools/methodologies

To Apply

To apply for a job with the OAG, electronic applications can be submitted through CAPPS Recruit. A State of Texas application must be completed to be considered, and paper applications are not accepted. Your application for this position may subject you to a criminal background check pursuant to the Texas Government Code. Military Crosswalk information can be accessed at  

https://hr.sao.texas.gov/Compensation/MilitaryCrosswalk/MOSC_PlanningResearchandStatistics.pdf

THE OAG IS AN EQUAL OPPORTUNITY EMPLOYER