ECC · 11 hours ago
Analytics Engineer I
ECC provides essential environmental, construction, and disaster response services, relying on its Data Science & Analytics Team for enterprise data pipelines, automation, Power BI datasets, and AI initiatives. As an Analytics Engineer, you transform data and technology into actionable insights to drive growth and improve performance, designing and maintaining data infrastructure while collaborating with business units to optimize key performance indicators.
ConstructionConsulting
Responsibilities
Design, develop, and maintain Azure-based ELT pipelines to ingest, clean, transform, and publish data. Ensure robust data quality, monitoring, and governance standards
Improve efficiency and scalability of SQL queries, stored procedures, and Spark/PySpark/Databricks jobs
Create Python automation scripts for API ingestion, web scraping, and scheduled data updates. Integrate external data sources securely into Azure Data Lake and Azure SQL
Build and publish enterprise datasets using star schema design, row-level security, incremental refresh, and deployment pipelines. Partner with BI analysts to enhance refresh times and model reliability
Develop and deploy machine learning models for business insights, leveraging modern AI frameworks and tools. Collaborate on research into advanced analytics and predictive modeling pipelines, aligning solutions with industry best practices and integrating them with data lake and data warehouse environments
Engage with HR, Operations, Scheduling, and Finance teams to define data requirements and participate in code reviews, contributing to shared repository standards
Proactively identify opportunities and initiate actions that drive progress, without waiting for direction
Apply strategic and holistic thinking to project work, keeping in mind how individual actions contribute to the organization’s long-term goals and success
Maintain thorough documentation, runbooks, monitor dashboards, and architecture diagrams. Provide support for production pipelines during deployments and major program cycles
Qualification
Required
Bachelor's degree in computer science, Information Systems, Engineering, Data Science, or a related field with at least 2 years of professional experience in data engineering, BI engineering, or analytics engineering; or a master's degree in one of these fields with at least 1 year of professional experience
Strong SQL includes window functions, performance tuning, and relational modeling
Hands‑on experience with Azure (ADF/Synapse, ADLS, Azure SQL, Key Vault, Functions, Fabric, Purview)
Proficient in Python for data analysis, automation, APIs, and scraping frameworks
Power BI dataset modeling experience (DAX fundamentals, RLS, incremental refresh)
Experience with Git and CI/CD pipelines
Understanding of data quality, observability, and structured documentation
Benefits
Medical/Dental/Prescription/Vision Insurance
Life Insurance, Long Term Disability Insurance
Paid Time off and Holiday Pay
401k with deferral matching, ESOP, Student Debt Reduction Program
Flexible Spending Accounts (FSA)
Educational Assistance, Mentorship Program, ECC University
Employee Referral Bonus Program
Company-matching charitable giving program
Company
ECC
ECC is an employee-owned company that consistently ranks among the top construction & environmental companies in the world.
H1B Sponsorship
ECC has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2024 (1)
Funding
Current Stage
Growth StageRecent News
yicaiglobal.com
2025-07-19
2024-10-11
Company data provided by crunchbase