Xpedient Technologies

KEY RESPONSIBILITIES

Category

Responsibility

Data Modeling & Report Development

Design and build complex dimensional data models from the bottom up, ensuring scalability and alignment with agency data standards.

Data Modeling & Report Development

Develop and publish Power BI reports and dashboards incorporating best practices for data accuracy and visual clarity.

Data Visualization & Storytelling

Visualize compelling data stories on the Power BI report canvas for diverse stakeholder audiences.

Data Visualization & Storytelling

Design interactive dashboards that enable TEA stakeholders to explore and interpret data with confidence.

Cross-Functional Collaboration

Collaborate with TEA business and IT teams to engineer agency-wide data solutions.

Cross-Functional Collaboration

Develop and implement end-to-end data visualization solutions, from requirements through deployment.

Data Quality & Analysis

Analyze data using standard statistical tools to identify patterns, trends, and anomalies.

Data Quality & Analysis

Identify and resolve data gaps, errors, and inconsistencies; clean and prepare data for analysis.

Data Quality & Analysis

Prepare concise technical reports presenting findings, alternatives, and recommendations.

REQUIREMENTS MATRIX (Required vs. Preferred)

Category

Requirement

Priority

Education

Bachelor's degree in Data Science, Business Analytics, Computer Science, MIS, Mathematics, Statistics, or a related field.

Required

Experience

Minimum five (5) years of experience in data analysis, research, compilation, and/or reporting.

Required

Experience

Demonstrated hands-on experience developing Power BI reports, dashboards, and dimensional data models.

Required

Technical Skills

Proficiency in Microsoft Power BI, including DAX, Power Query (M), and data modeling.

Required

Technical Skills

Strong SQL skills; familiarity with data warehousing concepts and relational database technologies.

Required

Technical Skills

Knowledge of data models, database design, data mining, and segmentation techniques.

Required

Technical Skills

Experience working with structured and unstructured data from disparate source systems.

Required

Soft Skills

Strong verbal and written communication skills; ability to present findings to non-technical audiences.

Required

Soft Skills

Collaborative mindset with demonstrated ability to work across teams and functional areas.

Required

Soft Skills

High attention to detail and commitment to data quality and analytical rigor.

Required

Preferred

Experience in a Texas state agency or public-sector environment.

Preferred

Preferred

Familiarity with education data or student information systems.

Preferred

Preferred

Experience with Azure data services (Data Factory, Synapse, Azure SQL) as Power BI data sources.

Preferred

Preferred

Microsoft Power BI certification (PL-300 or equivalent).

Preferred