Data Engineer - Solutions Provider

Hamilton Barnes Associates Limited; Oregon (WI); On-site; USD 110,000 - 150,000; Full time

Benefits offered by this job

Medical Benefits

Dental Benefits

Vision Benefits

EAP

FSA

PTO & Holidays

401(k) & Profit Sharing

Job summary

Hamilton Barnes Associates Limited seeks a Cloud Engineer to design, implement, and support complex data pipelines and cloud data solutions for a diverse client base. The role emphasizes building and maintaining Microsoft Fabric, Azure Synapse Analytics, and Snowflake data warehouses, with strong SQL development and ETL/ELT responsibilities.

You will collaborate with BI developers and business stakeholders, ensuring data quality, governance, and security while evolving data architectures and

Qualifications

• Strong experience with Microsoft Fabric and data platforms.
• Hands-on Azure Synapse Analytics experience.
• Experience building Snowflake solutions.
• Advanced SQL development and performance tuning.
• Experience developing ETL/ELT data pipelines.
• Strong understanding of relational databases.
• Experience integrating data from multiple sources.
• Knowledge of data modeling and warehouse design.
• Experience with Microsoft Azure services.
• Understanding of data governance and security.
• Strong troubleshooting and analytical skills.
• Excellent communication and collaboration skills.

Responsibilities

• Design, build, and maintain scalable data pipelines.
• Develop and optimize Microsoft Fabric data solutions.
• Build and support Azure Synapse Analytics environments.
• Design and maintain Snowflake data warehouses.
• Create and optimize complex SQL queries and stored procedures.
• Integrate data from multiple cloud and on-premises sources.
• Develop ETL/ELT processes for enterprise data platforms.
• Monitor, troubleshoot, and optimize data pipeline performance.
• Ensure data quality, integrity, and governance standards.
• Collaborate with BI developers and business stakeholders.
• Support reporting and analytics initiatives across the organization.
• Document data architecture, processes, and best practices.
• Implement data security and access controls.
• Participate in architecture discussions and technical planning.
• Stay current on Microsoft and cloud data technologies.

Skills

Microsoft Fabric

Azure Synapse

Snowflake

SQL optimization

ETL/ELT pipelines

Relational databases

Data integration

Data modeling

Azure services

Data governance

Problem solving

Communication

Job description

Our client is an established technology solutions provider that helps organisations design, deliver and support complex IT infrastructure. Their expertise spans enterprise networking, cloud, cybersecurity, data centre technologies and managed services, delivering tailored solutions that keep businesses secure, connected and prepared for future growth.

Taking a consultative, engineering-led approach, they partner closely with customers throughout the entire technology lifecycle, from design and implementation through to ongoing support and optimisation. This is an opportunity to join a collaborative business with a strong technical reputation, where engineers are trusted to make an impact while continuing to develop their careers.

They are now seeking a Cloud Engineer to design, implement, and support complex network solutions for a diverse client base.

Responsibilities

• Design, build, and maintain scalable data pipelines.
• Develop and optimize Microsoft Fabric data solutions.
• Build and support Azure Synapse Analytics environments.
• Design and maintain Snowflake data warehouses.
• Create and optimize complex SQL queries and stored procedures.
• Integrate data from multiple cloud and on-premises sources.
• Develop ETL/ELT processes for enterprise data platforms.
• Monitor, troubleshoot, and optimize data pipeline performance.
• Ensure data quality, integrity, and governance standards.
• Collaborate with BI developers and business stakeholders.
• Support reporting and analytics initiatives across the organization.
• Document data architecture, processes, and best practices.
• Implement data security and access controls.
• Participate in architecture discussions and technical planning.
• Stay current on Microsoft and cloud data technologies.

Skills/Must have

• Strong experience with Microsoft Fabric.
• Hands-on Azure Synapse Analytics experience.
• Experience building solutions in Snowflake.
• Advanced SQL development and performance tuning.
• Experience developing ETL/ELT data pipelines.
• Strong understanding of relational databases.
• Experience integrating data from multiple sources.
• Knowledge of data modeling and warehouse design.
• Experience with Microsoft Azure services.
• Understanding of data governance and security.
• Strong troubleshooting and analytical skills.
• Excellent communication and collaboration skills.

Benefits

• Medical, dental, vision, Employee Assistance Program, and Flexible Spending Accounts
• Life and AD&D insurance, disability coverage, critical illness, and accident insurance
• Paid Time Off (PTO) and paid holidays
• Company-matching 401(k) and profit sharing

Salary

• $130,000 Base