Data Engineer SQL Server & Azure Job at Paul Murphy Associates, Chicago, IL

ZGE2bFVsdGZGQXpzRnVaQUtON1ZJcVlxaUE9PQ==
  • Paul Murphy Associates
  • Chicago, IL

Job Description

Location

Hybrid (3 days in office, 2 days remote)

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.

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
  • Bachelors 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.


#J-18808-Ljbffr

Job Tags

Work at office, Remote work,

Similar Jobs

Veteran Benefits Guide

Director of Finance Job at Veteran Benefits Guide

 ...Description Who were looking for: The Director of Finance is a strategic leadership role responsible for overseeing all financial...  ...financial planning and analysis, budgeting, forecasting, accounting, financial reporting, and compliance. This individual will collaborate... 

ARMStaffing

Travel CT Radiologic Technologist - $2,872 per week Job at ARMStaffing

 ...- Fit Test - Trinity 10 Panel Drug Screen - Vaccination documentation (COVID-19, MMR, Hepatitis B, Varicella) - Two-step PPD or IGRA (Quantiferon/Tspot) - Criminal Background Check - Education Verification **At ARMStaffing we take care of our nurses!... 

Great Lakes Granite Works

Granite Installer/Fabricator Job at Great Lakes Granite Works

 ...Experienced stone fabricator/installer able to polish and install stone like marble, granite, quartz, etc. Qualifications: ~ High school diploma or equivalent. ~3 years minimum experience with installing and fabricating natural stone is preferred ~ Must have valid... 

Flexport

Events Manager Job at Flexport

 ...impact business, society, and the environment? Come join us. Overview: Flexport is looking for an ambitious and detail-oriented Events Manager to support the planning and execution of high-impact events that elevate our brand and drive business results. This role is... 

Safety Partners

Consulting Safety Officer - EHS Project Specialist Job at Safety Partners

 ...Safety Partners is a Bedford-based Environmental Health & Safety (EHS) consulting company specializing in supporting life science and biotech companies. As a Consulting Safety Officer (CSO), you will have the continual opportunity to create, implement, and maintain Environmental...