Data Reporting Analytics

Summary LeadLife Sciences Clinical Manufacturing Systems and GMP experience is a MUST have. Client has rejected internal candidates due to lack of functional exposure to Clinical Manufacturing environment and Good Manufacturing Practices. We can find technical data engineers, but the role needs prior functional and technical experience with data from clinical manufacturing sources – Pi historian, LIMS, MES, RT data Responsibilities Power BI Desktop, DAX, Power Query/M language, Semantic Model design, SQL, Data Modeling, Row-level Security (RLS) Secondary: PBI Administration Develop data visualization to support the Foundry operational reporting needs Configure and establish the LMF Fabric workspace with appropriate security controls for Red CCI data Set up OneLake shortcuts to AWS S3 buckets containing LMF data (Bronze/Silver/Gold zones) Design and build semantic models (datasets) using Direct Lake mode for optimal performance Develop initial Batch Review Dashboard integrating MES and LIMS data Implement Row-Level Security (RLS) aligned with Red CCI access requirements Establish report development standards and templates for LMF Requirements Enable Skills-Based HiringNoPrimary Skill Required for the Role Microsoft - Power BILevel Required for Primary Skill Advanced (6-9 years experience)Additional Skills Requested for Role Skill (optional) Level (optional) Criteria (optional) Power BI Life Sciences and Healthcare Modernization Strategy and ImplementationAdditional Details for Role Power BI Desktop, DAX, Power Query/M language, Semantic Model design, SQL, Data Modeling, Row-level Security (RLS) Secondary: PBI Administration Develop data visualization to support the Foundry operational reporting needs Configure and establish the LMF Fabric workspace with appropriate security controls for Red CCI data Set up OneLake shortcuts to AWS S3 buckets containing LMF data (Bronze/Silver/Gold zones) Design and build semantic models (datasets) using Direct Lake mode for optimal performance Develop initial Batch Review Dashboard integrating MES and LIMS data Implement Row-Level Security (RLS) aligned with Red CCI access requirements Establish report development standards and templates for LMFWill any work be done by the contractor outside of the United States? If yes, please explain. NoWhat stage is the Project in? Sold/FundedAre Expenses permitted? YesMax Vendor Rate (Contractor hourly rate inclusive of Supplier mark-up) 90Client Flow Down Terms No Are there client flow down requirements that the Supplier should be aware of when sourcing? Standard BGV Skills data visualization Power BI Desktop Clinical Manufacturing Systems and GMP