Business Intelligence & Data Platform Developer
- Vaughan, ON, Canada
Full-time
Applications open in a new tab.
Job details
- Job type
- Full-time
- Apply by
- Experience
- Minimum 5 years experience
- Posting language
- English
- Posted
Original job description
Job Description:
We are looking for a candidate to join our Business Process Improvement team. In this role, you will collect report requirements, create complex datasets, and create reports/dashboards. You will also ensure high performance of MSSQL databases through monitoring and maintenance, plan and implement backup strategies, ensure databases meet security standards, manage user access, provide guidance to other technical staff on existing database structures. This position is in the Vaughan area.
Key Responsibilities:
- Develop data sets for reporting tools and for other applications.
- Develop and customize reports.
- Write SQL Queries using internal and external data.
- Perform data quality and verification checks
- Perform software performance testing prior to solutions being released to production
- Solution documentation, creating training videos, training end-users on solutions, and monitoring solution usage to ensure adoption
- Support ticketing system for a variety of use cases, from quick fixes and permission control requests to more complex tickets for various systems including corporate ERP, SQL Queries, Power BI, others.
- Maintenance of existing solutions and responding rapidly to requests that ensure continuity of key business operations
Qualifications:
- College or university degree in Computer Science or analytics related field
- Minimum 5 years experience
- Customer service orientation
- Detail oriented
- Strong understanding of data security protocols
- Possess tact and judgement in dealing with stakeholders
- Must be able to respond to tight deadlines during peak periods
- Power BI and Excel (Advanced) – Required
- Writing and documentation skills - Required
- SQL Server Integration Service (SSIS) – Required
- SQL Server Management Studio (SSMS) – Required
- Database maintenance and optimization experience – Strong Advantage
- SQL Server Jobs monitoring & failures troubleshooting- Strong Advantage
- Proficient with SQL, M-query, and DAX – Required
- Microsoft Fabric: Dataflow Gen2, Lakehouse/OneLake, data pipelines, semantic models, capacity optimization – Required
- Fabric: capacity management, Direct Lake semantic models, real-time alerts, data pipeline orchestration, and AI model integration – Strong Advantage.
- Office Script and VBA - Advantage
- Understanding of statistics and/or Lean methodologies – Advantage
- AutoML and/or custom ML model development – Advantage
- SharePoint administration - Advantage
More about this job
Responsibilities
Develop datasets, SQL queries, reports, and dashboards, and perform data quality checks and performance testing before solutions are released. Maintain and secure MSSQL databases, manage access and backups, support users and business systems, document and train users on solutions, and maintain existing tools to ensure business continuity.
Requirements
A college or university degree in Computer Science or an analytics-related field and at least five years of experience are required. Candidates need advanced Power BI and Excel skills, proficiency with SQL, M-query, DAX, SSIS, SSMS, and Microsoft Fabric, along with strong customer service, attention to detail, data security knowledge, and documentation skills.
Skills
- Power BI
- Advanced Excel
- SQL
- M Query
- DAX
- SQL Server Integration Services (SSIS)
- SQL Server Management Studio (SSMS)
- Microsoft Fabric
- Database Maintenance and Optimization
- Data Quality and Verification
- Report and Dashboard Development
- Data Security
- Performance Testing
- Documentation and Training
- Stakeholder Communication
Visa sponsorship
Not detected in the job text
Categories
- Data & Analytics
- Technology
- Software
- Customer Service & Support
Keywords
- Business Intelligence
- Data Platform Development
- Business Process Improvement
- Power BI
- Excel
- SQL
- M Query
- DAX
- SQL Server
- SQL Server Integration Services (SSIS)
- SQL Server Management Studio (SSMS)
- Microsoft Fabric
- Dataflow Gen2
- Lakehouse
- OneLake
- Data Pipelines
- Semantic Models
- Direct Lake
- Capacity Optimization
- Database Maintenance
- Database Optimization
- Database Security
- Backup Strategies
- Data Quality
- Report Development
- Dashboard Development
- Performance Testing
- AutoML
- Machine Learning
- Lean Methodologies