Intermediate ETL Developer specializing in Microsoft SQL Server and Power BI to Design and deve[...]

1 month ago


Vancouver, Canada S I Systems Full time
Intermediate ETL Developer specializing in Microsoft SQL Server and Power BI to Design and develop ETL processes to enable creation a comprehensive dashboard

Our construction client is looking for an Intermediate ETL Developer specializing in Microsoft SQL Server and Power BI to Design and develop ETL processes to enable creation a comprehensive dashboard

4 months, Vancouver, hybrid 1 day a week (open to remote)

Must Have:

·5+ years of experience as an ETL Developer or related role.

·Proficiency in MicrosoftSQL Server ( T-SQL ), and SSMS (Microsoft Management Studio)

·Experience with Power BI for data visualization and reporting.

·Experience with ETL tools and technologies (e.g., SSIS, Power Query ).

·Strong understanding of data warehousing concepts and dimensional modeling.

Nice to Have:

·Experience with Azure SQL

·Knowledge of additional database technologies (e.g., Oracle, MySQL).

·Previous work with financial data or in the financial sector

·Previous experience in a business intelligence or analytics role.

Responsibilities:

·Design and develop ETL processes using SSIS or other relevant tools to extract data from various source systems (e.g., CRM, ERP, flat files).

·Clean, transform, and load data into the MS SQL Server data warehouse following best practices for data quality and performance.

·Develop and maintain T-SQL queries for data extraction, transformation, and loading tasks.

·Collaborate with business analysts and stakeholders to understand data requirements and translate them into technical specifications.

·Develop and implement a new data management solution using Azure SQL

·Collaborate with the Financial Planning and Analysis Team to understand data requirements

·Design and implement ETL processes using SSIS for efficient data integration

·Create comprehensive Power BI dashboards for financial data analysis

