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

Global Nexus HR service

Director of Government Relations Job at Global Nexus HR service

 ...to maintain positive relationships between the organization ( government agency, corporation, or nonprofit) and government entities, policymakers...  ...or concerns from government bodies, media, or the public related to organizational policies, ensuring consistent and compliant... 

CF Industries

Accountant Job at CF Industries

 ...world's transition to clean energy. Function: Finance & Accounting Job Summary: The Accountant prepares and focuses on preparing...  ...'s Degree in accounting; 1 - 3 years' accounting experience CPA candidate preferred Have strong analytical and problem-... 

LifePoint

Travel Nurse RN - Case Management Job at LifePoint

 ...Registered Nurse, Compact state, CCM/ACM preferred Years of Experience: 5 Float Requirements: None Additional Notes: InterQual, discharge planning, Conditions of Participation, CMS guidelines, required.MorCare preferred. UTILIZATION REVIEW EXPERIENCE REQUIRED... 

VAinUSA

Medical Biller - Insurance Claims & Collections Job at VAinUSA

 ...are seeking a skilled and compassionate **Medical Biller** to manage insurance claims,...  ...candidate will bring not only extensive billing experience but also strong patient-facing...  ...independently in a **remote, permanent work-from-home** environment. **Why Join Us?***... 

Buona Forchetta

Dishwasher Job at Buona Forchetta

 ...Job Description Job Description Dishwasher Were on the lookout for a reliable, hardworking Dishwasher to join our friendly team at our casual dining restaurant. If youre someone who takes pride in keeping things clean and organized, and youre looking to get...