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 dataBuild and maintain ML models within the Databricks ML platformShare insights and collaborate with domain teams and governance leadsRelease Manager
Coordinate promotion of notebooks, jobs, and data objects between environmentsOversee change control and deployment workflowsManage versioning and release calendar coordinationValidate content before production deploymentDomain Role Capabilities :
Domain Editor
Develop data transformations and ingestion logic for specific domainsWrite and maintain bronze / silver dataset pipelinesCoordinate with domain stewards for data certification processesMaintain documentation and versioning of domain datasetsPrimary Accountabilities :
Lead data migration projects from legacy database systems (SQL Server, Oracle, DB2), DOMO, and other existing platforms to Databricks Data LakehouseDesign and implement medallion architecture (Bronze / Silver / Gold) following established governance standardsLead hybrid data architecture spanning on-premise and cloud systems across multiple database platformsArchitect scalable ingestion pipelines using Databricks workflows, Delta Live Tables, and other platform-native toolsDesign enterprise-scale data transformation pipelines with emphasis on real-time and batch processing capabilitiesCollaborate with Domain Stewards and Approvers to ensure data certification and compliance with Unity Catalog RBACImplement data quality frameworks and monitoring solutions across the lakehouse platformMentor junior engineers and provide technical guidance on modern data platform best practicesEvaluate and recommend new data sources for platform integration, including structured and unstructured data assessmentDrive automation initiatives to reduce manual processes and improve operational efficiencySupport and build replication and advanced data movement technologies between disparate systemsOrganize and coordinate with team members to resolve complex technical issues and project deliverablesUtilize change management tools to document and gate all changes that could affect production systemsBuilding advanced tools to automate data collection and processing workflowsUtilize source control tools and best practices while developing enterprise-scale solutionsDrive continuous learning initiatives and knowledge transfer within the team and across domainsFind unique solutions to difficult problems involving complex data integration challengesModel and document database schemas and processes for both legacy and modern architecturesSupply support and research for future technologies, processes, and platform capabilitiesSupport non-inhouse system management through collaboration with peers and external partnersProvide support and respond to production-down emergencies 24 / 7 with advanced troubleshooting capabilitiesWork in a hybrid agile environment supporting both platform administration and domain-specific initiativesProvide advanced database and distributed system performance tuning and optimization recommendationsDemonstrates accountability for technical decision making and project outcomesAdapt to assigned platform or domain roles as determined through agile sprint planning and organizational needsMaintain role separation and compliance with the Mutually Exclusive Roles Matrix to ensure proper governanceParticipate in role-based workflows including data certification processes and governance activitiesCollaborate across role boundaries while maintaining appropriate separation of duties and audit complianceSupport agile development processes for both platform administration and domain-specific engineering initiativesTransition between roles as project phases and organizational priorities evolve, ensuring proper knowledge transferDocument role-specific activities and maintain clear audit trails for governance and compliance purposesPerforms 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 architecturesStrong SQL programming skills with experience across multiple database platforms and complex query optimizationData integration and ETL development experience using various tools and methodologiesAdvanced knowledge of database management systems throughout the entire development lifecycleProgramming experience in at least one modern language (Python, Scala, Java, or C#)Understanding of data architecture patterns and willingness to learn modern lakehouse conceptsAbility to work well with a team of peers on complex, enterprise-scale projectsProvide excellent customer experience across internal and external stakeholdersExpert knowledge of core SQL language with experience across multiple database dialects and platformsKnowledge of database sizing, monitoring, and performance optimizationExperience with database upgrades, migrations, and version managementExperience managing and monitoring multiple database servers and instancesExperience with High Availability, Disaster Recovery, and backup / recovery technologiesExperience with database backup, recovery, and data lifecycle management tools and patternsExperience with DevOps processes and tools or willingness to learn CI / CD practicesStrong analytical and problem-solving skills with attention to detail in complex systemsExcellent verbal and written communication skills in English for cross-functional collaborationAbility to work independently and as part of a team in a dynamic, multi-role environmentAdaptability and eagerness to learn new technologies and methodologiesUnderstanding of data governance principles or willingness to learn compliance frameworksLeadership Responsibility :
Technical and role-based leadership responsibility including :
Leading complex migration projects and mentoring junior team membersServing in assigned platform or domain roles with appropriate authority and accountabilityMay lead cross-functional project teams while maintaining governance complianceResponsible for role-specific deliverables and stakeholder communicationPreferred Qualifications :
Enterprise database administration certification (SQL Server, Oracle, DB2, or equivalent)Programming with robust depth of programming knowledge across multiple languagesUnderstanding of process mapping, business analysis, and design principlesExperience with workflow tools, databases, and APIsExperience with Qlik and other BI / analytics platformsProficiency in SQL across multiple database platforms and query optimizationCloud platform exposure (AWS / Azure) or willingness to learnAgile / Scrum methodology experience or willingness to learnBenefits Summary :
Health, Dental, Vision, Prescription Drug plansLife and Accidental Death & Dismemberment InsuranceFlexible Spending AccountEmployee Assistance Program401K with 4% company matchBonus ProgramWellness ProgramOnsite Fitness Center (vary by location)Tuition ReimbursementCareer Development and Ongoing TrainingPaid holidays and vacationCafeteria and food markets (vary by location)Volunteer opportunitiesEmployee recognition (employee and milestone events)Annual Salary : $94,000-$117,000
J-18808-Ljbffr