WHAT YOU'LL DO

• Define data architecture for key domains within the Data Products Portfolio.
• 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
• Provide technical expertise and mentorship to Data Engineers and Data Analysts in the Data Architecture.
• Develop and maintain processes, standards, policies, guidelines, and governance to ensure that a consistent framework and set of standards is applied across the company.
• Create and maintain conceptual / logical data models to identify key business entities and visual relationships.
• Work with business and IT teams to understand data requirements.
• Maintain a data dictionary consisting of table and column definitions.
• Review data models with both technical and business audiences.
• Partner with Technology, Data Stewards and various Products teams in an Agilework stream while meeting program goals and deadlines.
• Lead to design / build new models to efficiently deliver the financial results to senior management.

YOU'RE GOOD AT

• Design, document & train the team on the overall processes and process flows for the Data architecture.
• Resolve technical challenges in critical situations that require immediate resolution.
• Develop relationships with external stakeholders to maintain awareness of data and security issues and trends.
• Review work from other tech team members and provide feedback for growth.
• Implement Data Architecture and Data security policies that align with governance objectives and regulatory requirements

YOU BRING (EXPERIENCE & QUALIFICATIONS)

• Bachelor's degree or equivalent combination of education and experience.
• Bachelor's degree in information science, data management, computer science or related field preferred.

• 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 hands-on 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 with Python would be preferable
• Experience working with agile methodologies (Scrum, Kanban) and Meta Scrum with cross-functional 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

YOU'LL WORK WITH

• Global functional portfolio technical leaders (Finance, HR, Marketing, Legal, Risk, IT), product owners, functional area teams across levels
• Global Data portfolio Management & teams (Enterprise Data Model, Data Catalog, Master Data Management)
• Consulting and internal Data Tribe teams across BCG