**Must be at least 18 years old to be considered.**
Overview:
Position Summary:
The Data Warehouse Data Analyst supports the development and use of data in AutoNation’s AWS Data Lake and Snowflake Cloud Data Warehouse. The Data Analyst will build SQL queries for data analysis, validation, testing, and reporting activities. The position will work collaboratively with a team of data engineers and data architects to support the development of data pipelines, data marts and reports. We are seeking a talented individual with experience working in a matrix IT organization to deliver enterprise class software projects in a fast-paced environment.
Organizational Relationships:
- IT Leadership: Director and Sr. Director positions in IT organization
- IT Teams: BI, QA, Security, DevOps, DBA, Architecture, Infrastructure, PMO
- Product owners
- Product stakeholders
- Scrum team members: Developers, QA testers, Business Analysts, Data Analysts, Project Manager
Job Responsibilities:
- Perform analysis on new data being added to the DW to understand how to integrate with existing data and identify data issues
- Analyze and identify data discrepancies within the Cloud DW and work with development team on resolution
- Develop data quality validations to ensure data accuracy and proactively identify data issues
- Ensure that data governance standards are adhered to within the data warehouse
- Support business users on data warehouse knowledge and query assistance
- Develop queries to analyze data based on business requirements
- Collaborate with business teams to advance usage of the data warehouse across the business
Qualifications:
- BA/BS degree in Information Technology or equivalent combination of education and experience
- 5-10 years of experience developing in SQL
- Good understanding of Data Warehouse architecture and design and ETL processes
- Strong analytical and problem-solving skills
- Excellent communication and documentation skills
- Experience with relational databases such as SQL Server or Oracle
- Experience with cloud-based (AWS and Azure) database systems and environments
- Must meet company’s requirements for employment
- Valid in-state driver’s license and have and maintain an acceptable, safe driving record
Physical Requirements
- Work with computers and other common office equipment
- Work location is in a corporate office environment with no special physical requirements beyond what is normally expected in a typical modern corporate office
AutoNation is an equal opportunity employer and a drug-free workplace
To apply for this job please visit itjobpro.com.