Business Intelligence Specialist 9934-1812

HM Note: This onsite contract role is in office every day at the manager's discretion. Candidate resumes must include first and last name, email and telephone contact information.

Description

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

Skills

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

Criteria Ratings :

Criteria 1 Technical Skills: 60 Points

• 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

Criteria 2 Documentation, Collaboration & Communication Skills: 40 Points

• 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

Knowledge Transfer:

• Knowledge to be Transferred: (at the end of the contract)
• Completed deliverables details
• Processes used for developing the deliverables
• Power BI models
• All source code created in development of deliverables

Knowledge to be Transferred to:

• Team lead / Team members

Details of Transfer: (how transfer will occur)

• 1:1 meetings / team meetings / throughout the duration of the project life cycle etc.

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