SAS Consultant

1 week ago

Toronto Ontario, Ontario, Canada Celebal Technologies Full time

About the role - We are seeking an experienced SAS Consultant with a strong background in data migration, particularly in transitioning from SAS environments to Databricks. The ideal candidate will possess deep technical expertise in SAS programming, data integration, and a thorough understanding of Databricks and Apache Spark. You will play a pivotal role in evaluating existing SAS environments, identifying migration opportunities, and ensuring a seamless transition to a modern, scalable Databricks-based architecture.



Responsibilities -

  • Evaluate the current SAS environment, including data structures, workflows, dependencies, and integration points.
  • Analyze the existing SAS codebase to identify components suitable for migration to Databricks.
  • Design, develop, and execute migration strategies to transition SAS workloads to Databricks, ensuring minimal disruption to ongoing operations.
  • Ensure the integrity, consistency, and accuracy of data during the migration process.
  • Conduct comprehensive testing to validate the functionality, performance, and accuracy of migrated components.
  • Identify and resolve bottlenecks, such as inefficient queries, data pipeline performance issues, or resource contention, during and after migration.
  • Provide ongoing support and troubleshooting expertise to address any challenges encountered in the migration process.
  • Collaborate with the Databricks engineering team and stakeholders to design enhancements and implement optimizations based on evolving requirements.
  • Document the migration process, including code translations, data transformation logic, and performance benchmarks, to support knowledge transfer and scalability.
  • Offer training and mentoring to clients or internal teams to ensure a smooth transition to Databricks.
  • Stay updated with the latest advancements in Databricks, Apache Spark, and data migration tools to ensure the adoption of best practices.



Required Skills



SAS Expertise:

  • Proficiency in SAS programming, including data manipulation, analysis, and reporting using SAS tools.
  • Deep knowledge of SAS data structures, macros, procedures, and workflows.
  • Understanding of SAS-based ETL processes and integration frameworks.


Databricks and Spark Expertise:

  • Hands-on experience with Apache Spark, particularly within the Databricks platform.
  • Proficiency in Spark SQL, Python, Scala, or other Databricks-supported programming languages.
  • Experience in designing and optimizing data pipelines in a Databricks environment.


Data Engineering and Analytics:

  • Strong knowledge of ETL processes, data transformation, and data modeling.
  • Familiarity with data warehousing principles and best practices.


Testing and Optimization:

  • Proven ability to test and validate large-scale migrations, ensuring performance, functionality, and accuracy.
  • Expertise in identifying and resolving performance issues in data pipelines or queries.


Collaboration and Communication:

  • Strong interpersonal skills to liaise effectively with stakeholders, including technical teams, clients, and end-users.
  • Ability to create clear and concise documentation to facilitate knowledge sharing.


Experience:

  • Minimum of 6+ years in SAS programming, data analysis, or related fields.
  • At least 2 years of experience in Databricks, Apache Spark, or a similar cloud-based big data platform.
  • Proven track record of successfully migrating workloads from SAS or other legacy systems to modern platforms.

Preferred Skills

  • Certification in Databricks or Apache Spark.
  • Experience with cloud platforms such as Azure, AWS, or GCP.
  • Knowledge of automation tools or frameworks for streamlining migration processes.

  • SAS Campaign Specialist

    4 weeks ago

    Toronto, Ontario, Canada Randstad Canada Full time

    At Randstad Canada, we are seeking a highly skilled SAS Campaign Specialist to join our team. With a strong background in CRM implementation and analysis, you will have the opportunity to work with a leading employer in the Toronto market.This is a hybrid role that requires 3 days of in-office work and 2 days of remote work. As a SAS Campaign Specialist, you...

  • SAS Campaign Management Specialist

    4 weeks ago

    Toronto, Ontario, Canada Randstad Canada Full time

    Job SummaryWe are seeking a skilled SAS Campaign Management Specialist to join our team. The ideal candidate will have experience with CRM systems, business analyst skills, and excellent communication abilities.Key Responsibilities• Collaborate with clients to analyze business requirements and recommend solutions• Support project managers in delivering...

  • Salesforce Marketing Cloud Consultant

    1 week ago

    Toronto, Ontario, Ontario, Canada Tata Consultancy Services Full time

    TCS is an equal opportunity employer, and embraces diversity in race, nationality, ethnicity, gender, age, physical ability, neurodiversity, and sexual orientation, to create a workforce that reflects the societies we operate in. Our continued commitment to Culture and Diversity and is reflected in our people stories across our workforce implemented through...

  • SAS Campaign Analyst

    3 weeks ago

    Toronto, Ontario, Canada Randstad Canada Full time

    We are seeking a highly skilled SAS Campaign Analyst to join our team in Toronto. In this role, you will have the opportunity to work with a leading employer in the local market.As a SAS Campaign Analyst, you will be responsible for interfacing directly with clients, analyzing business requirements, and recommending solutions through functional requirements...

  • Biostatistical Consultant

    4 weeks ago

    Toronto, Ontario, Canada Baycrest Full time

    Job SummaryWe are seeking a skilled Senior Biostatistician to join our team at Baycrest. The ideal candidate will have a strong background in statistical analysis and methodological consultation, with experience in healthcare settings.Key Responsibilities• Provide statistical consultation and mentorship to clinicians, researchers, and other clients...

  • Data Scientist Consultant

    1 month ago

    Toronto, Ontario, Canada Management Solutions, S.L Full time

    Career Opportunity: Data Scientist ConsultantWe are seeking a highly skilled Data Scientist Consultant to join our team at Management Solutions. As a Data Scientist Consultant, you will play a key role in delivering business, risk, financial, organisational and process-related advisory services to our clients.Recent graduates or final year students from...

  • Senior Biostatistician Consultant

    3 weeks ago

    Toronto, Ontario, Canada Baycrest Full time

    About the Role:We are seeking a highly skilled Senior Biostatistician to join our team at Baycrest. As a senior biostatistician, you will play a key role in providing statistical consultation and mentorship to clinicians, researchers, and other clients.Job Description:The Senior Biostatistician will be responsible for data management, including extracting...

  • Data Science Consultant to Healthcare Organizations

    3 weeks ago

    Toronto, Ontario, Canada Tiger Analytics Full time

    Tiger Analytics, a leading advanced analytics consulting firm, is seeking an experienced Data Science Consultant to join our team. Our consultants bring deep expertise in Data Science, Machine Learning, and AI, and we maintain one of the best Glassdoor ratings among our peers.Responsibilities:Design and implement advanced analytics solutions to drive...

  • Advanced Analytics Consultant

    3 weeks ago

    Toronto, Ontario, Canada Tiger Analytics Full time

    Tiger Analytics, a leading advanced analytics consulting firm, seeks an experienced Advanced Analytics Consultant to join our team. We are the trusted analytics partner for multiple Fortune 500 companies and have been recognized as a leader by various market research firms.This is an exceptional opportunity to work on the latest applications of data science...

  • Strategic Analytics Consultant

    4 weeks ago

    Toronto, Ontario, Canada Tiger Analytics Full time

    Unlock Your Career in Advanced AnalyticsTiger Analytics is a pioneering firm specializing in advanced analytics consulting. As a trusted partner for Fortune 500 companies, we have consistently been recognized as leaders by market research firms such as Forrester and Gartner. This achievement marks our third consecutive year on the Inc. 5000 list of...

  • Anti-Money Laundering Investigator

    1 month ago

    Toronto, Ontario, Ontario, Canada emergiTEL Full time

    The RoleMy client is seeking skilled professionals in financial crimes to help identify and mitigate risks of money laundering and terrorist financing. This is a 9-month contract within Financial Crimes Services, in a hybrid model with 3 days onsite in Downtown Toronto (initially 4 days per week for training). You’ll have access to a fully equipped...

  • Consultant Senior d'Amélioration Continue

    4 weeks ago

    Toronto, Ontario, Canada CIBC Full time

    Qui sommes-nous ?La Banque CIBC est une institution financière axée sur les relations qui se distingue par son engagement envers sa clientèle et son personnel. Nous sommes en quête de professionnels talentueux et passionnés qui partagent nos valeurs et sont prêts à faire une différence significative.Nos valeursNous mettons nos clients au cœur de...

  • Mulesoft Developer

    5 days ago

    Toronto, Ontario, Ontario, Canada Tata Consultancy Services Full time

    Inclusion without Exception;TCS is an equal opportunity employer, and embraces diversity in race, nationality, ethnicity, gender, age, physical ability, neurodiversity, and sexual orientation, to create a workforce that reflects the societies we operate in. Our continued commitment to Culture and Diversity and is reflected in our people stories across our...

  • Data Analyst

    1 month ago

    Toronto, Ontario, Ontario, Canada Astek Full time

    The Astek GroupFounded in France in 1988, Astek is a global player in engineering and technology consulting. With its expertise in various industrial and tertiary sectors, Astek supports its international clients in the intelligent deployment of their products and services, as well as in the implementation of their digital transformation.Since its inception,...

  • Digital Transformation Consultant

    3 weeks ago

    Toronto, Ontario, Canada Orion Innovation Full time

    Company Overview:Orion Innovation is a leading business and technology services firm, renowned for delivering innovative solutions that drive game-changing business transformation. With a unique combination of agility, scale, and maturity, we help clients across various industries achieve their goals.About the Role:This exciting opportunity as a Business...

  • Data Science Manager

    1 month ago

    Toronto, Ontario, Ontario, Canada MathCo Full time

    To explore more roles at MathCo® visit our careers page.Designation: Data Science, Manager – Customer Success About UsTheMathCompany or MathCo® is a global Enterprise AI and Analytics company trusted for data-driven decision-making by leading Fortune 500 and Global 2000 enterprises. Founded in 2016, MathCo builds custom AI and advanced analytics...

  • Executive Architect

    3 days ago

    Toronto, Ontario, Canada Royal Bank of Canada Full time

    As a Senior Solutions Architect at Royal Bank of Canada, you will play a key role in designing and implementing cutting-edge technology solutions to drive business growth. With a strong focus on architecture, innovation, and collaboration, this position requires an exceptional leader with expertise in cloud-based technologies.The ideal candidate will have 8+...

  • Biostatistical Research Expert

    3 weeks ago

    Toronto, Ontario, Canada Baycrest Full time

    Job SummaryKL-CARE, a hub for clinical, applied, and evaluative research at Baycrest, seeks a skilled Senior Biostatistician to collaborate in statistical design, data management, and analysis. The successful candidate will provide consultation and mentorship on study planning, data extraction, and quantitative analyses, as well as develop reports and...

  • Data Architecture Lead

    8 hours ago

    Toronto, Ontario, Canada Royal Bank of Canada Full time

    Job SummaryRoyal Bank of Canada is seeking an experienced Data Architecture Lead to join our Wealth Management Technology & Solutions team.About the RoleThis is a key leadership position responsible for designing and implementing architecturally significant IT initiatives that meet sponsor/stakeholder needs. You will lead development of the end-to-end...

  • Actuarial Consultant, Commercial Insurance Specialist

    3 weeks ago

    Toronto, Ontario, Canada Definity Full time

    About the RoleWe are seeking a highly skilled Actuarial Analyst to join our experienced commercial pricing department. The ideal candidate will have a strong background in actuarial sciences and commercial insurance product knowledge.Key ResponsibilitiesParticipate in individual commercial rated auto regulatory filings;Develop and apply your experience with...