Principal Data Visualization Consultant (Power BI & Claude AI)

inSync Staffing

Lebanon, IN

JOB DETAILS
SKILLS
Analysis Skills, Application Programming Interface (API), Artificial Intelligence (AI), Automation, Biotech and Pharmaceutical, CSS (Cascading Style Sheet), Capital Project, Computer Systems, Construction, Consulting, Customer Relations, Data Analysis, Data Management, Data Modeling, Data Visualization, Database Extract Transform and Load (ETL), Documentation, Enterprise Data Integration, Forecasting, GxP, HTML (HyperText Markup Language), Health Insurance, JavaScript, JavaScript Libraries, Knowledge Transfer, Laboratory Information Management System (LIMS), Leadership, Manufacturing, Meeting Minutes, Microsoft Product Family, Microsoft SQL Server, Microsoft SharePoint, Oracle, Oracle Database, Power BI, Primavera, Project Schedule, Reporting Dashboards, SAP, System Validation, User Interface/Experience (UI/UX), Web Programming, XML (EXtensible Markup Language)
LOCATION
Lebanon, IN
POSTED
1 day ago

 JOB TITLE:      Principal Power BI & Claude Data Visualization Consultant
LOCATION:       Lebanon, IN (one week a month, the rest remote)
INDUSTRY:       Manufacturing
 
JOB OVERVIEW:  We are seeking a highly experienced Data Visualization Consultant to support a large-scale   construction program based in Lebanon, Indiana. This role will partner directly with senior leadership to deliver high-impact, executive-level dashboards and insights.  This is a 6-month engagement with strong potential for extension. The role is primarily remote, with travel to the Lebanon, IN site one week per month.
 
RESPONSBILITIES:
Data Engineering & Integration

  • Establish secure, read-only connections to Oracle Primavera P6 (EPPM) data sources and staging environments (e.g., BigQuery).
  • Design and optimize data models that unify multiple project schedules into a single, analysis-ready structure.
  • Integrate scheduling data with enterprise systems such as SharePoint and Veeva.
  • Build modern, automated data pipelines—no reliance on file-based extracts (e.g., XER, XML, Excel).
Power BI Dashboard Development
  • Create executive-level dashboards, including large-scale Gantt visualizations across multiple sites and systems.
  • Develop intuitive drill-down capabilities (Program → Site → System → Product Line).
  • Incorporate key project insights such as critical path, dependencies, and planned vs. actual vs. forecast variance.
  • Ensure dashboards stay current through automated data refresh processes.
AI-Driven Visualization & Applications (Claude AI)
  • Build and deploy custom data connectors leveraging Claude AI to transform and interpret P6 data.
  • Develop interactive, web-based dashboards (HTML/JavaScript) generated through AI workflows.
  • Package reusable AI capabilities for internal rollout, including documentation and deployment guidance.
  • Design automation to generate monthly executive status presentations using project data and meeting notes.
  • Validate dashboard accuracy against Primavera P6 outputs at a detailed level.
  • Document data models, pipelines, and transformation logic for transparency and maintainability.
  • Lead knowledge transfer sessions and provide clear handoff materials to internal teams.
 
REQUIREMENTS:
  • Strong background in data engineering, including ETL/ELT pipeline design and advanced SQL (Oracle, BigQuery, or SQL Server).
  • Deep expertise in Power BI, including DAX, custom visuals, and Power BI Service administration.
  • Experience building AI-powered applications using LLMs (preferably Claude) and integrating APIs.
  • Front-end development experience with HTML, CSS, and JavaScript visualization libraries (e.g., D3.js).
  • Experience working with large-scale schedule data, including complex Gantt charts and dependency mapping.
 
Preferred Experience
  • Background in pharmaceutical, biotech, or regulated (GxP) environments.
  • Familiarity with large capital project environments or greenfield facility buildouts.
  • Exposure to systems such as MES, LIMS, SAP, Tulip, or Computer System Validation (CSV).
 
Certifications (Nice to Have)
  • Microsoft Certified: Power BI Data Analyst Associate (PL-300)
  • Claude or LLM-related certifications, or demonstrated experience delivering AI-based solutions in production
 
 
 
 
Best-In-Class-Benefits:  We are in the people business; treating people right is our ONLY priority. Theoris Services consultants are full-time employees with full benefits, including:
  • Robust Health Insurance
  • 401(k) plan
  • PTO
  • Paid holidays

 
About Theoris: Our goal is to Fuel Your Career! As a Theoris team member, you join a culture based on people-centered values and an environment that fosters both personal and professional growth. We build long-term relationships with our clients and our consultants. With over 30 years of building strong relationships in the industry, we’re uniquely positioned to make the right connections. This knowledge is used to find the right job placement. Our recruiting teams are experts dedicated to the information technology and engineering staffing space and are highly respected by our client base.
 


All qualified applicants will receive consideration for employment without regard to age, race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran. Rate of pay within the stated range will depend on the qualification of the applicant.

About the Company

i

inSync Staffing

We recognize the VMS program management team is our customer and needs to be serviced with integrity, so we built and continue to improve upon our delivery methods as we strive to provide the highest quality service possible. inSync Staffing’s management team recognized ten years ago the inevitable changes to the staffing industry being brought about by technology and the growing trend of Fortune 1000 corporations to outsource management of their contingent workforces to meet compliance and cost control goals. Rather than swim upstream against the changes, inSync Staffing has embraced MSP and VMS programs as our customers, not competitors. We asked program managers how they want to be serviced. The result of their input is that we have structured inSync Staffing as a recruiting and customer service organization, unlike traditional staffing companies who sell directly to the end client. Our delivery model allows us concentrates our resources on how to best supply candidates in a very competitive MSP/VMS program environment.
COMPANY SIZE
50 to 99 employees
INDUSTRY
Staffing/Employment Agencies
FOUNDED
2014
WEBSITE
http://www.insyncstaffing.com/default.html