Enterprise Data Analytics & Automation Lead

Dashiell Corporation; Houston (TX); On-site; USD 120,000 - 170,000; Full time

Benefits offered by this job

Health insurance

401(k) with company match

Dental and vision

Job summary

Dashiell Corporation, based in Houston, TX, seeks an experienced Enterprise Data Analytics & Automation Specialist to connect ERP systems to scalable analytics platforms across EPC project lifecycles.

You will design Alteryx-powered workflows, KPI frameworks, and executive dashboards for Operations, Project Management, Finance, and Commercial teams, enabling real-time visibility and governance.

Qualifications

• Bachelor’s degree in Engineering, Computer Science, Information Systems, Business, or a related field is required.
• Minimum 5 years of experience in enterprise analytics, ERP integration, or data engineering.
• Advanced proficiency in Alteryx Designer and Alteryx Server administration.
• Strong SQL skills with Oracle, SQL Server, and IBM iSeries.
• Proficiency in Power BI and Azure cloud analytics platforms.
• Deep ERP system expertise including Salesforce, SharePoint, and Azure.

Responsibilities

• Design and deliver ERP-integrated analytics solutions across project execution, cost tracking, and decision-making.
• Support EPC project launches, bids, and capital programs through data modeling and variance reporting.
• Develop and maintain KPI frameworks and dashboards in Power BI and Alteryx.
• Create enterprise data pipelines integrating ERP, Salesforce, Azure Synapse, and SharePoint.
• Own data governance, QA, and provisioning across Alteryx Server and related platforms.

Skills

Communication

Strategic thinking

Problem solving

Education

Bachelor’s degree in Engineering/CS/IS/Business

Tools

Alteryx Designer

Alteryx Server

Power BI

Azure Synapse

SQL (Oracle/SQL Server/IBM iSeries)

Salesforce

SharePoint

Job description

Dashiell, an operating unit of Quanta Services (trading as PWR), is a leading national provider of technical and construction services supporting critical electric infrastructure. We serve electric utilities, power generation, industrial, renewable, and energy markets with integrated capabilities spanning planning and system studies, engineering and design, maintenance and testing, program management, construction, and turnkey EPC delivery. With more than 60 years of experience executing large, complex projects, Dashiell specializes in medium- and high-voltage electrical infrastructure and delivers safe, reliable solutions across the full project lifecycle. Backed by the scale, resources, and safety culture of Quanta Services, Dashiell partners with clients to build and maintain the infrastructure that powers communities and economies. Learn more at www.dashiell.com.

Primary Function

The Enterprise Data Analytics & Automation Specialist is a senior-level individual contributor responsible for connecting ERP systems to scalable analytics and automation platforms, transforming operational and financial data into real-time visibility across project execution, cost control, and resource management. Working with a high degree of independent judgment, this role owns the design and delivery of Alteryx-powered workflows, operational KPI frameworks, and executive dashboards serving Operations, Project Management, Finance, and Commercial teams across the full EPC project lifecycle. The position will be based in our Houston, Texas office located at 12301 Kurland Drive STE 400, Houston, TX 77034 and will report to Dashiell’s Sr. Director of ERP & Project Controls.

Duties & Responsibilities

• Partner with Operations, Project Management, Finance, and Commercial leadership to design and deliver ERP-integrated analytics solutions, extracting, transforming, and reporting on ERP data to support project execution, cost tracking, and operational decision-making.
• Support major EPC project launches, contract bids, and capital programs through ERP-sourced data modeling, cost-to-complete analysis, and variance reporting.
• Develop and maintain operational KPI frameworks using Power BI and Alteryx that track EPC project performance, cost variances, schedule milestones, and resource efficiency.
• Translate complex ERP and operational data into executive-ready dashboards and narratives that support leadership decision-making.
• Design and maintain enterprise data pipelines integrating ERP systems, Salesforce, Azure Synapse, and SharePoint to consolidate data into unified reporting layers supporting financial close, project controls, and commercial reporting cycles.
• Develop and govern Alteryx workflows, including Designer, Server, and Gallery administration, to automate data extraction, transformation, and delivery from ERP and other enterprise systems into Power BI and Azure reporting layers.
• Ensure data quality, pipeline reliability, and platform governance across Alteryx Server environments, including user provisioning, workflow scheduling, system upgrades, and integration with SQL Server, Oracle, and Azure.
• Lead analytics workstreams within ERP implementation and migration projects, partnering with IT, Finance, and Operations to map data requirements, design reporting solutions, and validate data integrity.
• Design and maintain Power BI dashboards and reports for orders, KPIs, financials, and operational metrics accessible to technical and non-technical audiences.
• Build and maintain Azure Synapse pipelines, Power BI data models, and DAX measures that surface EPC project and financial data in scalable, self-service dashboards.
• Automate recurring manual reporting workflows to reduce manual effort across teams.
• Architect and deploy end-to-end Alteryx automation workflows that eliminate recurring manual processes across EPC operations, integrating ERP, Salesforce, SharePoint, and Azure data sources.
• Develop lightweight operational applications using Power Apps and Power Automate to surface ERP and project data directly to field teams, project managers, and regional operations.
• Integrate GenAI and AI-assisted capabilities into operational workflows to automate recommendations and surface intelligent insights for project controls and commercial teams.
• Collaborate across Finance, Commercial, Sales, Operations, and Engineering to align analytical priorities with enterprise-wide objectives.
• Translate complex ERP and operational business requirements into scalable, governed analytics solutions, working independently across IT, Operations, and Finance stakeholders with minimal oversight.
• Mentor analysts and contribute to team standards for documentation, data governance, and reproducibility.
• Perform special projects and complete other duties as assigned or requested.

