Part-Time Enterprise Data Engineer & DBA (Remote)

Leyden Solutions, Inc.; Columbia (SC); Híbrido; USD 83.000 - 124.000; A tiempo parcial

Ventajas ofrecidas por este puesto de trabajo

401(k)

401(k) matching

Flexible schedule

Descripción de la vacante

The South Carolina Department of Probation, Parole, and Pardon Services (SCDPPPS) seeks a Database Administrator (DBA) / Enterprise Data Engineer to design, build, and sustain enterprise data platforms supporting OMS, PIC, PAC, IIMS, SSO, and related systems.

You will architect data warehouses or lakes, develop ETL/ELT pipelines, and ensure data quality, security, and accessibility for analytics and reporting.

Formación

• Bachelor's degree in computer science, information systems, data engineering, or related technical discipline.
• Experience in database administration, data engineering, data architecture, or related technical role.
• Experience designing or supporting enterprise data warehouses, data lakes, lakehouses, or comparable platforms.
• Experience developing ETL/ELT processes, data pipelines, transformations, and system integrations.
• Experience with legacy data migration, mapping, profiling, cleansing, reconciliation, validation, and remediation.
• Proficiency with SQL, relational database design, normalization, indexing, query optimization, backup and recovery, and performance tuning.
• Experience developing Power BI data models, datasets, dashboards, reports, and refresh pipelines.
• Knowledge of data quality, governance, metadata, lineage, security, and access-control principles.
• Ability to manage competing priorities and deliver reliable support within ~75–80 hours per month.

Responsabilidades

• Design, develop, and maintain an enterprise data warehouse, data lake, or comparable data platform.
• Define data models, schemas, metadata, integration patterns, storage approaches, and lifecycle-management practices.
• Establish standards for data ingestion, transformation, storage, access, retention, lineage, cataloging, quality, and security.
• Develop and maintain scalable ETL/ELT pipelines for batch, near-real-time, and real-time data processing.
• Design secure interfaces among enterprise applications, reporting platforms, analytics tools, and data repositories.

Conocimientos

SQL

Data modeling

Power BI

ETL/ELT

Data governance

Security controls

Cloud data platforms

Educación

Bachelor's degree in CS/IS/Data Eng

Herramientas

Azure

Azure Synapse

Power BI

Databricks

SQL Server

Descripción del empleo

The South Carolina Department of Probation, Parole, and Pardon Services (SCDPPPS) seeks a Database Administrator (DBA) / Enterprise Data Engineer to design, build, and sustain enterprise data platforms supporting OMS, PIC, PAC, IIMS, SSO, and related systems.

You will architect data warehouses or lakes, develop ETL/ELT pipelines, and ensure data quality, security, and accessibility for analytics and reporting.