RQ09934 - Business Intelligence Specialist - Senior

Scope:

Work with project teams to ensure a successful release of Business Intelligence reporting using Power BI. The resource(s) will be responsible for:

• Use Power Query to extract data from different data sources and choose a storage mode and connectivity type. 
  
• Profile, clean, and load data into Power BI 
  
• Design data models that are intuitive, high-performing, and simple to maintain 
  
• Use M and DAX language to create measures 
  
• Ensure high performance of Power Query data retrieval tasks 
  
• Create Power BI report designs and report formatting, including report navigation
  
• Examine, sort and present data using Power BI in a cohesive manner. 
  
• Leverage statistical summaries of data and facilitate export of data from Power BI when required. 
  
• Apply and perform advanced analytics on reports for deeper and more meaningful data insights. 
  
• Leverage workspaces in the Power BI service. 
  
• Deploy Power BI artifacts to workspaces and enable sharing to users. 
  
• Connect Power BI reports to on-premise data sources. 
  
• Configure automatic refresh for Power BI datasets. 
  
• Enable Row-level security 
  
• Understand the report users needs and their requirements
  
• Develop reports all the way into production. 
  
• Work with the project team in completing all relevant and required documentation in alignment with OPS standards.
  

Deliverables:

• Create Power BI report(s), data models
  
• Undertake special assignments/sub-projects as assigned
  
• Conduct, assess, evaluate and document stakeholder interests and business needs
  
• Ensure alignment and adherence to IT processes and standards
  
• Support the testing team during system and UAT testing
  
• Participate in Knowledge transfer
  

Experience and Skill Set Requirements:

Must Haves:

• Use Power Query to extract data from different data sources and choose a storage mode and connectivity type. 
  
• Profile, clean, and load data into Power BI 
  
• Design data models that are intuitive, high-performing, and simple to maintain 
  
• Create Power BI report designs and report formatting, including report navigation
  
• Examine, sort and present data using Power BI in a cohesive manner
  
• Connect Power BI reports to on-premise data sources
  

Skill Set Requirements:

Skills and Knowledge:

• Proven experience as a Microsoft Power BI developer, building Business Intelligence reports and dashboards
  
• Demonstrated experience with M, DAX and Power Query
  
• Knowledge of Microsoft Azure ecosystem
  
• Proven experience with SQL Server and other database technologies
  
• Proven, demonstratable experience in data modeling and data visualization; working with different data schemas and BI implementation methodologies
  
• Knowledge of data analysis, data management
  
• Proven ability to partner with internal/external stakeholders and liaise with technical experts and non-technical colleagues
  
• Experience in understanding, capturing, and analyzing complex and sometimes competing business requirements to develop Power BI and Business Intelligence products
  
• Excellent verbal and written communication skills, interpersonal and facilitation skills  
  
• Strong written, presentation and interpersonal communication skills with special attention to correct use of tense, grammar/spelling and terminology
  
• Demonstrated effective time management and organizational skills, including the ability to plan and prioritize workload, ensuring timelines are met and respond to demands of a dynamic environment
  
• Mandatory Requirements: At least 5 years of experience
  
• All roles procured are required to be cleared through the Contractor Security Clearance Process of the OPS. 
  
• Security Clearance process, levels, roles etc. are subject to change without prior notice. Candidates may be required to undergo revised/new process (or levels) any time prior or during the term of the contract.
  

Mandatory Requirements:

• Use Power Query to extract data from different data sources and choose a storage mode and connectivity type. 
  
• Profile, clean, and load data into Power BI 
  
• Design data models that are intuitive, high-performing, and simple to maintain 
  
• Create Power BI report designs and report formatting, including report navigation
  
• Examine, sort and present data using Power BI in a cohesive manner
  
• Connect Power BI reports to on-premise data sources
  

Technical Skills:

• Proven work experience as a Power BI Report Developer
  
• Demonstrated experience with M, DAX and Power Query
  
• Knowledge of Microsoft Azure ecosystem and the Power Platform
  
• Proven experience with SQL Server and Power BI Datasets
  
• Proven, demonstratable experience in data modeling and data visualizations for Power BI; working with different data schemas and BI implementation methodologies 
  
• Knowledge of data analysis, data management
  
• Experience in understanding, capturing, and analyzing complex and sometimes competing business requirements to develop Power BI and Business Intelligence products
  
• Demonstrated experience with performance tuning in Power BI including measures, relationships and visuals
  
• Demonstrated experience with data sources for Power BI including DirectQuery, Import and appropriate Considerations and limitations
  
• Demonstrated experience with Power BI datasets
  
• Demonstrated experience with Power BI refresh
  

Documentation, Collaboration & Communication Skills:

• Ability to partner with internal/external stakeholders and liaise with technical experts and non-technical colleagues, regarding project deliverables
  
• Proven experience in developing documentation
  
• Demonstrated experience collaborating with Developers, Testers and Program Managers
  
• Proven experience in producing diagrams, videos, and other visual content
  
• Experience analyzing customer feedback and responding to it to improve the customer experience
  
• Experience in bringing clarity to complex business challenges and conflicting articulation of business issues through techniques that result in a common understanding of the issues, as well as agreement business process requirements vs technology requirements to solve the issues.
  
• Experience in understanding, capturing, and analyzing complex and sometimes competing business requirements to develop Business Intelligence products
  
• Excellent verbal and written communication skills, interpersonal and negotiation skills  
  
• Facilitation skills, Interpersonal and consultative skills
  
• Stakeholder management skills. Demonstrated strong problem-solving and organizational skills
  
• A team player with a track record for meeting deadlines.  
  
• Working knowledge and experience developing reports for use by a wide spectrum of stakeholders 
  
• Strong written, presentation and interpersonal communication skills with special attention to correct use of tense, grammar/spelling and terminology.
  
• Demonstrated effective time management and organizational skills, including the ability to plan and prioritize workload, ensuring timelines are met and respond to demands of a dynamic environment