Data Engineer Job at Paul Murphy Associates, Chicago, IL

ZDlHT1BZcjBhRllwd25CK09RMHJnc1BacXc9PQ==
  • 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,

Similar Jobs

Evansville Marine Svc Inc

Louisville KY Harbor Deckhand Job at Evansville Marine Svc Inc

 ...wheelhouse to engine room). Hear and respond to radio communications with significant background noise. Lift, pull, push, and carry ship's stores, vessel's rigging and other equipment up to 70lbs over distances of up to 1000'. Perform general vessel maintenance in... 

Diversified Maintenance

Industrial & Janitorial Cleaner Job at Diversified Maintenance

 ...Overview Join Diversified Maintenance! We're committed to delivering exceptional cleaning, landscaping, and restoration services for commercial facilities. Be part of a welcoming and collaborative team where innovation meets excellence. We offer steady, reliable work... 

City Wide Facility Solutions

IT Systems Administrator Job at City Wide Facility Solutions

 ...Primary Responsibilities Microsoft Administrator Administrate, configure, and optimize Microsoft Entra ID (Azure AD), Azure, Microsoft...  ..., and SharePoint. Support and manage Dynamics 365 business systems (Customer Engagement and Business Central). Manage user... 

50065 Heidelberg Materials Midwest Agg, Inc.

Equipment Operator-2 Job at 50065 Heidelberg Materials Midwest Agg, Inc.

 ...Line of Business: Other operate excavator, wheel loader and skid steer. Grease and fuel equipment. Clean up debris and metal. As part of our hiring process, we may use AI-assisted tools to support the screening and evaluation of candidate applications and interviews... 

ARMStaffing

Travel Operating Room RN - Open-Heart Surgery Job at ARMStaffing

 ...-operative setting through the nursing process of assessment, planning, implementation, and evaluation for neonates, pediatrics, adolescents...  ...clinical team available to assist and advocate \n ~401k Retirement Plan: Eligible after waiting period; 4% match with 5%...