Senior Data Warehouse Analyst (ETL Developer) to design, develop, deploy, and test end-to-end data pipelines and data models - RFC-2024-030

S.i. Systems
Vancouver
Temporary

S.i. System's client is looking for an Senior Data Warehouse Analyst (ETL Developer) to design, develop, deploy, and test end-to-end data pipelines and data models

This is a 8-month contract to start with chances of extension. This is a hybrid model, looking for candidates open to coming to the office once a week at their New Westminster office.

MUST HAVES :

  • 10+ years’ experience with Business Intelligence / Data Analytics
  • Hands-on experience with a range of Azure Services, including ADF / Azure Databricks , Delta Lake, Azure Data Lake Storage, Azure Synapse , Power BI Report and Crystal Report.
  • Hands-on experience with authoring Power BI reports, exposure to Power BI Cloud.
  • Experience designing, building, and maintaining ETL / ELT data pipelines, (preferably Azure Data Factory).
  • Demonstrated ability to interact professionally with a diverse group of executives, managers, supervisors, subject matter experts and end users.
  • Skilled at facilitating and managing consultation processes with a wide range of stakeholder groups.
  • Proven experience with gathering and analyzing functional and technical requirements and information from key business areas and stakeholder groups.
  • Excellent interpersonal skills combined with highly developed communication skills, both verbal and written

Nice to Have :

  • Hands-on experience with Spark (PySpark / Python) in Azure.
  • Experience with data migration from on-prem to cloud (preferably Azure Data Factory).
  • Strong knowledge and experience designing Data Lakes and Data Warehouses.
  • Hands-on knowledge of Azure SQL Data Warehouse architecture and best practices.
  • Extensive knowledge of Dimensional Modelling and Kimball EDW principles Understanding of Azure
  • Managed Instance.
  • Experience working with Data Lakes and Data Marts.
  • Ability to work with large volumes of data from multiple sources.
  • Microsoft SQL Server SSIS / SSRS / ETL.
  • Experience in Azure IaaS, PaaS and Database migration.
  • Experience working with external vendors.
  • Experience working in a unionized environment.
  • 20 hours ago
Related jobs
Promoted
Vancouver Airport Authority
Vancouver, British Columbia

Reporting to the Manager, Enterprise Advanced Analytics, the Senior Technical Analyst – Advanced Analytic (Data Engineer) is responsible for determining the required strategy and technical architecture, leading technical decisions, leading projects, managing day to day operational activities, guidin...

Promoted
ApexFocusGroup
Richmond, British Columbia

Ability to read, understand, and follow oral and written instructions. You get to review and use new products or services before they are released to the public. Our company is seeking individuals to participate in National & Local Paid Focus Groups, Clinical Trials, and Market Research assignments....

Promoted
Vancouver Airport Authority
Delta, British Columbia

Mentor business and junior IT resources in business analysis, technical troubleshooting, and BI and Data Warehouse support skills. Lead the planning and implementation of BI and data analytics projects, including defining scope, develop project plan, budgets, tracking deliverables and alignment with...

S.i. Systems
Vancouver, British Columbia

Our client is seeking Data Scientists specialized in Computer Vision, Python and Machine Learning to support various robotics and automation projects in the mining industry (HYBRID SASKATOON, SK). Will be responsible for documentation, learning new technology/emerging technology, and supporting auto...

Warman O'Brien
Canada

You will be expected to oversee and manage end-to-end delivery of data management services across individual or multiple projects. You will be responsible for delivering your data management expertise to the data management team and assisting in providing the highest quality results for customer nee...

S.i. Systems
Vancouver, British Columbia

Architectural experience using modelling languages and frameworks (UML, TOGAF, Archimate, 4 View Model, etc), architecture practices and principles in Business, Information (data), Application, Technology, and Security architecture disciplines. Senior Solution Architect to create and support Digital...

Miovision
Canada
Remote

The ideal candidate will have a very strong attention to detail, analytical skills, financial modeling, and an in-depth experience and understanding of commission structures and calculating complex commissions. Develop financial models, forecasts, and BI dashboards to analyze trends, performance, an...

S.i. Systems
Vancouver, British Columbia

Monitor and optimize ARC platform data pipelines to ensure efficient data flow and system performance. Senior Data Engineer Team Lead to oversee critical data engineering activities within the Digital Health sector. Work with stakeholders and data SMEs to identify and implement enhancements to ARC p...

Amazon Development Centre Canada ULC
Vancouver, British Columbia

You will work closely with Data Engineers, Product Managers, Business Intelligence Engineers, and Software Engineers to develop statistical models, design and run experiments, and find new ways to to optimize the customer experience. Understanding customer behavior to personalize customer experience...

Amazon Data Services Canada, Inc.
Vancouver, British Columbia

The successful applicant will work with our Product and SDE teams to build data systems that will simplify bringing new models to customers and enhance the visibility into our underlying modeling process. Our team operates the public Customer Carbon Footprint Tool and we have a high bar for releasin...