Senior Database Architect

About the position

As a member of the Data Governance and Analytics team, the Senior Database Architect will be responsible for architecting, designing, and implementing data structures and tables, and recommending architecture for ETL/ELT pipelines from/to on-prem and cloud data sources. The Senior Database Architect will work closely with the development teams, DBA and business stakeholders to understand business outcomes and requests and translate them into clear, actionable technical requirements. The Senior Database Architect will apply knowledge of SQL, t-SQL, stored procedures, and ETL/ELT to perform PoCs (proof of concept) to ensure the validity of proposed solutions. The Database Architect will work closely with other members of the Enterprise Applications & Data (EAD) team to understand and implement roadmap initiatives to drive business outcomes.

Responsibilities

• Understand business requirements and perform technical implementations by leveraging knowledge of enterprise applications and technical expertise.
• Strong understanding of data warehouse/data lake implementation methodologies/concepts (Ralph Kimball, Bill Inmon, Dimension modelling, etc.).
• Understand master data management concepts.
• Design and develop efficient techniques for fast, optimized data access and transfer of on-prem or cloud database systems.
• Design, implement, and test novel data structures, data search, query, and retrieval solutions to enable access to and processing of data access across different scales and complex datasets.
• Research and recommend latest and stable data architecture methodologies.
• Provide end user support, system maintenance/security and incident resolution to ensure stable and resilient business operations of enterprise applications.
• Ensure enhancements, changes and systems configurations are appropriately documented.
• Participate in agile team ceremonies including sprint planning, daily stand-ups, backlog grooming, and retrospectives.
• Maintain professional and technical knowledge by attending educational workshops, reviewing professional publications; develop personal networks, and participate in professional groups.

Requirements

• Bachelor's degree in business, computer science, or a related field of study, or equivalent experience.
• Cloud Architect Certification (AWS preferred).
• MS SQL Server Developer Certification.
• 10 + years of relevant experience (on-prem and AWS cloud).
• Strong problem-solving and analytical skills.
• Comfortable as both a team member and individual contributor/independent thinker.
• Pragmatic problem-solving and decision-making skills with excellent written and verbal communication.
• Excellent diligence.
• Relentless passion and commitment to operational excellence, delivering within scope, on time, and within budget to exceed internal customer expectations.

Nice-to-haves

• Experience with QAD or SAP ERP.
• Experience migrating databases from on-prem to cloud.