Overview
The BI/DW Architect (Finance Analytics & Insights) is a strategic leader within the Global Controllership organization responsible for building and managing the finance reporting, analytics, and business intelligence ecosystem.
What you'll do
- Serve as the accounting organization's subject matter expert for Power BI and enterprise reporting solutions.
- Design, develop, and maintain executive dashboards supporting the Corporate Controller, CFO, Finance Leadership Team, and Audit Committee.
- Build interactive dashboards covering S2P | Supply Chain/Procurement and AP Close metrics, account reconciliations, SOX compliance, intercompany, revenue, fixed assets, AR, treasury, tax, M&A integration, ERP implementation, and finance transformation initiatives.
- Develop self-service reporting capabilities that enable Finance leaders to access timely and reliable operational and financial insights.
- Design and maintain scalable financial data models supporting enterprise reporting.
- Build optimized semantic models within Power BI.
- Develop ETL/ELT processes to automate data extraction, transformation, and loading from ERP and finance applications.
- Partner with Finance Systems and IT to establish standardized data pipelines.
- Improve data quality, consistency, and governance across financial systems.
- Establish governance, development standards, security models, and best practices for Power BI.
- Lead dashboard architecture, workspace administration, deployment pipelines, and lifecycle management.
- Optimize report performance and scalability.
- Develop reusable datasets and standardized financial reporting models.
- Mentor Finance users on Power BI capabilities and self-service analytics.
- Eliminate manual reporting through automation, including automated KPI reporting for monthly close, quarterly reporting, SEC reporting, Audit Committee reporting, executive operating reviews, and SOX monitoring.
- Integrate reporting across Oracle, NetSuite, Workday, Salesforce, BlackLine, Coupa, and other enterprise applications.
- Develop predictive analytics supporting cash flow forecasting, revenue trends, close cycle performance, working capital, AP and AR analytics, journal entry monitoring, and financial risk indicators.
- Utilize DAX, Power Query (M), SQL, Python, and AI-enabled analytics to enhance financial decision-making.
- Explore machine learning and AI opportunities to improve financial forecasting and anomaly detection.
- Develop executive dashboards and standardized reporting packages for the Corporate Controller, CFO, Finance Leadership Team, Executive Leadership Team, Audit Committee, and Board of Directors.
- Partner with Finance leadership to modernize financial reporting, digitize accounting operations, reduce manual reporting, improve decision support, and drive automation across the Controllership organization.
- Partner closely with Corporate Accounting, SEC Reporting, Technical Accounting, Tax, Treasury, FP&A, Internal Audit, Finance Systems, Enterprise Data & Analytics, IT, HR, and Sales Operations.
What you'll need
- Bachelor's degree in Engineering, Computer Science, Information Systems, Data Analytics, Finance, Accounting, or a related technical discipline.
- 8–12+ years of experience in business intelligence, analytics, or financial systems.
- Expert-level Power BI development experience.
- Advanced expertise in DAX, Power Query (M), data modeling, semantic models, Row-Level Security (RLS), Power BI Service administration, Deployment Pipelines, and performance optimization.
- Strong SQL development skills.
- Experience integrating multiple enterprise systems into reporting solutions.
- Experience building executive dashboards for senior leadership.
- Strong understanding of financial statements and accounting processes.
- Experience working within Finance organizations supporting Accounting and Controllership.
Nice to have
- Degree in Computer Engineering, Software Engineering, Data Engineering, Information Systems, or a related engineering discipline.
- Experience with Microsoft Fabric, Azure Synapse, Azure Data Factory, Azure Data Lake, and Microsoft Purview.
- Experience with Oracle ERP Cloud, Oracle Fusion, NetSuite, SAP, or Workday.
- Knowledge of financial close, consolidation, SEC reporting, SOX compliance, and internal controls.
- Experience supporting publicly traded companies.
- Experience with Power Automate, Power Apps, and Microsoft Copilot.
- Familiarity with Python, R, or other analytics programming languages.
- Experience leading enterprise reporting transformations.
Details
Read the full description and apply on the company’s own careers page.