Senior Data & Analytics Leader - Power BI & Fabric

Automatic Data Processing, Inc.; Colwich (KS); On-site; USD 140,000 - 190,000; Full time

Job summary

Automatic Data Processing, Inc. seeks an experienced Senior Manager for Enterprise Data & Analytics in Colwich, KS. You will lead data strategy, build data lakes with Microsoft Fabric, and create Power BI reporting solutions to drive insights across operations and finance.

You will partner with executives to set KPIs, modernize reporting, and develop self-service analytics while guiding a team of data engineers and analysts.

Qualifications

• Bachelor's degree as required.
• 5+ years of experience in business intelligence, analytics, data engineering, or related disciplines.
• 5+ years of progressive experience, including at least 2 years directly leading, mentoring, or coordinating technical staff (e.g., data engineers and report developers).
• Advanced experience with Microsoft Fabric and Power BI.
• Strong experience designing enterprise data models, data lakes and reporting architecture utilizing best practices.
• Strong hands-on proficiency in SQL, with working knowledge of Python and/or related languages for data transformation and analysis.
• Experience designing and maintaining ETL/data pipelines using tools such as Fabric Data Factory or SQL Server Integration Services (SSIS).
• Experience integrating with Microsoft D365 Finance & Supply Chain, AX2012, and the Azure data ecosystem (Azure Data Lake Storage, OneLake) preferred.
• Working knowledge of data governance, data security, access control, and regulatory/compliance considerations for financial and HR data.
• Relevant Microsoft certifications (e.g., Fabric Analytics Engineer, Power BI Data Analyst, or Azure Data Engineer) preferred.

Responsibilities

• Develop and execute ICM's enterprise data and analytics roadmap.
• Partner with executive leadership to align analytics investments with business objectives and growth priorities.
• Establish priorities, success measures, and adoption targets for enterprise analytics initiatives.
• Evaluate and champion emerging analytics and AI capabilities to improve decision-making and business performance.
• Provide leadership for ICM's enterprise analytics ecosystem, including Microsoft Fabric, Power BI, data warehouses, data lakes, and related technologies.
• Establish scalable data architecture, integration standards, and reporting frameworks that support long-term organizational growth.
• Partner with IT to ensure appropriate security, reliability, governance, and lifecycle management of analytics platforms.
• Lead modernization efforts supporting migration from legacy reporting and data environments.
• Establish enterprise standards for data quality, stewardship, ownership, and metric consistency.
• Develop and maintain trusted KPI definitions, business rules, and reporting standards.
• Drive resolution of data quality and reporting issues through collaboration with business and technical stakeholders.
• Promote secure, governed, and responsible use of enterprise data assets.
• Deliver trusted reporting, dashboards, and analytical solutions that improve organizational performance and decision-making.
• Partner with Finance and business leaders to identify trends, opportunities, risks, and process improvement initiatives.
• Enable self-service analytics through user training, documentation, and adoption programs.
• Translate complex data into meaningful business insights and actionable recommendations.
• Lead and develop internal analytics resources while fostering a high-performance, customer-focused culture.
• Manage external partners and vendors to ensure quality delivery and effective knowledge transfer.
• Build scalable analytics capabilities, processes, and operating models that support the organization's continued growth.
• Strengthen collaboration between Business Process Optimization, Finance, IT, and operational teams.

Skills

Power BI

Microsoft Fabric

SQL

Python

ETL pipelines

Data modeling

Data governance

Team leadership

Data warehousing

Education

Bachelor's degree in Information Systems, Data Analytics, Computer Science, Engineering, Finance, Business Administration, or related field

Tools

SSIS

Fabric Data Factory

Azure Data Lake Storage

OneLake

Dynamics 365 Finance & Supply Chain

Job description

Automatic Data Processing, Inc. seeks an experienced Senior Manager for Enterprise Data & Analytics in Colwich, KS. You will lead data strategy, build data lakes with Microsoft Fabric, and create Power BI reporting solutions to drive insights across operations and finance.

You will partner with executives to set KPIs, modernize reporting, and develop self-service analytics while guiding a team of data engineers and analysts.