Air Transport Services Group
CI/BI Analyst
Air Transport Services Group, Wilmington, Ohio, United States, 45177
At ATSG, we believe that our people are our greatest asset. Our workforce brings together talent, innovation, and dedication, driving both individual growth and company success. We prioritize professional development and work-life balance, ensuring every employee has the tools to thrive. We actively engage in community outreach, volunteering, and initiatives that make a lasting positive impact.
We are adding a CI/BI Analyst to the Operations team. Responsibilities include creating Power BI visualizations and dashboards, data analysis, and data warehousing tasks for internal and external clients. This will require a skilled professional that can collect and analyze customer requirements, assemble data from various sources and produce outputs in Power BI to achieve the customer's goals.
Duties and Responsibilities:
Consult with internal and external customers to collect BI requirementsUnderstand the customer's datasets, correlate the datasets with the BI requirementsCreate Power BI visualizations and edit existing reportsAudit existing databases and reports to optimize performancePublish and administrate Power BI reports, datasets, workspaces and appsCreation of staging databases and data warehouses for consumption by Power BISetup and administration of Power BI data connectionsOther duties as assignedRequired Education and Experience:
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 queriesGreen Belt / LSS certification preferredAviation / Aircraft knowledge preferredRequired Competencies / Skills / Abilities:
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 environmentStrong general technical aptitudeAdditional software development skills, particularly in .NET, Python, R are highly desirable.Advanced skills in MS Excel also highly desirable.
Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities
The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor's legal duty to furnish information. 41 CFR 60-1.35(c)
We are adding a CI/BI Analyst to the Operations team. Responsibilities include creating Power BI visualizations and dashboards, data analysis, and data warehousing tasks for internal and external clients. This will require a skilled professional that can collect and analyze customer requirements, assemble data from various sources and produce outputs in Power BI to achieve the customer's goals.
Duties and Responsibilities:
Consult with internal and external customers to collect BI requirementsUnderstand the customer's datasets, correlate the datasets with the BI requirementsCreate Power BI visualizations and edit existing reportsAudit existing databases and reports to optimize performancePublish and administrate Power BI reports, datasets, workspaces and appsCreation of staging databases and data warehouses for consumption by Power BISetup and administration of Power BI data connectionsOther duties as assignedRequired Education and Experience:
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 queriesGreen Belt / LSS certification preferredAviation / Aircraft knowledge preferredRequired Competencies / Skills / Abilities:
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 environmentStrong general technical aptitudeAdditional software development skills, particularly in .NET, Python, R are highly desirable.Advanced skills in MS Excel also highly desirable.
Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities
The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor's legal duty to furnish information. 41 CFR 60-1.35(c)