Apply on Employer Site

Chesapeake Utilities Corporation · 9 hours ago

Data Architect

Newark, DE

Full-time

Hybrid

Senior Level, Lead/Staff

17+ years exp

Chesapeake Utilities Corporation is seeking a Data Architect to join their Analytics and AI team. The role involves creating enterprise and product/project level data architecture artifacts, facilitating the development of data models and governance strategies, and integrating data from various applications into data warehouses.

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

Azure data platformData modelingETL processesData governanceSAP integrationEvent-Driven architectureAgile methodologyMachine learningTOGAF certificationArchiMate modelingSoft skills

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

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

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

Design and develop reports dashboards, KPIs, and data extracts

Provide proactive technical oversight and mentorship to architecture and development teams

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

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

Regular driver's license

Preferred

Master's degree preferred

Preferred Experience in the following: Architecting a Medallion Architecture

Data & SAP Integration

Utility industry data or similar complex environment

Defining or building Event-Driven microservices architecture

Agile Methodology and/or Scrum

ArchiMate Modeling

Gen AI, Agentic AI, machine learning

TOGAF certification

Benefits

Flexible work arrangement

Competitive base salary

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!