Senior Data Engineer

• Senior Data Engineer
• 📍 Location: Kenosha, WI, US
• 🏢 Industry: Wholesale
• 💼 Work Setting: Hybrid

• Are you a senior data engineering leader with expertise in enterprise data warehousing, ETL development, cloud modernization, and analytics platforms?
• We are seeking a Lead Data Engineer to design, develop, and deliver enterprise Business Intelligence (BI) and Data Warehouse solutions that support business growth across North America. This role combines hands-on technical leadership, cloud data engineering, ETL architecture, performance optimization, data modernization, and team mentorship.
• The ideal candidate brings deep expertise in Azure, Databricks, enterprise ETL, SQL development, data warehousing, BI solutions, and data engineering leadership while driving innovation through modern cloud and AI-enabled data platforms.

• Key Responsibilities
• Enterprise Data Warehouse Development
• Design and deliver enterprise-scale data warehouse solutions.
• Develop robust data architectures supporting analytics and reporting.
• Build scalable and maintainable data platforms.
• Support enterprise business intelligence initiatives.
• Ensure data solutions align with organizational growth objectives.
• Key Focus Areas
• Data Warehousing
• Business Intelligence
• Enterprise Analytics
• Reporting Infrastructure
• Data Architecture
• Data Modernization & Cloud Transformation
• Support and advance enterprise data modernization strategies.
• Leverage modern cloud technologies including:
• Microsoft Azure
• Databricks
• AI-Enabled Automation
• Modernize legacy data integration and reporting processes.
• Improve data quality, accessibility, and operational efficiency.
• Drive adoption of cloud-native analytics capabilities.
• Data Engineering & Pipeline Development
• Design and develop scalable data engineering pipelines.
• Build ETL and ELT solutions supporting enterprise reporting.
• Develop data ingestion, transformation, and integration processes.
• Support both structured and unstructured data workloads.
• Ensure reliability, scalability, and performance of data solutions.
• Responsibilities
• Data Integration
• Data Transformation
• Data Processing
• Pipeline Automation
• Enterprise Data Delivery
• ETL Architecture & Integration
• Develop enterprise ETL solutions using modern integration tools.
• Create efficient workflows for moving and transforming business data.
• Maintain high-performance integration environments.
• Improve existing ETL processes through optimization and automation.
• Support large-scale enterprise data ecosystems.
• Technologies
• Informatica PowerCenter
• SQL Server Integration Services (SSIS)
• Databricks
• Modern Data Integration Platforms
• Business Intelligence Enablement
• Deliver data solutions supporting business intelligence and reporting.
• Develop datasets and data structures optimized for analytics.
• Ensure trusted, governed data is available to reporting platforms.
• Improve speed and accuracy of business insights.
• Support enterprise-wide decision-making capabilities.
• Cross-Functional Collaboration
• Partner closely with:
• Data Engineers
• BI Developers
• Data Architects
• Business Analysts
• Application Teams
• Business Stakeholders
• Responsibilities
• Gather business requirements.
• Design technical solutions.
• Support testing and implementation.
• Ensure successful deployment and adoption.
• Align technical solutions with business objectives.
• Code Quality & Engineering Standards
• Lead code review processes.
• Establish and enforce development standards.
• Promote best practices in:
• Data Engineering
• ETL Development
• SQL Development
• Testing
• Documentation
• Improve overall solution quality and maintainability.
• Support continuous improvement initiatives.
• Database Development & Performance Tuning
• Write and optimize complex T-SQL queries.
• Design efficient data access and storage strategies.
• Analyze and resolve database performance issues.
• Improve query execution times and system scalability.
• Support enterprise database performance optimization efforts.
• Core Areas
• T-SQL Development
• Query Optimization
• Performance Tuning
• Database Design
• Troubleshooting
• Data Troubleshooting & Operational Support
• Investigate and resolve complex data issues.
• Perform root-cause analysis for data failures.
• Monitor integrity and reliability of data processes.
• Support production environments and critical business operations.
• Ensure timely resolution of data-related incidents.
• Technical Leadership & Mentorship
• Provide guidance and mentorship to Data Engineers.
• Promote engineering excellence across the team.
• Review technical designs and implementation approaches.
• Drive consistency in engineering practices and standards.
• Support team development and technical growth.

Qualifications

• Education
• Required
• Bachelor's Degree in:
• Information Technology
• Computer Science
• Computer Engineering
• Information Systems
• Related Technical Discipline
• Experience
• Required
• 8+ years of Data Engineering experience.
• 5+ years developing enterprise ETL and data integration solutions.
• Experience designing large-scale data warehouse architectures.
• Experience leading technical projects and engineering teams.
• Technical Skills
• Data Engineering
• Data Warehousing
• Data Modeling
• ETL / ELT Development
• Data Integration
• Enterprise Analytics
• Cloud & Modern Data Platforms
• Required
• Microsoft Azure
• Databricks
• Preferred
• Cloud-Native Data Architectures
• Data Lake Solutions
• Lakehouse Architectures
• AI-Driven Data Automation
• ETL Technologies
• Informatica PowerCenter
• SSIS (SQL Server Integration Services)
• Databricks Pipelines
• Enterprise Integration Frameworks
• Database Technologies
• Required
• SQL Server
• T-SQL
• Areas of Expertise
• Complex Query Development
• Stored Procedures
• Database Optimization
• Performance Tuning
• Data Validation
• Business Intelligence
• Reporting Systems
• Analytics Platforms
• Data Visualization Foundations
• Enterprise Reporting Architecture
• Leadership Competencies
• Technical Leadership
• Team Development
• Mentorship
• Stakeholder Management
• Problem Solving
• Strategic Thinking
• Collaboration
• Continuous Improvement
• Professional Competencies
• Analytical Thinking
• Root Cause Analysis
• Attention to Detail
• Communication Skills
• Project Delivery
• Innovation Mindset
• Customer Focus
• Quality Orientation

• Core Competencies
• Data Engineering
• Data Warehousing
• Azure
• Databricks
• ETL Development
• Informatica PowerCenter
• SSIS
• SQL Server
• T-SQL
• Data Integration
• Cloud Data Platforms
• Business Intelligence
• Data Modeling
• Performance Tuning
• Data Modernization
• Analytics Engineering
• Technical Leadership