How You Will Make an Impact

• Enable faster, more confident leadership decisions by delivering ERP-integrated analytics, cost-to-complete modeling, and variance reporting for major EPC projects and capital programs.
• Provide real-time execution visibility to project controls and operations leadership through operational KPI frameworks and executive dashboards.
• Reduce manual effort and improve data accuracy across teams by architecting and governing enterprise-wide Alteryx automation workflows.
• Strengthen data quality, pipeline reliability, and platform governance across the organization’s analytics and reporting environments.
• Elevate team capability by mentoring analysts and establishing standards for documentation, data governance, and reproducibility.

Required

Minimum Qualifications / Experience

• Bachelor’s degree in Engineering, Computer Science, Information Systems, Business, or a related field required (4 years of directly relevant experience may be considered in lieu of a degree).
• Minimum 5 years of experience in enterprise analytics, ERP integration, or data engineering, ideally within energy, utilities, EPC, or a similarly complex capital-intensive industry.
• Advanced proficiency in Alteryx Designer and Alteryx Server administration, including workflow governance, user provisioning, Gallery management, and enterprise platform integration.
• Strong SQL skills with hands‑on experience querying Oracle, SQL Server, and IBM iSeries, including ERP tool sets and backend data structures.
• Proficiency in Power BI (DAX, data modeling) and Azure cloud analytics platforms (Synapse Analytics, Data Factory, Azure SQL, Azure Data Explorer).
• Deep ERP system expertise, including data extraction, backend mapping, reporting tool sets, and cross‑platform integration with Salesforce, SharePoint, and Azure.
• Ability to communicate complex analytical results clearly to commercial and executive audiences.
• Driving is not required for this position.

Preferred

• Post-graduate education or certificate program in AI/ML, Data Analytics, or a related discipline.
• Alteryx Core or Advanced Certification (Designer and/or Server); Microsoft Azure AI Fundamentals or equivalent cloud certification.
• Familiarity with P6 Primavera or equivalent project controls/scheduling software.
• Experience with Alteryx Server governance, including AD group management, network security, and platform administration.
• Experience building AI-integrated analytics applications that automate commercial or operational workflows.
• Background in ERP implementation or migration projects, including data validation, go‑live support, and post‑implementation reporting.
• Experience acting as a strategic liaison between IT, business users, and external analytics partners, driving platform adoption, training, and governance at enterprise scale.

Physical Requirements

• Ability to sit for extended periods during computer-based work.
• Ability to stand and walk intermittently throughout the workday.
• Occasional lifting of up to 20 pounds.
• Occasional travel to other offices or meeting locations.

Environmental Conditions

• Primarily climate-controlled office environment.
• Occasional exposure to field or industrial environments during site visits.

Reasonable accommodations may be made to enable individuals with disabilities to perform essential functions as defined by Company policy.

Equal Employment Opportunity

Dashiell is an Equal Opportunity Employer. Employment decisions are made without regard to race, religion, color, sex, gender identity or expression, sexual orientation, age, national origin, disability, veteran status, or any other protected status under applicable law.

Dashiell offers a competitive compensation and benefits package. Benefits include company-paid life insurance, accidental death and dismemberment insurance, long‑term disability insurance, and an employee assistance program.

• company-paid life insurance
• accidental death and dismemberment insurance
• long‑term disability insurance
• employee assistance program
• medical coverage through a traditional PPO or one of two high-deductible health plans (with FSA or HSA options)
• dental and vision coverage
• supplemental life insurance
• short-term disability
• critical illness insurance
• group accident insurance
• hospital indemnity insurance
• 401(k) plan with immediate vesting

Additional benefit offerings include medical coverage through a traditional PPO or one of two high-deductible health plans (with FSA or HSA options), dental and vision coverage, supplemental life insurance, short-term disability, critical illness insurance, group accident insurance, hospital indemnity insurance, and a 401(k) plan with immediate vesting, among others.

Candidates must be at least 18 years of age and legally authorized to work in the United States on a permanent basis without current or future visa sponsorship.