Job Description

WHAT YOU'LL DO
------------------



• Design, document & implement the data pipelines to feed data models for subsequent consumption in Snowflake using dbt, and airflow.
• Ensure correctness and completeness of the data being transformed via engineering pipelines for end consumption in Analytical Dashboards.
• Actively monitor and triage technical challenges in critical situations that require immediate resolution.
• Evaluate viable technical solutions and share MVPs or PoCs in support of the research
• 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 Performance and data security policies that align with governance objectives and regulatory requirements
• Effectively mentor and develop your team member

YOU'RE GOOD AT
------------------



You have experience in data warehousing, data modelling, and the building of data engineering pipelines. You are well versed in data engineering methods, such as ETL and ELT techniques through scripting and/or tooling. You are good at analyzing performance bottlenecks and providing enhancement recommendations; you have a passion for customer service and a desire to learn and grow as a professional and a technologist.• Strong analytical skills related to working with structured, semi-structured, and unstructured datasets.
• Collaborating with product owners to identify requirements, define desired
• Outcomes, and deliver trusted results.
• Building processes supporting data transformation, data structures, metadata, dependency, and workload management.
• In this role, SQL is heavily focused. An ideal candidate must have hands-on experience with SQL database design. Plus, Python.
• Demonstrably deep understanding of SQL (level: advanced) and analytical data warehouses (Snowflake preferred).
• Demonstrated ability to write new code i.e., well-documented and stored in a version control system (we use GitHub & Bitbucket)
• Familiar with JIRA & Confluence.
• Must have exposure to technologies such as DBT, Apache airflow, and Snowflake.
• Desire to continually keep up with advancements in data engineering practices.
• Knowledge of AWS cloud, and Python is a plus.

YOU BRING (EXPERIENCE & QUALIFICATIONS)
-------------------------------------------



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 • 5+ years of IT experience with a major focus on data warehouse/database-relatedprojects
• Must have exposure to technologies such as DB and Snowflake.
• Must have experience in other data platforms: Oracle, SQL Server, MDM, Unstructured database etc.
• Expertise in writing SQL and database objects - Stored procedures, functions, and views. Hands-on experience in ETL/ELT and data security, SQL performance optimization and job orchestration tools and technologies e.g., dbt, APIs, Apache Airflow, etc.
• Experience in data modelling and relational database design.
• Well-versed in applying SCD, CDC, and DQ/DV framework.
• Demonstrate ability to write new code i.e., well-documented and stored in a version control system (we use GitHub & Bitbucket)
• Good to have experience with Cloud Platforms such as AWS, Azure, GCP.
• Good to have strong programming/ scripting skills (Python, PowerShell, etc.)
• Good to have experience around responsibility for analysing and interpreting worker, candidate, or HR, Workday data, to provide valuable insights and support strategic decision-making.
• Good to have experience working with agile methodologies (Scrum, Kanban) and Meta Scrum with cross-functional teams (Product Owners, Scrum Master, Architects, and data SMEs)
• Excellent written, and oral communication and presentation skills to present architecture, features, and solution recommendations

YOU'LL WORK WITH
--------------------



BCG's information technology group collaboratively delivers the latest digital technologies that enable our consultants to lead and our business to grow. For our IT jobs, we seek individuals with expertise in the areas of IT infrastructure, application development, business systems, collaborative and social technologies, information security, and project leadership.