IT Data Architect - Senior Manager

Who We Are

BCG pioneered strategy consulting more than 50 years ago, and we continue to innovate and redefine the industry. We offer multiple career paths for the world's best talent to have a real impact on business and society. As part of our team, you will benefit from the breadth and diversity of what we are doing today and where we are headed next. We count on your authenticity, exceptional work, and strong integrity. In return we are committed to supporting you in discovering the most fulfilling career journey possible-and unlocking your potential to advance the world. Our team called Global Services (GS) provides corporate support to business areas such as Finance, Legal, HR, Marketing and IT. This diverse team of experts, operators and specialists represent all levels from Partner to entry level staff, operating across the globe in multiple countries. Global Services is in short, the backbone of BCG.

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.
• This role is predominantly technical, requiring the candidate to function as an individual contributor (80%) while also demonstrating leadership capabilities (20%).

What You'll Bring

Essential Education

Bachelor's degree or equivalent combination of education and experience.

Bachelor's degree in information science, data management, computer science or related field preferred.

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 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

Who You'll Work With

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

Boston Consulting Group is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, age, religion, sex, sexual orientation, gender identity / expression, national origin, disability, protected veteran status, or any other characteristic protected under national, provincial, or local law, where applicable, and those with criminal histories will be considered in a manner consistent with applicable state and local laws.
BCG is an E - Verify Employer. Click here for more information on E-Verify.