Subaru of America
Overview
Azure Data Engineer
role at
Subaru of America Get AI-powered advice on this job and more exclusive features. Company background
Subaru is a globally renowned automobile manufacturer known for its commitment to innovation, safety, and sustainability. Subaru’s culture emphasizes collaboration, diversity, and a shared passion for the product, with a focus on the Subaru Love Promise. Role summary
The Azure Data Analytic Engineer will be the AZURE SME tasked with the development and optimization of cloud-based Business Intelligence solutions. Advances data analytics capabilities and drives innovative solutions. Possesses deep technical expertise in data engineering and plays an instrumental role in managing data integrations from on-premises Oracle systems, Cloud CRM (Dynamics), and telematics. Collaborates closely with Data Science and Enterprise Data Warehouse teams and business stakeholders.
Primary Responsibilities
Data Ingestion and Storage: Designs, develops, and maintains scalable, efficient data pipelines using Data Factory and Databricks, leveraging Py Spark for complex data transformations and large-scale processing. Builds and manages ETL/ELT processes to extract, transform, and load data from on-premises Oracle systems, CRM technology, and connected vehicles into data storage solutions such as Azure Data Lake Storage and Azure SQL Database. Data Engineering: Creates high-code data engineering solutions using Databricks to clean, transform, and prepare data for in-depth analysis. Develops and manages data models, schemas, and data warehouses, utilizing Lakehouse Architecture to enhance analytics and business intelligence. Leverages Unity Catalog to ensure unified data governance and management across the enterprise’s data assets. Optimizes data storage, retrieval strategies, and query performance. Data Integration: Integrate and harmonize data from diverse sources including on-premises databases, cloud services, APIs, and connected vehicle telematics. Ensure consistent data quality, accuracy, and reliability across all integrated data sources. GitHub Development: Utilizes GitHub for version control and collaborative development, implementing best practices for code management, testing, and deployment. Develops workflows for CI/CD to ensure efficient delivery and maintenance of data solutions. Additional responsibilities: Work with Data Science, Enterprise Data Warehouse, and Data Visualization teams and business stakeholders to understand data requirements and deliver solutions. Collaborate with cross-functional teams to troubleshoot data infrastructure issues and address performance bottlenecks. Provide technical leadership and mentorship to junior data engineers.
Required Skills and Personal Qualifications
Technical Expertise: Extensive experience with Azure Data Factory, Databricks, and Azure Synapse; proficiency in Python and PySpark. Data Integration: Experience integrating data from on-premises Oracle systems and connected vehicle data into cloud-based solutions. Lakehouse Architecture & Governance: Deep knowledge of Lakehouse Architecture and Unity Catalog for enterprise data governance. Version Control & Collaboration: Proficiency in GitHub for development, collaboration, and deployment in large-scale environments. Infrastructure as Code (IaC): Experience with ARM templates or Terraform. Problem-Solving & Troubleshooting: Strong analytical skills to diagnose and resolve data infrastructure challenges. Collaboration: Ability to work effectively with Data Science teams, business stakeholders, and cross-functional teams to drive data-driven insights. Communication: Excellent verbal and written communication skills with ability to translate technical concepts to non-technical stakeholders.
Education/Experience Requirements
BA/BS with 4 to 6 years of relevant experience. Relevant experience accepted in lieu of a degree.
Work Environment
Hybrid Role: Remote work 2 days per week (After 90 Days Onboarding) Travel Required: 0%
Compensation
The recruiting base salary range for this full-time position is
$99,700.00 - $140,000.00/year . Within the range, individual pay is determined by factors including job-related skills, experience, and relevant education or training. Subaru offers a comprehensive benefits package including: Medical, Dental, Vision Plans Pension, Profit Sharing, and 401K Match 15 Vacation days, 9 Company Holidays, 5 Floating Holidays, and 5 Sick days Tuition Reimbursement Program Vehicle Discount Programs
Job Details
Seniority level: Not Applicable Employment type: Full-time Job function: Information Technology Industries: Motor Vehicle Manufacturing
Referrals increase your chances of interviewing at Subaru of America by 2x
#J-18808-Ljbffr
Azure Data Engineer
role at
Subaru of America Get AI-powered advice on this job and more exclusive features. Company background
Subaru is a globally renowned automobile manufacturer known for its commitment to innovation, safety, and sustainability. Subaru’s culture emphasizes collaboration, diversity, and a shared passion for the product, with a focus on the Subaru Love Promise. Role summary
The Azure Data Analytic Engineer will be the AZURE SME tasked with the development and optimization of cloud-based Business Intelligence solutions. Advances data analytics capabilities and drives innovative solutions. Possesses deep technical expertise in data engineering and plays an instrumental role in managing data integrations from on-premises Oracle systems, Cloud CRM (Dynamics), and telematics. Collaborates closely with Data Science and Enterprise Data Warehouse teams and business stakeholders.
Primary Responsibilities
Data Ingestion and Storage: Designs, develops, and maintains scalable, efficient data pipelines using Data Factory and Databricks, leveraging Py Spark for complex data transformations and large-scale processing. Builds and manages ETL/ELT processes to extract, transform, and load data from on-premises Oracle systems, CRM technology, and connected vehicles into data storage solutions such as Azure Data Lake Storage and Azure SQL Database. Data Engineering: Creates high-code data engineering solutions using Databricks to clean, transform, and prepare data for in-depth analysis. Develops and manages data models, schemas, and data warehouses, utilizing Lakehouse Architecture to enhance analytics and business intelligence. Leverages Unity Catalog to ensure unified data governance and management across the enterprise’s data assets. Optimizes data storage, retrieval strategies, and query performance. Data Integration: Integrate and harmonize data from diverse sources including on-premises databases, cloud services, APIs, and connected vehicle telematics. Ensure consistent data quality, accuracy, and reliability across all integrated data sources. GitHub Development: Utilizes GitHub for version control and collaborative development, implementing best practices for code management, testing, and deployment. Develops workflows for CI/CD to ensure efficient delivery and maintenance of data solutions. Additional responsibilities: Work with Data Science, Enterprise Data Warehouse, and Data Visualization teams and business stakeholders to understand data requirements and deliver solutions. Collaborate with cross-functional teams to troubleshoot data infrastructure issues and address performance bottlenecks. Provide technical leadership and mentorship to junior data engineers.
Required Skills and Personal Qualifications
Technical Expertise: Extensive experience with Azure Data Factory, Databricks, and Azure Synapse; proficiency in Python and PySpark. Data Integration: Experience integrating data from on-premises Oracle systems and connected vehicle data into cloud-based solutions. Lakehouse Architecture & Governance: Deep knowledge of Lakehouse Architecture and Unity Catalog for enterprise data governance. Version Control & Collaboration: Proficiency in GitHub for development, collaboration, and deployment in large-scale environments. Infrastructure as Code (IaC): Experience with ARM templates or Terraform. Problem-Solving & Troubleshooting: Strong analytical skills to diagnose and resolve data infrastructure challenges. Collaboration: Ability to work effectively with Data Science teams, business stakeholders, and cross-functional teams to drive data-driven insights. Communication: Excellent verbal and written communication skills with ability to translate technical concepts to non-technical stakeholders.
Education/Experience Requirements
BA/BS with 4 to 6 years of relevant experience. Relevant experience accepted in lieu of a degree.
Work Environment
Hybrid Role: Remote work 2 days per week (After 90 Days Onboarding) Travel Required: 0%
Compensation
The recruiting base salary range for this full-time position is
$99,700.00 - $140,000.00/year . Within the range, individual pay is determined by factors including job-related skills, experience, and relevant education or training. Subaru offers a comprehensive benefits package including: Medical, Dental, Vision Plans Pension, Profit Sharing, and 401K Match 15 Vacation days, 9 Company Holidays, 5 Floating Holidays, and 5 Sick days Tuition Reimbursement Program Vehicle Discount Programs
Job Details
Seniority level: Not Applicable Employment type: Full-time Job function: Information Technology Industries: Motor Vehicle Manufacturing
Referrals increase your chances of interviewing at Subaru of America by 2x
#J-18808-Ljbffr