Position Description
CGI is seeking a self-directed, curious Senior Analytics Engineer to help build and operate a modern data platform using Snowflake, dbt and Azure Data Factory. In the initial phase, you will focus on completing and hardening the platform. As it matures, you will spend much of your time partnering with business teams and external stakeholders to turn questions into trusted data models, analysis and insights.
This role combines platform engineering, analytics and business partnership. You will take ownership from scoping through delivery, build solutions that can be reused across the organization, and look for ways to automate recurring work.
Your future duties and responsibilities
- Administer Snowflake, including warehouses, resource monitors, cost controls, account settings and environment management.
- Data platform engineering
- Design and maintain secure access patterns, including role based access control (RBAC) hierarchies, least privilege access, network policies, SSO, MFA, key pair authentication and object tagging.
- Configure and manage replication and failover to support business continuity.
- Build and maintain production dbt projects, including modeling standards, tests, documentation, CI/CD and deployment processes.
- Develop and orchestrate Azure Data Factory pipelines, including schedules, dependencies, monitoring and failure handling across Snowflake and dbt.
- Build Python stored procedures in Snowflake using Snowpark to connect to external REST APIs. Manage external access integrations, secrets, authentication, pagination and error handling.
- Maintain dynamic tables, Snowflake tasks, Iceberg tables and other open table formats.
- Investigate and improve query performance using query profiles, warehouse sizing, clustering, pruning, spill analysis and caching.
Automation and AI
- Use Snowflake Cortex tools, including Cortex Code, Cortex Agents and AI functions, to support dbt development and platform operations.
- Apply AI tools to tasks such as generating models, tests and documentation; reviewing changes; and diagnosing failed runs.
- Automate recurring maintenance, including cost and usage checks, access reviews, data freshness and quality monitoring, and warehouse tuning.
- Develop troubleshooting workflows that identify pipeline failures, slow queries and data issues; determine likely causes; and recommend or apply corrective actions.
Analytics and business partnership
- Serve as a key point of contact for data requests from business stakeholders and external partners.
- Learn business processes and data sources well enough to clarify requests, suggest useful alternatives and identify issues proactively.
- Build and maintain semantic views so that business metrics are consistently defined and reused.
- Deliver analysis and data products, including Power BI datasets and reports where appropriate.
- Explain findings and technical concepts clearly to non technical audiences.
Required Qualifications To Be Successful In This Role
- At least five years of experience in data engineering or analytics engineering, including at least three years of hands on Snowflake experience.
- Strong production experience with dbt.
- Production experience with Azure Data Factory, including pipelines, triggers, linked services and monitoring.
- Strong Python skills, including experience using Snowpark Python stored procedures to call external REST APIs.
- Expert SQL skills and a solid understanding of data modeling, including dimensional modeling and incremental processing patterns.
- Hands on experience with, and a strong interest in, using Snowflake Cortex or other AI and LLM tools to automate engineering workflows.
- Ability to work independently, scope ambiguous requests, investigate issues and carry work through to completion.
- Curiosity about business processes and the ability to communicate data concepts to non technical stakeholders.
Desired Qualifications
- Power BI experience, including data modeling, DAX and connecting to Snowflake.
- Experience building AI agents or agentic workflows, including tool use, prompt design, evaluation and guardrails.
- Broader Azure experience, such as Key Vault, Blob Storage or ADLS, and Microsoft Entra ID.
- Experience with Git based CI/CD and infrastructure as code, such as Snowflake DCM.
What will help you thrive in this role
You enjoy understanding the purpose behind a request, not simply completing a ticket. You look for opportunities to automate work that recurs, and you are comfortable moving between platform engineering and business focused analytics. You take initiative, ask thoughtful questions and follow through on the solutions you deliver.
CGI is providing a reasonable estimate of the pay range for this role. The determination of this range includes factors such as skill set level, geographic market, experience and training, and licenses and certifications. Compensation decisions depend on the facts and circumstances of each case. A reasonable estimate of the current range is $70,000 - $125,000
Together, as owners, let’s turn meaningful insights into action.
Life at CGI is rooted in ownership, teamwork, respect and belonging. Here, you’ll reach your full potential because…
You are invited to be an owner from day 1 as we work together to bring our Dream to life. That’s why we call ourselves CGI Partners rather than employees. We benefit from our collective success and actively shape our company’s strategy and direction.
Your work creates value. You’ll develop innovative solutions and build relationships with teammates and clients while accessing global capabilities to scale your ideas, embrace new opportunities, and benefit from expansive industry and technology expertise.
You’ll shape your career by joining a company built to grow and last. You’ll be supported by leaders who care about your health and well-being and provide you with opportunities to deepen your skills and broaden your horizons.
At CGI, we value the strength that diversity brings and are committed to fostering a workplace where everyone belongs. We collaborate with our clients to build more inclusive communities and empower all CGI partners to thrive. As an equal-opportunity employer, being able to perform your best during the recruitment process is important to us. If you require an accommodation, please inform your recruiter.
That same commitment to fairness extends to how we use technology. To support our recruitment team, AI tools may be used to help assess applications though they never replace human judgement. All hiring decisions remain entirely in the hands of our recruitment professionals.
To learn more about accessibility at CGI, contact us via email. Please note that this email is strictly for accessibility requests and cannot be used for application status inquiries.
Come join our team - one of the largest IT and business consulting services firms in the world.