Analytics Application Specialist

Job description / Role

Key responsibilities

Design, develop, and manage databases, data warehouses, and ETL (Extract, Transform, Load) processes, leveraging automation tools where appropriate.
Build and maintain interactive dashboards, reports, and data models using Power BI and related tools, ensuring accuracy, efficiency, and business alignment.
Collect and transform data from multiple sources (databases, APIs, flat files, etc.) into actionable insights.
Write and optimize DAX formulas to implement advanced business logic.
Design compelling visualizations, including charts, graphs, and maps, that effectively communicate insights.
Develop and maintain Power Apps (Canvas and Model-Driven) and Power Automate flows, integrating with Microsoft and third-party services.
Support data management through web, IT, and SharePoint-based applications.
Apply project planning and scheduling expertise using Oracle Primavera P6.
Collaborate with stakeholders to gather business requirements and translate them into practical, technical solutions.
Monitor data integrity, identify risks, and perform periodic data assessments to ensure quality and compliance.

About you

To succeed in this role, you will bring:

Qualifications

• Bacheloru2019s degree in Computer Science, Information Management, Engineering, Mathematics, Statistics, or a related discipline.

Experience

• Prior work as a Power BI Developer/Dashboard Designer or similar role (experience in large-scale projects, preferably construction or energy-related, is advantageous).
• Hands-on SQL experience for data manipulation and extraction.
• Proven experience with Oracle Primavera P6.

Technical skills

• Strong expertise in Power BI, MS SQL, SharePoint, Excel, and the Power Platform (Power Apps, Power Automate).
• Proficiency in:
  • Power BI development, data modelling, and data visualization concepts.
  • DAX, Power Query, and ETL tools (SSIS or similar).
  • ASP.NET, SharePoint, HTML, and CSS.
• Familiarity with:
  • Report automation tools (SSRS, Power BI Report Builder, etc.).
  • SAP Analytics Cloud (SAC), Lumira, BusinessObjects Web Intelligence, and SAP Data Services.
• Excellent written and spoken English, with strong communication and collaboration skills.
• Solid problem-solving abilities and supervisory skills.

Our role in supporting diversity and inclusion

As an international workforce business, we are committed to sourcing personnel that reflects the diversity and values of our client base but also that of Orion Group. We welcome the wide range of experiences and viewpoints that potential workers bring to our business and our clients, including those based on nationality, gender, culture, educational and professional backgrounds, race, ethnicity, sexual orientation, gender identity and expression, disability, and age differences, job classification and religion. In our inclusive workplace, regardless of your employment status as staff or contract, everyone is assured the right of equitable, fair and respectful treatment.