Senior Data Architect

About the position

The Senior Data Architect provides overall leadership, direction, guidance, and definition of an information architecture that effectively supports First Tech's data, reporting, and analytics strategy. The architect's initial focus will be on the development and maintenance of optimized data architectures for the Enterprise Data Warehouse and Person Master Data architectures and integrations and over time expand across all core enterprise business data sets. This role will partner with resources across IT and Business groups to establish and follow standards and best practices that align with governance, quality, and enablement program initiatives, as well as with software applications roadmaps.

Responsibilities

• Partner with Enterprise Data and Analytics product owners, Enterprise Architecture, and engineering teams to establish and align data architecture and naming standards
• Integrate models appropriately across subject areas and ensure transparency to business stakeholders
• Capture business rules, data definitions, and functional aspects accurately and appropriately within data models
• Conceptualize and ensure logical and physical data models incorporate reuse and interoperability in its design and supports EDW BI/Analytics and Master Data Management modeling best practices
• Offer hands on analysis where required to support Data Modelers as appropriate
• Provide data design direction and approvals to data modelers and developers
• Engage with stakeholders to define data requirements and ensure that data models and Data Engineering patterns, standards, guidelines, and best practices support ease of data consumption by federated analyst community
• Adherence to data governance policy - Partner with Information Governance Lead to engage Business/Data stewards in creation / maintenance of business glossary for the respective subject area and alignment with the glossary with other subject areas
• Data quality guidance and oversight - Partner with the Data Quality Program Lead to identify data architecture-related Data Quality improvements within the Enterprise Data Warehouse and drive back issues to the source system where appropriate
• Data access, integration, and security - Partner with EDW Product Owner to ensure processes and role-based user access model adheres to governance and security policies
• Simplify and optimize existing data architectures for reuse, scalability, connectedness, user adoption, and cost savings

Requirements

• Minimum 7 years' experience in logical data modeling, physical data modeling and database design optimization
• Minimum 5 years' MS SQL experience with strong data modeling background
• Minimum 5 years' experience in enterprise data warehouse architectures, master data management architectures and methodologies, tools, processes, and best practices
• Experience working with Snowflake is preferred
• Proven ability to create collateral to articulate strategy of complex concepts into simple solutions
• Demonstrated experience translating complex business and technical challenges into logical data models
• Strong analytical, problem-solving and critical thinking skills with excellent attention to detail
• Exceptional verbal and written communication skills in English
• Proven ability to build consensus across multiple stakeholder groups through partnership
• Ability to establish and maintain strong relationships with internal stakeholders
• Advanced knowledge of Microsoft Office Suite
• Minimum Education: Bachelor's degree in Business Administration, Mathematics, Statistics or related field

Benefits

• Traditional medical, dental, and vision coverage
• 401K matching up to 5% per pay period
• Accrue up to 17 days of Paid Time Off your first year of employment
• 11 paid federal holidays
• Special employee pricing on lending products such as mortgage, auto, and personal loans (eligibility for special employee pricing is subject to standard account requirements and underwriting criteria)