Lead .Net and BI(SSRS/ SSIS) Developer

3 weeks ago


Old Toronto, Canada Scotiabank Full time
Title: Lead .Net and BI(SSRS/ SSIS) Developer

Requisition ID: 209826

Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture.

The Team

We are looking for a Software Engineer for the Group Treasury Technology (GTT) IT group in support of the Liquidity & Funding mgmt. businesses.

Is this role right for you? In this role you will:

  1. Work closely with customers, Business Analysts, and team members to understand business requirements that drive the analysis and design of quality technical solutions.
  2. Be involved in the full systems life cycle and be responsible for designing, coding, testing, implementing, and supporting applications software that is delivered on time and within budget.
  3. Make recommendations towards the development of new code or reuse of existing code.
  4. Participate in component and data architecture design, performance monitoring and product evaluation.
  5. Provide guidance and training to less experienced analysts and programmers.
  6. Provide front-line application support and coordination when application problems occur.
  7. Participate in the evaluation of production logs and System Service Requests of high complexity and identify actions to be taken to accomplish successful resolution to problem logs and deployment of new enhancements to the field.
  8. Assist in Integrated System Test (IST) by supporting the test plan, test case validation and execution.
  9. Provide production support of global FI REPO trading platform.
  10. Liaise with external vendors, product users, operations staff, technical support groups and other development teams in all phases of development project activities and production support activities.
  11. Design and build data visualizations, dashboards and reports using software tools including but not limited to Power BI & SQL Server Reporting Services.
  12. Design and develop reports, dashboards, KPI Scorecards and other analytical assets.
  13. Create and maintain interactive data visualization through data interpretation and analyses, integrating various reporting components from multiple data sources.
  14. Create new methods to visualize core business metrics through reports, interactive dashboards, and analysis in Power BI.
  15. Work as part of a team to design, develop and deploy systems with configuration for different client data and business rules.
  16. Build back-end solutions of views/models to be consumed by other BI Developers or business users, as well as customer facing front end reporting models/visualizations.
  17. Devise and deliver testing plans and testing data to validate BI solutions.
  18. Coordinate user testing for acceptance of BI solutions.
  19. Deploy and Validate BI solutions ensuring changes follow appropriate Change and Release Management processes.
  20. Support and enhance existing reports and dashboards based on evolving business needs.
  21. Assist in facilitating hands-on sessions in prioritizing user-stories, designing analytical approaches, running experiments, and assessing data product performance.
  22. Assist in the discovery of business stakeholder analytical and reporting challenges and requirements.
  23. Collect, interpret and analyze large data sets using software packages including but not limited to SQL Server, Power BI, SSRS, SSIS to identify patterns and trends that can be used to increase efficiency of business units internally within the company.
  24. Assemble large, complex data sets that meet functional / non-functional business requirements and design custom ETL and ELT processes in support of these processes.

Do you have the skills that will enable you to succeed in this role? We’d love to work with you if you have:

  1. 5+ years experience in the design and implementation of BI solutions.
  2. 5+ years SSRS experience.
  3. 5+ years SSIS experience.
  4. 5+ years Power BI/Power Apps/ Power Automate experience.
  5. 5+ years SQL Server DB & Query development.
  6. Demonstrated experience in applying UI/UX and visualization design principles.

Nice To Have Skills:

  1. 2+ years' experience with Python is an asset.
  2. 2+ years working with cloud-based platform (Azure, PCF or GCP).
  3. Hands-on experience in Cloud Microservice and MicroApp development.

What's in it for you?

  1. We have an inclusive and collaborative working environment that encourages creativity, curiosity, and celebrates success
  2. We provide you with the tools and technology needed to create beautiful customer experiences.
  3. You'll get to work with and learn from diverse industry leaders, who have hailed from top technology companies around the world.
  4. Onsite cafeteria.
  5. Dress codes don't apply here, being comfortable does.
  6. We offer a competitive total rewards package that includes a base salary, a performance bonus, company matching programs (pension & profit sharing), generous vacation, personal & sick days, personal development funding, maternity leave top-up, parental leave and much more.

Location(s): Canada : Ontario : Toronto

