Data Analytics Engineer

$99,700 - $140,000/Yr

Subaru Of America - Camden, NJ

Full-time - Mid Level

Remote - Camden, NJ

Merchant Wholesalers, Durable Goods

About the position

The Data Analytics Engineer at Subaru is responsible for developing and optimizing cloud-based Business Intelligence solutions. This role enhances data analytics capabilities and drives innovative solutions, requiring deep technical expertise in data engineering. The engineer will manage data integrations from on-premises Oracle systems, Cloud CRM, and telematics, while collaborating closely with Data Science and Enterprise Data Warehouse teams and business stakeholders.

Responsibilities

• Design, develop, and maintain scalable data pipelines using Data Factory and Databricks, leveraging Py Spark for complex data transformations.
• Build and manage ETL/ELT processes to extract, transform, and load data from on-premises Oracle systems and CRM technology into data storage solutions.
• Create high-code data engineering solutions using Databricks to prepare data for analysis.
• Develop and manage data models, schemas, and data warehouses utilizing Lakehouse Architecture.
• Leverage Unity Catalog for unified data governance across the enterprise's data assets.
• Optimize data storage, retrieval strategies, and query performance for scalability and efficiency.
• Integrate and harmonize data from diverse sources including on-premises databases and cloud services.
• Ensure consistent data quality, accuracy, and reliability across all integrated data sources.
• Utilize GitHub for version control and collaborative development, implementing best practices for code management.
• Develop workflows for continuous integration and continuous deployment of data solutions.
• Collaborate with Data Science and Enterprise Data Warehouse teams to understand data requirements and deliver solutions.
• Provide technical leadership and mentorship to junior data engineers.

Requirements

• Extensive experience with Data Factory, Databricks, and Synapse.
• Proficiency in Python and PySpark.
• Experience integrating data from on-premises Oracle systems and connected vehicle data into cloud-based solutions.
• Deep knowledge of Lakehouse Architecture and Unity Catalog for enterprise data governance.
• Demonstrated proficiency in GitHub for development and deployment.
• Experience with Infrastructure as Code tools such as ARM templates or terraform.
• Strong analytical skills for diagnosing and resolving data infrastructure challenges.
• Proven ability to work effectively with cross-functional teams to drive data-driven insights.
• Excellent verbal and written communication skills.

Nice-to-haves

• Experience with additional cloud services and data visualization tools.
• Familiarity with machine learning concepts and applications.

Benefits

• 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