BI & Analytics Developer transforming raw data into business insights for decision-making at PCL Constructors. Focused on reporting, analytics, and ETL development.
Responsibilities
Translate business needs to design, develop, and maintain production reports and dashboards
Acquire data from a variety of structured and unstructured data sources
Design and develop business data models to support self-service BI, analytics, and AI
Develop and maintain ETL/ELT data pipelines and processes
Create and maintain technical documentation
Define test plans and execute test cases to ensure analytics content processes meet quality assurance standards
Ensure data solutions follow and meet PCL’s data governance and security policies
Liaise with business, technology, and support teams to ensure business requirements are met
Prepare and structure business data to support AI use-cases
Develop Fabric Data Agents to enable AI-driven interaction with PCL business data
Requirements
Bachelor's degree or diploma in computer science (or equivalent education)
Demonstrated experience or certification in Microsoft Fabric Analytics Engineer Associate (DP-600) and/or Microsoft Fabric Data Engineer Associate DP-700
Extensive hands-on experience with data visualization tools such as Microsoft Power BI is preferred
Experience in Fabric capacity management and resource optimization
Extensive hands-on experience with data development in Microsoft Fabric
Solid understanding of data modeling and relational database design and implementation techniques
Experience in UI/UX development as it applies to dashboard and report design
Excellent problem-solving and data-analysis skills
Experience in the complete software development lifecycle (SDLC) including requirements analysis, design, development, QA, maintenance, and CI/CD and version control tools
Effective communication and writing skills necessary to effectively lead technical discussions and information-gathering sessions
Positive, can-do attitude, enthusiastic, self-motivated, and able to manage multiple development projects simultaneously
Ability to work in a fast-paced environment, be flexible, stay organized, and maintain attention to detail and accuracy
Benefits
Employee ownership opportunities that build long-term value
Annual discretionary performance bonuses
RRSP, TFSA, Pension Contribution Options
Flexible medical, dental and vision benefits
Prescription drug coverage and virtual care services
Life, AD&D and disability insurance
Paid parental leave and family care support
Health and lifestyle spending account options
Mental health and wellness support, including Employee Assistance Programs
Career growth pathways, leadership development and mentorship programs
Access to world-class training through PCL's College of Construction and professional development courses
Ongoing opportunities to learn new skills, explore different roles and grow your career across sectors and regions
Network Analytics Engineer at TIM managing network performance indicators and ensuring data reliability for decision making and customer experience improvement.
Analytics Engineer crafting advanced data models using BigQuery and Snowflake for Dasa. Collaborating in a dynamic environment to innovate healthcare solutions for millions.
Senior Data & Financial Analytics Engineer at Pliant turning complex financial data into scalable insights. Collaborating with Finance and leadership to ensure reliable financial metrics.
Analytics Engineer analyzing and visualizing data for orthodontic treatments at DentalMonitoring. Collaborating closely with teams to provide insights and support data - driven decisions.
Analytics Engineer improving data processes at Zaha Hadid Architects. Developing scalable ELT/ETL pipelines and collaborating across teams for data - driven decision - making.
Data Engineering Specialist at Dasa, optimizing data architectures for a leading health network in Brazil. Focused on innovation and technical excellence in data management.
Analytics Engineer joining Our Future Health to build and maintain data models. Working with large - scale health data to enable analytics for decision making and research.
ETL Developer developing and integrating financial crimes risk management solutions at Truist. Collaborating with business product owners and delivering technically complex solutions in the U.S.
Senior Marketing Analytics Engineer leading complex analytical initiatives at Generac Power Systems. Collaborating across teams to drive business effectiveness and enhance marketing analytics.