Job Summary
We are seeking an experienced IT professional with over 12 years of expertise in data warehouse and database-related projects. The ideal candidate will have a strong background in cloud databases data modeling and data architecture with hands-on experience in ETL/ELT processes and data analytics tools. This role requires excellent communication skills and the ability to work effectively in agile environments with cross-functional teams.
Responsibilities
Essential Experience & Job Requirements
12+ years of IT experience with major focus on data warehouse/database related projects
Expertise in cloud databases like Snowflake/RedShift data catalogue MDM etc
Expertise in writing SQL and database procedures
Proficient in Data Modelling Conceptual logical and Physical modelling
Proficient in documenting all the architecture related work performed.
Hand on experience in data storage ETL/ELT and data analytics tools and technologies e.g. Talend DBT Attunity Golden Gate FiveTran APIs Tableau Power BI Alteryx etc
Experienced in Data Warehousing design/development and BI/ Analytical systems
Experience working projects using Agile methodologies
Strong handson experience with data and analytics data architecture solution design and engineering experience
Experience with Cloud Big Data technologies such as AWS Azure GCP and Snowflake
Experience working with agile methodologies (Scrum Kanban) and Meta Scrum with crossfunctional teams (Product Owners Scrum Master Architects and data SMEs)
Review existing databases data architecture data models across multiple systems and propose architecture enhancements for cross compatibility and target systems
Excellent written oral communication and presentation skills to present architecture features and solution recommendations
WHAT YOULL DO
Define and design future state data architecture for risk data products.
Partner with Technology Data Stewards and various Products teams in an Agile work stream while meeting program goals and deadlines.
Create user personas to support various business initiatives.
Engage with line of business operations and project partners to gather process improvements.
Lead to design / build new models to efficiently deliver the risk results to senior management.
Evaluate Data related tools and technologies and recommend appropriate implementation patterns and standard methodologies to ensure our Data ecosystem is always modern.
Collaborate with Enterprise Data Architects in establishing and adhering to enterprise standards while also performing POCs to ensure those standards are implemented