The OpportunityReporting to the
Senior Director, Technical Services, the
Senior Developer, Business Intelligence plays a vital role in Atlantic's Technical Services Group, bringing expertise to the Power platform (Power Bi, Power Automate, SharePoint etc) and its tools. The successful candidate will be tasked with supporting our global operations by designing, developing and maintaining engaging and insightful dashboards using current technologies and BI tools including retrieving and transforming raw data into valuable business intelligence solutions to allow our North American business leaders to make strategic decisions to support our business goals.
The incumbent will initially focus on supporting and collaborating with various business users to collect and comprehend their requirements, translate in technical requirements, develop a data solution, and create reporting solutions tailored to their needs. They will also ensure best practices in data visualization are being followed and will enforce data governance aligning with the standards set by the Corporate IT team. The incumbent needs agility, a collaborative spirit, and an ability to create structure from unstructured sources of information.
Location: Scarborough, Ontario (hybrid, 3 days in office)
What You'll Do- Collect, study, analyze and understand business requirements in context to business intelligence and be able to convert requirements into technical specifications and decide the timeline to accomplish tasks and deliver same in a timely manner.
- Design intuitive and visually appealing user interfaces for web and mobile applications that align with corporate standards and "get it right the first time".
- Design and map data models to shift raw data into meaningful insights.
- To design, develop, and deploy Power BI scripts and perform efficient detailed analysis.
- Utilize Power BI to build interactive and visually appealing dashboards and reports.
- To create charts and document data with algorithms, parameters, models, and relations explanations and verify all data with business subject matter experts prior to publishing reports.
- Onboard new IT team members in best practices as well as support the training program to allow business users to build quality reports.
- Ensure all reports and visualizations follow the corporate standard.
- Demonstrated ability to prioritize tasks, manage deadlines, and work efficiently in a fast-paced environment, while maintaining a high level of attention to detail and quality in deliverables.
- To identify KPIs with clear objectives and monitor them consistently.
- Analyze previous and present data through reports for better decision making.
- To conduct and maintain data warehouse development.
- Build multi-dimensional data models.
- Develop strong data documentation about algorithms, parameters, models and conduct knowledge sharing sessions as required within the Atlantic's analytics team.
- Perform detailed analysis on tested and deployed Power BI scripts.
- Run DAX queries and functions in Power BI
- To perform SQL querying for best results
- To define and design new systems by analyzing current ETL processes.
- Make essential technical and strategic changes to improve present business intelligence systems and enhance their functioning.
- Identify the requirements and develop custom charts accordingly.
What You Bring- University Degree in Computer Science or Statistics, or related major.
- 5+ years' experience using Power BI tools and BI systems.
- Ability to use Power Automate and other Power BI tools to build robust reporting.
- Skilled in building rich dashboards, writing DAX expressions, and implementing security.
- Ability to analyze existing tools and databases and provide software solution recommendations.
- Experience with big data architectures and data modeling to efficiently process large volumes of data.
- Comprehensive knowledge of data platform architecture, data modeling, database optimization, data management practices and processes.
- Experience in data governance, data governance tools, ingestion and extraction frameworks, data security, etc.
- Data warehousing experience.
- Experience in ELT and ETL data processing.
- In-depth knowledge of Microsoft Business Intelligence stack like Power Platform (BI, Automate), SSRS, SSIS and SSAS.
- Well versed in programming languages like SAS, R, Python, VBA and Excel.
- Proficient in database management of SQL and NoSQL.
- Ability to work with stakeholders and to assess potential risks.
- Ability to communicate fluently in French would be an asset.
- Frequent travel to various US operations may be required.
What We Offer - Comprehensive health, dental and vision coverage (dependents included)
- Teamwork-focused culture with sustainability initiatives and social events
- A culture of appreciation through a point-based recognition
- Opportunities for advancement and internal movement
- Education assistance for continuous skill development
- Academic scholarships for employees' children
- Safety equipment and PPE support program
- Retirement savings and wellness initiatives
- Employee Assistance Program (EAP)
