Power BI Lead Developer
About the Role
The Power BI Lead Developer is a role within the Finance department requiring hands-on experience designing, building, and deploying Power BI solutions. A successful candidate has a passion for consulting with internal stakeholders to understand their needs, visual storytelling, and modeling data to deliver Power BI-based solutions.
Responsibilities
- Leads the design, development, and implementation of the company’s BI architecture and strategy
- Collaborates with the 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 highlight solutions
- Builds visualizations that make complex information accessible, understandable, and usable to derive insights and enable better business decisions
- Applies branding standards to create intentional design choices, color palettes, and report design standards
- Explores large data sets and relational databases, performs analyses, and identifies unique storytelling opportunities
- Imports, cleans, and analyzes large data sets from disparate data sources
- Creates relationships between data and develops tabular data models
- Creates complex Data Analysis Expression (DAX) measures to support visualization needs
- Maps data models to source systems and tracks entire data lineage
- Configures incremental refresh logic for reports, including designing models that support incremental refresh and deploying XMLA commands
- 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
- Serves as a leader to 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 Row Level Security (RLS) within Power BI
- Maintains a broad and current understanding of advancements and best practices in data analytics solutions
- Stays up-to-date on Power BI monthly updates
- Trains and mentors team members on Power BI best practices
- Performs other duties as assigned
Requirements
- Bachelor's degree, required; degree in Computer Science, Accounting, or Finance, preferred
- 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
Skills
- Strong SQL skills, required
- Strong ETL/ELT processes, required
- Microsoft Power Automate experience, preferred
- Oracle Database experience, preferred
- 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 retrieving and organizing high volumes of information
- Ability to work in a deadline-driven environment and handle multiple projects simultaneously
- Team player who can lead and initiate
- Ability to work after hours and weekends as needed
- Excellent organizational and time management skills
Pay
Individual salaries are determined after consideration of numerous factors including qualifications, experience, skills, and geography.
- National Range: $100,000 - $110,000
- Maryland Range: $100,000 - $110,000
- NYC/Long Island/Westchester Range: $100,000 - $110,000
About Us
Join us at BDO, where you will find more than a career—you’ll find a place where your work is impactful, and you are valued for your individuality. We offer flexibility and opportunities for advancement. Our culture is centered around making meaningful connections, approaching interactions with curiosity, and being true to yourself, all while making a positive difference in the world.
At BDO, our purpose of helping people thrive every day is at the heart of everything we do. Together, we are focused on delivering exceptional and sustainable outcomes and value for our people, clients, and communities. BDO is proud to be an ESOP company, reflecting a culture that puts people first by sharing financially in our growth in value with our U.S. team.
BDO professionals provide assurance, tax, and advisory services for a diverse range of clients across the U.S. and in over 160 countries through our global organization. BDO is the first large accounting and advisory organization to implement an Employee Stock Ownership Plan (ESOP). The ESOP offers participants a stake in the firm’s success through beneficial ownership and enhances financial well-being, with no employee contributions required.
- We are committed to delivering exceptional experiences to middle-market leaders by sharing insight-driven perspectives.
- Helping companies take business as usual to better than usual with industry knowledge and experience.
- Empowering team members to explore their full potential.
- Celebrating ingenuity and innovation to transform our business and help our clients transform theirs.
- Focusing on resilience and sustainability to positively impact our people, clients, and communities.
BDO Total Rewards encompass more than traditional benefits. Click here to find out more!