Database Administrator Enterprise Data Engineer

Leyden Solutions, Inc. is hiring a Database Administrator / Enterprise Data Engineer to support the South Carolina Department of Probation, Parole, and Pardon Services. The role develops and maintains enterprise data platforms, migrates and validates legacy data, enables reporting and analytics, and administers databases supporting agency systems.

Responsibilities:

• Design, develop, and maintain an enterprise data warehouse, data lake, or comparable data platform supporting structured, semi-structured, and unstructured data
• 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, reliable interfaces among enterprise applications, reporting platforms, analytics tools, and data repositories
• Plan, execute, document, and support migration of legacy data to the enterprise data environment
• Assess source-system structures, data quality, business rules, integration dependencies, and technical constraints
• Develop data mappings, transformation rules, migration procedures, reconciliation methods, validation criteria, and rollback plans
• Migrate and validate data associated with OMS, PIC, PAC, IIMS, SSO, and other assigned applications
• Perform data profiling, cleansing, standardization, deduplication, reconciliation, and exception resolution to ensure data accuracy, completeness, consistency, and integrity
• Produce validation results, discrepancy logs, remediation recommendations, and migration-completion documentation
• Develop and maintain Power BI reporting pipelines, semantic models, datasets, dashboards, and reports
• Implement telemetry-based reporting to support visibility into application activity, system health, performance, and operational metrics
• Develop real-time and near-real-time ingestion workloads for reporting, monitoring, analytics, and decision support
• Optimize reporting data models, refresh processes, queries, and dashboards for performance, security, accuracy, and usability
• Work with stakeholders to define reporting requirements, key performance indicators, data definitions, and dashboard enhancements
• Perform database design, configuration, administration, maintenance, optimization, and operational support for assigned databases and data platforms
• Monitor database health, availability, capacity, storage, performance, query efficiency, replication, backups, and telemetry
• Resolve performance issues through indexing, query tuning, partitioning, caching, archiving, configuration improvements, and capacity planning
• Execute database-maintenance activities, including backup and recovery validation, integrity checks, statistics maintenance, patch coordination, and monitoring
• Implement and maintain database security controls, including role-based access control, least-privilege access, authentication, authorization, encryption, auditing, and logging

Requirements:

• Bachelor's degree in computer science, information systems, data engineering, software engineering, or a related technical discipline; equivalent experience, education, training, or certifications may be considered
• Experience in database administration, data engineering, data architecture, or a 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 an estimated commitment of 75–80 hours per month
• Experience with Microsoft Azure, Microsoft Fabric, Azure Synapse Analytics, Azure Data Factory, Databricks, AWS, Google Cloud Platform, or comparable cloud data platforms
• Experience implementing streaming, event-driven, telemetry, or real-time data-ingestion solutions
• Experience with data cataloging, master-data management, and data-governance tools
• Experience supporting public-sector, regulated, criminal-justice, or security-sensitive environments
• Familiarity with DevOps, DataOps, CI/CD, source control, automated testing, and infrastructure-as-code practices
• Relevant cloud, database, data-engineering, or Power BI certifications