Data Engineer

As a Data Engineer with WesTech, you will design, develop, and optimize scalable data solutions that support enterprise reporting, analytics, and operational decision-making. This role builds reliable data pipelines, implements dimensional data models, and partners with business stakeholders to deliver trusted datasets and analytics capabilities. The ideal candidate brings hands-on experience with modern data engineering tools and practices, including dbt, Microsoft Fabric, and Kimball dimensional modeling methodologies.

Candidates for this position may be required to pass pre-employment and periodic screenings, including background checks, drug and alcohol tests, or other necessary assessments.

Some of the work you will do:

• Design, develop, and maintain scalable data transformation pipelines using dbt.
• Build and optimize data solutions within Microsoft Fabric.
• Develop dimensional models and enterprise data marts using Kimball methodology.
• Collaborate with analysts, business stakeholders, and technical teams to gather requirements and deliver data solutions.
• Implement data quality checks, testing, and monitoring processes.
• Troubleshoot and resolve data pipeline performance and reliability issues.
• Support CI/CD, deployment, and source control processes for analytics engineering workflows.
• Improve documentation standards for data lineage, business rules, and technical architecture.
• Contribute to data governance and master data management initiatives.

Do you have experience in Version control?, Do you have a Bachelor’s degree?, * Bachelor’s degree in a related field, equivalent practical experience, and/or relevant technical certifications.

• 2-3 years of experience in data engineering, analytics engineering, software development, business intelligence, or a related technical role.
• Hands-on experience building ETL/ELT pipelines, enterprise data models, and enterprise reporting or analytics solutions.
• Strong SQL development and query optimization skills, with experience analyzing complex data issues and implementing scalable solutions.
• Experience using dbt in a production environment and working with data warehousing, ELT architecture, and data pipeline orchestration.
• Experience with Microsoft Fabric or related Microsoft data technologies, as well as cloud-based analytics platforms.
• Strong understanding of Kimball dimensional modeling principles.
• Experience with Git, source control, and development lifecycle practices.
• Strong communication and stakeholder collaboration skills.

Here are the skills and qualifications that will set you apart:

• Experience with Python for automation, data processing, or analytics.
• Exposure to data science, forecasting, or machine learning workflows.
• Experience with Power BI or enterprise BI platforms.
• Familiarity with ERP systems such as Business Central, SAP, Oracle, or similar enterprise systems.
• Experience working in manufacturing, engineering, supply chain, construction, or project-based industries.

Physical Requirements:

• Ability to sit at workstation using computer/phone.
• Frequently required to sit, talk, hear, and see. Specific vision abilities required by this job include close vision and distance vision.
• Regularly required to move around the facility.
• Occasionally required to lift and/or move up to 50 pounds

Pulled from the full job description

• Tuition reimbursement
• Paid parental leave
• AD&D insurance
• Parental leave
• Health insurance
• 401(k) matching
• Paid time off, * Competitive salary and performance-based annual bonuses.
• Dollar for dollar 401K match of 6%.
• Flexible work hours, hybrid schedules with remote work options.
• Comprehensive health and wellness benefits package with an onsite and virtual medical facility
• Company HSA contribution, Paid Parental Leave, Employee Assistance Program
• Company-paid Life Insurance, Accidental Death and Dismemberment, and Long-term Disability.
• PTO plan and Paid Holidays.
• Tuition Reimbursement.
• Company celebrations, summer parties, volunteer opportunities, games, prize drawings, and more!

Our mission at WesTech is to help communities thrive by delivering high-quality water solutions with superior service - safely and sustainably. To achieve this mission, we recruit great people to be part of our collegial and collaborative teams in engineering, design, project management, field service, plant operations, professional services and more.

As one of the leading operating brands of Swire Water, our values of integrity, humility, endeavor, excellence and continuity make this an outstanding working environment. Our continuing success creates attractive opportunities for purpose-driven professionals to develop new skills, support vital industries, and grow their careers.