#J-18808-Ljbffr

  • Vancouver, Canada Microsoft Full time

    Overview With over 18,000 employees worldwide, the Microsoft Customer Experience & Success (CE&S) organization is responsible for the strategy, design, and implementation of Microsoft’s end-to-end customer experience. Come join CE&S and help us build a future where customers come to us not only because we provide industry-leading products and...


  • Vancouver, British Columbia, Canada Microsoft Canada Full time

    OverviewWith over 18,000 employees worldwide, the Microsoft Customer Experience & Success (CE&S) organization is responsible for the strategy, design, and implementation of Microsoft's end-to-end customer experience. Come join CE&S and help us build a future where customers come to us not only because we provide industry-leading products and services, but...


  • Vancouver, Canada CB Canada Full time

    Intermediate Data Integration Developer, SSISOn behalf of our client in the private sector, PROCOM is looking for an Intermediate Data Integration Developer, SSIS. Intermediate Data Integration Developer, SSIS Job DescriptionSupport and develop SSIS solutions executing systems integrations and data migrationsLeverage extensive SSIS experience to reverse...


  • Vancouver, Canada CB Canada Full time

    Intermediate Data Integration Developer, SSISOn behalf of our client in the private sector, PROCOM is looking for an Intermediate Data Integration Developer, SSIS. Intermediate Data Integration Developer, SSIS Job DescriptionSupport and develop SSIS solutions executing systems integrations and data migrationsLeverage extensive SSIS experience to reverse...

  • Lead Data Analyst

    4 weeks ago


    Vancouver, BC, Canada tsworks Full time

    Who We Aretsworks Canada, Inc is a technology products and services company based out of Ontario, Canada. We are a subsidiary of The Software Works, Inc, USA. Our mission is to adopt, challenge and set the best practices in Information Technology. At tsworks Canada Inc, we value our employees, take pride in providing best value in customer engagements, and...

  • Lead Data Analyst

    4 weeks ago


    Vancouver, BC, Canada tsworks Full time

    Who We Aretsworks Canada, Inc is a technology products and services company based out of Ontario, Canada. We are a subsidiary of The Software Works, Inc, USA. Our mission is to adopt, challenge and set the best practices in Information Technology. At tsworks Canada Inc, we value our employees, take pride in providing best value in customer engagements, and...

  • Lead Data Analyst

    2 months ago


    Vancouver, Canada tsworks Full time

    Who We Aretsworks Canada, Inc is a technology products and services company based out of Ontario, Canada. We are a subsidiary of The Software Works, Inc, USA. Our mission is to adopt, challenge and set the best practices in Information Technology. At tsworks Canada Inc, we value our employees, take pride in providing best value in customer engagements, and...

  • Lead Data Analyst

    2 months ago


    Vancouver, Canada tsworks Full time

    Who We Are tsworks Canada, Inc is a technology products and services company based out of Ontario, Canada. We are a subsidiary of The Software Works, Inc, USA. Our mission is to adopt, challenge and set the best practices in Information Technology. At tsworks Canada Inc, we value our employees, take pride in providing best value in customer engagements, and...

  • Lead Data Analyst

    2 months ago


    Vancouver, Canada tsworks Full time

    Who We Aretsworks Canada, Inc is a technology products and services company based out of Ontario, Canada. We are a subsidiary of The Software Works, Inc, USA. Our mission is to adopt, challenge and set the best practices in Information Technology. At tsworks Canada Inc, we value our employees, take pride in providing best value in customer engagements, and...

  • BI Analyst

    2 months ago


    Vancouver, BC, Canada Arcas Technology Ltd Full time

    Arcas Technology is partnered with a leading Property Management company based in Surrey who are currently looking for an experienced BI Analyst to join their business on a permanent basis. Role Summary: My client is seeking a dedicated individual to collaborate closely with various teams and stakeholders in order to fulfil business intelligence...

  • SQL Report Writer

    2 weeks ago


    Vancouver, Canada Gaming Laboratories International Full time

    While providing integrity to the casino and gambling industry for over 33 years, GLI has established an incomparable team of professionals. The SQL Report Writer is responsible for serving as a link between engineers, marketing associates, developers, as well as external clients, to identify and conceptualize insightful data analysis with actionable...


  • Vancouver, Canada Point Alliance Inc. Full time

    Job title: Senior Microsoft .NET DeveloperPosted on: April 10, 2024Job Location: Toronto, CanadaJob Status: Permanent Full TimeYears of Work Experience: ≥4Degrees Required: University or College DegreeWe are looking for a Senior Microsoft .NET Developer to join our consulting firm and build functional applications and websites in the Greater Toronto...


  • Vancouver, Canada Point Alliance Inc. Full time

    Job title: Senior Microsoft .NET DeveloperPosted on: April 10, 2024Job Location: Toronto, CanadaJob Status: Permanent Full TimeYears of Work Experience: ≥4Degrees Required: University or College DegreeWe are looking for a Senior Microsoft .NET Developer to join our consulting firm and build functional applications and websites in the Greater Toronto...


  • Vancouver, Canada Microsoft Full time

    Overview With over 18,000 employees worldwide, the Microsoft Customer Experience & Success (CE&S) organization is responsible for the strategy, design, and implementation of Microsoft’s end-to-end customer experience. Come join CE&S and help us build a future where customers come to us not only because we provide industry-leading products and...


  • Vancouver, Canada PHSA Full time

    **Job Summary**: In accordance with the Mission, Vision and Values, and strategic directions of Provincial Health Services Authority patient safety is a priority and a responsibility shared by everyone at PHSA, and as such, the requirement to continuously improve quality and safety is inherent in all aspects of this position. The Business Intelligence...


  • Vancouver, Canada Appara Full time

    OVERVIEW: We’re looking for an Intermediate Full Stack Software Developer for our Software Development team to join us in the design, building, testing, and deployment of new products and features for the Appara Legal Automation Platform. You’ll be working with a team of talented developers to deve

  • Snr Bi

    5 days ago


    Vancouver, Canada Fastloop Full time

    **BI Development**: - Understand business strategy, objectives and processes that will be enabled and/or enhanced by an analytics solution - Drive dashboarding best practices and adoption amongst internal and external stakeholders - Being able to effectively communicate insights through data visualization and storytelling. **Data Analysis and...


  • Vancouver, Canada PHSA Full time

    **Business Intelligence Database Analyst** BC Centre for Disease Control 655 W 12th Ave, Vancouver, BC V5Z 4R4 In accordance with the Mission, Vision and Values, and strategic directions of Provincial Health Services Authority patient safety is a priority and a responsibility shared by everyone at PHSA, and as such, the requirement to continuously improve...

  • It- Reporting Analyst

    2 weeks ago


    Vancouver, Canada Northland Full time

    **About Northland **Recognized throughout Canada as one of the most trusted names in hotels, restaurants, and sports & entertainment. Northland Properties Corporation is the force behind such brands as Sandman Hotel Group, The Sutton Place Hotels, Moxie's Grill & Bar, Chop Steakhouse & Bar, Denny's Restaurants, the Dallas Stars, Grouse Mountain, Revelstoke...


  • Vancouver, Canada Zortechsolutions Full time

    Role: Data Engineer-SQL, Python, ETLLocation: Vancouver/CANADADuration: Full TimeJob DescriptionKey Skills required: We are looking for Senior Data Engineering Candidates based out of the Canada. Expertise in SQL, Python and ETL flows is a must have. Medium expertise/working knowledge in Scala is also needed, as our data pipelines are written in both Scala...