Business Intelligence (BI) Engineer – SQL and Power BI

Procom


Date: 3 weeks ago
City: Toronto, ON
Contract type: Full time

Business Intelligence (BI) Engineer - SQL & Power BI On behalf of our client in the Banking Sector, Procom is looking for a Business Intelligence (BI) Engineer - SQL & Power BI
Business Intelligence (BI) Engineer - SQL & Power BI
– Job Description

  • Lead small to medium sized BI projects including collecting and documenting user requirements
  • Translating user requirements to visual prototypes, and solution and data architecture documentation
  • Development of data ingestion solution and data visualizations in the form of dashboards
  • Spreadsheet extracts and reports
  • Planning and execution of unit and user testing
  • Using testing and UAT environments and testing datasets
  • Build End to end BI solutions utilizing a variety of industry tools
  • Author report specifications from documented requirements or through discussion with end users
  • Develop Data ETL (Extract, Transform and Load) scripts as required to acquire or transpose data from other systems or databases into report databases and maintain databases as required to support reporting and reporting environments
  • Translates raw data into insights by quickly grasping the concepts in a dataset or database
  • Understanding relationships in the data
  • Running complex SQL queries to summarize or transform data
  • Using statistical analysis to find data quality issues
  • Provide day-to-day support of production BI applications that support IT&S executives on the strategy planning and decision-making process
  • Conduct ETL, SQL and DB performance tuning, troubleshooting, support, and capacity estimation to ensure highest data quality standards with the business and technical SMEs


Business Intelligence (BI) Engineer - SQL & Power BI
– Mandatory Skills

  • 10+ years of experience working on BI projects with the Microsoft BI stack (SQL Server, SSIS, SSAS, SSRS, SSMS)
  • 10+ years’ experience in SQL
  • 10+ years’ experience with database modeling and BI / Data warehousing concepts / OLAP – to demonstrate best approaches to design models
  • 5+ years of experience working with data visualization tools like Power BI (preferred) or Tableau
  • Experience working with Agile methods and tools: Git, Jira, Confluence, etc.
  • Good communications skills


Business Intelligence (BI) Engineer - SQL & Power BI
– Preferred Skills

  • Experience with IT Governance concepts; COBIT or ITIL certification; IT & Cyber Security concepts
  • Experience with data ingestion automation tools and technologies. i.e. automated data ingestion using Python scripts and frameworks or VBA and excel spreadsheets
  • Experience with open-source data integration platforms like Airflow, NiFi, Prefect
  • Experience storing, manipulating and integrating NoSQL data to BI reporting
  • Experience from FI / Banking
  • Bachelors in technical field like computer science nice to have
  • COBIT or ITIL certifications nice to have
  • Microsoft SQL certification nice to have


Business Intelligence (BI) Engineer - SQL & Power BI
– Assignment Start Date ASAP – 6 months to start
Business Intelligence (BI) Engineer - SQL & Power BI
– Assignment Location Toronto, ON – Work Hybrid

How to apply

To apply for this job you need to authorize on our website. If you don't have an account yet, please register.

Post a resume

Similar jobs

RQ08107 - Business Analyst - Senior

Maarut Inc, Toronto, ON
11 hours ago
Scope:Provide technical expertise related to Microsoft Dynamics 365/CRM solutions and system integration with other systems. Verify configured workflows, dashboards, forms, views to ensure in alignment and compliance of business requirements, industry standard best practices Participate in functional and technical design reviews, perform integration/functional and system testing, and verify test results. Provide specific technical support and defect fixing during SIT/UAT/Regression Testing/Deployment...

RQ08094 - Product Manager - Intermediate

Maarut Inc, Toronto, ON
11 hours ago
Responsibilities:Responsible for the product planning and execution throughout the product lifecycle, including: Gathering and prioritizing product and customer requirements Defining the product vision Ensuring that the product supports the company’s overall strategy and goals Gain a deep understanding of customer experience: Identify and fill product gaps Generate new ideas that grow market share Improve customer experience Drive growth Create buy-in...

PSW Program Supervisor

Trebas Institute Toronto, Toronto, ON
12 hours ago
DescriptionPSW PROGRAM LEADPosition Title: PSW Program SupervisorDepartment: AcademicsProgram: PSW ProgramsFaculty Leadership and ManagementProvide leadership and bring excitement, enthusiasm, and commitment to the Personal Support Worker – PSW Hybrid / NACC Certificate. Identify the need for faculty resources, participate in the hiring process, and make effective recommendations regarding Instructor selection. Onboard new departmental faculty and serve as a mentor in the...