5-8 years of relevant experience, preferably in Data Engineering or ETL Testing.
Expert in SQL and Python for data manipulation and automation.
Familiarity with data quality frameworks such as dbt and Great Expectations.
Experience with data visualization tools like Power BI or Tableau.
Hands-on with cloud platforms including Snowflake and AWS.
Responsibilities
Analyze data sources for structure and quality, identifying data anomalies.
Design and implement automated testing frameworks for ETL data workflows.
Develop reusable data quality rules and monitoring systems for real-time issue detection.
Investigate data discrepancies and collaborate with engineering teams for resolution.
Work as a liaison to align business data requirements with technical solutions.
Ensure data handling practices comply with regulations such as GDPR or HIPAA.
Benefits
Opportunity to work with cutting-edge technology and data solutions.
Collaborative team environment focusing on professional growth.
Exposure to a variety of industries and data challenges.
Work-life balance initiatives to support employee well-being.
Full Job Description
Ampcus Inc. is a certified global provider of a broad range of Technology and Business consulting services. We are in search of a highly motivated candidate to join our talented Team.
Job Title: Data Quality Engineer. Location: Milwaukee, WI.
Key Responsibilities:
Data Profiling & Assessment: Analyzing data sources to understand structure, content, and quality; identifying anomalies, duplicates, or missing values.
Automated Testing: Designing and implementing automated data validation frameworks (e.g., dbt tests, Great Expectations) within ETL pipelines.
Framework Development: Building reusable data quality rules and monitoring systems to detect issues in real-time.
Root Cause Analysis: Investigating why data discrepancies occur and working with engineering teams to drive permanent resolutions.
Stakeholder Liaison: Bridging the gap between business requirements (what "good data" looks like for a product) and technical implementation.
Governance & Compliance: Ensuring data handling meets regulatory standards like GDPR or HIPAA, including implementing data masking and lineage.
Required Technical Skills:
Languages: Expert-level SQL for complex querying and Python for automation scripting.
Data Quality Tools: Proficiency in frameworks like dbt, Great Expectations, Soda, Monte Carlo, or Informatica Data Quality, Databricks, Snowflakes.
Data Visualization: Proficiency in Power BI, Tableau.
Cloud Platforms: Hands-on experience with modern data stacks like Snowflake, AWS (Redshift/S3), Azure, or Databricks.
Big Data Tech: Knowledge of Spark, Hadoop, Kafka, or Airflow for managing and monitoring large-scale pipelines.
Preferred Qualifications:
Experience: Typically, 3-8 years in Data Engineering, ETL Testing, or a specialized Data Quality role.
Education: A degree in Computer Science, Data Science, or a related technical field.
Soft Skills: High attention to detail, strong communication for explaining technical issues to non-technical stakeholders, and critical thinking for spotting hidden patterns.
Ampcus is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, protected veterans or individuals with disabilities.
