Quick overview
Job description
At a Glance
Legrand has an exciting opportunity for a Data and Analytics Technical Lead to join the Data Center Power and Control Division Team. This is a remote position. The Data and Analytics Technical Lead will drive the design, development, and maintenance of our enterprise data warehouse solutions. The ideal candidate will have deep expertise in SAP BW/4HANA, SAP Data Sphere, Power BI reporting, and data integrations with Salesforce and SQL Server environments, strong data modeling skills, and the ability to work closely with business stakeholders and offshore teams to deliver scalable reporting and analytics solutions. This role will also lead the migration from legacy SAP BW to SAP Datasphere and drive adoption of Microsoft Fabric, Azure Synapse, and Microsoft AI/Copilot capabilities within the analytics ecosystem.
What Will You Do?
Technical Leadership & Architecture:
- Lead the design and development of SAP BW and Data Sphere data models, data flows, transformations, and queries.
- Architect and maintain BW data models (InfoProviders, ADSOs, Composite Providers, Open ODS views, etc.).
- Ensure optimal performance of data loads and reporting by following SAP best practices.
- Guide integration between SAP BW and external systems such as Salesforce, SQL Server, Power BI, or other data lakes/warehouses.
Platform Migration & Modernization:
- Lead the end-to-end migration from legacy SAP BW/BW4HANA to SAP Datasphere, including assessment, data model conversion, delta migration, and cutover planning.
- Architect hybrid data flows connecting SAP Datasphere with Microsoft Fabric and Azure Synapse Analytics to enable unified analytics across SAP and non-SAP data domains.
- Integrate Microsoft Copilot, Azure OpenAI, and AI Builder capabilities into reporting and analytics workflows to deliver intelligent, AI-augmented insights to business users.
- Define and enforce data migration standards, validation frameworks, and reconciliation processes to ensure data integrity during and after platform transitions.
Project Delivery:
- Manage BW-related deliverables across multiple projects from requirements through implementation.
- Define technical solutions in collaboration with functional teams and enterprise architects.
- Conduct code reviews and enforce technical standards and best practices.
Stakeholder Engagement:
- Interact with business users to gather reporting and analytics requirements.
- Translate business requirements into technical solutions within SAP BW.
- Present prototypes and final deliverables to business and IT stakeholders.
Team Collaboration:
- Lead and mentor offshore development teams; assign tasks and review deliverables.
- Ensure timely execution and quality assurance of all development activities.
- Serve as the escalation point for BW-related issues and performance challenges.
Required Skills
- 7+ years of experience in: BW/4HANA
- Strong expertise in:
- InfoObjects, ADSOs, CompositeProviders, Open ODS Views, Transformations, DTPs, Process Chains
- Query Designer / BW Queries / Analysis for Office
- Proficient in ABAP for BW for custom logic, routines, and enhancements.
- Experience integrating BW with SAP ECC, S/4HANA, Salesforce, and external databases (SQL Server, etc.).
- Strong knowledge of data warehousing concepts and data modeling.
- Experience with Power BI or other frontend tools connected to BW is a plus.
- Strong analytical, debugging, and performance tuning skills.
- Hands-on experience with SAP Datasphere or demonstrated experience migrating from SAP BW/BW4HANA to a modern SAP data platform.
- Working knowledge of Microsoft Fabric, Azure Synapse Analytics, and Azure Data Factory for hybrid data warehouse and lakehouse architectures.
- Familiarity with Microsoft Copilot for Power BI, Azure OpenAI Service, and AI Builder to embed AI-driven analytics and natural language querying into business reporting.
Preferred Qualifications
- Exposure to Azure, SAP Datasphere, or cloud integration scenarios.
- Experience with SAP BW-to-Datasphere migration tools and methodologies, including the use of SAP’s migration cockpit and data migration objects.
- Familiarity with Microsoft Purview for data governance and lineage across SAP and Microsoft platforms.
- Understanding of generative AI and large language model (LLM) use cases applied to enterprise analytics, including natural language querying, automated insight generation, and AI-assisted data preparation.
Skills/Knowledge
- Excellent communication and interpersonal skills
- Strong leadership and mentoring capabilities
- Ability to manage multiple priorities in a fast-paced environment
- Proactive problem-solver with strong attention to detail
Similar jobs
- OR

Senior Data Migration Architect - Oracle Health
Oracle · United States · Hybrid 🇺🇸
Stakeholder ManagementOracleSQL+9Salary not listed4 months ago - OR

MySQL Architect, Community & Ecosystem
Oracle · Nashville · Hybrid 🇺🇸
MySQLOracleSpring+9Salary not listed5 months ago - OR

Manager, Data Architecture - Oracle Health
Oracle · United States · Hybrid 🇺🇸
OnboardingOracleMicrosoft Excel+5TechnologySalary not listed6 weeks ago - OR

Senior Oracle Health Principal Data Migration Architect
Oracle · United States · Hybrid 🇺🇸
Stakeholder ManagementOracleSQL+14Salary not listed4 days ago - AS
Data & Analytics Data ArchitectNew
A.O. Smith · Nashville, Tennessee · Hybrid 🇺🇸
ETLTechnologySalary not listed3 hours ago - SA
Oracle Database Architect
SAIC · Flexwork · Remote 🇺🇸
OraclePL/SQLSQL+10Salary not listed3 weeks ago - IN
Database Architect - InteleShare Auto Apply
Intelerad · Remote · Hybrid 🇺🇸
GCPMongoDBOracle+13Technology$116.3k - $155k/yr5 days ago - LT

Jr. Data Architect/EngineerNew
Ledgent Technology · Plano, TX · Hybrid 🇺🇸
OracleSQLMicrosoft Excel+17TechnologySalary not listedYesterday - WO

Senior Business Intelligence Architect Auto Apply
Woodardcurran · Virtual · Remote 🇺🇸
SQLGitERP+7Technology$115k - $175k/yr1 week ago - WA
Senior IT Data Architect - #3003 Auto Apply
Wadetrim · Taylor · Hybrid 🇺🇸
SQLDiversity & InclusionTechnologySalary not listed2 months ago - VE

Senior Director, Enterprise Data Management Auto Apply
Versapay · United States (Remote) · Remote 🇺🇸
Technology$180k - $220k/yr6 weeks ago - VE
Global Network MDM Strategy Lead Auto Apply
Veeva · Massachusetts - Boston · Remote 🇺🇸
Customer SuccessSalary not listed7 months ago