Developer, Power BI - Mast

This position supports the global Maritime Asset Strategy & Transformation (MAST) Program by coordinating data analysis efforts, driving data requirements, analyzing operational data, and providing insights related to key operational activities on our vessels and shoreside activities. The role involves partnering with stakeholders to understand business needs and leveraging technical expertise in SQL programming to build efficient data models and robust Power BI Dashboards.

Additionally, the role demands strong data visualization experience and proficiency in PowerPoint to present findings effectively and support the preparation of comprehensive monthly and quarterly reports.

This role will report to the MAST Reporting Senior Manager and work closely with key stakeholders such as MAST analysts, global IT, brand leadership, and business teams. The Business Analyst will gather requirements, design reporting solutions, respond to ad hoc requests, and support strategic decision making.

• Data Visualization and Reporting: Partner with stakeholders to identify reporting business needs through the requirements gathering process. Create and maintain data visualizations and interactive dashboards, scheduled reports and analytic tools using Power BI. Support the automation of workflows and reports to improve efficiency and accuracy, reducing manual efforts. Replicate best practices and learnings from ad hoc requests and dashboards across different departments/functions.

• Monthly & Quarterly Report Package: Assist in the development of comprehensive report packages in PowerPoint ensuring they are visually appealing, and design elements communicate insights effectively to stakeholders. Compile/update and prepare monthly and quarterly reporting packages for MAST and Brand leadership, ensuring the accuracy and timeliness of all reports.

• Ad Hoc Request Support: Action ad hoc requests from stakeholders by clarifying requirements and responding with adequate analysis and insights. Maintain a high standard of data accuracy across all ad hoc requests. Verify the integrity of data sources, performing thorough data validation checks, and ensuring that the data used in analysis is reliable. Document and track all ad hoc requests ensuring timely and accurate delivery of analysis and insights.
  
  Maintain a log of completed requests to provide a reference for future analysis and to identify any recurring themes or common data needs.

• Process Improvement Support: Provide technical support for various improvement projects by analyzing data, identifying bottlenecks, and offering solutions. Continuously evaluate and improve the ad hoc request process. Identify ad hoc requests that occur frequently and evaluate a dashboard solution. Work closely with senior manager to identify opportunities to increase the effectiveness and efficiency of the MAST Reporting unit.

• Data Processing/Consolidation: Create advanced SQL queries to extract, transform, and load (ETL) data, ensuring data pipelines are efficient and well-maintained for accurate reporting and analysis. Leverage Snowflake’s capabilities to integrate data from various resources and perform complex queries to optimize processes. Design, develop, and maintain scalable and secure data pipelines in Snowflake to support business intelligence and analytics initiatives. Collaborate with stakeholders to gather requirements and design data models, ETL processes, and data visualizations in Snowflake.
  
  Develop and optimize SQL queries, stored procedures, and functions in Snowflake to support data analysis and reporting.

• Scope: Supports the MAST Program by ensuring accurate reporting, with responsibilities extending across Inventory, Maintenance, Procurement, Finance, and operational teams within the corporate organization.

• Problem-solving: Deep understanding of data warehousing concepts, SQL, ETL pipelines, and data architecture. Ability to work with large, complex datasets and create scalable data solutions. Proficiency in extracting and manipulating data across systems.

• Impact: Strong ability to analyze trends, identify patterns, and create actionable…