Overview
Skills
Job Details
Position :: Power BI Technical Lead with Life Sciences
Location :: 100% remote
Duration :: 6+ months
Interview :: Video
Job Description:
MUST have a Life Sciences background excellent communicator!!
We are seeking a skilled PowerBI expert to create intuitive reports and dashboards that provide actionable insights.
The ideal candidate will have a deep understanding of building semantic models to ensure data accuracy and relevance.
You will be responsible for transforming raw data into meaningful visualizations that drive decision-making.
Need someone who has a passion for data visualization and a strong background in PowerBI.
Project Name: E2E Labeling/ Regulatory Data Hub and Reporting
Project Scope:
Analysis and Design
Front end reporting:
- Workshops to create high-level report wireframes
- Leverage sample data and PowerBI to create mockups
- Finalize Reports for MVP
Back end reporting:
- Build silver ER diagram from RIM Reference Model
- Build gold dimensional model
- Create data mapping specifications
Build
Reporting build:
- Create mock data structures in development environment to allow report build to start in parallel with ETL development
- Leverage Agile Process to release reports in waves as data comes online
ETL and Model implementation:
- Ingest needed data from FOCUS and other data sources as needed (bronze)
- Build dbt ETL for silver and gold models
- Implement matching, data quarantine, and error handing for joining data across systems
Validation and Deployment:
- Implement any needed fixes or updates from MVP usage
- Perform needed SDLC activities for IQ, OQ, PQ
- Establish CI/CD pipelines for release management
- Establish and transition support activities