Join Amplifi as a Data Engineer to design, build, and maintain scalable data pipelines and modern data warehouses. This full-time role offers a hybrid/remote work arrangement with a preferred location in Wisconsin and an anticipated salary of $115,000 – $160,000 per year.
Requirements
4+ years of experience in a data engineering or related software engineering role.
Proficiency in SQL and Python.
Strong experience with Snowflake and MSSQL Server.
Practical knowledge of Microsoft Azure and cloud data platforms.
Preferred experience includes Databricks, Azure Data Factory, DBT, and Microsoft Fabric.
Skills & Responsibilities
SQL and Python: Write clean, efficient, and testable code for data manipulation, transformation, automation, and scripting.
Snowflake and MSSQL Server: Build and maintain data models and warehouse layers enabling high-performance analytics and reporting.
Azure Data Factory and DBT: Support deployment, orchestration workflows, and modern data transformation logic.
CI/CD and Data Governance: Contribute to CI/CD practices, data pipeline observability, and ensure data security and compliance.
Potential transition routes: People from software engineering, database administration, or business intelligence roles may bring transferable programming and data management skills, alongside meeting the required SQL and Python experience.
Job description
About us
Amplifi is a full-service data and AI consultancy with deep expertise across multiple data disciplines throughout North America and EMEA. We work as one team to solve our clients’ most complex data challenges. While others talk about the potential of data and AI, we help organizations realize it. We partner with some of the world’s largest brands to evolve, adapt, and modernize how they operate through practical, results-driven solutions. At Amplifi, we take pride in delivering measurable value and tackling both technical and business challenges head-on. We’re looking for collaborative, growth-minded individuals who are eager to learn, grow, and mentor others as part of the Amplifi team.
Position Summary
The Data Engineer will be responsible for designing, building, and maintaining scalable, secure data pipelines that drive analytics and support operational data products. The ideal candidate brings a strong foundation in SQL, Python, and modern data warehousing with a deep understanding of Snowflake, Databricks, or Microsoft Fabric, and a solid understanding of cloud-based architectures.
What You Will Get To Do
Design, develop, and optimize robust ETL/ELT pipelines to ingest, transform, and expose data across multiple systems.
Build and maintain data models and warehouse layers, enabling high-performance analytics and reporting.
Collaborate with analytics, product, and engineering teams to understand data needs and deliver well-structured data solutions.
Write clean, efficient, and testable code in SQL and Python to support automation, data quality, and transformation logic.
Support deployment and orchestration workflows, using Azure Data Factory, dbt, or similar tools.
Work across multi-cloud environments (Azure preferred; AWS and GCP optional) to integrate data sources and manage cloud-native components.
Contribute to CI/CD practices and data pipeline observability (monitoring, logging, alerting).
Ensure data governance, security, and compliance in all engineering activities.
Support ad hoc data science and machine learning workflows within Dataiku.
What You Bring to the Team
4+ years of experience in a data engineering or related software engineering role.
Proficiency in SQL and Python for data manipulation, transformation, and scripting.
Strong experience working with Snowflake and MSSQL Server.
Practical knowledge of working with cloud data platforms, especially Microsoft Azure.
Experience with modern data modeling and warehouse optimization techniques.
Experience with Databricks, Azure Data Factory, or DBT preferred.
Exposure to Microsoft Fabric components like OneLake, Pipelines, or Direct Lake.
Familiarity with cloud services across AWS, GCP, or hybrid cloud environments.
Understanding of or curiosity about Dataiku for data science and advanced analytics collaboration.
Ability to work independently and with a team in a hybrid/remote environment.
Compensation & Work Location
The preferred location for this role is Wisconsin, and the anticipated salary range is $115,000 – $160,000. Final compensation will be based on the candidate’s skills, experience, and work location. A candidate’s compensation may also include bonuses consistent with Amplifi’s corporate bonus plan.
Travel
Ability to travel up to 10% of the time.
Benefits
Amplifi offers excellent compensation and benefits including, but not limited to, health, dental, 401(k) program, employee assistance program, short and long-term disability, life insurance, accidental death and dismemberment (AD&D), PTO program, flex work schedules and paid holidays.
Equal Opportunity Employer
Amplifi is proud to be an Equal Opportunity Employer. We consider all qualified applicants without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, veteran status, or other protected characteristics.
