BI & AI Data Scientist
- Hiring from
- United States
- Work type
- Hybrid
- Posted
624,339 remote jobs, straight from company career pages
100% free · New jobs every minute
Show job descriptionHide job description
BI & AI Data Scientist
Department: Information Technology & Enterprise Data
Location: Charlotte, NC (Hybrid)
Reports To: VP of Information Technology
Position Summary
We are seeking a hands-on, mid-level BI & AI Data Scientist to help build and scale our enterprise data warehouse, business intelligence reporting, and modern AI workflows.
Working closely with IT leadership, you will build and maintain data pipelines from Salesforce and core business systems into Azure Synapse Analytics, develop executive-grade Power BI semantic models, and configure governed AI integrations—specifically connecting Anthropic’s Claude via Model Context Protocol (MCP)—so leadership and operational teams can securely query and act on live business data.
Key Responsibilities
· Enterprise Data Warehousing (Azure Synapse): Build, maintain, and optimize automated ELT/ETL pipelines ingesting data from Salesforce, financial platforms, and operational databases into Azure Synapse (SQL pools and Spark).
· Business Intelligence & Semantic Modeling (Power BI): Develop scalable Power BI datasets, write clean DAX measures, and build intuitive dashboards for Sales, Finance, and Executive leadership.
· AI & MCP Integration (Claude AI): Configure, test, and maintain Model Context Protocol (MCP) connectors (both Salesforce Hosted MCP and Azure/Synapse MCP endpoints) to enable secure natural-language querying in Claude Desktop/Enterprise.
· Data Security & Governance Execution: Implement IT leadership's security architecture by applying Salesforce permission models, Azure Synapse Row-Level Security (RLS), and Power BI access controls across BI and AI layers.
· Analytics & Workflow Automation: Build statistical forecasts, anomaly detection scripts, and automated reporting workflows in Python and SQL to turn historical CRM and financial data into actionable insights.
Qualifications
Required
· 3–5 years of hands-on experience in Business Intelligence, Data Engineering, or Applied Data Science.
· Solid proficiency in Azure Synapse Analytics (or Azure SQL / Microsoft Fabric), Azure Data Factory (ADF), T-SQL querying, and dimensional data modeling.
· Proven experience building Power BI semantic models, writing DAX measures, using Power Query (M), and configuring Row-Level Security (RLS).
· Working knowledge of Salesforce standard/custom objects, SOQL, API integrations, and user permission structures.
· Hands-on experience using or integrating generative AI tools—specifically Anthropic Claude (Claude Desktop/Enterprise, Claude API, tool use/function calling) or similar LLM platforms—in practical workflows.
Preferred
· Direct experience configuring or testing Model Context Protocol (MCP) servers for SQL databases, Azure, or Salesforce.
· Familiarity with financial PSA/ERP data models (e.g., Certinia / FinancialForce) and Microsoft Entra ID SSO/OAuth 2.0.
· Proficiency in Python (pandas, scikit-learn, PySpark) for predictive modeling and pipeline automation.
Working Conditions
Work is performed primarily in a standard office environment, with extended computer use and occasional work beyond standard hours during reporting, close, system implementation or acquisition cycles.
About SOLID
Founded in 1996 in Charlotte, North Carolina, SOLID Surface Care, Inc. is the nation's largest self-performing facility care company. SOLID provides science-based cleaning, disinfection, restoration and maintenance for hard and soft surfaces, with a commitment to environmentally conscious methods and a best-in-class client experience.
Equal Employment Opportunity
SOLID Surface Care, Inc. is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, veteran status or any other characteristic protected by law.
Disclaimer
This job description outlines the general nature and level of work performed and is not an exhaustive list of duties, responsibilities or qualifications. Duties may change based on business needs. This description does not constitute an employment contract.
