Senior BI Developer

4 weeks ago


Toronto, Canada GTT, LLC Full time
Senior BI Developer

Job Overview:
  • Senior BI Developer works with the Data Exchange Platform and HR DW team to bring onboard the legacy data into the platform.
  • The developer will be working on Azure Pipeline, Databricks, and converting PL/SQL packages into Databricks code.
  • The acceleration of our data-driven decision-making and the complexity of our data landscape necessitates a consultant with extensive experience in data engineering.

Job Responsibilities:
  • Senior BI Developer is required to translate technical systems specifications into working, tested applications. This includes:
    • developing detailed programming specifications writing and/or generating code compiling data-driven programs,
    • maintaining, and conducting unit tests.
  • Resolves and troubleshoots technical problems that arise during the use and operation of software packages, including technical assistance in implementation, conversion, and migrations.

Must Haves:
  • Demonstrated experience in Azure Databricks, Delta Lake, Azure Storage, ADF, Azure Analysis Service
  • Implement, maintain, and support BI solutions in Microsoft and other BI platforms
  • We seek a candidate with extensive experience with Oracle SQL and Spark SQL
  • Experience with cloud platforms like Azure and working knowledge of cloud migration
  • Experience with Microsoft Azure data analytics tools, such as Azure Data Factories, Azure Databricks, Azure Synapse

 

Nice to Have:

  • Prior public sector experience would be an asset
  • Experience working with PeopleSoft data would be an asset.
  • Proficiency with Power BI and DAX would be an asset.

Evaluation Criteria:

Development Skills 40%

  • 10+ years of experience in data analysis developing business intelligence and reporting in a medium to large-size corporate environment demonstrating detailed knowledge of BI functions such as analytics, data modeling & data mining, reporting, report conversion, and data cleansing.
  • Demonstrated experience in Azure Databricks, Delta Lake, Azure Storage, ADF, Azure Analysis Service (must have)
  • Design and develop BI dashboards and reports based on business requirements
  • Implement, maintain, and support BI solutions in Microsoft and other BI platforms (must-have)
  • Complete committed backlog and sprints within the agreed-upon timeframe
  • Curate data from multiple data sources for an efficient presentation in an enterprise environment
  • Recommend improvements to streamline processes regarding data flow and data quality to improve data accuracy, usability, and value
  • Remain abreast of technology developments within fields relevant to current and future BI and Reporting initiatives
  • The document "As Built' reports all data transformations deployed to production
  • Take ownership of end-to-end development of each dashboard and report being developed
  • We seek a candidate with extensive experience with Oracle SQL and Spark SQL (must have)
  • Proven ability to work with complex SQL queries, potentially hundreds or thousands of lines in length.
  • Ability to organize complex SQL for readability and understanding by others.
  • A solid understanding of concepts underlying analytical data models is required.
  • Experience working with PeopleSoft data would be an asset.
  • Proficiency with Power BI and DAX would be an asset.


Technology Skills 35%

  • Experience with cloud platforms like Azure and working knowledge of cloud migration (must have)
  • Experience with Microsoft Azure data analytics tools, such as Azure Data Factories, Azure Databricks, and Azure Synapse (must have)
  • Expertise in advanced prediction and prescriptive analytics including machine learning algorithms, designing experiments, fraud detection
  • Internally motivated and adaptable, able to work proficiently both independently and in a team environment.
  • Managing PowerBI workspaces, report access, report deployment, developing best practices in an enterprise environment
  • Strong knowledge and experience in analyzing as well as designing data models that meet the reporting needs
  • Advanced knowledge of writing complex SQL queries.
  • Strong Power BI experience (Power Query, DAX, Power Bi Services)
  • Experience with Microsoft BI and Azure stack
  • Able to troubleshoot BI reporting and analytic business needs and provide solutions for issue resolution


Soft Skills- 20%

  • Strong communication skills; both written and verbal
  • Ability to develop and present new ideas and conceptualize new approaches and solutions
  • Excellent interpersonal relations and demonstrated ability to work with others effectively in teams
  • Demonstrated ability to work with functional and technical teams
  • Demonstrated ability to participate in a large team and work closely with other individual team members
  • Proven analytical skills and systematic problem-solving
  • Strong ability to work under pressure, work with aggressive timelines, and be adaptive to change


