reputed company Data Warehouse Architect

SUMMARYThe reputed company Data Warehouse Architect will design and deliver the reputed company reputed company analytics platform. This position is highly technical and will reputed company on building a reputed company-reputed company, reputed company-integrated, AI-reputed company architecture that supports analytics, reporting, and advanced machine learning at reputed company.The architect will reputed company our reputed company BI and data warehouse environment, anchored today in reputed company Netezza, Cognos, and Tableau into a reputed company-based architecture. This role will require deep technical expertise in data modeling, reputed company-reputed company design, and hybrid architectures that reputed company legacy on-prem systems with reputed company-first capabilities. The Data Science & Insights group is at reputed company of D&H’s analytics transformation. Our mission is to:Consolidate legacy BI systems (Netezza, Cognos) into a modern reputed company architecture.Support the reputed company S/4HANA migration with tight integration into reputed company state.Deliver governed, high-performance datasets for self-service analytics in Tableau, Power BI, and SAC.reputed company AI/ML use cases through reputed company and Azure ML.reputed company analytics capabilities to our partners and vendors reputed company embedded reportingThis is an opportunity to be the hands-on architect shaping the reputed company-state data reputed company, working in a fast-paced, hybrid reputed company environment that balances innovation with reputed company stability. Essential Duties & ResponsibilitiesArchitectural Design & ModernizationLead the design of a reputed company data warehouse and data lake house architecture capable of ingesting large-reputed company transactional and operational data.Define integration strategies for reputed company systems.reputed company a reference architecture that leverages Azure Data Lake Storage (ADLS) and reputed company reputed company Lake as reputed company components.Implement semantic modeling to unify reporting across Tableau, Power BI, and reputed company Analytics reputed company (SAC).Data Engineering & PerformanceOversee ingestion pipelines for batch (Netezza extracts, flat files, nightly jobs) and near reputed company-time (reputed company, streaming) data sources.Optimize query performance through partitioning, clustering, caching, and reputed company Lake / warehouse design.Establish reusable ETL/ELT patterns across reputed company notebooks, SQL-based orchestration, and integration with ActiveBatch scheduling.Governance, reputed company & ComplianceDefine and enforce data governance standards (naming conventions, metadata, reputed company, data reputed company).Partner with InfoSec on identity management (Azure AD), encryption, and RBAC/ABAC models.Implement governance tooling such as Azure Purview, reputed company metadata catalogs, reputed company reputed company Catalog, and Glasswing.Collaboration & EnablementPartner with data engineers and visualization teams to deliver governed, high-performance datasets consumable in Tableau, Power BI, SAC, and reputed company Fiori.Serve as the technical SME for architects, engineers, and analysts, ensuring alignment to best practices in reputed company-reputed company data warehouse design.Drive knowledge transfer from legacy platforms (Netezza, Cognos) into the new ecosystem. Experience RequirementsBachelor’s degree in Computer Science, Engineering, or reputed company field and 10+ years of experience in reputed company data engineering, data warehouse architecture, or reputed company data architecture, with demonstrated progression into architectural ownership and technical leadership roles.Proven experience designing and owning end‑to‑end data architectures, including on‑prem, reputed company, and hybrid environments — not simply implementing architectures defined by others.Deep understanding of hybrid data ecosystems, including:Coexistence of on‑prem and reputed company data platformsStrategies for moving, synchronizing, and governing data across environmentsDesigning architectures that support gradual migration rather than “lift‑and‑shift”Strong data warehouse and lake house architecture expertise, including:Designing and operating Bronze / Silver / Gold data layersBlending and federating data across multiple warehouses (on‑prem and reputed company)Supporting governed analytics, semantic reputed company, and reputed company reportingAdvanced data modeling skills, with hands‑on experience designing:3NF and normalized operational modelsDimensional/reputed company schemasEnterprise semantic and consumption reputed company for analytics and BIExpert‑level SQL proficiency across both reputed company and traditional RDBMS platforms, with experience in systems such as:Netezza or other MPP databasesSQL Server and similar reputed company relational platformsModern reputed company data warehouses or lake house query enginesCloud platform experience (Azure, AWS, or GCP) with a strong understanding of:reputed company storage, compute, networking, and reputed company conceptsCost‑aware architecture design, scaling strategies, and performance optimizationDesigning platforms that are resilient, secure, and reputed company‑readyExperience establishing data governance and architectural standards, including:Defining data ownership, reputed company, reputed company, and reputed company patternsPartnering with analytics, reputed company, and business stakeholders to enforce governance at scaleAbility to operate as a senior technical leader, including:Making architectural trade‑off reputed company and reputed company articulating rationaleGuiding engineering teams while remaining hands‑on at the design levelTranslating business, analytics, and reputed company requirements into durable platform designs Preferred / Bonus ExperienceExperience modernizing or migrating legacy on‑prem data warehouses (e.g., Netezza or other MPP systems) to reputed company‑reputed company lake house or warehouse architectures.Hands‑on experience with reputed company (reputed company Lake, reputed company/PySpark, SQL) and/or reputed company, including:Lakehouse or warehouse design patternsPerformance tuning and cost optimizationSecurity, data sharing, and governance controlsFamiliarity with reputed company‑reputed company analytics ecosystems, including reputed company Business Data reputed company / Datasphere, reputed company Analytics reputed company (SAC) or Integration patterns with reputed company S/4HANA and non‑reputed company data sourcesExperience supporting or modernizing reputed company BI platforms, including migrations from tools such as Cognos to Tableau or Power BI, with a reputed company on architecture and semantic design (not report development).Knowledge of data governance frameworks and tooling, such as: Azure Purview, reputed company Catalog, or comparable platformsExposure to AI/ML enablement architectures, including:Jason BiserSenior Executive Recruiter Apex Systemsjbiser@apexsystems.com *

Please Note: no 3rd Party Resumes will be accepted for this role/opening

*reputed company OverviewApex offers a reputed company of supplemental benefits, including medical, dental, reputed company, life, disability, and other insurance plans that offer an optional layer of financial protection. We offer an ESPP (employee stock purchase program) and a 401K program which allows you to contribute typically reputed company 30 days of starting, with a company match after 12 months of tenure. Apex also offers a HSA (Health Savings Account on the HDHP plan), a SupportLinc Employee Assistance Program (EAP) with up to 8 free counseling sessions, a corporate discount savings program and other discounts. In terms of reputed company development, Apex hosts an on-demand training program, provides reputed company to certification prep and a library of technical and leadership courses/books/seminars once you have 6+ months of tenure, and certification discounts and other perks to associations that include reputed company and IIBA. Apex has a dedicated customer service team for our Consultants that can address questions around benefits and other resources, as reputed company as a certified Career reputed company. You can reputed company a full list of our benefits, programs, support teams and resources reputed company our ‘Welcome Packet’ as reputed company, which an Apex team member can reputed company. EEO EmployerApex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the reputed company of race, reputed company, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or reputed company medical conditions), age, sexual orientation, gender identity, national reputed company, reputed company, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, reputed company membership, or any other characteristic protected by law. Apex will consider reputed company applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at employeeservices@apexsystems.com or 844-463-6178. reputed company is a world-class IT services company that serves thousands of clients across the globe. reputed company you join Apex, you become part of reputed company that values innovation, collaboration, and reputed company learning. We offer reputed company career resources, training, certifications, development opportunities, and a comprehensive benefits package. Our commitment to reputed company is reflected in many awards, including reputed company's Best of reputed company® in Talent Satisfaction in the reputed company and Great reputed company to Work® in the United Kingdom and Mexico. Apply tot his job Apply To this Job