Data Engineer

Pyramid Consulting, Inc; Ann Arbor (MI); On-site; USD 66,000 - 72,000; Full time

Benefits offered by this job

Health insurance

401(k)

Paid sick leave

Job summary

Pyramid Consulting, Inc. is seeking a Data Engineer for a 06+ months contract in Ann Arbor, MI (onsite). You will design and maintain robust data pipelines and ETL/ELT workflows to support analytics and reporting.

Required skills include Python, PySpark, Azure Databricks, Data Factory, SQL, and data governance. Strong problem solving and communication are essential. Competitive hourly pay plus health, 401(k) and paid leave.

Qualifications

• 5+ years of experience with Python, PySpark, and Azure data services.
• Strong SQL skills and hands-on Azure Databricks experience.
• Experience with data governance, REST APIs, and Git/GitLab.
• Excellent problem solving and communication skills.

Responsibilities

• Design, develop, and maintain robust data pipelines and ETL/ELT workflows.
• Build scalable pipelines and process large datasets.
• Collaborate with analysts, scientists, and stakeholders for reporting.
• Maintain documentation and data governance standards.
• Optimize queries and pipeline performance.
• Implement data validation, monitoring, and error handling.
• Integrate data from multiple sources including databases and APIs.
• Develop and maintain data warehouses, data lakes, and data models.

Skills

Python

PySpark

Analytical skills

Communication skills

Tools

Azure Databricks

Azure Data Factory

Unity Catalog

Azure Data Lake Storage

SQL

Git/GitLab

REST APIs

Data governance

Job description

Immediate need for a talented Data Engineer. This is a 06+months contract opportunity with long-term potential and is located in Ann Arbor, MI(Onsite). Please review the job description below and contact me ASAP if you are interested.

Job ID: 26-32822

Pay Range: $48/hr - $52/hour. Employee benefits include, but are not limited to, health insurance (medical, dental, vision), 401(k) plan, and paid sick leave (depending on work location).

Key Responsibilities:

• Design, develop, and maintain robust data pipelines and ETL/ELT workflows.
• Build scalable ETL/ELT pipelines and process large datasets.
• Collaborate with data analysts, data scientists, and business stakeholders to support reporting and analytics.
• Maintain technical documentation and follow data governance and security standards.
• Optimize queries and pipeline performance for scalability and efficiency.
• Implement data validation, quality checks, monitoring, and error-handling mechanisms.
• Integrate data from multiple sources, including databases, APIs, and enterprise applications.
• Develop and maintain data warehouses, data lakes, and data models.

Key Requirements and Technology Experience:

• Years of strong experience in Python, PySpark, Azure Databricks, Azure Data Factory, Unity Catalog, Azure Data Lake Storage, and ETL/ELT.
• Proficiency in SQL and strong hands-on experience with Azure Databricks.
• Familiarity with Git/GitLab, REST APIs, and data governance.
• Strong troubleshooting, analytical, and communication skills.

Our client is a leading IT Industry, and we are currently interviewing to fill this and other similar contract positions.

Pyramid Consulting, Inc. provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.