Data Engineer

Our client, is seeking a high-caliber Data Engineer to join their specialized Enterprise Analytics and IT division.

In this professional engineering role, you will be responsible for designing, building, and deploying highly scalable, production-grade Extract, Transform, Load (ETL) pipelines and analytical data streams. You will act as a key technical contributor within a collaborative, fast-paced Agile team, partnering with Solution Architects, Scrum Masters, and business teams to transform business requirements into robust data architectures. Your mandate includes designing modern data marts, engineering columnar Data Warehouses, and implementing enterprise reporting layers to maximize data accessibility and drive strategic operational intelligence.

Duration: 6-Month Contract

Work Arrangement: Hybrid (In-office at the corporate headquarters once a month, or more frequently based on project delivery requirements—up to once a week).



Advantages
Enterprise Retail Analytics Sandbox: Gain hands-on exposure working with massive, diverse datasets within a leading, high-volume retail technology ecosystem.

Modern Cloud Stack Focus: Solidify your cloud engineering portfolio by leveraging cutting-edge GCP tools, including BigQuery columnar storage and automated pipeline workflows.

Highly Collaborative Environment: Accelerate your career within a mature Agile environment alongside expert architects, technical leads, and business stakeholders.

Flexible Hybrid Framework: Benefit from a work model that prioritizes autonomy, offering primarily remote engagement with highly targeted on-site collaboration milestones.



Responsibilities
Data Pipeline Engineering & Architecture
ETL Pipeline Development: Design, code, and implement clean, high-performing ETL/ELT processes delivering high-quality data structures in alignment with software development best practices.

Data Warehouse & Mart Modeling: Analyze enterprise data usage to architect, build, and optimize scalable data marts and analytical data models tailored for complex business reporting.

GCP Cloud Orchestration: Leverage cloud-native utilities to support real-time and batch ingestion streams, workflow automation, and distributed data transformations.

Validation, Reporting & Stakeholder Integration
Comprehensive Quality Assurance: Prepare rigorous test scripts and execute functional unit, integration, and regression testing. Coordinate, monitor, and drive User Acceptance Testing (UAT) with business partners to ensure complete data accuracy and completeness.

Reporting & Visualization Solutions: Collaborate with analytics teams to design, build, and deploy data visualization interfaces and reporting dashboards.

Technical Synthesis & Prototyping: Partner daily with technical leads and functional resources to translate raw requirements into technical specifications. Conduct Proof of Concepts (POCs) to evaluate new or emerging data platform technologies.

Production Governance: Troubleshoot production pipeline defects and SQL execution friction. Adhere strictly to enterprise IT standards and change management protocols when deploying code to live environments.



Qualifications
Experience: 5 to 8 years of proven professional experience operating as a Data Engineer, BI Developer, or Cloud Data Specialist.

Advanced SQL Mastery: Expert-level capability in advanced SQL scripting, including data management, mining, window functions, and complex query performance tuning.

Data Modeling Excellence: Meticulous understanding of database design principles, relational concepts, and dimensional data modeling (Star/Snowflake schemas) within modern column-oriented systems.

Cloud Platform Infrastructure Depth: Direct hands-on experience or functional configuration familiarity within Google Cloud Platform (GCP), specifically leveraging BigQuery, Airflow (Cloud Composer), Pub/Sub, and Dataflow.

Quality & Validation Acuity: Proven track record establishing automated data validation rules, data profiling scripts, and accuracy checks across large-scale datasets.

Soft Skills: Outstanding verbal and written communication skills with a demonstrated ability to draft technical specifications and solution documentation. Highly adaptable with the capacity to quickly master new technologies and communicate engineering issues cleanly to business management.

Preferred Assets
Prior professional experience operating within the Retail or E-Commerce sector.

Exposure to a variety of relational, NoSQL, and columnar database platforms.



Summary
If you are a tech-savvy Data Engineer who pairs an absolute command of advanced SQL and analytical data modeling with a solid foundation in Google Cloud architectures (BigQuery/Airflow), this 6-month contract offers a premier technology platform. Bring your warehouse design skills, validation precision, and collaborative mindset to an enterprise-defining analytics team today!

Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary/gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.

Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to accessibility@randstad.ca to ensure their ability to fully participate in the interview process.