Developer – Power BI & SSRS

Developer – Power BI & SSRS

ProViso Consulting

Story Behind the Need:

• Business Group: Global Finance & Risk Technology
• The Enterprise Compliance and Regulatory Systems team is accountable for developing and supporting a number of compliance and risk management related tools and reporting systems within the Bank. The team is seeking a developer to ingest data from source systems and to develop dashboards and reports hosted on SharePoint. The incumbent will be joining a team of solution developers and architects that focus on systems utilized in compliance and risk management.
• They are seeking a Sharepoint SQL .NET Developer for multiple data projects regarding Regulatory & Global Compliance projects.

Candidate Value Proposition:

• The successful candidate will have the opportunity to work on other projects/initiatives beyond the mat leave coverage term.

Typical Day in the Role:

• Writing code to bring in data to our databases, configure with Sharepoint sites to allow users to get the data reports being developed
• Development with Data with SQL Server & PowerBI Reporting
• .net Development (some) & SharePoint configuration to enable reports
• SharePoint (1/3 of role)
• PowerBI (1/3 of role)
• Report Developer (1/3 of role)
• [Critical] Developing SQL queries / ETL packages using T-SQL and SSIS to ingest data from source systems to integrate with data warehouse
• [Critical] Design and development of high quality dashboards / reports using tools like Power BI, SSRS, Excel/PowerPivot and Tableau. Develop custom reports, analytics and KPI’s for the Business
• [Critical] Setting up and supporting SharePoint Online portals for content management / document management reports with access control groups.
• Collecting business requirements / user stories from clients
• Complete testing to ensure high quality product for clients
• Developing SQL views to enable data consumers to read data from data warehouse
• Integrate systems via REST API, database views, SharePoint lists, sFTP etc
• Responsible for documenting databases, data process flows and maintain data dictionaries
• Troubleshoot and resolve database and applications defects in a timely manner. Consult with internal and external groups as required
• Train and assist users at all levels

Must Have Skills/Requirements:

• 2+ years of hands on experience with Microsoft BI stack SQL Server, T-SQL, SSRS, MS SQL Enterprise Manager etc (experience with majority of them)
• 2+ years of hands on experience in developing BI reports and completing ad hoc queries and data analysis required
• 2+ years of hands on experience with data visualization / BI tools eg. Power BI, SSRS
• 2+ years of hands on experience configuring SharePoint Online for hosting data and reporting solutions

Nice to Have Skills:

• Knowledge and experience with Diyotta for data movement
• Knowledge and experience with GCP Google Cloud Platform for data ingestion
• Experience with EDL / Hadoop / Hive / Jupyter Notebooks / Tableau a plus
• Attention to detail and feedback from clients on dashboards and reports must be completed rapidly
• Experience with SDLC methodologies required eg. Agile / Waterfall
• Experience with databases, data modeling design
• Experience with data warehouse, ETL, SSIS, SSAS/cubes a plus
• Experience working with Content Management Systems like MS SharePoint or a plus
• Knowledge on Banking / Risk related systems is a plus
• Experience developing code to consuming REST API services a plus
• Experience integrating systems with COTS Commercial Off The Shelf software packages a plus
• Experience with implementing DevOps a plus
• Experience with MS Azure Cloud services, Google Cloud Platform etc a plus
• Experience with web development (in ASP.NET or Angular/CSS/HTML 5) a plus

Job Details



9 Months



Latest Blogs

© 2020 ProViso Consulting - Toronto Recruitment and Staffing Agency

Send this to a friend