Scotiabank is a leading bank in the Americas. Guided by our purpose: "for every future", we help our customers, their families and their communities achieve success through a broad range of advice, products and services, including personal and commercial banking, wealth management and private banking, corporate and investment banking, and capital markets.

At Scotiabank, we value the unique skills and experiences each individual brings to the Bank, and are committed to creating and maintaining an inclusive and accessible environment for everyone. If you require accommodation (including, but not limited to, an accessible interview site, alternate format documents, ASL Interpreter, or Assistive Technology) during the recruitment and selection process, please let our Recruitment team know. If you require technical assistance, please click here. Candidates must apply directly online to be considered for this role. We thank all applicants for their interest in a career at Scotiabank; however, only those candidates who are selected for an interview will be contacted.

#J-18808-Ljbffr

  • Old Toronto, Canada Scotiabank Full time

    Job Title: Lead .Net and BI(SSRS/ SSIS) DeveloperJob SummaryWe are seeking a highly skilled Lead .Net and Business Intelligence Developer to join our team. The successful candidate will be responsible for designing, developing, and implementing business intelligence solutions using .Net and related technologies.Key ResponsibilitiesDesign and develop business...


  • Old Toronto, Canada Scotiabank Full time

    Title: Lead .Net and BI(SSRS/ SSIS) Developer Requisition ID: 209826Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture. The Team We are looking for a Software Engineer for the Group Treasury Technology (GTT) IT group in support of the Liquidity & Funding mgmt. businesses. Is this role right for you? In...


  • Old Toronto, Canada Scotiabank Full time

    Title: Lead .Net and BI(SSRS/ SSIS) DeveloperRequisition ID: 209826Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture.The TeamWe are looking for a Software Engineer for the Group Treasury Technology (GTT) IT group in support of the Liquidity & Funding mgmt. businesses.Is this role right for you? In this role...


  • Old Toronto, Canada Scotiabank Full time

    Requisition ID: 209826Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture.The TeamWe are looking for a Software Engineer for the Group Treasury Technology (GTT) IT group in support of the Liquidity & Funding mgmt. businesses.Is this role right for you? In this role you will:Work closely with customers,...


  • Toronto, Ontario, Canada Scotiabank Full time

    Job SummaryWe are seeking a highly skilled Senior .Net and Business Intelligence Developer to join our team in support of the Liquidity & Funding management businesses. The ideal candidate will have a strong background in designing and implementing BI solutions, with expertise in SSRS, SSIS, Power BI, and SQL Server DB & Query development.Key...


  • Toronto, Canada Purple Drive Full time

    Senior .Net Developer with .Netcore Angular 12 AND SQL AZUREToronto CanadaExceptionalknowledge of C# .Net Core REST APIs Angular 12 & aboveTypescript CSS/SCSS MSSQL Cosmos DB/Mongo (No SQL)Experiencewith serverless architecture like Azure Functions MicroservicesGoodknowledge in Object Oriented programming (OOPS) language conceptsGoodknowledge in patterns and...

  • SSIS Support

    2 months ago


    Toronto, Canada Purple Drive Full time

    SSISSupport TorontoONExposureto one of collections domain inBankingApplicationsupport experience in collectionsdomainGoodexperience in SSIS and ETL and datawarehousingStrongknowledge in database SQL queries by using DMLDDLlanguages.Knowledgein batch jobprocessingUnderstandingof data management bestpractices and indepth experience withMicrosoft SSIS / SSRS...

  • Senior .NET Developer

    1 month ago


    Toronto, Ontario, Canada Macdonald, Dettwiler And Associates Corporation Full time $90,000 - $120,000

    Job Title: Senior .NET DeveloperWe are seeking a highly skilled Senior .NET Developer to join our Business Systems Team at Macdonald, Dettwiler And Associates Corporation. As a key member of our team, you will be responsible for designing, developing, modifying, debugging, and evaluating complex problems related to enterprise applications supporting...


  • Toronto, Canada Purple Drive Full time

    JobDescription:Exposureto one of collections domain inBankingApplicationsupport experience in collectionsdomainGoodexperience in SSIS and ETL and datawarehousingStrongknowledge in database SQL queries by using DMLDDLlanguages.Knowledgein batch jobprocessingUnderstandingof data management bestpractices and indepth experience withMicrosoft SSIS / SSRS...


  • Toronto, Ontario, Canada Purple Drive Full time

    Job Title: SSIS Support SpecialistAbout the Role:We are seeking a highly skilled SSIS Support Specialist to join our team at Purple Drive. As an SSIS Support Specialist, you will be responsible for building data transformations with SSIS, including importing data from files and moving data from one database platform to another.Key Responsibilities:Build data...


  • Toronto, Ontario, Canada Macdonald, Dettwiler And Associates Corporation Full time $65,000 - $95,000

    Job Title: Senior .NET Developer/AnalystMacdonald, Dettwiler And Associates Corporation is seeking a highly skilled Senior .NET Developer/Analyst to join our Business Systems Team. As a key member of our team, you will be responsible for designing, developing, modifying, debugging, and evaluating complex problems related to enterprise applications supporting...


  • Toronto, Ontario, Canada Purple Drive Full time

    Job Description:At Purple Drive, we are seeking a highly skilled professional to join our team as an SSIS Production Support Specialist.As a key member of our team, you will be responsible for providing applications support experience in the collections domain, with a strong focus on SSIS and ETL data warehousing.Key responsibilities will include building...

  • BI Engineer

    1 month ago


    Old Toronto, Canada ProViso Staffing Full time

    Story Behind the Need: The IT Risk Data & Analytics Team plays a critical role in the management of technology-related risks by identifying, collecting, and reporting on IT Governance and Risk related data, utilizing modern analysis techniques and data visualization tools.Work on changes to Software Currency Dashboard and RCMP tool to support US EOL...

  • Senior BI Developer

    4 months ago


    Toronto, Canada Scotiabank Full time

       Requisition ID: 203146Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture. The Team We are looking for a Software Engineer for the Group Treasury Technology (GTT) IT group in support of the Liquidity & Funding mgmt. businesses.  Is this role right for you? In this role you will: Works closely with...


  • Toronto, Canada Aarorn Technologies Inc. Full time

    Aaron Technologies is looking for a Specialized IT Consultant to join the team of one of our clients. Applicants must fulfil the following requirements. **Responsibilities** **General Skills** - Experience in programming and analysis at the specified experience level - Ability to collaborate with IT Professionals throughout the Software Development Life...


  • Toronto, Ontario, Canada Purple Drive Full time

    Purple Drive is seeking a skilled SSIS Data Specialist to join our team.We are looking for a highly motivated individual with experience in data transformation using SSIS, ETL, and data warehousing. If you have a strong background in SQL queries and batch job processing, we want to hear from you.Key responsibilities will include:Building and maintaining...

  • SSIS Developer

    4 weeks ago


    Toronto, Ontario, Canada Purple Drive Full time

    Job Title: SSIS SupportAbout the Role:We are seeking a highly skilled SSIS developer to join our team at Purple Drive. As an SSIS developer, you will be responsible for building data transformations with SSIS, including importing data from files and moving data from one database platform to another.Key Responsibilities:Design and implement data...


  • Old Toronto, Ontario, Canada GS1 Canada Full time

    Job SummaryGS1 Canada is seeking a skilled Software Development Specialist to join our team. The successful candidate will be responsible for designing and developing software solutions to support our internal and external applications.Key ResponsibilitiesCollaborate with cross-functional teams to gather and analyze business requirements for software...


  • Toronto, Ontario, Canada Scotiabank Full time

    OverviewWe are seeking a seasoned Senior Data Engineer to join our Group Treasury Technology (GTT) IT group in support of the Liquidity & Funding mgmt. businesses.About ScotiabankScotiabank is a leading bank in the Americas. Our purpose: 'for every future', guides us as we help our customers, their families and their communities achieve success through a...


  • Toronto, Ontario, Canada Global Pharma Tek Full time

    Job Title: Senior Software DeveloperJob Summary:Global Pharma Tek is seeking a highly skilled Senior Software Developer to join our team. The ideal candidate will have extensive experience in the entire Software Development Life Cycle as well as Microsoft .Net Framework Technologies. They will be responsible for developing web-based applications in a...