Power BI Lead Developer

BDO USA; Chicago (IL); On-site; USD 100,000 - 110,000; Full time

Job summary

BDO USA is hiring a Power BI Lead Developer to enhance its Finance department by designing and implementing Power BI solutions. The ideal candidate will have over five years in Data Analytics and Power BI experience, strong SQL skills, and will lead the development of BI architecture. Responsibilities include creating data models, visualizations, and collaborating with stakeholders to translate needs into effective data solutions. The role is critical in driving data-informed decisions and insights across the organization.

Qualifications

• 5+ years of experience in Data Analytics, Business Intelligence or Application Development.
• 5+ years of experience with Power BI.
• 1+ years of experience with Data Modeling or Star Schema Construction.

Responsibilities

• Lead the design and implementation of BI architecture and strategy.
• Collaborate with data governance in creating standards.
• Create visualizations to aid business decision-making.

Skills

Data Analytics

Business Intelligence

Power BI

SQL

Education

Bachelor’s degree in Computer Science, Accounting, or Finance

Tools

Power BI

SQL

Microsoft Power Automate

Oracle Database

Job description

Job Summary

The Power BI Lead Developer is a role within the Finance department where hands‑on experience designing, building, and deploying Power BI solutions is required. A successful candidate consults with internal stakeholders to understand their needs, create visual stories, and model data to deliver Power BI based solutions. This position requires in‑depth knowledge of visual design and data modeling best practices within Power BI, performance tuning, deployment, architecture planning, and expertise in SQL.

Job Duties

• Leads the design, development, and implementation of the company’s BI architecture and strategy
• Collaborates with data governance team in developing data modeling standards, standardized datasets, and governance frameworks
• Serves as the technical authority for Power BI development
• Creates reusable components and templates for Power BI development
• Understands business requirements and designs data models to transform raw data into meaningful insights and compelling stories
• Creates effective and compelling “art of the possible” presentations to help highlight solutions
• Builds visualizations that take complex information and make it more accessible, understandable, and usable to derive insights and enable better business decisions
• Applies branding standards and creates intentional design choices, color palette, and report design standards, choosing appropriate locations for objects with intention, and utilizing fonts and colors to design easily consumable reports
• Explores large data sets and relational databases, performs analyses and identifies unique storytelling opportunities
• Implements modern data visualization methodologies and maintains up‑to‑date knowledge of data visualization approaches
• Imports, cleans, and analyzes large data sets from disparate data sources
• Creates relationships between data and develops tabular data models
• Creates complex DAX measures to support the data analysis needs of visualizations
• Maps data models to source systems and tracks entire data lineage
• Configures incremental refresh logic for reports and understands how to design a model which supports incremental refresh, including writing and deploying the XMLA commands to customize incremental refresh
• Creates data model documentation explaining algorithms, parameters, models, and relations
• Develops training documentation for Power BI reports
• Collaborates with data engineers in ingesting and warehousing data to support data models
• Leads other team members, reviewing proposed solution designs, conducting code reviews, and troubleshooting advanced technical issues
• Manages workspaces, user permissions and deploys Power BI apps
• Designs and supports complex RLS within Power BI
• Maintains a broad and current understanding of advancements and best practices in the design and development of data analytics solutions
• Stays up‑to‑date on Power BI monthly updates
• Trains and mentors team members on Power BI best practices
• Other duties as assigned

Education

• Bachelor’s degree, required; degree in Computer Science, Accounting, or Finance, preferred

Qualifications, Knowledge, Skills, and Abilities

• Five (5) or more years of experience within Data Analytics, Business Intelligence or Application Development, required
• Five (5) or more years of experience with Power BI, required
• One (1) or more years of experience with Data Modeling, Semantic Model Definition or Star Schema Construction, required
• Experience working with Finance data, preferred

Software

• Strong SQL skills, required
• Strong ETL/ELT processes, required
• Microsoft Power Automate experience, preferred
• Oracle Database experience, preferred

Other Knowledge, Skills & Abilities

• 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 internal and client personnel
• 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 retrieval and organization of high volumes of information
• Ability to work in a deadline‑driven environment and handle multiple projects simultaneously
• A team player who can lead and initiate
• Ability to work after hours and weekends as needed
• Excellent organizational and time management skills

Keywords

Data Analytics, Business Intelligence, Machine Learning, Power BI, Azure, DAX, API, RLS, Row Level Security, Application Programming Interface, Data Analysis Expression, Power Automate, Python

Salary

National Range: $100,000 - $110,000
Maryland Range: $100,000 - $110,000
NYC/Long Island/Westchester Range: $100,000 - $110,000

Equal Employment Opportunity

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.