DTI (Diversified Technology Inc.) · 17 hours ago
Data Reporting Analytics
Indianapolis, IN
Full-time
Onsite
Senior Level
$65/hr - $65/hr
6+ years expDTI (Diversified Technology Inc.) is a successful 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
Design, develop, and maintain reporting solutions to provide actionable insights and support business decision-making
Develop and maintain data models, dashboards, and reports to visualize data findings
Utilize tools like PowerBI to create report layouts that support and convey critical KPIs and important business insights
Perform data validation and quality checks to ensure the accuracy and integrity of reports
Gather and analyze data requirements to ensure the necessary data is available for reporting
Continuously optimize reports and data to meet the evolving needs of the business
Primary Skill Required for the Role: Microsoft - Power BI
Level Required for Primary Skill: Advanced (6-9 years experience)
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
Company
DTI (Diversified Technology Inc.)
DTI (Diversified Technology Inc.)
51-200 employees
Funding
Current Stage
Growth StageLeadership Team
Tony Henry
Chief Executive Officer
Company data provided by crunchbase