Data Analyst - Remote

Our client is seeking a Remote Data Analyst with 7+ years of experience to support enterprise data solution design and development. The role involves translating business requirements into scalable data products, building data models, and supporting ETL and integration work using SQL, Python, Spark, Databricks, and Azure. The ideal candidate will help modernize legacy data systems, implement medallion architecture, and ensure alignment with data governance standards while working closely with business and technical stakeholders in an Agile environment.

*** Candidates must be eligible for Government of Canada Reliability Security Clearance (5+ years in Canada) ***

*** Remote contract position ***

Advantages
•Improved work life balance through flexible scheduling and no commute.
•Broader collaboration opportunities with diverse teams regardless of location.


Responsibilities
•Gather, document, and analyze business and data requirements
•Translate business needs into data solutions and enterprise data products
•Design end-to-end data solutions, including data flows, models, and ETL mappings
•Develop and maintain conceptual, logical, and physical data models
•Build and refactor SQL-based ETL processes and support data integration work
•Reverse engineer legacy ETL systems and source-to-target mappings
•Ensure solutions align with enterprise data architecture and governance standards
•Collaborate with data architects, governance teams, and business stakeholders
•Implement and support medallion architecture (bronze, silver, gold layers)
•Support modernization of legacy systems and improve financial reporting data processes
•Produce clear documentation for designs, requirements, and solution validation
•Communicate technical concepts, issues, and solutions to both technical and non-technical stakeholders


Qualifications
•Bachelor’s degree in Management Information Systems, Computer Science, Engineering, Business, or related field
•7+ years of experience as a Data Analyst or Data Modeler
•Strong hands-on experience with SQL programming and ETL development (including refactoring)
•Experience with data modeling (conceptual, logical, and physical) and data integration
•Experience working with Azure Data Platform and Databricks
•Proficiency in Python, SQL, and Apache Spark
•Experience reverse engineering legacy ETL solutions (e.g., DataStage)
•Strong understanding of data architecture, data lineage, and data governance principles
•Experience implementing or working within medallion architecture
•Strong analytical, problem-solving, and attention-to-detail skills
•Excellent communication and stakeholder engagement abilities
•Ability to work in Agile environments

Assets (nice to have):

•Experience with erwin or other data modeling tools
•Knowledge of CI/CD practices
•Experience with Denodo data virtualization
•Power BI development experience

Summary
If you're qualified and interested please submit your resume and one of our experienced Recruiters would be happy to give you a call. Thank you.

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.