Data Architect
Data Architect
O'Reilly Auto Parts
United States
See who O'Reilly Auto Parts has hired for this role
A Data Architect constructs and maintains the Enterprise Data Warehouse for use by the O'Reilly Auto Parts enterprise. This team focuses on collaborating with business stakeholders for the development, design and integration of the data produced by the transactional systems into core Enterprise Data Warehouse Databases. The Data Strategy team follows the Kimball methodology of organizing and co-locating data for sourcing, transforming, access and analytics performance. This team leverages Informatica Power Center and Cloud, ER Studio, SQL, and IBM Integrated Analytics System.
Essential Job Functions
- Partner with key stakeholders to understand their data needs and data required for their analytics.
- Work with business systems analysts and stakeholders to translate business to technical requirements and problem solve.
- Collaborate with project teams and cross functional teams to troubleshoot issues and bug-fixes.
- Collaborate, coach and mentor team members on best practices, code reviews, internal tools, and process improvements.
- Create data models that are optimized and scalable.
- Own data architecture from conception and design to implementation and support.
- Create and update advanced technical documentation and Entity Relational Diagrams.
Skills and Qualifications
Required:
- Bachelor's Degree in Information Technology.
- 6+ years of experience in data warehouse, data migration or integration.
- Minimum 3 years of lead experience in data warehousing, reporting, and/or migration.
- Mastery of databases including writing and amending queries in DB/2, Oracle, PostgreSQL and/or NoSQL.
- People management skills including the ability to provide constructive feedback to analysts and project team members with a focus on accountability and development.
- Must be comfortable working with stakeholders including business users, architects, project managers, business analysts, developers, test analysts, and production support team.
- Experience in effectively communicating with a broad base of end users and multiple management layers, including the ability to interact with vendors as needed.
- Ability to work flexible schedule including nights/weekends.
Desired:
- Ability to articulate advanced technical concepts and teach others.
- Experience working with Agile/Scrum methodology.
Benefits
All full time team members are eligible for a benefits package that is designed to offer convenience and security to our team members and their families. Programs, resources and benefit eligibility varies based on employment status, average hours worked, location and length of service. For detailed benefits info type http://bit.ly/ORLYBenefits in your browser.
-
Seniority level
Mid-Senior level -
Employment type
Full-time -
Job function
Engineering and Information Technology -
Industries
Retail
Referrals increase your chances of interviewing at O'Reilly Auto Parts by 2x
See who you knowGet notified about new Data Architect jobs in United States.
Sign in to create job alertSimilar jobs
People also viewed
-
Solution Architect
Solution Architect
-
Remote VMware Architect - Azure Cloud Urgent
Remote VMware Architect - Azure Cloud Urgent
-
Health Data Architect
Health Data Architect
-
Solution Architect
Solution Architect
-
Solution Architect
Solution Architect
-
Remote Work - Need Senior AWS Architect
Remote Work - Need Senior AWS Architect
-
Application Architect
Application Architect
-
Solution Architect
Solution Architect
-
Senior Infrastructure Solution Architect
Senior Infrastructure Solution Architect
-
Cloud Architect
Cloud Architect
Looking for a job?
Visit the Career Advice Hub to see tips on interviewing and resume writing.
View Career Advice Hub