Senior Data Warehouse Engineer

What is the position? The Senior Data Warehouse Developer role is centered on data-focused development projects within an Enterprise Data Solutions environment. You'll be responsible for ingesting and transforming data from a wide variety of sources using modern tools and platforms, primarily on an on-premises infrastructure. What are the responsibilities? As a Senior Data Warehouse Engineer, you will: • Develop ETL solutions using SQL Server Integration Services (SSIS), SQL, and C# within Visual Studio. • Maintain and troubleshoot metadata-driven ETL processes. • Work with Azure DevOps and Git for version control and collaboration. • Ingest and process multiple file types and source systems including CSVs, fixed-width files, Oracle, and Kafka. • Leverage AI-enabled tools such as Microsoft Copilot to improve development efficiency and analytical capabilities • Support and enhance data ingestion, transformation, and integration processes across enterprise systems • Contribute to AWS-based data engineering initiatives, including integration with Amazon S3 and related services What are the requirements? • 8+ years of experience in data-centric development, primarily within on-premises SQL Server environments • Advanced knowledge of SQL Server 2019 and complex SQL development • Strong experience with SSIS • Experience with Visual Studio and C# for maintaining and debugging code • Experience working with diverse data sources (fixed-width files, sub-record type files, CSV files, Oracle, Kafka) • Familiarity with Azure DevOps and Git-based workflows • Experience utilizing AI-powered tools (e.g., Microsoft Copilot) • 2+ years of hands-on AWS data engineering experience, including data ingestion, transformation, and integration with Amazon S3 and related services You would be really happy here if: • You can be counted on in crucial times, possessing great focus while completing projects successfully and efficiently • You are left-brained and understand that the devil’s in the details, proactively seeking them out and understanding how they contribute to the whole of a project JoCo is an Equal Opportunity Employer. We are committed to providing a diverse and inclusive workplace and do not discriminate on the basis of race, color, religion, gender, gender identity, sexual orientation, national origin, disability, age, or any other characteristic protected by applicable law. All employment decisions are made based on qualifications, merit, and business needs.