Apply on Employer Site

Chesapeake Utilities Corporation · 1 day ago

Data Architect

Newark, DE

Full-time

Hybrid

Senior Level, Lead/Staff

17+ years exp

Chesapeake Utilities Corporation is seeking a Data Architect to be a key member of the Chesapeake Analytics and AI team. This role involves creating enterprise and product/project level data architecture artifacts, facilitating data models, and recommending strategies through collaboration with various stakeholders.

EnergyRenewable Energy

Diversity & Inclusion

Responsibilities

Lead the architecture and design of cloud-based data architecture using Azure data platform solutions

Determine architecture solutions that meet performance, scalability, reliability and security needs

Lead multiple, large, highly complex efforts simultaneously, making key architecture and technology decisions

Support conceptual, logical, and physical data modeling efforts for strategic initiatives

Design and develop data warehouse database schemas, extract, transform, and load (ETL) mappings, procedures, and schedules

Coordinates activities with data source application owners to ensure integration and data integrity

Lead the build, test, and execution of data migration processes from legacy applications to SAP. Coordinate extraction, transformation and loading (ETL) activities from legacy systems to SAP

Assess data quality and recommend cleansing actions; oversee manual and automated cleansing tasks

Work closely with functional leads, business SMEs, and technical teams for source-to-target mapping. Partner with system owners to identify conversion sources and manage access to production-like environments

Design and develop reports dashboards, KPIs, and data extracts

Provide proactive technical oversight and mentorship to architecture and development teams fostering re-use, design for scale, stability, and operational efficiency based on strategic business initiatives

Research and evaluate emerging data management technologies for applicability and adoption

Build prototypes of learning solutions to show proof-of-concepts and develop scalable integrated enterprise services

Design, develop, implement, test intelligent application solutions in a Paas environment

Work with technical leadership to drive innovation and create best practices within the team

Present technical ideas and high-level concepts and solutions to internal and external team members

Collaborate and contribute to the company’s data mining architectures, modeling standards, reporting and data analysis methodologies

Contribute to a positive culture of continuous improvement and operational excellence by identifying and implementing process improvements where appropriate

Collaborate with cross-functional teams to understand the business problem, gather business requirements, supporting data and with/without guidance of leadership, help stakeholders/partners understand the business and scientific principles behind the process in order to gain their buy-in

Train/coach team members or peers and actively share expertise with peers

Qualification

Data ArchitectureAzure Data PlatformETL ProcessesData ModelingSAP IntegrationEvent-Driven MicroservicesAgile MethodologyMachine LearningTechnical OversightContinuous ImprovementTeam LeadershipCollaborationMentorship

Required

Bachelor of Science in Computer Science or related field

Seventeen (17) years' relevant work experience with at least three (3) years leading teams and/or projects

Strong programming skills including SQL

Ability to lead the architecture and design of cloud-based data architecture using Azure data platform solutions

Ability to determine architecture solutions that meet performance, scalability, reliability and security needs

Ability to lead multiple, large, highly complex efforts simultaneously, making key architecture and technology decisions

Ability to support conceptual, logical, and physical data modeling efforts for strategic initiatives

Ability to design and develop data warehouse database schemas, extract, transform, and load (ETL) mappings, procedures, and schedules

Ability to coordinate activities with data source application owners to ensure integration and data integrity

Ability to lead the build, test, and execution of data migration processes from legacy applications to SAP

Ability to assess data quality and recommend cleansing actions; oversee manual and automated cleansing tasks

Ability to work closely with functional leads, business SMEs, and technical teams for source-to-target mapping

Ability to design and develop reports dashboards, KPIs, and data extracts

Ability to provide proactive technical oversight and mentorship to architecture and development teams

Ability to research and evaluate emerging data management technologies for applicability and adoption

Ability to build prototypes of learning solutions to show proof-of-concepts and develop scalable integrated enterprise services

Ability to design, develop, implement, test intelligent application solutions in a Paas environment

Ability to collaborate and contribute to the company's data mining architectures, modeling standards, reporting and data analysis methodologies

Ability to contribute to a positive culture of continuous improvement and operational excellence

Ability to collaborate with cross-functional teams to understand the business problem and gather business requirements

Ability to train/coach team members or peers and actively share expertise with peers

Preferred

Master's degree

Experience in architecting a Medallion Architecture

Experience in Data & SAP Integration

Experience in utility industry data or similar complex environment

Experience in defining or building Event-Driven microservices architecture

Experience in Agile Methodology and/or Scrum

Experience in ArchiMate Modeling

Experience in Gen AI, Agentic AI, machine learning

TOGAF certification

Regular driver's license

Benefits

Flexible work arrangement

Fantastic opportunities for career growth

Cooperative, supportive and empowered team atmosphere

Annual bonus and salary increase opportunities

Monthly recognition events

Endless wellness initiatives and community events

Robust and customizable benefit packages-choose what works best with your life. Options include generous 401k, medical, dental and life insurance, tuition reimbursement, compensated volunteer hours and MORE!

Paid time off, holidays and a separate bank of sick time!