{"schemaVersion":"jobsearcher.job.v1","id":"bea33f3a588264b729f6f026","url":"https://jobsearcher.com/jobs/bea33f3a588264b729f6f026","canonicalUrl":"https://jobsearcher.com/jobs/bea33f3a588264b729f6f026","title":"Data Engineer - SQL Server & Azure","description":"Location\r\nHybrid (3 days in office, 2 days remote)\r\nOverview\r\nAs 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.\r\nResponsibilities\r\nDesign and implement modern data architectures including data lakes, lakehouses, and streaming data platforms using tools such as Azure Synapse, Databricks, or Snowflake.\r\nBuild and optimize data pipelines using Python, SQL, Spark, and orchestration tools like Airflow or Azure Data Factory.\r\nAct as a hands-on SQL developer working on data ingestion (ADF), transformation, and integration workflows across structured and semi-structured sources.\r\nWrite and maintain robust, testable code (Python) for data processes and infrastructure (SQL stored procedures, Python scripts, infrastructure as code).\r\nPartner with analytics and product teams to enable self-service data access, data modeling, and BI solutions (PowerBI).\r\nImplement data governance, security, lineage, and compliance practices using tools like Azure Purview.\r\nSupport CI/CD practices for data solutions, including automated testing, deployment, and monitoring.\r\nQualifications\r\nBachelor's degree in Computer Science, Information Technology, or a related field.\r\nStrong experience in SQL Server development and administration.\r\nProven experience designing and modeling relational databases from the ground up.\r\nProficiency in writing and optimizing complex SQL queries.\r\nExperience using SSIS for database-related tasks.\r\nExperience with Azure cloud platform for database solutions – Databricks, Synapse, Purview\r\nExperience with database migration and integration projects.\r\nStrong analytical thinking and attention to detail.\r\nExcellent communication and teamwork skills.\r\nJ-18808-Ljbffr","company":"Paul Murphy Associates","rawCompany":"paul murphy associates","city":"Chicago","state":"IL","isRemote":false,"isActive":false,"createdAt":"2026-04-09T09:04:12.549Z","occupations":[{"code":"15-1243.01","title":"Data Warehousing Specialists","slug":"data-warehousing-specialists"},{"code":"15-1243.00","title":"Database Architects","slug":"database-architects"},{"code":"15-1252.00","title":"Software Developers","slug":"software-developers"}],"industries":[{"code":"541512","title":"Computer Systems Design Services","slug":"computer-systems-design-services"},{"code":"541511","title":"Custom Computer Programming Services","slug":"custom-computer-programming-services"},{"code":"513210","title":"Software Publishers","slug":"software-publishers"}],"jobPosting":{"@context":"https://schema.org","@type":"JobPosting","title":"Data Engineer - SQL Server & Azure","description":"Location\r\nHybrid (3 days in office, 2 days remote)\r\nOverview\r\nAs 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.\r\nResponsibilities\r\nDesign and implement modern data architectures including data lakes, lakehouses, and streaming data platforms using tools such as Azure Synapse, Databricks, or Snowflake.\r\nBuild and optimize data pipelines using Python, SQL, Spark, and orchestration tools like Airflow or Azure Data Factory.\r\nAct as a hands-on SQL developer working on data ingestion (ADF), transformation, and integration workflows across structured and semi-structured sources.\r\nWrite and maintain robust, testable code (Python) for data processes and infrastructure (SQL stored procedures, Python scripts, infrastructure as code).\r\nPartner with analytics and product teams to enable self-service data access, data modeling, and BI solutions (PowerBI).\r\nImplement data governance, security, lineage, and compliance practices using tools like Azure Purview.\r\nSupport CI/CD practices for data solutions, including automated testing, deployment, and monitoring.\r\nQualifications\r\nBachelor's degree in Computer Science, Information Technology, or a related field.\r\nStrong experience in SQL Server development and administration.\r\nProven experience designing and modeling relational databases from the ground up.\r\nProficiency in writing and optimizing complex SQL queries.\r\nExperience using SSIS for database-related tasks.\r\nExperience with Azure cloud platform for database solutions – Databricks, Synapse, Purview\r\nExperience with database migration and integration projects.\r\nStrong analytical thinking and attention to detail.\r\nExcellent communication and teamwork skills.\r\nJ-18808-Ljbffr","datePosted":"2026-04-09T09:04:12.549Z","dateModified":"2026-04-09T09:04:12.549Z","hiringOrganization":{"@type":"Organization","name":"Paul Murphy Associates","sameAs":"https://jobsearcher.com"},"jobLocation":{"@type":"Place","address":{"@type":"PostalAddress","addressLocality":"Chicago","addressRegion":"IL","addressCountry":"US"}},"identifier":{"@type":"PropertyValue","name":"JobSearcher","value":"bea33f3a588264b729f6f026"},"url":"https://jobsearcher.com/jobs/bea33f3a588264b729f6f026"}}