Job Description

Job Overview Azure Data Engineer role at Subaru of America. Company Background Love. It's what makes Subaru, Subaru®. As a leading auto brand in the US, we strive to be More Than a Car Company®. Subaru believes in being a positive force in the communities in which we live and work, not just with donations but with actions that set an example for others to follow. That's what we call our Subaru Love Promise®. Subaru is a globally renowned automobile manufacturer known for its commitment to innovation, safety, and sustainability. With a rich history dating back to 1953, Subaru has consistently pushed the boundaries of automotive engineering to deliver vehicles that offer not only exceptional performance but also a unique blend of utility and adventure. Subaru's company culture is built on collaboration, diversity, and a shared passion for our product. We foster an inclusive environment that encourages employees to bring their unique perspectives and talents to the table. Our team members are driven by a common goal: to create exceptional vehicles that inspire and delight our customers. 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 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 Design and develop scalable, efficient data pipelines using Azure Data Factory and Databricks, leveraging PySpark for complex data transformations and large-scale processing. Build and manage ETL/ELT processes to seamlessly extract, transform, and load data from on-premises Oracle systems, CRM technology, and connected vehicles into Azure Data Lake Storage and Azure SQL Database. Implement high-code data engineering solutions on Databricks to clean, transform, and prepare data for in-depth analysis. Develop and manage data models, schemas, and data warehouses utilizing Lakehouse Architecture. Leverage Unity Catalog to ensure unified data governance and management across enterprise data assets. Optimize data storage, retrieval strategies, and query performance to drive scalability and efficiency. 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. Utilize GitHub for version control, implementing CI/CD workflows for efficient delivery and maintenance of data solutions. Work closely with Data Science, Enterprise Data Warehouse, and Data Visualization teams, as well as business stakeholders, to understand data requirements and deliver innovative solutions. Collaborate with cross-functional teams to troubleshoot and resolve data infrastructure issues, identifying and addressing performance bottlenecks. Provide technical leadership, mentorship, and guidance to junior data engineers, promoting continuous improvement and innovation. Additional Responsibilities Work closely with Data Science, Enterprise Data Warehouse, and Data Visualization teams, as well as business stakeholders, to understand data requirements and deliver innovative solutions. Collaborate with cross-functional teams to troubleshoot and resolve data infrastructure issues, identifying and addressing performance bottlenecks. Provide technical leadership, mentorship, and guidance to junior data engineers, promoting a culture of continuous improvement and innovation. Required Skills and Personal Qualifications Extensive experience with Azure Data Factory, Databricks, and Azure Synapse, proficiency in Python and PySpark. Experience integrating data from on-premises Oracle systems and connected vehicle data into cloud solutions. Deep knowledge of Lakehouse Architecture and Unity Catalog for enterprise data governance. Proficiency in GitHub for development, collaboration, and deployment in large-scale environments. Experience with Infrastructure as Code tools such as ARM templates or Terraform. Strong analytical skills for diagnosing and resolving complex data infrastructure challenges. Proven ability to work effectively with Data Science teams, business stakeholders, and cross-functional teams. Excellent verbal and written communication skills, translating 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 and Benefits Base salary $99,700.00 - $140,000.00 per year. Individual pay determined by factors including skills, experience, and education. Medical, Dental, Vision Plans Pension, Profit Sharing, and 401K Match Offerings 15 Vacation days, 9 Company Holidays, 5 Floating Holidays, and 5 Sick days. Tuition Reimbursement Program Vehicle Discount Programs Seniority Level Not Applicable Employment Type Full-time Job Function Information Technology Industries: Motor Vehicle Manufacturing #J-18808-Ljbffr Subaru of America

Job Tags

Similar Jobs