Data Hub

MAKE AN IMPACT

Innovative thinking, delivery excellence and thought leadership to help our clients transform their business. Together with our clients and industry partners, we deliver disruptive work that is changing energy and financial services.

#BEYOURSELFATWORK

Capco has a tolerant, open culture that values diversity, inclusivity, and creativity.

CAREER ADVANCEMENT

With no forced hierarchy at Capco, everyone has the opportunity to grow as we grow, taking their career into their own hands.

MAKE AN IMPACT

Job Description: We are looking for a strong Datawarehousing resource with 7 to 8 years of hands-on experience in Dataiku DSS, strong SQL programming skills in PostgreSql or Teradata databases, good hands-on on python programming and basic tableau reporting. • The candidate will be a core member of the Data Analytics & Reporting Tribe, working on the design, development and operationalization of end to end data solutions using Dataiku DSS. • The candidate should be able to independently design, build, debug, maintain, and enhance analytics solutions while collaborating effectively with business teams. • The role focuses on translating business requirements into robust, scalable data pipelines, data modeling and self service analytics while ensuring data quality, governance and performance standards of the BNP Paribas group. • We are looking for top-notch, energetic talent to keep up with the industry’s momentum and support the team efforts.

Responsibilities: Direct Responsibilities • Design, build and maintain data pipelines, recipes and flows in Dataiku DSS to ingest, transform and expose data from source systems (PostgreSQL, Teradata, flat files, etc.) into the enterprise data warehouse / lake. • Implement data warehousing concepts (dimensional modelling, slowly changing dimensions, star/snowflake schemas, data vault) to support analytical reporting and BI consumption. • Develop reusable Python code (Pandas, PySpark, SQLAlchemy) within Dataiku plugins, recipes and notebooks for data cleansing, enrichment and advanced analytics. • Ensure data quality and consistency by defining validation rules, unit tests and automated data quality checks inside Dataiku. • Collaborate with data architects and business analysts to translate functional requirements into technical specifications, functional designs and implementation plans. • Document technical and functional artefacts (design specs, data dictionaries, operational run books) and contribute to knowledge base for the Data Tribe. • Set up CI/CD pipelines (GitLab) for Dataiku projects to automate testing, versioning and deployment across environments (dev / test / prod). • Monitor and optimise pipeline performance, storage utilisation (Parquet/ORC) and cost on the cloud infrastructure (Kubernetes Engine, IBM Cloud). • Support production incidents and perform root cause analysis, applying fixes and preventive measures. • Mentor junior team members and champion best practices in data engineering and Dataiku usage.

The rest of this description is on the employer’s own page.