Senior Business Intelligence Developer

ROSS; Canada; On-site; CAD 80,000 - 100,000; Full time

Job summary

Join a leading online sports gaming company as a Senior BI Developer, where you will play a pivotal role in designing and maintaining the Data Warehouse. This position involves hands-on ETL development, data modeling, and creating insightful reports and dashboards that drive business decisions. Collaborate with a talented team to implement best practices in data governance and performance tuning. If you thrive in a dynamic environment and have a passion for data-driven solutions, this is the perfect opportunity to make a significant impact in the world of sports gaming technology.

Qualifications

• 6+ years of experience with Microsoft BI technologies and Data Warehousing.
• Strong TSQL skills and performance tuning experience required.

Responsibilities

• Design and maintain Data Warehouse and ETL processes.
• Develop reports and dashboards based on business requirements.

Skills

TSQL

ETL Development

Data Warehouse Administration

ASP.NET

SQL Server

SSRS

SSIS

Data Modeling

Business Intelligence

R

Tools

SQL Profiler

DevExpress

Job description

Our client is a leader in online sports gaming with a technical center of excellence in Toronto at Yonge and Sheppard. They have engaged ROSS to help them recruit a Senior BI Developer.

Position Summary

As a Senior BI Developer, candidate will be responsible for design, development and maintenance of the Data Warehouse and all related components (ETL, reporting applications, etc...). Candidate will be actively involved in all phases of software development life cycle; this includes requirements gathering, researching, initial configuration, set up, design, documentation, testing, debugging, updates, ongoing support, integration, maintenance and troubleshooting.

Responsibilities

• Hands-on ETL development using TSQL and Integration Services (SSIS) including associated performance tuning.
• Participate in data modeling, relational and star-schema design and implementation.
• Data Warehouse day-to-day administration including reviewing ETL load jobs for consistency and quality, and performance monitoring.
• Gather and analyze business requirements, functional requirements, and data specifications for ETL, dashboards and other business reporting needs.
• Design, develop and maintain reports and dashboards based on business requirements using ASP.NET with DevExpress, and some SSRS.
• Participate in developing and maintaining best practices as they relate to ETL, report design, and data quality/governance strategies.
• Research data warehousing/business intelligence trends and technological innovations in order to make appropriate development recommendations.
• Working closely with other developers and staff such as project managers, and quality assurance team.
• Provide support to business users and application developers.
• Participate in all phases of the software development life cycle.
• Provide mentorship to mid and junior level developers.

Required Skills and Experience

• 6+ years of Data Warehouse/Business Intelligence work experience using Microsoft BI technologies (SQL Server, SSRS, SSAS, SSIS, etc…)
• 10+ years of combined experience as Software Developer, Database Developer or Database Administrator.
• Strong and current database programming skills with Microsoft SQL Server 2012 and above.
• Up-to-date knowledge in regards to latest SQL Server editions, BI applications, etc...
• Exceptional TSQL skills and performance tuning abilities, and experience using tools such as SQL Profiler, reading execution plans, etc...
• Strong database design skills, including star-schema, and strong understanding of database normalization techniques.
• Experience with R highly desirable but not mandatory.
• Good Data Modeling skills.
• Strong written and oral communication skills.

Interpersonal skills

• Strong analytic, conceptual, and problem-solving abilities with attention to detail.
• Strong ability to analyze business requirements and build according to business specifications.
• Flexibility and adaptability to business requirements and priority changes.
• Self motivated, team player, action and results oriented.
• Well organized, good communication and reporting skills.
• Ability to successfully work under tight project deadlines.
• Ability to multi-task and work on several different projects simultaneously.
• Initiative to work independently, but also able to work effectively with team members.