Data Warehouse Architect

Job Summary: This is a senior-level data architecture role embedded within a customer portfolio organization, supporting large-scale modernization efforts, enterprise data initiatives, and AI-driven innovation. The position is responsible for designing and governing end-to-end data architectures across a hybrid cloud and on-premise environment, with a strong emphasis on lakehouse design, data product ownership, and cross-system integration. The ideal candidate brings deep expertise in modern data platforms, a collaborative mindset, and the ability to translate complex business and technical requirements into scalable, governed data solutions. This role operates at the intersection of strategy and execution, working closely with solution architects, data engineers, integration teams, governance stakeholders, and third-party vendors to deliver high-quality, reusable data products that support a Customer 360 vision and ongoing CIS modernization. Responsibilities: - Design and architect customer domain data products aligned with a Customer 360 framework - Define and standardize ingestion patterns across Salesforce, billing systems, and core operational platforms - Architect and govern data pipelines into a Databricks lakehouse environment hosted on AWS - Establish and enforce system of record and system of truth standards to minimize unnecessary data replication - Ensure data quality, lineage tracking, and governance compliance across all data flows - Assess and recommend data modeling approaches for both operational and analytical use cases, balancing storage efficiency with real-time access requirements - Provide architecture oversight and guidance for CIS modernization efforts, including data migration, conversion, and integration patterns - Collaborate with solution architects, data engineers, integration teams, and governance teams to deliver cohesive architectural solutions - Engage with internal business stakeholders and external third-party vendors to align on data architecture standards and integration approaches - Produce clear, well-structured architecture artifacts, diagrams, and documentation to support handoff to engineering teams - Evaluate and recommend technology options for data movement, access, visualization, and integration across hybrid cloud and SaaS environments Skills: - Deep expertise in AWS data architecture and native AWS data services - Hands-on experience with Databricks and lakehouse architecture design - Strong proficiency in data modeling for both operational and analytical domains - Experience designing and implementing data products within an enterprise data fabric or platform context - Knowledge of data integration patterns including ELT, change data capture, and streaming architectures - Familiarity with Salesforce and SAP data models and their integration into enterprise data ecosystems - Understanding of data governance frameworks, including lineage, quality management, and metadata standards - Experience working with hybrid cloud and on-premise database environments - Ability to produce high-quality architecture diagrams and technical documentation - Strong communication, collaboration, and architectural leadership skills - Self-motivated with a humble, team-oriented approach and a commitment to continuous learning - Experience working with third-party data connectors and integration platforms is a plus - Familiarity with AI-assisted architecture, AI agent creation, or AI skill building is a plus - Knowledge of SAP ISU or AWS Aurora is a plus Experience: - 8 to 12 or more years of progressive experience in data architecture, data engineering, or a closely related discipline - Demonstrated experience delivering enterprise-scale data architecture solutions in a modernization or transformation context - Proven track record of designing and governing data products in a cloud-based or hybrid environment - Experience collaborating across cross-functional teams including engineering, governance, and business stakeholders - Background working with or integrating SaaS platforms such as Salesforce or SAP in a data architecture capacity - Experience in the energy, utility, or communications industry is preferred but not required - History of stable, long-term engagement with employers or projects is strongly preferred Qualifications: - No specific degree or certification is required; commensurate professional experience is considered equivalent and is highly valued - AWS architecture or data-related certifications are considered a plus but are not mandatory This is a compelling opportunity to work at the forefront of enterprise data modernization within a large, established energy organization that is actively investing in cloud-native platforms, AI initiatives, and Customer 360 capabilities. The role offers meaningful technical challenges, a highly collaborative team culture, and the chance to shape data architecture standards that will influence the organization for years to come. With a strong likelihood of contract extension and exposure to cutting-edge technologies including Databricks, AWS, and emerging AI tooling, this position is well-suited for a seasoned data architect who is passionate about innovation, ownership, and making a measurable impact.