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

TekTronIT LLC

AWS Data Engineer Job at TekTronIT LLC

 ...Job Title: AWS Data Engineer Employment Type: Full-Time, Permanent Location: Remote (United Kingdom) Experience Range: 1 15 Years...  ...remote within the UK and is open to professionals at varying levels of experience, from early-career engineers to senior... 

Grifols, S.A

Senior Injection Molding Supplier Quality Engineer Job at Grifols, S.A

 ...healthcare company is seeking a Senior Supplier Quality Engineer in San Diego, CA. The role involves overseeing supplier quality for injection molding materials, ensuring compliance, and leading cross-functional teams. Ideal candidates have a Bachelor's degree in a related... 

Auffenberg Dealer Group

Parts Delivery Driver Job at Auffenberg Dealer Group

We're looking to add Parts Delivery Drivers to the Auffenberg Dealer Group team for all OEMs; Nissan, VW, CDJR, Mazda, KIA, Ford.Benefits:...  ...clean Drivers Abstract (driving record)* Have knowledge with auto parts* Are able to work in a fast-paced work environment... 

Crime Scene Resources, Inc

Crime Scene Investigator I-II Job at Crime Scene Resources, Inc

 ...similar, related, or a logical assignment for this classification. Other duties may be required and assigned. Crime Scene Investigator I Keeps the mission, vision, and values of the City of Port St. Lucie at the forefront of decision making and action; builds strategic... 

Ironwood Grill

LINE COOK Job at Ironwood Grill

 ...team at Ironwood Grill, where we are passionate about delivering delicious food and exceptional service. As a highly skilled Line Cook, you will have the opportunity to learn and grow in the fast-paced food and beverage industry. Enjoy a flexible schedule while...