TELECOMMUTE Lead Business Intelligence & Data Integration Analyst

· Lead enterprise BI and data integration initiatives across Salesforce, ERP, MDM, data warehouse, Power BI, Fabric, and other analytics platforms.

· Serve as a technical lead for Salesforce Life Science Cloud, CRM Analytics, and downstream BI integration work.

· Design, develop, and maintain data models, semantic models, dataflows, and curated datasets that support enterprise reporting and analytics.

· Partner with business stakeholders to gather, document, and translate requirements into actionable technical specifications.

· Write, troubleshoot, and optimize complex SQL queries, stored procedures, views, and data transformation logic.

· Support ETL processes, job dependencies, pipeline monitoring, and production issue resolution across business-critical reporting systems.

· Provide SME support for sales reporting, geography alignment, service contracts, customer data, and other core commercial reporting domains.

· Support MDM and Syniti-related data initiatives, including data validation, mapping logic, integration planning, and governance alignment.

· Assist with Microsoft Fabric and Power BI modernization efforts, including migration of legacy datasets, cubes, reports, and data marts.

· Partner with data engineering and application teams to ensure data is accurate, reliable, scalable, and aligned with business requirements.

· Troubleshoot reporting, cube, data warehouse, Insight, DSR, and integration-related issues and coordinate resolution with technical teams.

· Support SQL Server performance tuning efforts, including investigation of high-cost workloads, batch jobs, and long-running queries.

· Guide BI developers and analysts on data structures, joins, business logic, and reporting best practices.

· Support ServiceNow intake, evaluation, prioritization, and assignment for BI and data-related requests as needed.

· Assist with UAT, documentation, end-user support, and post-deployment enhancements.

· Stay current with BI, data integration, cloud analytics, and Microsoft Fabric/Power BI best practices.

· 7+ years of experience in Business Intelligence, data warehouse, reporting, analytics, or data integration roles.

· Strong SQL Server experience, including complex query development, troubleshooting, and performance optimization.

· Experience designing and supporting enterprise reporting datasets, semantic models, dashboards, and analytics solutions.

· Experience working with ETL processes, dataflows, data marts, cubes, or data warehouse environments.

· Strong understanding of data quality, validation, reconciliation, and business-rule documentation.

· Ability to work directly with business stakeholders to gather requirements and translate them into technical solutions.

· Strong analytical, troubleshooting, and problem-solving skills.

· Ability to work independently and manage multiple priorities across projects and support activities.

· Experience with Microsoft Fabric, Power BI, Azure, or modern cloud-based analytics platforms.

· Experience with Salesforce, CRM Analytics, Life Science Cloud, or other CRM/ERP integration work.

· Experience with MDM platforms or customer master data processes, including Syniti or similar tools.

· Experience with Informatica, Azure Data Factory, SSIS, or similar ETL/integration technologies.

· Experience supporting legacy reporting environments, cubes, SSRS, Power BI, and migration/modernization efforts.

· Exposure to SQL Server tuning, batch job optimization, Control-M, or production reporting support.

· Experience leading cross-functional projects involving business, IT, external vendors, and data engineering teams.

· Ability to mentor BI developers, analysts, and technical resources.