Business Data Analyst II

Role Overview:

Shift: Monday – Friday, day shift. Some flexibility in schedule will be required based on the needs of the Operation.

Pay: $70,000 - $78,000 annually

Benefits: Health & Dental benefits following 30 days of employment.

The Business Data Analyst will be reporting directly to the Operational Business Manager. 

Additional Job Responsibilities

• Designs, develops, and maintains Power BI dashboards and reports to support operational, financial, and leadership decision making
• Writes and optimizes DAX measures to enable accurate KPIs, performance tracking, and drill?down analysis
• Uses SQL across multiple platforms (e.g., SSMS and Snowflake) to extract, transform, and validate data from various source systems for reporting and ad hoc analysis
• Designs and maintains data pipelines using Azure Data Factory (ADF) to ingest, transform, and move data across source systems and reporting environments
• Applies Python scripting to support data cleansing, transformation, and preparation as part of analytics and reporting workflows
• Applies data modeling best practices to ensure data accuracy, consistency, and scalability across reports
• Performs exploratory and root cause analysis to identify trends, gaps, and improvement opportunities in operational performance
• Documents reporting logic, definitions, and processes to support knowledge sharing and continuity
• Continuously evaluates opportunities to improve reporting processes, data quality, and analytical capabilities
• Maintain and update current reporting tools
• Liaise with counterpart at sister site in Edmonton

Business Data Analyst II

 

Are you a passionate leader looking for autonomy and exciting career possibilities? Do you take an energetic and resourceful approach to problem-solving while bringing innovative ideas and analytics to life on behalf of your team and your customers? Do you enjoy effectively translating requirements into an efficient process and/or system solution? If so, DHL Supply Chain has the opportunity for you.

 

Job Description

To apply knowledge and analytics to develop and communicate timely, accurate, and actionable insight to the business through the use of modeling, visualization, and optimization. Responsible for the reporting, analyzing, and predicting of operational processes, performance, and Key Performance Indicators. Communication with site leadership, operations, and finance on efficiency, customer requirements, account specific issues, and insight into to the business, operations, and customer.

• Applies hindsight, insight, and foresight techniques to communicate complex findings and recommendations to influence others to take action
• Uses knowledge of business and data structure to discover and/or anticipate problems where data can be used to solve the problem
• Uses spreadsheets, databases, and relevant software to provide ongoing analysis of operational activities
• Applies data visualization for discovery and timely insights to decrease Cycle Time to Action (CTA)
• Assists site operations in identifying areas for improving service levels, reducing operational costs, and providing other operational enhancements
• Supports account start-up analysis and/or report implementation as needed
• Develop standardized and ad hoc site and/or customer reporting
• Streamlines and/or automates internal and external reporting
• May investigate and recommend new technologies and information systems
• May conduct feasibility analyses on various processes and equipment to increase efficiency of operations
• Partners with Finance to develop financial models to analyze productivity and payroll; calculates cost benefits and business impact and proposes solutions
• Develops predictive models to help drive decision making
• Designs, develops, and implements data gathering and reporting methods and procedures for Operations
• Responsible for tracking, planning, analysis, and forecasting of storage capacities, inventory levels, equipment and/or labor requirements
• Coordinates with Operations Systems group to ensure technical issues and problems are being identified, addressed, and resolved in a timely manner
• May coordinate with ILD group on issues related to modeling customer solutions, including providing data and relevant insight for customer pursuits
• Responsible for assisting finance and senior leadership in modeling yearly labor budget based on operational and profile changes

Required Education and Experience

• Undergraduate degree in business, logistics, mathematics, statistics, related field, or equivalent experience, required
• 0-2 years of analytics experience, required

                                          

Our Organization is an equal opportunity employer. We are committed to accommodating applicants with disabilities throughout the hiring process. Accommodations for job applicants with disabilities will be provided upon request.