C5i is a pure-play AI \& Analytics provider that combines the power of human perspective with AI technology to deliver trustworthy intelligence. The company drives value through a comprehensive solution set, integrating multifunctional teams that have technical and business domain expertise with a robust suite of products, solutions, and accelerators tailored for various horizontal and industry-specific use cases. At the core, C5i’s focus is to deliver business impact at speed and scale by driving adoption of AI-assisted decision-making.
C5i caters to some of the world’s largest enterprises, including many Fortune 500 companies. The company’s clients span Technology, Media, and Telecom (TMT), Pharma \& Lifesciences, CPG, Retail, Banking, and other sectors. C5i has been recognized by leading industry analysts like Gartner and Forrester for its Analytics and AI capabilities and proprietary AI-based platforms.
Global offices
United States \| Canada \| United Kingdom \| United Arab of Emirates\| India
Job Description:
This role is hyper-focused on the Consumption Layer—transforming complex, curated data into intuitive, actionable insights and self-service tools for the Canadian business. You will be the primary expert responsible for the design, development, and maintenance of data models and reports that directly influence business strategy and day-to-day operations.
You will leverage a modern data stack, including Snowflake and GCP, with primary front-end tools being Domo and Sigma. While your core accountability is the consumption layer, a strong understanding of the entire data pipeline (ingestion and curated layers) is required, and you may be called upon to assist in those areas to ensure end-to-end data quality and integrity.
Key Responsibilities
Business Requirements Gathering:
Elicit, analyze, and document business needs, processes, and data requirements from stakeholders through interviews, workshops, and documentation review.
BI Solution Design \& Development
: Design, build, and maintain data models, dashboards, and reports within Domo and Sigma to support the Canadian Marketing, Retail Marketing, and Sales teams.
Data Transformation:
Utilize SQL, DBT models and programming languages (e.g., Python) within the Snowflake environment to perform complex data transformations required for reporting and analysis.
Stakeholder Partnership:
Act as a strategic partner to the Canadian commercial teams, translating complex business questions and requirements into technical data requirements and compelling visualization solutions.
Data Quality \& Governance:
Implement robust data validation and quality checks at the consumption layer to ensure accuracy and reliability of all published data products.
Pipeline Understanding:
Maintain a comprehensive understanding of the entire data lifecycle, from ingestion into GCP, CI/CD process, and transformation in Snowflake, to final delivery in BI tools, to effectively troubleshoot and provide input on upstream processes.
Stakeholder Communication:
Serve as the primary liaison between technical team and business units, ensuring alignment on goals, scope, and deliverables.
Documentation:
Create and maintain clear documentation for data models, metrics definitions, and self-service BI assets to promote data literacy and usage consistency.
Qualifications
Required Skills \& Experience
Education:
Bachelor’s degree in Computer Science, Information Systems, Business Analytics, or a related quantitative field.
Experience:
3+ years of professional experience in a data-focused role, with demonstrated expertise in both Data Engineering and Business Analysis principles.
Technical Proficiency:
Demonstrated understanding of modern data warehouse design principles and data engineering best practices.
Strong proficiency in SQL for data manipulation and querying. Write high quality SQL code to retrieve and analyze data from database tables, and learn and understand a broad range of data resources and know how, when, and which to use and which not to use.
Experience with a programming language (e.g., Python, R) for data transformation and automation.
Solid understanding of ETL/ELT processes and data warehousing concepts utilizing Snowflake.
Familiarity with cloud platforms, specifically GCP (Google Cloud Platform).
Practical experience using data visualization and/or BI tools, with Demonstrated expertise in Domo and/or Sigma.
Analytical \& Business Acumen: Proven ability to analyze complex business problems, propose data-driven solutions, and create clear documentation (e.g., ERDs, flowcharts, wireframes).
Preferred Skills
Master’s degree in a relevant field.
Demonstrated experience with Git/GitHub, dbt Core/Cloud, and Airflow.
Demonstrated understanding of marketing analytics concepts, including marketing mix modeling, customer churn, new user acquisition, and customer lifetime value.
Experience with advanced data modeling techniques.
Knowledge of agile development methodologies.
Experience in the CPG or Retail industry
.
C5i is proud to be an equal opportunity employer. We are committed to equal employment opportunity regardless of race, color, religion, sex, sexual orientation, age, marital status, disability, gender identity, etc. If you have a disability or special need that requires accommodation, please keep us informed about the same at the hiring stages for us to factor necessary accommodations.