Power BI Lead Developer

Job Summary :

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.

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

Qualifications, Knowledge, Skills, and Abilities :

Education :

Experience :

Software :

Other Knowledge, Skills & Abilities :

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

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 : $85,000 - $110,000

California Range : $85,000 - $110,000

Colorado Range : $85,000 - $110,000

Maryland Range : $85,000 - $110,000

Minnesota Range : $85,000 - $110,000

NYC / Long Island / Westchester Range : $85,000 - $110,000

Washington Range : $85,000 - $110,000

Washington DC Range : $85,000 - $110,000