DTI (Diversified Technology Inc.) · 1 day ago
Data Reporting Analytics
DTI (Diversified Technology Inc.) is an IT Consulting/Staffing firm based in Chicago's Loop. They are seeking a Data Reporting Analytics Contractor to design, develop, and maintain reporting solutions that provide actionable insights and support business decision-making.
Information Technology & Services
Responsibilities
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
Qualification
Required
Life Sciences Clinical Manufacturing Systems and GMP experience is a MUST have
Prior functional and technical experience with data from clinical manufacturing sources – Pi historian, LIMS, MES, RT data
Microsoft - Power BI (Advanced, 6-9 years experience)
Power BI Desktop
DAX
Power Query/M language
Semantic Model design
SQL
Data Modeling
Row-level Security (RLS)
PBI Administration