CoreFactor is searching for a Business Intelligence (BI) Developer on a full-time/permanent basis for a client in the GTA
This position is hybrid and will require the person to come into the Toronto office three (3) times per week.
Purpose of the Position:
The Business Intelligence (BI) Developer is responsible for designing, developing, and maintaining Business Intelligence solutions. The BI Developer will work closely with key stakeholders to gather and understand the business requirements and translate them into effective BI solutions. Collaborate with Data Warehouse Developer to develop and maintain the Business Intelligence frameworks. BI developer will drive Business Intelligence solutions. This role is essential to the day-to-day tactical planning and the longer-term investment planning of the Development and Communications Department.
The BI Developer develops and establishes an efficient, augmenting all data for Department KPI reports, Data Quality/Data Integrity Report, Analysis Reports, Dashboards from Data Warehouse Repository both on-premise and on-cloud.
Working with cross-functional teams this position is responsible for developing the automated reporting that provide the capability to view and analyze CRM data and other marketing data from the Data Warehouse and other data sources. The individual will interact affectively with business stakeholders, data engineer, and other teams within the department to bring new features and platform enhancements from conception to release by following best practices in data governance, communicating, documenting, and interacting effectively with both technical and non-technical professionals.
Key Result Areas:
Design and Development 25%
- Design, develop, and maintain BI solutions including dashboards, reports, and data visualizations in Power BI, SSRS
- Identify and develop crucial business metrics that will provide insight into operations
- Create automated reporting processes for efficiency in all business function
- Develop analysis to illustrate business trends and identify areas of business opportunities
- Produce insights and recommend business actions to align with strategy and/or solve business problems
Data Integration and ETL 25%
- Create or maintain Data Models for consistent, reliable reporting which align with business rules and data warehouse schema
- Create or maintain semantic layers to enable intuitive access for business users
- Create or maintain the ETL (Extract, Transform, Load) processes to ensure data is collected, integrated, and loaded accurately from multiple data sources into data warehouses (on premise and cloud) or other data storage solutions.
- Create or maintain secured data connectivity via REST API to Engaging Networks, API to Salesforce marketing Cloud, Payment Gateway (iATS), AKA Raisin and Canada Post and other API sources
- Ensure scalability and adaptability for future data domains
Data Quality and Integrity: 20%
- Ensure ETL pipelines are produced with the highest quality standards, metadata and validated for completeness and accuracy
- Establish quality assurance and data integrity checks to ensure accurate reporting and data records
- Following best practices in data governance, data management, security, and privacy, with a focus on CRM and marketing data
Project Management 15%
- Collaborate with cross-functional teams to understand project requirements and translate to technical specifications to deliver data reporting solutions on time, within scope and on budget
- Prioritize and manage multiple tasks and projects effectively
- Give the status of the project in weekly meeting
Documentation, Training, Support & Troubleshooting 15%
- Maintain clear documentation of BI solutions, data models, including business requirements and design specifications
- Perform testing before reports deployment
- Document the business rules in the reports and dashboards and other visualization solutions
- Provide ongoing support for BI tools and resolve data/reporting issues
- Conduct training on Power BI and SSRS and knowledge sharing within the team and promote a culture of continuous learning
Requirements
Qualifications
- Bachelor's degree or College Diploma in Computer Science / Data Science / Math / Engineering with minimum of 5 years of relevant industry experience
- Proficiency in Microsoft BI technologies (SSIS, SSRS, SSAS, SQL Server)
- Proficiency in developing ETL packages to extract, transform, and load data from various sources
- Proficiency in DAX, and M language for data manipulation and modeling.
- Experience using alternative or custom data sources within Power BI (ex. REST APIs).
- Experience in reports and data visualization design principles and able to give design opinions and recommendations
- Strong communication skills to effectively interact with stakeholders
- Results-driven and flexible approach, with a passion for variety in work and making meaningful contributions
Experience:
- 5+ years of business intelligence development experience
- Strong knowledge of SQL Server, including database design, query optimization, and performance tuning
- Experience with cloud platforms (e.g., Azure, AWS, Google Cloud)
- Familiarity with data warehousing concepts, OLAP cubes and dimensional modeling
- Knowledge of Python or R for data analysis
- Translate business requirements to analytics and reporting needs.
- Ability to identify crucial business metrics that provide valuable insights into operations
- Provide business expertise to place context around analytics discovery and provide recommendations
- Collaborate with cross-functional teams to understand business needs and translate them into BI solutions ensuring that our data-driven strategies are aligned with each unit's specific objectives and contribute to their success.
- Experience in project management, including task prioritization, time management, and delivering projects within deadline and budget through cross-functional teams
- Experience working with CRM and marketing data is a plus
- Certifications in Power BI or related technologies would be a plus
