Macpower Digital Assets Edge Private Limited Principal SQL Developer in Washington, DC | 1310101419

Verified Pay check_circle	$152000 - $163000 per year
Hours	Full-time
Location	Washington, DC 20001 Washington, District of Columbia open_in_new

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.
Architect, 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.

Principal SQL Developer