Data Analyst – Power BI & Aviation Aftermarket

Responsibilities

• Design and maintain sophisticated Power BI dashboards and reports to inform executive-level decisions.

• Build and sustain a suite of critical operational reports and data-extraction methods to monitor accuracy, performance, and business metrics.

• Interrogate and support corporate ERP, line-of-business applications, and database environments, including Microsoft SQL Server, Oracle, and Salesforce/Force.com.

• Deliver clear data products and visualizations for teams such as Operations, Repair Management, and Sales.

• Analyze complex datasets related to USM inventory, sales, procurement, and operational performance to uncover trends and opportunities.

• Partner with multiple departments to define data requirements and translate them into actionable insights.

• Track and visualize KPIs, highlighting potential risks and growth prospects.

• Develop scorecards to measure vendor, customer, and internal performance.

• Support forecasting, pricing analysis, and market intelligence initiatives.

• Maintain high standards of data integrity, accuracy, and consistency across all systems and reporting layers.

• Present findings and recommendations effectively to both technical and non-technical audiences.

• Prepare data extracts and conduct data cleanup for system migrations, upgrades, and integrations.

• Provide line-of-business application support, responding to tickets and requests in a timely manner while ensuring issues are resolved or escalated appropriately.

• Collaborate with application users and technology vendors to troubleshoot and implement solutions.

• Recommend and help implement technology and process enhancements that drive efficiency and value.

Qualifications

• Bachelor’s degree in Data Analytics, Business Intelligence, Aviation Management, or a related discipline.

• Minimum of 3 years in data analysis, ideally within the aviation aftermarket.

• Advanced proficiency in Power BI, including DAX, Power Query, and data modeling.

• Strong analytical and problem-solving capabilities with meticulous attention to detail.

• Hands-on experience with ERP systems; familiarity with aviation-specific databases is advantageous.

• At least 3–5 years’ experience with databases and report development.

• Familiarity with aviation parts catalogs, teardown data, and lifecycle analysis.

• Experience with the Quantum ERP platform preferred.

• Knowledge of SQL, Python, or similar data-analysis tools a plus.

• Understanding of Microsoft Fabric and modern Power BI features.

• Competence in API and web-service development for data and system integration.

• Strong foundation in data validation, error checking, and problem-solving techniques.

• Solid command of SQL, including stored procedures and packages, across platforms such as Microsoft SQL Server and Oracle.

• Experience with reporting tools such as Excel, Power BI Pro, Crystal Reports, and Business Objects Web Intelligence.

• Excellent communication skills, professional demeanor, and reliability.

• Ability to work both independently and collaboratively, with a strong sense of accountability and urgency.

• Quick learner who adapts easily to evolving processes and technologies.

Additional Details

• Occasional travel may be required to other company sites.