Data Analytics Developer - Information Technology

Data Analytics Developer

Information Technology

Company Overview:

Subaru of Indiana Automotive, Inc. or “SIA”, located in Lafayette, Indiana, is the only Subaru vehicle manufacturing facility outside of Japan. SIA is a 4.4 million square foot automotive OEM – meaning our manufacturing process begins with coils of steel and ends with the high-quality vehicles you see out on the roads. We employ 6500+ Associates, both production and administrative, all under one roof. SIA is the safest automotive manufacturing plant in the United States and is also a pillar in the community due to its numerous fundraising activities held onsite, donations to local charities and plentiful volunteer opportunities. SIA is a frontrunner in environmental stewardship being the first Zero-Landfill automotive manufacturing plant and the first to have its campus designated a backyard wildlife habitat. SIA has grown tremendously since its 1989 beginnings and continues to be an example of success within the automotive industry.

Position Summary:

Data Analytics Developers are data experts who design, build and maintain data analysis solutions.  Data Analytics Developers understand, mine, aggregate, and expose business data to enable efficient decision-making and the discovery of data-based business insights.  Data Analytics Developers use a variety of tools, techniques, and languages to create dashboards and populate reporting tools.

Outline of Duties:

• Collaborate with SIA management and business users to define data analysis requirements and specifications
• Work with transactional system developers to locate and understand source data
• Use ETL and data modeling tools to translate requirements into functioning, accurate data analysis solutions, including writing custom code in SQL, MDX and other languages as needed
• Develop efficient, robust ETL processes to extract data from transactional systems and other sources; follow organizational change management procedures
• Design, create, and maintain data warehouses, data lakes, data marts, etc. to support analysis and reporting, following best practices and considering data retention policies
• Define OLAP data cubes using dimensional schemas; design and build reports and data visualizations, including dashboards
• Modify solutions to fix errors, adapt to new hardware or runtimes, improve performance, or upgrade interfaces or software versions
• Lead and/or support continuous improvement activities to improve analysis capability and performance; advise the business on possible and recommended metrics based on experience and industry best practice
• Deliver ad hoc reports and data extracts as needed
• All other duties as assigned (ex. Perform or coordinate web development)

Minimum Qualifications:

• Bachelor’s Degree in Computer Science, Data Analytics, Informatics or related field or equivalent experience

Desired Qualifications:

• Master’s Degree in Computer Science or related field or equivalent experience
• Experience working with Pentaho
• Experience working with Microsoft PowerBI

Subaru of Indiana Automotive, Inc. is an equal opportunity employer committed to employing a diverse workforce.