Data Architect - Apex Systems

Job#: 2046177

Job Description:

Position Description:
The candidate will play a Data Architecture role for Marketing Sales and Service major initiative around Dealer Systems. The position requires a strong architect with comprehensive knowledge of data architecture, hands on experience in data model design, data quality analysis and good understanding of data analytics architecture. As Information / Data Architects, the candidate will work with enterprise architects, solution architects, business, and product teams to create strategy, design data models, information flows, perform data quality analysis, set standards, best practices, and guide product teams in implementation of the design.
Skills Required:
•Lead design discussions, create conceptual data models, logical data models and data dictionaries.
• Manage and maintain data models
• Define reporting strategy and identify sources for reporting data.
• Perform data quality analysis, identify issues, and propose solution to resolve them.
• Guide product teams to create physical data model design and data dictionary.
• Review design adherence and ensure standards, guidelines & best practices are followed.
• Consult and guide product team through design and implementation.
• Create information architecture roadmap with now, near and far view.
• Facilitate discussions to understand source of data, establish system of record, and create current & future state data flows.
• Create information architecture roadmap with now, near and far view.
Skills Preferred:

• Good Collaborative and Communication Skills
• Data modeling in a enterprise tool such as Power Designer or ERWIN
• Capable to work well individually and as a team member

• 7+ years Data Modeling experience with expertise in Relational and/or Dimensional Analysis
• 5+ years in experience in Data Warehouse database design
• Have a deep understanding of data modeling principles and architecture concepts.
• Extensive experience designing databases supporting complex business process.
• Experience in supporting database technologies - Oracle, DB2, Teradata, Hadoop, MS SQL Server, PostgreSQL, GCP Big Query
• Knowledge of Data Analytics, Google Cloud Technologies

• GCP
• Big Query
• Master Data Management

Education Required:
Bachelor’s degree
Education Preferred:
Prefer certification GCP or other Data Architecture related certifications

EEO Employer

Apex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at [email protected] or 844-463-6178.