Public Sector Experience 5%

  • Prior public sector experience would be an asset

Note:
  • Hybrid role- 3-days per week onsite required

#gttca
#LI-GTT
  • Senior BI Developer

    7 days ago


    Toronto, Canada GTT, LLC Full time

    Senior BI Developer (x3) Contract Duration 6+ MonthsOverview: Our client needs BI Developers to work with the data Exchange platform team. Senior BI Developer will be working on Azure Pipeline, and Databricks to create the dashboard and Power BI Reporting for Digital Dealer Registration (DDR) and other projects across the practice to re-platform and...


  • Toronto, ON, Canada 2i Solutions, Inc Full time

    There is 3 months contract opportunity, with possible extension for a Senior BI Developer, in Mississauga, Toronto. Work would be done remotely until the pandemic situation normalizes. Must haves: • Reliability level security clearance is mandatory • 3-5 years of relevant experience • Strong knowledge of Tableau 10 and above in design and...


  • Old Toronto, Canada 2i Solutions, Inc Full time

    There is 3 months contract opportunity, with possible extension for a Senior BI Developer, in Mississauga, Toronto.Work would be done remotely until the pandemic situation normalizes.Must haves:• Reliability level security clearance is mandatory• 3-5 years of relevant experience• Strong knowledge of Tableau 10 and above in design and development•...


  • Old Toronto, Canada 2i Solutions, Inc Full time

    There is 3 months contract opportunity, with possible extension for a Senior BI Developer, in Mississauga, Toronto.Work would be done remotely until the pandemic situation normalizes.Must haves:• Reliability level security clearance is mandatory• 3-5 years of relevant experience• Strong knowledge of Tableau 10 and above in design and development•...


  • Old Toronto, Canada 2i Solutions, Inc Full time

    There is 3 months contract opportunity, with possible extension for a Senior BI Developer, in Mississauga, Toronto.Work would be done remotely until the pandemic situation normalizes.Must haves:• Reliability level security clearance is mandatory• 3-5 years of relevant experience• Strong knowledge of Tableau 10 and above in design and development•...


  • Toronto, Canada Interac Corp. Full time

    Senior Business Intelligence (BI) Developer At Interac, we design and deliver products and solutions that give Canadians control over their money so they can get more out of life. But that’s not all. Whether we’re leading real-time money movement, driving innovative commerce solutions like open payments for transit systems, or making advancements in...

  • Senior BI Analyst

    6 days ago


    Toronto, Canada North Horizon Holdings Inc. Full time

    Job summary:The Senior BA/BI Analyst is mainly responsible for collecting, sorting, and analyzing business needs (BA) from the different business units, and leveraging the Microsoft 365 and Power Platform to quickly find an intelligent solution (BI) to fulfill the business need and ultimately help the business department to improve the productivity and...

  • BI Developers

    1 week ago


    Toronto, Canada Global Pharma Tek Full time

    Position: BI Developer Location: Toronto, ON (Hybrid) Duration: Business days + Possible Extension Job Description: Development Skills: We are seeking a candidate with extensive experience with Oracle SQL and Spark SQL. Proven ability to work with complex SQL queries, potentially hundreds or thousands of lines in length (must have) . Ability...


  • Toronto, Canada CB Canada Full time

    Senior Business Intelligence (BI) Specialist On behalf of our client in the Government Services Sector, PROCOM is looking for a Senior Business Intelligence (BI) Specialist. Senior Business Intelligence (BI) Specialist – Job Description Work with project teams to ensure successful release of Business Intelligence reporting using Power BI Use Power Query to...

  • Azure BI Developer

    3 weeks ago


    Toronto, Ontario, Canada Cleo Consulting Full time

    Assignment: RQ Software Developer SeniorStart Date:End Date:Office Location: 222 Jarvis StreetOrganization: Government Services Integration ClusterMinistry: Ministry of Public and Business Service Delivery (former MGCS) # Business Days: 226.00Title: Software DeveloperNOTE:Candidate is required to work onsite 3 days per week as requiredMust Haves:...

  • Senior BI Analyst

    7 days ago


    Toronto, ON, Canada North Horizon Holdings Inc. Full time

    Job summary:The Senior BA/BI Analyst is mainly responsible for collecting, sorting, and analyzing business needs (BA) from the different business units, and leveraging the Microsoft 365 and Power Platform to quickly find an intelligent solution (BI) to fulfill the business need and ultimately help the business department to improve the productivity and...

  • Senior BI Analyst

    7 days ago


    Toronto, ON, Canada North Horizon Holdings Inc. Full time

    Job summary:The Senior BA/BI Analyst is mainly responsible for collecting, sorting, and analyzing business needs (BA) from the different business units, and leveraging the Microsoft 365 and Power Platform to quickly find an intelligent solution (BI) to fulfill the business need and ultimately help the business department to improve the productivity and...

  • Senior BI Analyst

    1 week ago


    Toronto, ON, Canada North Horizon Holdings Inc. Full time

    Job summary:The Senior BA/BI Analyst is mainly responsible for collecting, sorting, and analyzing business needs (BA) from the different business units, and leveraging the Microsoft 365 and Power Platform to quickly find an intelligent solution (BI) to fulfill the business need and ultimately help the business department to improve the productivity and...

  • Senior BI Analyst

    6 days ago


    Toronto, ON, Canada North Horizon Holdings Inc. Full time

    Job summary:The Senior BA/BI Analyst is mainly responsible for collecting, sorting, and analyzing business needs (BA) from the different business units, and leveraging the Microsoft 365 and Power Platform to quickly find an intelligent solution (BI) to fulfill the business need and ultimately help the business department to improve the productivity and...

  • BI Developer

    3 weeks ago


    Toronto, ON, Canada Winsopro Full time

    We are seeking a skilled and experienced Business Intelligence (BI) Developer to join our team. As a BI Developer, you will be responsible for designing, developing, and maintaining our business intelligence solutions. You will collaborate with stakeholders to gather requirements, design data models, and create insightful reports and visualizations. Your...

  • BI Developer

    3 weeks ago


    Old Toronto, Canada Winsopro Full time

    We are seeking a skilled and experienced Business Intelligence (BI) Developer to join our team. As a BI Developer, you will be responsible for designing, developing, and maintaining our business intelligence solutions. You will collaborate with stakeholders to gather requirements, design data models, and create insightful reports and visualizations. Your...

  • BI Developer

    3 weeks ago


    Old Toronto, Canada Winsopro Full time

    We are seeking a skilled and experienced Business Intelligence (BI) Developer to join our team. As a BI Developer, you will be responsible for designing, developing, and maintaining our business intelligence solutions. You will collaborate with stakeholders to gather requirements, design data models, and create insightful reports and visualizations. Your...

  • BI Developer

    4 weeks ago


    Old Toronto, Canada Winsopro Full time

    We are seeking a skilled and experienced Business Intelligence (BI) Developer to join our team. As a BI Developer, you will be responsible for designing, developing, and maintaining our business intelligence solutions. You will collaborate with stakeholders to gather requirements, design data models, and create insightful reports and visualizations. Your...

  • BI Developer

    7 minutes ago


    Old Toronto, Canada Winsopro Full time

    We are seeking a skilled and experienced Business Intelligence (BI) Developer to join our team. As a BI Developer, you will be responsible for designing, developing, and maintaining our business intelligence solutions. You will collaborate with stakeholders to gather requirements, design data models, and create insightful reports and visualizations. Your...

  • Senior BI Analyst

    2 days ago


    Toronto, Canada North Horizon Holdings Inc. Full time

    Job summary: The Senior BA/BI Analyst is mainly responsible for collecting, sorting, and analyzing business needs (BA) from the different business units, and leveraging the Microsoft 365 and Power Platform to quickly find an intelligent solution (BI) to fulfill the business need and ultimately hel