Data Architect - Troy, MI


Job Responsibilities
Logical and Physical Data model design (using Erwin) working collaboratively with Enterprise Data Architects. Design, model, organize, and execute technical data constructs within AFDW. Lead activities related to maintaining metadata, integration of data, and data governance. Coordinate, support and troubleshoot Data Warehouse Infrastructure including activities such as environment buildout, database sizing Develop and maintain data quality checks Develop Performance test plan and tuning of the data components. Define security, backup procedures, and recovery specifications Provide support throughout the project cycle to ensure development of efficient data systems utilizing established standards, procedures and methodologies (i.e. design reviews, architect reviews). Promote adherence to design standards and methodologies. Mentor team members on database best practices. Qualifications
Mandatory 10+ years overall IT experience Must have 5+ years of experience in database technologies, data design and performance optimization for large OLAP applications Excellent PL/SQL skills Experience in data modeling (logical and physical), data management, metadata and reference data management Experience with ODS data architecture and staging strategy Experience with Entity Relationship Modeling tools (ERWin modeling software preferred) Experience in performing data mapping lineage (knowledge of Business Glossary and Metadata Workbench preferred) Owns the authoring and coordination to deliver key data specific documentation including the AFDW data dictionary Ability to work in a large, complex business and technical environment Provide input to planning activities to estimate effort to complete sprint planning and execution tasks/activities Must be detail oriented and have the ability to multi-task Fast starter, effectively delivers with limited supervision Must have excellent communication skills written as well as verbal; must be able to articulate the value proposition of Warehouse solutions Ability to communicate effectively with both the business and technical teams Preferred Finance or Automotive Industry experience Experience in Agile / SCRUM (with sprints) methodologies Experience with Version One and Blue Print requirement management tools as well as HP Quality Center testing tool Experience with ETL tools preferably Datastage Experience with Data Vault  

Business Unit/Enterprise Function
Information Technology (IT) organization is focused on supporting and improving the position of its industry-leading business franchises through cost effective, innovative IT solutions as well as overseeing critical functions that enable the day-to-day operations of the entire Financial enterprise. IT is also responsible for the administration and execution of information protection, disaster recovery and IT risk management. 
Total Rewards Information
compensation program offers market-competitive base pay and pay-for-performance incentives (bonuses) based on achieving personal and company goals. Plus, we have a flexible paid-time-off program including time off for volunteer opportunities. Total Rewards Program is designed to enrich your life at work -- and outside of it and includes: 
Industry-leading 401K retirement savings plan with matching and company contributions Wellness program encouraging healthy living with financial rewards Flexible health insurance options including dental and vision Pre-tax Health Savings Account with generous employer contributions Pre-tax commuter benefits Other work-life integration benefits including parental and caregiver leave, adoption assistance, backup child and adult/elder day care program, child care discounts, tuition reimbursement, LifeMatters® Employee Assistance Program, subsidized and discounted Weight Watchers® program and other employee discount programs is an Equal Opportunity Employer
We extend equal employment opportunities to qualified applicants and employees on an equal basis regardless of an individual's age, race, color, sex, religion, national origin, disability, sexual orientation, gender identity or expression, pregnancy status, marital status, military or veteran status, genetic disposition or any other reason protected by law. 

Base Salary - $131K+ 
Full-time Benefits - Full
Relocation Assistance Available - No
Commission Compensation - No
Bonus Eligible - Yes
Overtime Eligible - No
Interview Travel Reimbursed - Yes 

10+ to 15 years experience
Seniority Level - Associate
Management Experience Required - No
Minimum Education - High School Diploma or Equivalent
Willingness to Travel - Occasionally