Air Transport Services Group - Wilmington, OH

posted 4 months ago

Full-time
Wilmington, OH
Support Activities for Transportation

About the position

ATSG is seeking a skilled CI/BI Analyst to join our Operations team, focusing on the creation of Power BI visualizations and dashboards, as well as performing data analysis and data warehousing tasks for both internal and external clients. This role is crucial for understanding and fulfilling customer requirements by collecting and analyzing data from various sources to produce insightful outputs in Power BI that align with the customer's goals. The ideal candidate will possess a strong analytical mindset and the ability to translate complex data into actionable insights. In this position, you will be responsible for consulting with internal and external customers to gather Business Intelligence (BI) requirements. A deep understanding of the customer's datasets is essential, as you will need to correlate these datasets with the BI requirements effectively. You will create new Power BI visualizations and edit existing reports to ensure they meet the evolving needs of our clients. Additionally, auditing existing databases and reports to optimize their performance will be a key part of your responsibilities. You will also publish and administrate Power BI reports, datasets, workspaces, and apps, ensuring that all outputs are accessible and user-friendly. The creation of staging databases and data warehouses for consumption by Power BI will be part of your duties, along with setting up and administering Power BI data connections. As the role evolves, you may be assigned other duties as needed, contributing to the overall success of the Operations team.

Responsibilities

  • Consult with internal and external customers to collect BI requirements
  • Understand the customer's datasets and correlate them with the BI requirements
  • Create Power BI visualizations and edit existing reports
  • Audit existing databases and reports to optimize performance
  • Publish and administrate Power BI reports, datasets, workspaces, and apps
  • Creation of staging databases and data warehouses for consumption by Power BI
  • Setup and administration of Power BI data connections
  • Other duties as assigned

Requirements

  • Bachelor's degree required; Masters preferred (technical field a plus)
  • Four-plus years' experience with BI tools (Power BI or Tableau)
  • Proven expertise in creating Power BI visualizations, reports, data models, DAX, database queries
  • Green Belt / LSS certification preferred
  • Aviation / Aircraft knowledge preferred
  • Experience in working through all stages of analytics lifecycle, especially data extraction, validation, and cleansing
  • Knowledge of data warehousing products and techniques, including OLAP and/or SSAS
  • Experience in working with different departments and cross-functional teams, including customer interface and requirements gathering
  • Ability to manage multiple priorities and juggle customer demands
  • Exceptional problem-solving skills with the ability to leverage a wide variety of data and related tools to improve the efficiency of the organization
  • Strong communication, teamwork, and organizational skills
  • Helps improve team function and dynamics by using facilitation skills and leading brainstorming sessions
  • Performs quantitative analysis of key process indicators to identify opportunities for process improvement
  • Solid relationship management and leadership skills and the ability to assume increasing responsibilities in a rapidly-changing environment
  • Strong general technical aptitude

Nice-to-haves

  • Additional software development skills, particularly in .NET, Python, R are highly desirable
  • Advanced skills in MS Excel also highly desirable
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service