Senior Data Analyst (Project Reporting - Power BI)

Parsons Oman; Chelmsford; On-site; CAD 80,000 - 120,000; Full time

Job summary

An established industry player is seeking a Senior Data Analyst to enhance project reporting systems and deliver insightful data analytics. This role involves designing and implementing databases, developing dashboards, and optimizing data quality for informed decision-making in construction projects. Join a dynamic team where your expertise in Power BI, SQL, and statistical analysis will drive impactful results. This is an exciting opportunity to work collaboratively with diverse stakeholders and contribute to innovative solutions in a supportive environment. If you're passionate about data and looking for growth, this position is perfect for you!

Benefits

Health Insurance

Flexible Working Hours

Professional Development Opportunities

Employee Wellness Programs

Retirement Savings Plan

Qualifications

• 10+ years of experience in data analysis or BI development.
• Strong proficiency in Power BI and advanced statistical techniques.
• Ability to develop dashboards and reports from operational data.

Responsibilities

• Design and implement robust databases and data collection systems.
• Analyze complex data sets and provide actionable insights.
• Develop and maintain Power BI reports and dashboards.

Skills

Power BI

SQL

DAX

Statistical Analysis

Data Visualization

Excel

ETL Processes

Education

Bachelor's degree in Computer Science

Master's degree in Statistics

Tools

Power Apps

Power Automate

Microsoft Suite

Job description

In a world of possibilities, pursue one with endless opportunities. Imagine Next!

When it comes to what you want in your career, if you can imagine it, you can do it at Parsons. Imagine a career working with intelligent, diverse people sharing a common quest. Imagine a workplace where you can be yourself. Where you can thrive. Where you can find your next, right now. We’ve got what you’re looking for.

Job Description:

Parsons is looking for an amazingly talented Senior Data Analyst (Project Reporting) to join our team! In this role you will get to design, develop, and implement robust databases, data collection systems, and advanced data analytics strategies. This role will optimize statistical efficiency and data quality to deliver professional dashboards, data analysis and establish automated reports for various construction functions, driving informed decision-making. Also, setup automated reports that provide timely and accurate data analysis for various construction teams and senior management.

What You'll Be Doing:

• Responsible for establishing, maintaining, and improving project reporting systems and processes.

• Identify new process, improvement opportunities and risks.

• Design, develop and implement reports, dashboards, databases, data collection systems, data analytics and other strategies that optimize statistical efficiency and quality.

• Interpret data, analyze results using statistical techniques and provide ongoing reports and presentations.

• Acquire, organize, and maintain data from various primary and secondary

• Sources. Identify, analyze, and interpret trends or patterns in complex data sets.

• Create effective charts, graphs, and dashboards to visually represent project data and facilitate understanding of key performance indicators (KPIs).

• Work closely with the construction department, supply chains and stakeholders to gather, maintain and analyze data and set up automated reports to ensure report accuracy.

• Analyze quantitative and qualitative data related to construction projects. Apply testing and statistical analysis to construction projects data.

• After receiving the raw data, the candidate will need to perform the analytical processes and the automated reports.

• Work with the Project Controls team in compiling and presenting progress and cost reports, and identifying variances.

• Ensure all reporting activities comply with relevant company policies and procedures.

• Design, develop, deploy, and maintain Power BI reports, dashboards, and datasets

• Connect and integrate data from multiple sources (e.g., SQL Server, Excel, SharePoint, etc.)

• Create calculated columns and measures using DAXfor advanced analytics

• Develop data models and ensure performance optimization of BI solutions

• Collaborate with business users to gather requirements and translate them into functional reports

• Provide support and training to business users on Power BI and related tools

What Required Skills You'll Bring:

• A Bachelor’s degree or equivalent in computer science, information technology, statistics, mathematics, or related technical or scientific field; or a related subject.

• Minimum of 10 years’ experience in a similar position.

• Able to develop dashboards in Power BI from the operational data received.

• Familiarity with Microsoft suite of programs, data mining, ability to develop and manipulate, and maintain databases.

• Demonstrated experience using software packages used for advanced statistical analysis of operational data and tools for data visualization. Minimum of 3 years of experienceas a BI Developer or Data Analyst, preferably within the construction or engineeringdomain

• Proficiency in Power BI, DAX, and M language (Power Query)

• Strong Excel skills (formulas, Power Query, Power Pivot)

• Experience with SQL, data modeling, and ETL processes

• Experience with Power Appsand Power Automateis an advantage

• Certifications in Power BI, SQL, or Power Platform are desirable

• Ability to identify systems enhancements and new capabilities, concept demonstrators, capability business cases.

• Ability to provide training as new systems and capabilities move into operational use.

• Background in the creation and execution of reporting, information management systems, processes and procedures in a construction/engineering program environment.

• Good verbal, written, and interpersonal communication skills.

• Ability to work effectively, as well as independently, in a team environment.

• Energetic self-starter who is flexible, organized, conscientious and proactive.

Parsons equally employs representation at all job levels no matter the race, color, religion, sex (including pregnancy), national origin, age, disability or genetic information.

We truly invest and care about our employee’s wellbeing and provide endless growth opportunities as the sky is the limit, so aim for the stars! Imagine next and join the Parsons quest—APPLY TODAY!

Parsons is aware of fraudulent recruitment practices. To learn more about recruitment fraud and how to report it, please refer tohttps://www.parsons.com/fraudulent-recruitment/.