Job Category: EngineeringDegree Level: Bachelor's DegreeJob Description:Job Summary:DENSO North America Enterprise Solutions Group is transforming its enterprise analytics and business intelligence capabilities through a comprehensive Data Lakehouse platform built on Databricks. This strategic initiative involves migrating legacy data warehouses, reporting systems, and analytical workloads from on-premise platforms (SQL Server data warehouses, Oracle analytics, iSeries reporting) and current BI tools (DOMO, Qlik) into a unified, governed analytical platform. The organization manages complex analytical data flows, dimensional modeling, reporting datasets, and advanced analytics capabilities across multiple business domains.The E3 Data Engineer role serves as a technical leader in building and maintaining enterprise-scale analytical data solutions. This position focuses on designing data warehouse architectures, implementing ETL/ELT processes, creating dimensional models, and enabling self-service analytics within the modern Data Lakehouse framework. The role bridges traditional data warehousing and business intelligence expertise with cutting-edge lakehouse technologies, working within established governance frameworks to deliver scalable, performant analytical solutions that support strategic business decision-making across the enterprise.Data Lakehouse Role Responsibilities:Based on project needs and organizational priorities, the E3 Data Engineer may be assigned to fulfill one or more of the following platform or domain roles:Platform Role Capabilities:Platform Engineer
Build and maintain core platform infrastructure and data pipelines
Support catalog automation and orchestration across domains
Monitor job performance and compute resource usage
Collaborate with Unity Catalog admins for infrastructure provisioning
Platform Data Scientist
Conduct advanced analysis and modeling across domains using certified data
Build and maintain ML models within the Databricks ML platform
Share insights and collaborate with domain teams and governance leads
Release Manager
Coordinate promotion of notebooks, jobs, and data objects between environments
Oversee change control and deployment workflows
Manage versioning and release calendar coordination
Validate content before production deployment
Domain Role Capabilities:Domain Editor
Develop data transformations and ingestion logic for specific domains
Write and maintain bronze/silver dataset pipelines
Coordinate with domain stewards for data certification processes
Maintain documentation and versioning of domain datasets
Primary Accountabilities:
Lead data migration projects from legacy database systems (SQL Server, Oracle, DB2), DOMO, and other existing platforms to Databricks Data Lakehouse
Design and implement medallion architecture (Bronze/Silver/Gold) following established governance standards
Lead hybrid data architecture spanning on-premise and cloud systems across multiple database platforms
Architect scalable ingestion pipelines using Databricks workflows, Delta Live Tables, and other platform-native tools
Design enterprise-scale data transformation pipelines with emphasis on real-time and batch processing capabilities
Collaborate with Domain Stewards and Approvers to ensure data certification and compliance with Unity Catalog RBAC
Implement data quality frameworks and monitoring solutions across the lakehouse platform
Mentor junior engineers and provide technical guidance on modern data platform best practices
Evaluate and recommend new data sources for platform integration, including structured and unstructured data assessment
Drive automation initiatives to reduce manual processes and improve operational efficiency
Support and build replication and advanced data movement technologies between disparate systems
Organize and coordinate with team members to resolve complex technical issues and project deliverables
Utilize change management tools to document and gate all changes that could affect production systems
Building advanced tools to automate data collection and processing workflows
Utilize source control tools and best practices while developing enterprise-scale solutions
Drive continuous learning initiatives and knowledge transfer within the team and across domains
Find unique solutions to difficult problems involving complex data integration challenges
Model and document database schemas and processes for both legacy and modern architectures
Supply support and research for future technologies, processes, and platform capabilities
Support non-inhouse system management through collaboration with peers and external partners
Provide support and respond to production-down emergencies 24/7 with advanced troubleshooting capabilities
Work in a hybrid agile environment supporting both platform administration and domain-specific initiatives
Provide advanced database and distributed system performance tuning and optimization recommendations
Demonstrates accountability for technical decision making and project outcomes
Adapt to assigned platform or domain roles as determined through agile sprint planning and organizational needs
Maintain role separation and compliance with the Mutually Exclusive Roles Matrix to ensure proper governance
Participate in role-based workflows including data certification processes and governance activities
Collaborate across role boundaries while maintaining appropriate separation of duties and audit compliance
Support agile development processes for both platform administration and domain-specific engineering initiatives
Transition between roles as project phases and organizational priorities evolve, ensuring proper knowledge transfer
Document role-specific activities and maintain clear audit trails for governance and compliance purposes
Performs other duties as assigned.
Minimum Level of Education:Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field. A combination of degree and experience can be considered.Experience:5+ years in software development, data engineering, database administration, IT, or a related field (including internships or coursework).Minimum Level of Knowledge and Skills Required:
Advanced knowledge of database systems (SQL Server, Oracle, DB2, or other enterprise platforms) and data warehouse architectures
Strong SQL programming skills with experience across multiple database platforms and complex query optimization
Data integration and ETL development experience using various tools and methodologies
Advanced knowledge of database management systems throughout the entire development lifecycle
Programming experience in at least one modern language (Python, Scala, Java, or C#)
Understanding of data architecture patterns and willingness to learn modern lakehouse concepts
Ability to work well with a team of peers on complex, enterprise-scale projects
Provide excellent customer experience across internal and external stakeholders
Expert knowledge of core SQL language with experience across multiple database dialects and platforms
Knowledge of database sizing, monitoring, and performance optimization
Experience with database upgrades, migrations, and version management
Experience managing and monitoring multiple database servers and instances
Experience with High Availability, Disaster Recovery, and backup/recovery technologies
Experience with database backup, recovery, and data lifecycle management tools and patterns
Experience with DevOps processes and tools or willingness to learn CI/CD practices
Strong analytical and problem-solving skills with attention to detail in complex systems
Excellent verbal and written communication skills in English for cross-functional collaboration
Ability to work independently and as part of a team in a dynamic, multi-role environment
Adaptability and eagerness to learn new technologies and methodologies
Understanding of data governance principles or willingness to learn compliance frameworks
Leadership Responsibility:Technical and role-based leadership responsibility including:
Leading complex migration projects and mentoring junior team members
Serving in assigned platform or domain roles with appropriate authority and accountability
May lead cross-functional project teams while maintaining governance compliance
Responsible for role-specific deliverables and stakeholder communication
Preferred Qualifications:
Enterprise database administration certification (SQL Server, Oracle, DB2, or equivalent)
Programming with robust depth of programming knowledge across multiple languages
Understanding of process mapping, business analysis, and design principles
Experience with workflow tools, databases, and APIs
Experience with Qlik and other BI/analytics platforms
Proficiency in SQL across multiple database platforms and query optimization
Cloud platform exposure (AWS/Azure) or willingness to learn
Agile/Scrum methodology experience or willingness to learn
Benefits Summary:
Health, Dental, Vision, Prescription Drug plans
Life and Accidental Death & Dismemberment Insurance
Flexible Spending Account
Employee Assistance Program
401K with 4% company match
Bonus Program
Wellness Program
Onsite Fitness Center (vary by location)
Tuition Reimbursement
Career Development and Ongoing Training
Paid holidays and vacation
Cafeteria and food markets (vary by location)
Volunteer opportunities
Employee recognition (employee and milestone events)
