Work with project teams to ensure 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 company standards.
Experience and Skill Set Requirements:
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 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
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.
Must Have:
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