Location: Allen, TX (Primarily On-site)

Reports To: Director of Application Development

Direct Reports: n/a

FLSA: Exempt

Position Summary

The Analytics Engineer is responsible for developing business intelligence solutions and supporting the growth of our data infrastructure. Working at the intersection of business needs and technical execution, this role focuses on building reliable data models, designing and delivering dashboards, and improving reporting efficiency across the organization.

You will collaborate closely with business stakeholders and members of the development team to translate requirements into scalable datasets and visualizations. In addition to supporting day-to-day reporting and self-service analytics, you will play a key role in preparing and maintaining the data foundations necessary for our AI initiatives.

Key Responsibilities

Business Intelligence Development

• Support end-to-end BI solutions from data ingestion to dashboard delivery
• Design, develop, and maintain Power BI dashboards and reports used across departments
• Build intuitive data visualizations that support operational and executive decision-making.
• Optimize and enhance existing dashboards for performance, usability, and scalability.
• Identify opportunities to automate repetitive reporting processes and improve data workflows.

Data Preparation & Modeling

• Write and optimize SQL queries to support reporting and analytics needs.
• Assist in developing and maintaining data models and curated datasets used in Power BI.
• Engineer the data models and pipelines required to provide a reliable foundation for AI applications.
• Support data transformation and preparation processes using ETL tools such as Alteryx & SQL.

Business Collaboration

• Support ad-hoc analysis and reporting requests across business teams.
• Assist in validating data and supporting user acceptance testing (UAT) for reports.
• Work collaboratively with the other development team members and cross-functional business teams to deliver reliable analytics solutions.
• Support data refresh monitoring, troubleshooting, & improve data reliability

Data Documentation & Knowledge Management

• Create and maintain clear technical and business documentation for new data pipelines, datasets, dashboards, and reporting processes.
• Assist in documenting existing data workflows, SQL views, Alteryx processes, and Power BI reports to improve maintainability and knowledge sharing.
• Maintain documentation of data definitions, calculation logic, and KPI metrics used across reports.

Additional Information

• This job description is not intended to be a comprehensive list of all duties. Responsibilities may evolve based on business needs.