Enterprise Data Engineer

Greenwood Industries LLC; Worcester (MA); On-site; USD 110,000 - 160,000; Full time

Benefits offered by this job

Medical Coverage through BCBS

401(k) with company match

Paid time off

Disability insurance

Dental and Vision Insurance

FSA

Employee Assistance Program (EAP)

Job summary

Greenwood Industries LLC is seeking an Enterprise Data Engineer for on-site work in Worcester, MA. You will design and operate the enterprise data environment, build scalable data pipelines, and ensure trusted datasets to support reporting, analytics, and BI initiatives.

You will collaborate with business and technology teams, integrate data across ERP/CRM/HRIS systems, and help standardize data elements across new branches and acquisitions. Strong SQL, BI, and cloud skills are required.

Qualifications

• 5+ years of experience in Data Engineering, Data Integration, or BI.
• Bachelor’s degree in Computer Science, Information Systems, Data Analytics, or related field, or equivalent experience.
• Advanced SQL skills with design, optimization, and troubleshooting of complex queries.
• Experience with Power BI or similar BI platforms.
• Experience with cloud-based data services (Microsoft Azure a plus).
• Experience with data pipelines and transformation tools (Databricks, Fivetran, dbt).
• Experience with data modeling for data warehouses, data lakes, or modern analytics platforms.
• Data quality, governance, and validation processes.
• Python for data transformation and automation.
• Experience integrating ERP/CRM/HRIS platforms and REST APIs.

Responsibilities

• Design, develop, and maintain enterprise data pipelines across ERP, CRM, HRIS, and other apps.
• Translate business needs into scalable data solutions and meaningful insights.
• Create clean, reliable, and scalable datasets for reporting and BI.
• Design data models to enable accurate, timely reporting.
• Develop integrations between enterprise apps using APIs and database connections.
• Collaborate with tech and business stakeholders to ensure data quality and accessibility.
• Support migrations and acquisitions with data mapping and transformation.
• Monitor data quality, governance, and documentation across sources.
• Troubleshoot data integration and reporting issues.
• Partner with Finance, Operations, Sales, HR, and IT to deliver data solutions.

Skills

Advanced SQL

Power BI

Azure cloud

ETL pipelines

Data modeling

Python

REST APIs

Git

Data governance

Communication

Education

B.S. in Computer Science

Tools

Databricks

Fivetran

dbt

Job description

Greenwood Industries is a leading provider of custom building envelope solutions, including commercial roofing, architectural metal, waterproofing, masonry, maintenance, and historic restoration.

Through our growing family of market-leading specialty contractors, we continue to expand our expertise and regional reach across the Northeast. When you join the Greenwood family of brands, you’ll find a culture that puts family and craftsmanship first, while offering a rewarding career and professional growth.

As an Enterprise Data Engineer, you will meet with business leaders to understand how they are running their business and the data and dashboards needed for data driven decisions. You will design, develop, administer, and operate Greenwood’s enterprise data environment and associated technologies. You will design and maintain scalable data pipelines, enterprise data models, and trusted datasets that support the Company’s reporting, analytics, and business intelligence initiatives.

You will work closely with business and technology teams to integrate data across enterprise applications, ensuring data quality, consistency, and accessibility. As Greenwood continues to grow through acquisitions and national expansion, the Enterprise Data Engineer will play a critical part in ensuring newly integrated branches adopt common data elements, workflows, and reporting structures. The position will support scalable system architecture, integrated software systems, and operational visibility across all divisions.

This role is on-site in Worcester, MA.

Key Responsibilities

• Design, develop, and maintain enterprise data pipelines supporting ERP, CRM, HRIS, and other business applications.
• Translate business requirements into scalable data solutions to provide meaningful insights and support informed decision-making across the organization
• Develop and maintain clean, reliable, and scalable datasets to support reporting, analytics, and business intelligence initiatives.
• Design and optimize data models that enable accurate, timely, and consistent reporting across the organization.
• Develop and maintain integrations between enterprise applications using APIs, database connections, and other modern integration methods.
• Collaborate effectively with both technical and non-technical stakeholders, including business stakeholders, application owners, and third-party SaaS providers to understand data requirements and ensure data quality, integrity, and consistency.
• Support enterprise application implementations, acquisitions, and system migrations through data mapping, transformation, validation, and conversion activities.
• Monitor and improve data quality, governance, and documentation across enterprise data sources.
• Troubleshoot and resolve data integration, transformation, and reporting issues.
• Partner with Finance, Operations, Sales, HR, and IT to deliver scalable data solutions that support business decision-making.
• Ensure enterprise data solutions adhere to company security, privacy, and compliance standards.

Applicants must be authorized to work for any employer in the U.S. We are unable to sponsor or take over sponsorship of an employment visa for this position.

Qualifications

• 5+ years of experience in Data Engineering, Data Integration, or Business Intelligence.
• Bachelor’s degree in Computer Science, Information Systems, Data Analytics, or a related technical field, or equivalent combination of education and experience.
• Advanced SQL skills with experience designing, optimizing, and troubleshooting complex queries.
• Experience developing enterprise reporting and analytics solutions using Microsoft Power BI or similar BI platforms.
• Experience working with cloud-based enterprise applications and data services (Microsoft Azure experience is a plus).
• Experience with data pipeline and transformation tools (e.g., Databricks, Fivetran, dbt, or similar technologies).
• Experience with enterprise data modeling and designing data warehouses, data lakes, or modern analytical data platforms.
• Experience implementing data quality, data governance, and data validation processes.
• Experience developing data transformation and automation solutions using Python.
• Experience integrating enterprise applications, including ERP, CRM, and HRIS platforms (e.g., NetSuite, Salesforce, Dayforce, or similar).
• Experience working with REST APIs, JSON, XML, and modern data integration methods.
• Experience using Git or other version control systems.
• Excellent communication and interpersonal skills with the ability to effectively collaborate with both technical and non-technical stakeholders.
• Strong analytical, problem-solving, and organizational skills with exceptional attention to detail.
• Ability to manage multiple priorities, work independently, and deliver high-quality solutions in a fast-paced environment.
• Experience supporting enterprise application implementations, system migrations, and acquisitions is preferred.

At Greenwood, our benefits prioritize your health, financial security, and overall well-being:

• Medical Coverage through Blue Cross Blue Shield with No Deductible
• 401(k) Retirement Plan with Company Match
• Generous Paid Time Off - Vacation, Sick, and 10 paid company holidays
• Company-Paid Short-Term and Long-Term Disability Insurance
• Comprehensive Blue Cross Dental and Vision Insurance
• Pre-Tax Flexible Spending Accounts (FSA)
• Employee Assistance Program (EAP)

The salary and benefits represent what is expected for this role at the time of posting. Compensation offered may be influenced by a variety of factors including work experience, qualifications, industry experience, market and business considerations, and internal equity, among other factors.

Greenwood Industries is an Equal Opportunity Employer. We consider all qualified applicants for employment regardless of race, color, religion, sex, gender identity, sexual orientation, age, national origin, protected veteran status, disability, or any other basis protected by federal, state, or local law.

It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability.