Data Analyst

1 week ago

Toronto, Ontario, Canada Altitude Technology Solutions Full time

Position: Data Analyst

Location: Toronto, Canada (3 days Hybrid)

Required Skills: Linux shell scripting, SQL, Stored procedures, MS SQL DB experience, IBM Datastage, MS SQL utilities (BCP).

Job Summary

We are seeking a highly skilled Data Analyst with strong expertise in SQL, IBM DataStage, and Linux shell scripting to join our data engineering and analytics team. The ideal candidate will be responsible for managing, transforming, and analyzing large datasets, developing automation scripts, and ensuring data quality and integrity across multiple environments.

Key Responsibilities

  • Design, develop, and maintain ETL processes using IBM InfoSphere DataStage for data extraction, transformation, and loading.
  • Write and optimize complex SQL queries, views, and stored procedures for data manipulation and analysis.
  • Perform data validation, reconciliation, and quality checks to ensure data accuracy.
  • Utilize Linux shell scripting to automate routine data processes, job scheduling, and system monitoring.
  • Use MS SQL utilities such as BCP and BULK INSERT for high-volume data import/export operations.
  • Collaborate with data engineers, BI developers, and business stakeholders to define data requirements and reporting needs.
  • Troubleshoot ETL workflows, database issues, and performance bottlenecks.
  • Document data flows, transformations, and process logic for audit and maintenance purposes.

Required Skills & Qualifications

  • Bachelor's degree in Computer Science, Information Technology, or related field.
  • 8+ years of experience as a Data Analyst, ETL Developer, or Database Analyst.
  • Strong proficiency in MS SQL Server (T-SQL), including query optimization and stored procedure development.
  • Hands-on experience with IBM InfoSphere DataStage (job design, debugging, deployment).
  • Proficient in Linux/Unix shell scripting for automation and system operations.
  • Experience using MS SQL utilities (e.g., BCP, BULK INSERT).
  • Strong analytical, problem-solving, and debugging skills.
  • Good understanding of data warehousing concepts and ETL best practices.

Nice-to-Have Skills

  • Experience with data visualization tools (Power BI, Tableau, etc.).
  • Knowledge of Python or other scripting languages for data manipulation.
  • Familiarity with version control systems (Git) and job scheduling tools (Control-M, cron).
  • Exposure to cloud data platforms (Azure, AWS, GCP).

Thanks & Regards

Kundan Mishra

Sr. Technical Recruiter

Job Type: Fixed term contract

Contract length: 6 months

Pay: $50.00-$75.00 per hour

Expected hours: 40 per week

Experience:

  • Data Analyst: 10 years (preferred)
  • Linux: 2 years (preferred)
  • SQL: 5 years (preferred)
  • DataStage: 3 years (preferred)
  • Banking: 5 years (preferred)

  • Quality Analyst

    1 week ago

    Toronto, Ontario, Canada NTT DATA Full time

    Req ID: 347976NTT DATA strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now. We are currently seeking a Quality Analyst to join our team in Toronto, Ontario (CA-ON), Canada (CA). QA Analyst Who we are: NTT DATA America's...

  • Data Analyst

    1 week ago

    Toronto, Ontario, Canada Tata Consultancy Services (TCS) Full time

    Inclusion without Exception:Tata Consultancy Services (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 is reflected in our...

  • Data Analyst

    2 weeks ago

    Toronto, Ontario, Canada WongDoody Full time

    WONGDOODY is hiring a Data Analyst to join our Insights & Strategy team and support a high-profile digital transformation initiative for an automotive OEM primary dot com website. This end-to-end program spans user research, content strategy, CMS replatforming, UX/UI design, front-end development, QA/testing, and launch. As a Data Analyst, you'll turn raw...

  • Data Analyst

    1 week ago

    Toronto, Ontario, Canada WongDoody Full time

    WONGDOODY is hiring a Data Analyst to join our Insights & Strategy team and support a high-profile digital transformation initiative for an automotive OEM primary dot com website. This end-to-end program spans user research, content strategy, CMS replatforming, UX/UI design, front-end development, QA/testing, and launch.As a Data Analyst, you'll turn raw...

  • Data Analyst

    1 week ago

    Toronto, Ontario, Canada Fairstone Full time

    WHO WE ARE:Eden Park Inc. ("EdenPark") is a dynamic automobile finance brand committed to enabling our dealer partners to sell more cars. Since 2012, EdenPark has serviced a wide network of automobile dealers and tens of thousands of consumers from coast to coast. EdenPark is a wholly owned subsidiary of Fairstone Financial Inc., which is a subsidiary of...

  • Data Analyst

    1 week ago

    Toronto, Ontario, Canada Fairstone Bank Full time

    WHO WE ARE:Eden Park Inc. ("EdenPark") is a dynamic automobile finance brand committed to enabling our dealer partners to sell more cars. Since 2012, EdenPark has serviced a wide network of automobile dealers and tens of thousands of consumers from coast to coast. EdenPark is a wholly owned subsidiary of Fairstone Financial Inc., which is a subsidiary of...

  • Data Analyst

    1 week ago

    Toronto, Ontario, Canada Fairstone Bank Full time

    Who We AreEden Park Inc. ("EdenPark") is a dynamic automobile finance brand committed to enabling our dealer partners to sell more cars. Since 2012, EdenPark has serviced a wide network of automobile dealers and tens of thousands of consumers from coast to coast. EdenPark is a wholly owned subsidiary of Fairstone Financial Inc., which is a subsidiary of...

  • Data Analyst

    1 week ago

    Toronto, Ontario, Canada Randstad Digital Americas Full time

    Our firm operates at the exciting intersection of financial analytics and the global gaming industry. We're looking for a bright, motivated Data Analyst to join our team in a unique.This role is perfect for a smart, process-oriented analyst who wants to make a significant impact in a fast-paced, learning-focused environment. You'll dive deep into complex...

  • Data Analyst

    2 weeks ago

    Toronto, Ontario, Canada Environmental Career Center Full time

    About The RoleJoin KPCA as a Data Analyst and play a pivotal role in transforming data into actionable insights within the dynamic Gambling & Casinos industry. This position offers a unique opportunity to work at the intersection of data and entertainment, helping drive strategic decisions that enhance player experience and business performance.As a key...

  • Data Analyst

    1 week ago

    Toronto, Ontario, Canada Procom Full time

    Data Analyst - SAS and Power BI:On behalf of our Banking client, Procom is searching for a Data Analyst - SAS and Power BI for a 12-month role. This position is a hybrid position with 2 days onsite at our client's Toronto office.Job Description:The role supports the newly formed Credit Card and Unsecured Lending (CCUL) Engagement Squad, focusing on engaging...