Power BI Lead Developer

BDO USA•Grand Rapids, MI

About The Position

The Power BI Lead Developer is a role withing the Finance department where hands on experience designing, building, and deploying Power BI solutions is required. A successful candidate has a passion for consulting with our internal stakeholders to understand their needs, visual storytelling, and modeling data to deliver Power BI based solutions. This position brings and maintains in-depth knowledge on visual design and data modeling best practices within Power BI, performance tuning, deployment, and architecture planning, as well as being an expert in SQL.

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
Strong SQL skills, required
Strong ETL/ELT processes, required
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 the 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

Nice To Haves

Experience working with Finance data, preferred
Microsoft Power Automate Experience, preferred
Oracle Database Experience, preferred

Responsibilities

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 design 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
Takes 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, perform analyses and identify unique storytelling opportunities
Implements modern data visualization methodologies and maintains an up-to-date knowledge of data visualization approaches
Imports, cleans and analyzes large data sets from disparate data sources
Creates relationships between data and develop tabular data models
Creates complex Data Analysis Expression (DAX) measures to support the data analysis needs of visualizations
Maps data models to source systems and track 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 XML for Analysis (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
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 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