Senior Data Analyst - SL
Senior Data Analyst - SL
Posted on :
10-07-2025
Employer Active
1 Vacancy
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Share
Send me jobs like this
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Job Description
We are seeking a highly skilled Senior Data Analyst with a strong background in SQL SSIS and data pipeline development. This role is ideal for someone who thrives in a collaborative Agile environment and is passionate about transforming business requirements into actionable data insights.
Location: Hybrid 1-Day a week
Clearance Requirement: Active Security Clearance required or must be eligible for Reliability Security Clearance
Responsibilities:
- Collaborate with business stakeholders to gather and refine user stories and translate them into data requirements
- Design and develop robust ETL pipelines using SSIS and SQL
- Perform data mapping ingestion and extraction across multiple sources
- Incorporate business logic into SSIS workflows using stored procedures
- Define and contribute to data modeling efforts in partnership with data engineers
- Develop and maintain dashboards and reports using Tableau
- Write and optimize complex SQL queries for data analysis and reporting
- Conduct unit testing and support business acceptance testing
- Document business rules data flows and technical specifications
Qualifications:
- Minimum 5 years of experience in business data analysis and report development
- Must have proven expertise in SQL
- Must have experience with Python
- Proven expertise in SSIS and ETL pipeline development
- Must have strong experience with data modeling and integrating business logic into data workflows
- Must be proficient in Tableau for dashboard and report creation
- Solid understanding of Agile methodologies
- Familiarity with QA processes including unit functional and user acceptance testing
- Excellent communication skills with the ability to articulate technical concepts to non-technical stakeholders
5+ years of experience in data quality assurance and testing, including developing and executing functional test cases, validating data pipelines, and coordinating deployments from development to production environments. Has supported at least one Enterprise/Government Organization with Big Data platforms and tools, such as Hadoop (HDFS, Pig, Hive, Spark), Big SQL, NoSQL, and Scala, ideally within cloud-based environments. 3+ data analysis and modeling projects, including working with structured and unstructured databases, building automated data quality pipelines, and collaborating with data engineers and architects to ensure high data integrity. Experience developing and executing test cases for Big Data pipelines, with deployments across dev, test, and production environments. Strong SQL skills for validation, troubleshooting, and data profiling. Applied knowledge of Big Data platforms including Hadoop (HDFS, Hive, Pig), Spark, BigSQL, NoSQL, Scala. Familiarity with cloud data ingestion and integration methods. Experience working with structured and unstructured data formats. Understanding of data modeling, data structures, and use-case-driven design. Experience in test automation for data validation pipelines is a strong asset. Prior experience with Genesys Cloud testing is a plus. Exposure to Tableau or other BI tools is beneficial. Hybrid role: 2 days/week onsite in North Vancouver
Employment Type
Full Time
Key Skills
Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.
