Post Job Free
Sign in

Principal SQL Developer

Company:
Macpower Digital Assets Edge
Location:
Washington, DC, 20022
Posted:
November 22, 2025
Apply

Description:

Job Summary:

Provide technical leadership to design, develop, optimize, and secure enterprise data platforms supporting analytics and critical business applications for a public sector healthcare finance environment.

Translate complex business and regulatory requirements into scalable, reliable, high-performance data solutions. Core responsibilities:

Lead end-to-end data architecture for relational and cloud platforms, including schema design, indexing strategies, and data integrity.

Own performance tuning for complex SQL queries, stored procedures, and database configurations in high-volume environments.

rchitect, build, and maintain ETL/ELT pipelines to integrate data from diverse sources into data warehouses and downstream stores.

Define and govern data modeling standards, design practices, tools, and development lifecycle processes.

Enforce database security, access controls, backup/recovery, and disaster recovery aligned to regulations (e.g., HIPAA, GDPR).

Proactively monitor databases, troubleshoot complex issues, and implement permanent fixes to minimize downtime.

Produce and maintain comprehensive documentation for architectures, pipelines, standards, and operational procedures.

Provide technical leadership, code reviews, and mentoring for SQL developers and data engineers.

Partner with senior leadership, application teams, data science, and business stakeholders to align data strategies and roadmaps.

Create implementation, testing, and integration plans for new platforms, features, and migrations.

Lead adoption of advanced data technologies and platforms to maximize IT investment and value. Required qualifications:

Bachelor's degree in IT, Computer Science, or related field, or equivalent experience.

6+ years leading advanced technology or service projects with full systems engineering lifecycle exposure.

6+ years creating implementation, integration, test plans, and training materials.

Deep expertise with major DBMS platforms (SQL Server, Oracle, PostgreSQL, MySQL) and advanced T-SQL/PL/SQL.

Strong experience delivering analytics platforms and enterprise apps using SQL, SSRS, SSIS, SSAS, Azure Data Factory, Databricks, Python, and DAX.

Hands-on data modeling (dimensional/star/snowflake), ETL tools (SSIS/Informatica), and cloud data platforms (Azure SQL, AWS RDS).

Solid knowledge of database architecture, high availability (clustering/replication), and capacity planning.

Senior-level understanding of healthcare management systems and experience engaging senior executives.

Excellent communication and documentation skills. Preferred qualifications:

Master's degree in CS, IT, data, or related field.

Certifications such as Microsoft Certified: Azure Database Administrator Associate.

Experience with Big Data technologies (Spark, Hadoop) and DevOps practices.

Apply