Analytics Engineer
Analytics
Azure Data Factory
Azure Synapse Analytics
Big Data
Business Analytics
Business Intelligence
Business Systems
Data Analysis
Data Analytics
Data Architecture
Data Build Tool
Data Engineer
Data Integration
Data Management
Data Modeling
Data Pipeline
Data Pipelines
Data Platform
Data Processing
Data Visualization
Data Warehouse
Database
Databases
Databricks
ERP Systems
Estimating
ETL
Microsoft Azure
Microsoft Fabric
Microsoft Power Platform
Power BI
Power Platform
Programming Language
Programming Languages
Reporting and Analytics
SQL
Job Description
ALMAG Contracting Group offers a collaborative and innovative environment with flexibility for work arrangements, robust professional development, and clear opportunities for career advancement. This hybrid Analytics Engineer role in Frisco, TX supports estimating, project management, finance, operations, and executive decision making. The position offers a salary of USD 62,400 per year.
Benefits
- Paid time off and company holidays
- Health insurance
- Flexible work environment
- Flexible schedule
- Professional development and continuing education opportunities
- Professional development assistance
- Opportunities for career advancement
- Collaborative and innovative workplace culture
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
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