
Data Architect
Ford Motor Company
full-time
Posted on:
Location Type: Hybrid
Location: Dearborn • Missouri • United States
Visit company websiteExplore more
Salary
💰 $86,600 - $166,200 per year
About the role
- Design and develop information data models including EDM, Conceptual, logical and physical data models for Industrial Systems. Manage and maintain the models in a Power Designer repository.
- Map Application to Conceptual Data Model, Business Process and Business Capability
- Support product team’s intake process, understanding business requirements, translating them into people, process, data and system requirements, applying data architectural principles, and providing expert guidance.
- Lead the discovery and analysis phase of Industrial Systems Data Platform, ensure a deep understanding of our data landscape and facilitate integration of diverse sources into a unified data model.
- Provide data analytics guidance to product teams.
- Lead conceptual discussions to understand the organization's data landscape. Identify and evaluate candidate data sources, maintain data models and data dictionaries for all identified source systems. Develop and define Canonical Domain Models.
- Profile source system data, define comprehensive data quality requirements, identify data quality dimensions and metrics. Provide guidance on data quality monitoring, measuring, reporting and addressing issues.
- Establish data architecture principles, data standards, best practices, and guidelines for the design of the data platform including data catalog, data lineage, observability, security and interoperability.
- Perform proof of concepts and guide Product team members to design and develop using different GCP data engineering technologies and tools.
Requirements
- Bachelor of Computer Science, Information Systems, Systems Programming or equivalent combination of relevant education and experience
- 8+ years overall IT experience.
- 5+ years of Data Architecture, Data Engineering, or advanced Database Design/Modeling experience in designing or implementing OLTP/RDBMS databases, Data Warehouse, Data Marts.
- Knowledge of Master Data Management concepts and tools
- Functional and Architecture Experience with one or more PLM platforms (e.g., Siemens’ Teamcenter, Dassault’s 3D Experience)
- Knowledge of TOGAF, DAMA Architecture Framework and Standards
- Ability to define data architecture principles, guidelines and standards
- 4+ years of hands-on experience creating data models using data modeling tools (e.g. Power Designer)
- 2+ years of experience in GCP technologies including Big Query, Alloy DB, PostgreSQL, Cloud Run, Mongo DB, Data Flow. Similar cloud experience may be acceptable.
Benefits
- Immediate medical, dental, vision and prescription drug coverage
- Flexible family care days, paid parental leave, new parent ramp-up programs, subsidized back-up childcare and more
- Family building benefits including adoption and surrogacy expense reimbursement, fertility treatments, and more
- Vehicle discount program for employees and family members and management leases
- Tuition assistance
- Established and active employee resource groups
- Paid time off for individual and team community service
- A generous schedule of paid holidays, including the week between Christmas and New Year’s Day
- Paid time off and the option to purchase additional vacation time.
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills & Tools
data modelingdata architecturedata engineeringdatabase designOLTPRDBMSData WarehouseData Martsdata qualitydata analytics
Soft Skills
leadershipcommunicationanalytical thinkingproblem-solvingcollaboration
Certifications
Bachelor of Computer ScienceBachelor of Information SystemsTOGAFDAMA Architecture Framework