Data Engineer II (Enterprise Data Warehouse)

Key Responsibilities

Database Administration & Engineering

• Support and maintain the Enterprise Data Warehouse (EDW) platform, ensuring uptime, performance, and data integrity.
• Collaborate closely with engineering and delivery teams responsible for SQL Server databases and SSIS workloads to ensure consistent and reliable processing and to ensure adherence to established standards.
• Perform deep analysis and troubleshooting of complex SQL Server processes to resolve failures, diagnose performance issues, and identify upstream data problems.
• Optimize existing database structures, queries, and ETL workflows to improve efficiency and reliability, with a focus on sustaining current business processes.
  
  

SSIS Development & Administration

• Develop, maintain, and administer SSIS packages supporting enterprise data pipelines.
• Lead and execute the transition from package-based deployment to project-based deployment, applying best practices for configuration, deployment, and monitoring.
• Provide training and support for engineering teams transitioning to project-based deployment
  
  

Technical Leadership & Collaboration

• Serve as a technical guide to teams with varying levels of experience, helping them troubleshoot issues and adopt improved SQL Server and SSIS practices.
• Share knowledge, provide mentorship, and promote consistent engineering approaches across teams.
• Apply broad technical expertise to support related infrastructure components and interconnected systems.