Data Analyst

Job Title: Senior Data Analyst

Job Description

The Senior Data Analyst is a pivotal role responsible for leading the development and maintenance of complex business intelligence solutions that drive critical decision-making for construction projects. This role demands a high level of expertise in data modeling, advanced querying, and robust reporting to maximize the accessibility and business value derived from diverse organizational data. The Senior Data Analyst is also responsible for developing innovative analytics, supporting advanced users, and optimizing the entire data lifecycle from source to visualization within a cutting-edge data warehouse environment.

Responsibilities

• Design, develop, and maintain highly complex Power BI reports and dashboards, incorporating advanced data modeling techniques to integrate data from systems
• Work extensively with Databricks and Delta Lake, developing optimized 'gold' level SQL queries for Power BI models, and perform advanced transformations directly within the data warehouse where appropriate
• Identify, map, and implement data lineage and transformation strategies, determining the optimal stage for data manipulation (data warehouse vs. Power BI data model) to ensure data quality, performance, and scalability
• Lead the integration of data from ARAS (PLM), Oracle P6 (Scheduling), IFS (ERP/MRP), and future Oracle Cloud ERP, ensuring a unified and coherent data model for comprehensive reporting
• Develop sophisticated Power BI data models, leveraging advanced DAX expressions and Power Query (M language) to create robust measures, calculated columns, and tables that meet complex business requirements
• Collaborate closely with business stakeholders to understand complex requirements, translate them into impactful data visualizations, and iteratively refine reports to ensure maximum user adoption and actionable insights
• Validate data sources, complex transformations, and analytical outputs against business rules and reference data to guarantee the accuracy, completeness, and integrity of all derived reports
• Create comprehensive documentation for business requirements, data sources, infrastructure, complex data models, and reporting governance processes to provide clarity and context for all data consumers
• Act as a Subject Matter Expert (SME) in Business Intelligence, providing guidance, training, and knowledge transfer to team members and business users on advanced Power BI functionalities, data best practices, and data interpretation
• Optimize all stages of the data analysis process, from data extraction and advanced querying to data modeling and visualization, ensuring high performance and efficiency of all BI solutions

Essential Skills

• Bachelor's degree in Computer Science, Statistics, Data Science, Business Analytics, or a closely related quantitative field. A Master's degree is an asset
• 7 - 10 years of progressive experience in data analysis and business intelligence, with a strong emphasis on complex report development in large-scale enterprise environments
• Demonstrated expert-level experience with Microsoft Power BI, including advanced data modeling, DAX, Power Query (M), and custom visualizations
• Proven expert-level experience with SQL for complex query development, performance tuning, and data manipulation, ideally within a data warehouse environment like Databricks
• Extensive hands-on experience working with Databricks and Delta Lake architectures, specifically in developing gold-layer queries for BI consumption
• Demonstrated experience integrating data from diverse enterprise systems, particularly within a manufacturing or project-driven industry (e.g., ERP, PLM, Scheduling systems)
• Experience with Azure Analytics Services, including Azure SQL Data Warehouse and Azure Analysis Services, is highly desirable
• Experience in heavy manufacturing, or large-scale project management environment is a significant asset

Additional Skills & Qualifications

• Expert Data Modeling Skills: Deep understanding and practical application of star schema, snowflake schema, and other advanced data modeling techniques within Power BI and data warehouses
• Advanced SQL & Query Optimization: Exceptional proficiency in writing and optimizing complex SQL queries, stored procedures, and functions for large datasets
• DAX & M Language Mastery: Ability to write highly efficient and complex DAX measures, calculated columns, and tables, as well as advanced Power Query (M) transformations
• Data Architecture Understanding: Strong conceptual and practical understanding of data warehousing principles, ETL/ELT processes, and data lake concepts
• Analytical & Problem-Solving Acumen: Superior analytical and problem-solving skills, with the ability to dissect complex business problems, identify underlying data issues, and propose innovative BI solutions
• Business Acumen: Strong understanding of operations, project management methodologies (e.g., Earned Value Management), and financial reporting, allowing for effective translation of business needs into technical solutions
• Communication & Collaboration: Excellent verbal and written communication skills, with the ability to effectively interact with business stakeholders at all levels, explain complex technical concepts, and present data-driven insights clearly and concisely
• Autonomy & Proactiveness: Proven ability to work independently with minimal supervision, manage multiple priorities in a dynamic environment, and proactively identify opportunities for BI improvement
• Attention to Detail: Meticulous attention to detail in data validation, report development, and documentation to ensure the highest level of accuracy and reliability

Job Type & Location

This is a Contract position based out of North Vancouver, BC.

Pay and Benefits

The pay range for this position is $45.00 - $60.00/hr.

Workplace Type

This is a hybrid position in North Vancouver,BC.

À propos d'Actalent:

Actalent est un chef de file mondial des services d’ingénierie et de sciences et des solutions de talents. Nous aidons les entreprises visionnaires à faire progresser leurs initiatives en matière d’ingénierie et de science en leur donnant accès à des experts spécialisés qui favorisent la mise à l’échelle, l’innovation et la mise en marché rapide. Avec un réseau de près de 30 000 consultants et plus de 4 500 clients aux États-Unis, au Canada, en Asie et en Europe, Actalent est au service d’un grand nombre d’entreprises du classement Fortune 500.

Actalent est un employeur souscrivant au principe de l’égalité des chances et accepte toutes les candidatures sans tenir compte de la race, du sexe, de l’âge, de la couleur, de la religion, des origines nationales, du statut d’ancien combattant, d’un handicap, de l’orientation sexuelle, de l’identité sexuelle, des renseignements génétiques ou de toute autre caractéristique protégée par la loi.

Si vous souhaitez faire une demande d’accommodement raisonnable, tel que la modification ou l’ajustement du processus de demande d’emploi ou d’entrevue à cause d’un handicap, veuillez envoyer un courriel à pour connaître d’autres options d’accommodement.

About Actalent

Actalent is a global leader in engineering and sciences services and talent solutions. We help visionary companies advance their engineering and science initiatives through access to specialized experts who drive scale, innovation and speed to market. With a network of almost 30,000 consultants and more than 4,500 clients across the U.S., Canada, Asia and Europe, Actalent serves many of the Fortune 500. We are proud to be an Engineering News-Record (ENR) Top 500 Design Firm for our engineering design services and a ClearlyRated Best of Staffing® winner for both client and talent service.

The company is an equal opportunity employer and will consider all applications without regard to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.

If you would like to request a reasonable accommodation, such as the modification or adjustment of the job application process or interviewing process due to a disability, please email for other accommodation options.