Database Warehouse Analyst II

🕒 July 24

🦌 Connecticut – Remote

🦌 Connecticut – Remote

⏰ Full Time

🟠 Senior

🔴 Lead

🧐 Analyst

Apply Now

Find Similar Remote Jobs

Set Up Email Alert For New Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

Legrand

WebsiteLinkedInAll Job Openings

10,000+ employees

🏭 Manufacturing

🔧 Hardware

🤝 B2B

Manufacturing • Hardware • B2B

Legrand is a French multinational and world leader in electrical and digital building installations and solutions. It designs, manufactures and sells a broad range of products for residential, commercial and industrial buildings — including switches and sockets, cable-management systems, access control, UPS and datacenter power and infrastructure — and provides bundled offers for datacenters and energy-transition applications. The group emphasizes design, sustainability/CSR, targeted acquisitions and digital solutions; it employs around 39,600 people and reported nearly €9. 5 billion in sales in 2025.

📋 Description

• 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. • 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. • 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. • 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. • 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.

🎯 Requirements

• 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. • 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. • 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

🏖️ Benefits

• comprehensive medical, dental, and vision coverage • high employer 401K match • paid time off (PTO) and holiday pay • short-term and long-term disability benefit plans • above-benchmark paid maternity and parental leave • bonus opportunities in accordance with the Company’s incentive plans • paid time off to volunteer • active/growing Employee Resource Group network