Analytics Engineer

ALMAG Contracting Group; Frisco (TX); Hybrid; USD 90,000 - 130,000; Full time

Benefits offered by this job

Paid time off

Flexible work environment

Health insurance

Professional development opportunities

Career advancement opportunities

Job summary

ALMAG Contracting Group is seeking an Analytics Engineer in Frisco, TX, to design, develop, and maintain data infrastructure and analytics ecosystems. Hybrid work supports estimating, project management, finance, operations, and executive decision-making for reliable reporting and forecasting.

The role emphasizes building scalable pipelines, dashboards, and predictive models while ensuring data quality and governance to drive strategic insights across the organization.

Qualifications

• Bachelor's or Master's degree in Business Analytics, Data Analytics, Computer Science, Software Engineering, Information Systems, Data Science, or a related field.
• Experience in analytics engineering, BI, data engineering, software development, or a related technical role.
• Strong proficiency in SQL.
• Experience programming with Python.
• Experience building dashboards using Power BI and/or Tableau.
• Knowledge of ETL/ELT processes and data modeling.
• Experience integrating multiple data sources using APIs.
• Strong analytical, organizational, and problem-solving skills.
• Excellent written and verbal communication skills.

Responsibilities

• Design, develop, and maintain scalable data pipelines and analytics solutions.
• Build interactive dashboards and executive reports using Power BI or Tableau.
• Develop and optimize SQL databases, data warehouses, and data models.
• Integrate data from accounting systems, CRM platforms, ERP software, estimating systems, project management platforms, and other business applications.
• Develop predictive analytics models for estimating, budgeting, project performance, labor utilization, equipment tracking, scheduling, and cash flow forecasting.
• Create company-wide KPIs, scorecards, and executive performance dashboards.
• Automate manual reporting and repetitive business processes using Python, APIs, and workflow automation tools.
• Design and maintain secure, scalable analytics architecture.
• Collaborate with leadership to identify opportunities for operational improvement through analytics and automation.
• Ensure data quality, governance, documentation, and security best practices.
• Support strategic planning through advanced reporting, forecasting, and business intelligence.

Skills

SQL

Python

Power BI

Tableau

Data Modeling

ETL/ELT

APIs

Git

Dashboards

Analytics

Education

Bachelor's or Master's in Data Analytics / CS

Tools

Power BI

Tableau

Azure Data Factory

Azure Synapse

Databricks

Snowflake

dbt

Git

Microsoft Fabric

Job description

ALMAG Contracting Group, based in Frisco, TX, is seeking an Analytics Engineer to design, develop, and maintain the company’s data infrastructure and analytics ecosystem. This hybrid role supports estimating, project management, finance, operations, and executive decision-making, enabling reliable reporting, forecasting, and strategic insights across the organization.

Responsibilities

• Design, develop, and maintain scalable data pipelines and analytics solutions.
• Build interactive dashboards and executive reports using Power BI or Tableau.
• Develop and optimize SQL databases, data warehouses, and data models.
• Integrate data from accounting systems, CRM platforms, ERP software, estimating systems, project management platforms, and other business applications.
• Develop predictive analytics models for estimating, budgeting, project performance, labor utilization, equipment tracking, scheduling, and cash flow forecasting.
• Create company-wide KPIs, scorecards, and executive performance dashboards.
• Automate manual reporting and repetitive business processes using Python, APIs, and workflow automation tools.
• Design and maintain secure, scalable analytics architecture.
• Collaborate with leadership to identify opportunities for operational improvement through analytics and automation.
• Ensure data quality, governance, documentation, and security best practices.
• Support strategic planning through advanced reporting, forecasting, and business intelligence.

Requirements

• Bachelor's or Master's degree in Business Analytics, Data Analytics, Computer Science, Software Engineering, Information Systems, Data Science, or a related field.
• Experience in analytics engineering, business intelligence, data engineering, software development, or a related technical role.
• Strong proficiency in SQL.
• Experience programming with Python.
• Experience building dashboards using Power BI and/or Tableau.
• Knowledge of ETL/ELT processes and data modeling.
• Experience integrating multiple data sources using APIs.
• Strong analytical, organizational, and problem-solving skills.
• Excellent written and verbal communication skills.

Technologies

• Python
• SQL
• Power BI
• Tableau
• Microsoft Fabric
• Azure Data Factory
• Azure Synapse Analytics
• Databricks
• Snowflake
• dbt
• Git
• Docker
• Microsoft Power Platform
• REST APIs
• Construction ERP software
• Estimating software

Benefits

• Paid time off and company holidays
• Professional development and continuing education opportunities
• Flexible work environment
• Opportunities for career advancement
• Collaborative and innovative workplace cultureFlexible schedule
• Health insurance
• Paid time off
• Professional development assistance

Projects you'll help build

• Business development pipeline dashboard
• Estimating and cost analytics platform
• Financial performance and executive reporting dashboards
• Project profitability analytics
• Cash flow forecasting models
• Proposal and sales pipeline analytics
• Vendor and subcontractor performance dashboards
• Equipment utilization and maintenance analytics
• Executive KPI dashboards
• Predictive project risk models
• Workforce productivity dashboards
• Interactive operational reporting tools

Technical Skills

• Python
• SQL
• Power BI
• Tableau
• Advanced Microsoft Excel
• Data Warehousing
• Data Modeling
• ETL/ELT
• APIs
• Git
• Dashboard Development
• Predictive Analytics
• Statistical Analysis
• Business Intelligence
• Data Visualization
• Process Automation