What are the responsibilities and job description for the Data Analytics Developer - Information Technology position at Subaru of Indiana Automotive?
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 :
Desired Qualifications :
Subaru of Indiana Automotive, Inc. is an equal opportunity employer committed to employing a diverse workforce.
