Benefits
Leyden Solutions offers a wide range of benefits, including competitive health and retirement plans, education assistance, paid time off, federal holidays, and programs that support you and your family!
Database Administrator Enterprise Data Engineer
Hybrid - US
Database Administrator Enterprise Data Engineer
Part Time • Hybrid - US
Benefits:
- 401(k)
- 401(k) matching
- Flexible schedule
Database Administrator (DBA) / Enterprise Data Engineer
Estimated Level of Effort: 75–80 hours per month
Position Summary
The South Carolina Department of Probation, Parole, and Pardon Services (SCDPPPS) supervises individuals placed on probation, parole, and other community-release programs. SCDPPPS relies on custom, mission-critical applications while modernizing its core Offender Management System (OMS).
The Database Administrator (DBA) / Enterprise Data Engineer supports the development, integration, security, modernization, and sustainment of these applications and their supporting data environments. The position designs and maintains enterprise data architecture; manages legacy-data migration and validation; enables reporting, telemetry, and analytics; and administers and optimizes databases supporting OMS, PIC, PAC, IIMS, SSO, and other assigned systems.
Reporting Relationship
Reports to the Program Manager, Chief Information Officer, Data Architect, or designated technical lead.
Key Responsibilities
Enterprise Data Architecture and Engineering
- 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.
Legacy Data Migration and Validation
- 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.
Business Intelligence, Reporting, and Telemetry
- 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.
Database Administration and Performance Management
- 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.
Required Qualifications
- 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.
Preferred Qualifications
- 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.
Work Schedule and Requirements
This is a part-time position requiring an estimated 75–80 hours per month. Duties may include recurring operational support, planned migrations, reporting releases, and response to database or data-pipeline issues.
Work may be remote, on-site, or hybrid, subject to program and customer requirements. The incumbent may access sensitive, proprietary, controlled, or government information and must comply with all applicable security, privacy, data-handling, background-screening, and customer-access requirements. Occasional work outside normal business hours may be required for maintenance, releases, migrations, or incident response.
Flexible work from home options available.
Compensation: $50.00 - $65.00 per hour
Our Story
Our Mission is to capture innovative thought, energy, and the talents of our team members, delivering intelligence services to America’s warfighters, civilians, and national security infrastructure. Leyden was created to accelerate the mission and business goals of our customers through unmatched expertise and a commitment to measurable results.
A Leyden jar is an antique electrical component which stores high-voltage electric charges. A precursor to the modern battery, Leyden jars were the first capacitors, As our namesake, we endeavor to capture and provide unique professionals offering creative solutions to corporate and national security challenges.
(if you already have a resume on Indeed)
Or apply here.
Bonuses
Performance and Longevity Bonuses!
Standard Referral Bonuses for all open positions!
Paid Time Off
26 days annual PTO and Holidays
Disability Insurance
100% employer paid short-term, long-term disability!
Health Insurance
50% employer paid health insurance. Dental & Vision Plans available.
Life Insurance
100% employer paid life Insurance!
Retirement
401(k) Plan with employer match on the first 5% of your salary! Pretax and Roth 401(k) available, along with a retirement planner.