Data Engineer

Position DescriptionWe are seeking a Data Engineer with proven hands-on experience with the design and development of highly available data management platforms and solutions for both on-prem and Azure-based cloud environments. This hands-on, technical role will partner closely with data scientists, analysts, and business stakeholders to ensure that data is accurate, accessible, and optimized for analytics, reporting, and operational needs. This resource will play a key role in building scalable data pipelines and integrations while championing best practices, and leading strategic data initiatives across teams.Key ResponsibilitiesDevelop and implement secure, scalable data pipelines using Azure Data Factory, Azure Functions, and Azure Data Lake StorageDesign and build reliable ETL/ELT processes using Python (pandas, PySpark), SQL, and SSIS, integrating data from diverse sources including REST APIs and various file formats (CSV, JSON, XML, Parquet)Collaborate cross-functionally to gather requirements and translate business needs into technical deliverablesDetect and resolve data quality issues; implement automated audits and monitoring processesParticipate in schema design and performance tuningMentor and support junior engineers across data engineering, analytics, and BI teamsParticipate in code reviews, promoting clean, well-documented, and testable codeStay current on trends in data engineering and cloud technologies, identifying opportunities to innovateMinimum Requirements 5 years of experience in data engineering, including1+ years with Azure cloud-native solutions3+ years with SQL Server Integration Services (SSIS)Critical SkillsExpertise in MS SQL Server, SSIS, Python (pandas, PySpark), Azure Data Factory, Azure Functions and Azure Data Lake Storage.Experience working with a variety of file formats (e.g., CSV, JSON, XML, Parquet).Familiarity using REST APIs for data extraction and integration.Proven experience designing and implementing data solutions.Good understanding of cloud architecture, data warehousing and modern data stack components.Additional Skills & QualificationsDemonstrated ability to perform root cause analysis on data and processing issuesStrong problem-solving skills with the ability to explain technical concepts to non-technical audiencesA successful history of manipulating, processing and extracting value from large disparate datasets Experience with Big Data technologies such as Databricks, Spark, or Azure SynapseKnowledge of CI/CD workflows, version control, and agile development practicesFamiliarity with data governance, privacy, and compliance frameworksExperience with data warehousing, analytics tools, and BI platformsEducation4-year degree in computer science, engineering or other related IT field of study, or equivalent professional work experiencePhysical Requirements General office demandsProlonged periods of sitting at a desk and working on a computer.Frequent reaching, handling, and fine manipulation for using office equipment, filing, and managing paperwork.Manual dexterity sufficient to operate a keyboard, mouse, and other office tools.Occasional standing, walking, and bending.Ability to lift up to 10-20 pounds occasionally.Vision abilities required include close vision for computer work and reading documents.Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.