Power BI Lead Developer

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 has a passion for consulting with 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
  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
  Develops 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
  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

Education

• Education Qualifications, Knowledge, Skills, and Abilities: Bachelor's degree, required; degree in Computer Science, Accounting, or Finance, preferred
  Experience: 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 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
  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

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, our clients, and our communities. BDO is the first large accounting and advisory organization to implement an Employee Stock Ownership Plan (ESOP). A qualified retirement plan, the ESOP offers participants a stake in the firm’s success through beneficial ownership and a unique opportunity to enhance their financial well-being. The ESOP stands as a compelling addition to our comprehensive compensation and Total Rewards benefits* offerings. The annual allocation to the ESOP is fully funded by BDO through investments in company stock and grants employees the chance to grow their wealth over time as their shares vest and grow in value with the firm’s success, with no employee contributions. 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, a Breadth And Depth Of Resources, And Unwavering Commitment To Quality, We Pride Ourselves On Welcoming diverse perspectives and understanding the experience of our professionals and clientsEmpowering team members to explore their full potentialOur talented team who brings varying skills, knowledge and experience to proactively help our clients navigate an expanding array of complex challenges and opportunitiesCelebrating ingenuity and innovation to transform our business and help our clients transform theirsFocus on resilience and sustainability to positively impact our people, clients, and communitiesBDO Total Rewards that encompass so much more than traditional “benefits.” Click here to find out more! Benefits may be subject to eligibility requirements. Equal Opportunity Employer, including disability/vets Click here to find out more! 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"