BI Manager, Finance BI

BDO USA; Madison (WI); On-site; USD 130,000 - 150,000; Full time

Job summary

BDO USA is seeking a BI Manager to lead a team of Finance BI Developers and Analysts responsible for designing, building, and governing reporting, analytics, and automation that support Finance and business-wide decision making.

You will set development standards, oversee Power BI, SQL, data modeling, and Power Automate deliverables, and ensure quality, security, and reliability of the Finance BI portfolio while developing team members and reporting to Finance BI leadership on performance and

Qualifications

• Bachelor's degree, required.
• Five or more years of experience in Data Analytics, BI or Application Development, required.
• Two or more years of experience leading or managing a technical team, required.

Responsibilities

• Leads, manages, and develops a team of Finance BI Developers and Analysts.
• Primary escalation point for complex Power BI, SQL, data modeling, and Power Automate issues.
• Owns and evolves Finance BI architecture, semantic model standards, and governance practices.

Skills

Power BI

SQL

Data modeling

DAX

Row Level Security

Power Automate

Oracle

Education

Bachelor's degree

Tools

Power Automate

Job description

JOB DESCRIPTION

The BI Manager leads a team of Finance BI Developers and Analysts responsible for designing, building, and governing the reporting, analytics, and automation solutions that support Finance and business-wide decision making. This position sets development standards, semantic model architecture, and governance practices for the Finance BI team, and serves as the primary escalation point for complex technical issues, cross-functional stakeholder needs, and resourcing decisions. The Finance BI Manager partners with Finance leadership and business stakeholders to translate strategic reporting and analytics priorities into a coordinated team roadmap, oversees Power BI, SQL, data modeling, and Power Automate deliverables produced by the team, and is accountable for the quality, security, and reliability of the Finance BI portfolio. This role manages and develops team members, drives adoption of best practices, and reports to Finance BI leadership on team performance, priorities, and risks.

Job Summary

The BI Manager leads a team of Finance BI Developers and Analysts responsible for designing, building, and governing the reporting, analytics, and automation solutions that support Finance and business-wide decision making. This position sets development standards, semantic model architecture, and governance practices for the Finance BI team, and serves as the primary escalation point for complex technical issues, cross-functional stakeholder needs, and resourcing decisions. The Finance BI Manager partners with Finance leadership and business stakeholders to translate strategic reporting and analytics priorities into a coordinated team roadmap, oversees Power BI, SQL, data modeling, and Power Automate deliverables produced by the team, and is accountable for the quality, security, and reliability of the Finance BI portfolio. This role manages and develops team members, drives adoption of best practices, and reports to Finance BI leadership on team performance, priorities, and risks.

Job Duties

• Leads, manages, and develops a team of Finance BI Developers and Analysts, including performance management, coaching, and career development
• Serves as the primary escalation point for complex Power BI, SQL, data modeling, and Power Automate issues that exceed the scope of individual developers
• Owns and evolves Finance BI architecture, semantic model design standards, data governance practices, and development guidelines across the team
• Partners with Finance leadership and business stakeholders to translate strategic priorities into a prioritized team roadmap and resourcing plan
• Reviews and approves Power BI reports, semantic models, DAX measures, data transformations, and documentation before deployment to ensure quality and consistency
• Ensures reports have up-to-date training available for end-users
• Oversees workspace management, permissions, deployment processes, and access controls, including Row Level Security, across the Finance BI Power BI environment
• Manages relationships with data engineering, IT, and other technical partners to secure the data and infrastructure the team needs
• Drives adoption of AI-enabled development practices responsibly, balancing efficiency gains with data privacy, security, and compliance requirements
• Establishes and monitors team standards for version control, testing, documentation, training materials, and peer review processes
• Communicates the status of major initiatives, risks, and resourcing needs to Finance BI leadership and other senior stakeholders
• Exercises diligence with financial information by maintaining accurate results, safeguarding sensitive data, and supporting trusted business decisions
• Builds and maintains relationships with business stakeholders to gather requirements and ensure delivered solutions meet evolving reporting and analytics needs
• Applies branding standards, design principles, and Finance BI development standards to ensure a consistent, professional look and feel across deliverables
• Maintains up-to-date knowledge of Power BI, data visualization, and analytics platform capabilities, and evaluate new tools and techniques for team adoption
• Supports hiring, onboarding, and training for new Finance BI team members
• Other duties as assigned

Education

• Bachelor's degree, required

Qualifications, Knowledge, Skills and Abilities

• Bachelor's degree, required

Experience

• Five (5) or more years of experience within Data Analytics, Business Intelligence or Application Development, required
• Two (2) or more years of experience leading or managing a technical team, required
• Experience working with Finance data, preferred

Software

• Strong SQL skills, required
• Five (5) or more years of experience with, Data Modeling, Semantic Model Definition or Star Schema Construction, required
• Strong SQL query development skills, including joins, aggregations, views, data validation, troubleshooting, and performance-aware query design, required
• Experience developing, maintaining, and troubleshooting Microsoft Power Automate workflows to support reporting, approvals, notifications, data collection, and process automation, preferred

Other Knowledge, Skills & Abilities

• Proven ability to lead, coach, and develop a team of technical professionals.
• Ability to interact effectively with people at all organizational levels and communicate complex concepts to senior and non-technical audiences
• Capacity to build and maintain strong relationships with stakeholders
• Solid organizational and excellent verbal and written communication skills
• Ability to successfully multi-task while working independently or within a group environment
• Comprehensive knowledge of data design, data modeling, data management, and data visualization
• Strong analytical and research skills related to the retrieval and organization of high volumes of information
• Ability to make sound decisions regarding architecture, prioritization, and resourcing with limited oversight
• Ability to work in a deadline-driven environment, and handle multiple projects simultaneously
• A team leader who takes initiative, supports team standards, and contributes to shared team success
• Excellent organizational and time management skills
• Ability to work after hours and weekends as needed

Keywords

Data Analytics, Business Intelligence, Power BI, DAX, RLS, Row Level Security, Power Automate, Oracle, Finance

Individual salaries that are offered to a candidate are determined after consideration of numerous factors including but not limited to the candidate’s qualifications, experience, skills, and geography.

National Range: $130,000 - $150,000

Maryland Range: $130,000 - $150,000

NYC/Long Island/Westchester Range: $130,000 - $150,000

• Benefits may be subject to eligibility requirements.

About Us

At BDO, how we show up matters. We build strong relationships by supporting one another, our clients, and our communities with care, curiosity, and a commitment to helping one another grow and succeed. Here, you’ll find meaningful work, leaders invested in your success, and opportunities to build a career around what matters most to you.

Our purpose is to be the people our clients count on to grow with confidence and achieve what matters most. Our values guide how we bring that purpose to life each day. Together, they shape how we work with one another, serve our clients, and create meaningful impact.

BDO provides assurance, tax, and advisory services to clients across the U.S. and around the world. No matter your role, you’ll be part of a team helping clients navigate complexity and move forward with clarity.

We are proud to be an ESOP company, offering participants a stake in the firm’s success through beneficial ownership and a unique opportunity to enhance their financial well-being. As a qualified retirement plan, the ESOP is a meaningful addition to our comprehensive compensation and Total Rewards benefits* offerings. It also reinforces an ownership mindset that strengthens our connection to one another, our clients, and the future we’re building together.

Learn more about our benefits: BDO Total Rewards encompass more than traditional benefits. Click here to find out more !

Equal Opportunity Employer, including disability/vets

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability or protected veteran status.

BDO USA, P.A. is an EO employer M/F/Veteran/Disability