Job Title: Sr Power BI Developer
Location: 3 days onsite (airport)
Position Type: 12-month contract

Our client is looking to fill a contract position for a Senior Power BI Developer that is proficient in the design and development of Power BI Dashboard standards and the creation and documentation of enterprise reporting portfolios. The Senior Developer will be a key resource in advocating for the adoption of these standards by our client’s business users and the Analytics Center of Excellence (COE) for all reporting and dashboard development.
The Senior Power BI Developer’s preliminary work will focus on designing and creating core BI semantic models for business users in addition to supporting the Center of Excellence by establishing standards and recommending robust role level security models. This position will demand critical thinking skills, having the ability to quickly understand existing data sources, models, and systems.
Additionally, the Senior Power BI Developer will take part in a community of Business Intelligence developers that will collaborate to share best practices, build and execute simple to complex dashboards for the business and catalog the dashboard inventory across the Enterprise such that all reports developed and in production are diarized and searchable
 

Responsibilities and Activities

• Strategy
  • Work with manager Analytics, Governance and Architecture to develop a reporting roadmap for the organization from the backlog inventory and business user community
  • Help implement best practices to determine when a report vs dashboard is needed to ensure a healthy and relevant reporting portfolio.

 

• Design and Development:
  • Design and create core BI semantic models
  • Support business users in creating smaller-scale, independent models to fulfill self-serve capabilities
  • Craft simple to complex reports and dashboards using Power BI for business use.
  • Propose best practices for displaying real time/ leading indicator data with historical views, outcomes.

 

• Optimization and Troubleshooting:
  • The Senior Developer will work directly with the business and the COE to understand compute requirements and offer optimization suggestions to ensure  dashboards perform and PBI / Azure costs are managed within approved thresholds.
  •  Perform capacity planning and optimize Power BI premium workloads
  • Troubleshoot and resolve performance issues with PBI Admin
  • Act as the subject matter expert to enhance query performance for extremely responsive interactive analytics, especially with large data sets.
  • Analyze existing reports and work with business users to determine how these reports can be improved based on current business needs.
  • Help document best practices and contribute to the learning series as part of a tailored Data Literacy Program to business functions where self-service is the delivery model.
  • Create comprehensive documentation for PBI solutions, including data models, report specifications, and user guides

 

• Integration and Migration:
  • In partnership with the Data Engineering team, co-direct the development of data pipelines, data warehousing, and data modeling solutions on the Azure Data Analytics environment. 
  • Work with ADF pipelines, Databricks, Data Lake, and Synapse DW on Azure.
  • Support migration projects, particularly transitioning from Tableau to Power BI and support business users in making the transition assisting them in functional differences and best practices.
• Collaboration and Communication:
  • Operate effectively within a hub-and-spoke model, providing strong support to various business units (spokes).
  • Communicate clearly and effectively with technology SMEs and architects
  • Document and articulate BI solutions to ensure clear communication with stakeholders.

 

• Data Modeling and Programming:
  • Utilize T-SQL extensively for writing Stored Procedures, Triggers, and Functions.
  • Perform data conversion, normalization

 

• Self-Serve Architecture:
  • In partnership with Data Engineering team establish the Power BI and Azure reporting requirements roadmap for increasing levels of compute and complexity
  • Partner with the PBI Admin and Data Engineering team to plan for future environment requirements including partitioned ‘sandboxes’ to help our client build proficiency in self-serve PBI development
  • Architect solutions that empower individual business units to perform self-serve reporting and dashboarding.
  • Provide guidance and best practices for business units to create and manage their own Power BI reports and dashboards. In conjunction with our Data Governance team, implement robust security model recommendations in Power BI solutions, including applying Row-Level Security (RLS).

Requirements:

• Education/ Experience:
  • Bachelor’s degree in computer science, Information Technology, or software development.
  • Graphic design minor considered a plus.
  • 8+ years of experience in building BI solutions using Microsoft technologies, including the Azure data stack.
  • 8+ years of experience in designing solutions with Power BI.
  • Proven experience with Power BI Dataflows and complex DAX calculations
  • Experience with Azure cloud BI solution implementation.
  • Experience with paginated reports is considered a plus.
• Skills:
  • Excellent written and verbal communication skills.
  • Expertise in designing and developing reports with Power BI.
  • Hands-on experience with SQL programming and Big Data processing on the Azure platform.
  • Knowledge of Enterprise Gateway, data refresh scheduling through service

 

• Preferred:
  • Certified PowerBI
  • Prior experience migrating Tableau to Power BI.
  • Knowledge or experience with Oracle, SharePoint, PPM, Tableau tools.
  • Experience with integrating PBI reports into various applications.