Data and Business Intelligence Analyst (IT, Business Process Sr.)

Key Responsibilities

• Collaborate with business stakeholders to gather reporting requirements and translate business needs into technical dashboard and reporting solutions.
• Be part of a team working with IT, external system integrators and business process owners to realize data and business intelligence solutions.
• Develop, maintain and support dashboards, scorecards and reports for program management, supply chain, quality management, engineering, operations, HR and finance functions.
• Design and maintain data models, relationships, calculated columns, KPIs, and DAX measures to support enterprise analytics and reporting.
• Create and maintain automated reporting solutions, refresh processes, gateway configurations, SQL queries, stored procedures, views and data validation logic.
• Aid with enterprise data integration efforts across all enterprise applications.
• Troubleshoot reporting discrepancies, refresh failures, data quality issues, and inconsistencies across reporting environments.
• Aid with the development of enterprise data governance and reporting standards, reusable reporting frameworks, data definitions and dashboard design best practices.
• Support ad hoc executive reporting requests and analytics initiatives with quick turnaround and high attention to detail.

Ideal Experience And Qualifications

• Bachelor’s degree in quantitative fields such as statistics, accounting, mathematics, economics, engineering, or computer science or equivalent job experience.
• Experience developing dashboards, reports and data visualizations.
• Experience working with enterprise class applications (e.g. ERP, EPM, CRM, HCM) and data warehouse application solutions.
• Experience supporting enterprise-wide operational reporting needs for business stakeholders (e.g. supply chain, manufacturing, finance etc..) to gather reporting requirements and deliver technical reporting solutions.
• Experience with using tools such as Microsoft Power BI, Cognos, Microsoft Fabric and Azure data services.
• Experience writing complex SQL queries, joins, stored procedures, data validation logic, Power Query and ETL/data transformation concepts.
• Proven hands-on experience building and maintaining data models, DAX calculations, KPIs, measures, and dataset relationships within Power BI.
• Experience creating automated reporting solutions and scheduled refresh processes.
• Experience documenting business rules, reporting logic, source-to-target mappings and data dictionaries.
• Experience supporting KPI scorecards, supplier performance metrics, inventory analytics or operational performance reporting.
• Familiarity with enterprise data governance and reporting standardization.
• Exposure to working with data warehouse and data lake technologies.
• Experience working with IT system integrators.
• Work experience with Deltek Costpoint and other Deltek applications.
• Experience within aerospace/defense/GovCon environments.

Desired Skills

• 5 or more years of experience.
• The ability to work with stakeholders to develop requirements.
• Strong analytical and problem-solving skills with keen attention to detail.
• The ability to analyze and interpret datasets to provide actionable business insights.
• Strong communication and presentation skills with the ability to communicate technical concepts to both technical and non-technical audiences.
• Strong technical skills with all aspects of data management, business intelligence and Microsoft technology.