Finance BI Lead & Analytics Architect

BDO USA; Melville (NY); On-site; USD 130,000 - 150,000; Full time

Job summary

The BI Manager at BDO USA 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.

They set development standards, semantic model architecture, governance practices, and partner with Finance leadership to translate priorities into a coordinated team roadmap, overseeing Power BI, SQL, data modeling, and Power Automate deliverables while ensuring

Qualifications

• Bachelor's degree, required.
• 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.

Responsibilities

• 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.

Skills

SQL

Data Modeling

DAX

Power BI

Power Automate

Education

Bachelor's degree

Tools

SQL

Power BI

Data Modeling

Semantic Model

Star Schema

Oracle

Job description

The BI Manager at BDO USA 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.

They set development standards, semantic model architecture, governance practices, and partner with Finance leadership to translate priorities into a coordinated team roadmap, overseeing Power BI, SQL, data modeling, and Power Automate deliverables while ensuring