Data Engineer Job at Paul Murphy Associates, Chicago, IL

cXQxWXh4U0dyM3pVbm1nTXd2aUx2Vlp1UWc9PQ==
  • Paul Murphy Associates
  • Chicago, IL

Job Description

Job Title: Data Engineer Location: Hybrid (3 days in office, 2 days remote)

Job Overview:

As a Data Engineer , you will be responsible for designing, developing, and maintaining robust and scalable database solutions to support business operations. This role requires strong expertise in SQL Server, database modeling, database design, and performance optimization. You will collaborate across teams to translate complex business requirements into effective technical solutions. Additionally, you will work on database design from the ground up and leverage tools like SSIS to support various data-related processes.

Key Responsibilities:

  • Design and implement modern data architectures including data lakes, lakehouses, and streaming data platforms using tools such as Azure Synapse, Databricks, or Snowflake.
  • Build and optimize data pipelines using Python, SQL, Spark, and orchestration tools like Airflow or Azure Data Factory.
  • Act as a hands-on SQL developer working on data ingestion (ADF), transformation, and integration workflows across structured and semi-structured sources.
  • Write and maintain robust, testable code (Python) for data processes and infrastructure (SQL stored procedures, Python scripts, infrastructure as code).
  • Partner with analytics and product teams to enable self-service data access, data modeling, and BI solutions (PowerBI).
  • Implement data governance, security, lineage, and compliance practices using tools like Azure Purview.
  • Support CI/CD practices for data solutions, including automated testing, deployment, and monitoring.

Qualifications:

  • Bachelor’s degree in Computer Science, Information Technology, or a related field.
  • Strong experience in SQL Server development and administration.
  • Proven experience designing and modeling relational databases from the ground up.
  • Proficiency in writing and optimizing complex SQL queries.
  • Experience using SSIS for database-related tasks.
  • Experience with Azure cloud platform for database solutions – Databricks, Synapse, Purview
  • Experience with database migration and integration projects.
  • Strong analytical thinking and attention to detail.
  • Excellent communication and teamwork skills.

Job Tags

Work at office, Remote work,

Similar Jobs

Petsmart

Only Natural Pet- Assistant Store Leader Job at Petsmart

 ...Only Natural Pet - Assistant Store Leader Only Natural Pet is a leading supplier in the natural pet supplies marketplace. Founded in 2004 in Boulder, Colorado, as an e-commerce business we now make 200 of our own highly popular Only Natural Pet branded products, including... 

Camaco, LLC

HR Generalist Job at Camaco, LLC

 ...needed (reviews applications, interviews, etc.)# Assists with onboarding and new hire orientation. # Acts as an employee relations specialist. # Weekly payroll through ADP. # Manages temp to hire program. # Monitors tardy and absenteeism report and ensures proper... 

The Smilist

Dental Assistant Job at The Smilist

 ...to provide high quality dental care in a warm,...  ...better one smile at a time. We are currently seeking...  ..., and motivated Dental Assistant to join our growing practice...  ...Qualifications: Proven experience as a Dental Assistant -...  ...Details: Schedule:Part Time - Thursdays,... 

The Gents Place

Remote Live Chat Agent Job at The Gents Place

We are looking for a Remote Live Chat Agent to join our customer support team. In this role, you will assist customers through live chatproviding fast, clear, and helpful responses to inquiries, issues, and support requests. Youll be the first point of contact for many... 

ALONJA Enterprises LLC

Customer Support Specialist 2 Job at ALONJA Enterprises LLC

 ...customers across various client accounts. This is a flexible, work-from-home role ideal for individuals with strong communication skills...  ...computer use Flexible schedule availability, including evenings/weekends Technology Requirements (MANDATORY to...