Adarshconsulting helps organizations accelerate their data and digital journey through modern data platforms, cloud engineering, and outcome-focused delivery. We work with clients across North America from our headquarters in Calgary, and we grow by bringing in people who combine strong technical skills with a commitment to quality and client success.
Senior Data Engineer
About the role
We deliver value by pairing clients with small, high-impact teams. As a Senior Data Engineer, you own the build and operation of data pipelines and platform components on client engagements. You work alongside our architects and consultants to turn requirements into reliable, scalable solutions on modern cloud data platforms such as Snowflake, Databricks, and cloud-native services on AWS and Azure.
What you'll be doing
- Design and implement batch and streaming data pipelines (ETL/ELT) on Snowflake, Databricks, or cloud data services (AWS, Azure).
- Support migration of legacy data warehouses and ETL workloads to cloud data platforms with a focus on correctness, performance, and maintainability.
- Build and tune data models, schemas, and query patterns to meet performance and cost goals.
- Collaborate with architects on technical approach, tool selection, and best practices; work with consultants to align deliverables with client expectations.
- Document solutions, runbooks, and handover materials so client teams can operate and extend what we deliver.
Your skills and experience
Technical
- 5+ years of hands-on data engineering experience, including building and maintaining production data pipelines.
- Strong experience with at least one of Snowflake or Databricks, and with at least one major cloud provider (AWS or Azure).
- Proficiency in SQL and at least one of Python, Java, or Scala for data and automation work.
- Experience with relational databases and/or cloud data services; familiarity with data lake or lakehouse patterns is a plus.
- Experience with batch and/or streaming ingestion and processing (e.g. Spark, Delta, Fivetran, dbt, or native cloud services).
Delivery and collaboration
- Ability to work in a client-facing or near-client role; clear communication and willingness to explain technical choices to non-technical stakeholders.
- Experience working in consulting, professional services, or cross-functional product/analytics teams.
Cloud & Data Architect
About the role
Our impact depends on giving clients clear technical direction that fits their business goals. We do that by staffing each engagement with a small, virtual team of specialists. The Cloud & Data Architect provides technical leadership on those teams: you guide data engineers, own the systems view of the solution, and ensure technical decisions align with project and stakeholder needs. You work closely with our principal consultants so that deliverables meet client expectations and reflect Adarshconsulting’s standards for quality and operational maturity.
What you'll be doing
Project delivery
- Provide technical leadership across cloud data technologies: drive tool and approach selection, resolve complex engineering issues, and establish best practices on engagements.
- Lead the design and implementation of data platforms (e.g. data warehouses, data lakes, lakehouse) to meet business requirements, using platforms such as Snowflake, Databricks, or Microsoft Fabric where appropriate.
- Facilitate design sessions with client and internal teams; identify and communicate technical risks and options as the project evolves.
- Partner with principal consultants during discovery to capture requirements, define deliverables, and break them into a technical roadmap; lead data engineers to execute that roadmap and manage scope with the client.
- Act as a trusted advisor to the client: set expectations, challenge assumptions, solicit feedback, and take ownership of technical deliverables.
Design and delivery
- Complex ETL/ELT, large-scale batch and real-time stream processing, and optimization of data and schemas.
- Data lakes and unified analytics platforms using native cloud services or third-party platforms (e.g. Snowflake, Databricks, Microsoft Fabric).
- Migrations of relational databases, NoSQL stores, and data warehouses (heterogeneous and homogeneous) to cloud data platforms.
- End-to-end data solutions: ingestion, cataloging, transformation, and consumption (e.g. reports, dashboards, ML-backed insights).
- Design and integration of AI/ML and MLOps solutions where they are part of the engagement scope.
Other technical
- Develop code in Python, Java, or Scala as needed; architect and operationalize solutions with attention to governance, privacy, lifecycle, and cost.
- Maintain relevant cloud and data platform certifications and stay current with industry trends.
Your skills and experience
Technical
- 7+ years of experience in public cloud environments (Azure or AWS).
- 5+ years of development in Python, Java, or Scala.
- Experience building complex data pipelines and ETL/ELT; experience with relational and/or NoSQL databases and with batch and real-time processing.
- Experience designing and building data warehouses, data lakes, or unified analytics platforms (e.g. Snowflake, Databricks, Fabric, or cloud-native stacks).
- Experience with three or more of: real-time streaming (Kafka, Kinesis, Spark Streaming, etc.); analytics and BI (e.g. Tableau, Power BI, Looker); ML/AI solution design and operations; object storage and data lake patterns (e.g. S3, ADLS); data governance and cataloging.
Consulting
- Ability to design and discuss solutions using concepts such as data lineage, quality gates, governance, security, replication, and lifecycle management; awareness of compliance contexts (e.g. HIPAA, PCI, GDPR, PIPEDA) where relevant.
- Strong written and verbal communication; experience producing technical documentation and mentoring others.
- Proven experience in a customer-facing delivery role in consulting or professional services.
Data & Analytics Consultant
About the role
We help clients become more data-centric and analytics-driven. The Data & Analytics Consultant focuses on the intersection of business needs and technical delivery: you run discovery, shape analytics and platform strategy, and enable clients to adopt tools such as Snowflake and Databricks effectively. You work alongside our architects and engineers so that solutions are not only built well but also aligned with how the business will use data and analytics day to day.
What you'll be doing
- Conduct requirements and discovery sessions with business and technical stakeholders to define analytics and reporting needs, success criteria, and constraints.
- Design and recommend analytics and BI approaches (e.g. semantic layers, dashboards, self-serve reporting) and support platform selection (Snowflake, Databricks, or cloud-native) based on client context.
- Support adoption of modern data platforms: help clients plan rollouts, define roles and processes, and get value from new capabilities.
- Create and maintain clear documentation: requirements, solution overviews, user guides, and handover materials.
- Collaborate with architects and data engineers to ensure deliverables meet stakeholder needs and are operable by client teams.
Your skills and experience
Technical and domain
- 4+ years in analytics, BI, or data-focused consulting (or equivalent client-facing data/analytics work).
- Hands-on experience with at least one modern analytics or data platform (e.g. Snowflake, Databricks, BigQuery, Redshift, or equivalent) and with BI or reporting tools (e.g. Tableau, Power BI, Looker, or similar).
- Familiarity with data pipeline and ETL/ELT concepts so you can work effectively with engineers and architects.
Consulting and delivery
- Strong facilitation and communication skills; comfort presenting to mixed technical and business audiences.
- Experience gathering and documenting requirements and turning them into clear scope and deliverables.
- Experience in a consulting or professional services environment with direct client contact.
What's in it for you
Compensation and perks
- Competitive compensation aligned with experience and role.
- Retirement savings matching program (RRSP).
- Partner and discount programs where applicable.
Flexibility and time off
- Remote-first work environment with flexibility in hours and location.
- Paid parental leave options.
Health and wellness
- Employer-paid health and dental premiums.
- Mental health support and counselling options.
- Annual health spending account.
Growth and development
- Training and certification support (e.g. cloud and data platform courses).
- Peer recognition and rewards.
At Adarshconsulting we encourage everyone to bring their whole self to work. We value diverse backgrounds, experiences, and perspectives and are committed to an inclusive environment where everyone can contribute and grow. If you need accommodations or support during the recruitment process, please contact us at careers@adarshconsulting.com.
We thank all applicants for their interest. We will contact those who meet the qualifications for the role for next steps.