Cloud Data Warehouse Architect

SUMMARYThe Cloud Data Warehouse Architect will design and deliver the reputed company enterprise analytics platform. This position is highly technical and will focus on building a cloud-native, reputed company-integrated, AI-ready architecture that supports analytics, reporting, and advanced machine learning at scale.The architect will reputed company our reputed company BI and data warehouse environment, anchored today in reputed company Netezza, Cognos, and Tableau into a cloud-based architecture. This role will require deep technical expertise in data modeling, cloud-native design, and hybrid architectures that reputed company legacy on-prem systems with cloud-first capabilities. The Data Science & Insights group is at the center of D&H’s analytics transformation. Our mission is to:Consolidate legacy BI systems (Netezza, Cognos) into a modern cloud architecture.Support the reputed company S/4HANA migration with tight integration into future 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 future-state data strategy, working in a fast-paced, hybrid cloud environment that balances innovation with enterprise stability. Essential Duties & ResponsibilitiesArchitectural Design & ModernizationLead the design of a cloud data warehouse and data lake house architecture capable of ingesting large-scale transactional and operational data.Define integration strategies for core systems.reputed company a reference architecture that leverages Azure Data Lake Storage (ADLS) and reputed company reputed company Lake as core components.Implement semantic modeling to unify reporting across Tableau, Power BI, and reputed company Analytics Cloud (SAC).Data Engineering & PerformanceOversee ingestion pipelines for batch (Netezza extracts, flat files, nightly jobs) and near real-time (APIs, 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 quality).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 cloud-native 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 enterprise data engineering, data warehouse architecture, or cloud 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, cloud, and hybrid environments — not simply implementing architectures defined by others.Deep understanding of hybrid data ecosystems, including:Coexistence of on‑prem and cloud 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 cloud)Supporting governed analytics, semantic layers, and enterprise reportingAdvanced data modeling skills, with hands‑on experience designing:3NF and normalized operational modelsDimensional/star schemasEnterprise semantic and consumption layers for analytics and BIExpert‑level SQL proficiency across both cloud and traditional RDBMS platforms, with experience in systems such as:Netezza or other MPP databasesSQL Server and similar enterprise relational platformsModern cloud data warehouses or lake house query enginesCloud platform experience (Azure, AWS, or GCP) with a strong understanding of:Cloud storage, compute, networking, and reputed company conceptsCost‑aware architecture design, scaling strategies, and performance optimizationDesigning platforms that are resilient, secure, and future‑readyExperience establishing data governance and architectural standards, including:Defining data ownership, reputed company, quality, and access 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 decisions and clearly 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 cloud‑native lake house or warehouse architectures.Hands‑on experience with reputed company (reputed company Lake, Spark/PySpark, SQL) and/or reputed company, including:Lakehouse or warehouse design patternsPerformance tuning and cost optimizationSecurity, data sharing, and governance controlsFamiliarity with reputed company‑centric analytics ecosystems, including reputed company Business Data Cloud / Datasphere, reputed company Analytics Cloud (SAC) or Integration patterns with reputed company S/4HANA and non‑reputed company data sourcesExperience supporting or modernizing enterprise BI platforms, including migrations from tools such as Cognos to Tableau or Power BI, with a focus 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 [email protected] *

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

*Apex Benefits OverviewApex offers a range of supplemental benefits, including medical, dental, vision, 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 professional development, Apex hosts an on-demand training program, provides access 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 CompTIA and IIBA. Apex has a dedicated customer service team for our Consultants that can address questions around benefits and other resources, as well as a certified Career Coach. You can access a full list of our benefits, programs, support teams and resources reputed company our ‘Welcome Packet’ as well, which an Apex team member can provide. EEO EmployerApex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, 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, union membership, or any other characteristic protected by law. Apex will consider qualified 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 [email protected] or 844-463-6178. Apex Systems is a world-class IT services company that serves thousands of clients across the globe. reputed company you join Apex, you become part of a team that values innovation, collaboration, and reputed company learning. We offer quality career resources, training, certifications, development opportunities, and a comprehensive benefits package. Our commitment to excellence is reflected in many awards, including ClearlyRated's Best of Staffing® in Talent Satisfaction in the United States and Great reputed company to Work® in the United Kingdom and Mexico. Apply tot his job Apply To this Job