Senior SQL Developer & DB Architect

Akaasa Technologies; New York (NY); Hybrid; USD 100,000 - 150,000; Full time

Job summary

Con Edison Construction is seeking a senior SQL Developer / Database Architect / Data Engineer to design, develop, and optimize data solutions across the enterprise. The role spans database architecture, ETL/ELT, and governance to support critical applications and analytics.

Hybrid work model with collaboration across cross-functional teams. Responsibilities include tuning, data integration, documentation, and contributing to digital transformation programs.

Qualifications

• Bachelor's degree in Information Technology, Computer Science, or related field, or equivalent experience.
• 5–8 years of MS SQL Server development experience.
• Strong T-SQL programming and query optimization.
• Experience with ETL/ELT processes and enterprise data integrations.
• Experience with data ingestion, incremental loading, and data quality processes.
• Experience with enterprise data warehousing and dimensional modeling.
• Strong MS Office skills (Excel, Word, PowerPoint, Outlook).
• Experience with SQL Server performance tuning, indexing, and optimization.
• Excellent analytical and communication skills.
• Ability to present technical concepts to non-technical audiences.
• Methodical and organized problem-solving approach.

Responsibilities

• Develop, maintain, and optimize SQL Server objects (stored procedures, views, functions).
• Design, develop, and support ETL/ELT processes for enterprise data integration and transformation.
• Build and maintain data ingestion, incremental load, reconciliation, data validation, and data quality processes.
• Analyze, resolve, and provide end-to-end solutions for data, ETL, and database issues.
• Maintain database objects and scripts with version control (Azure DevOps, GitHub).
• Document technical procedures and runbooks; follow and improve standards.
• Take ownership and deliver assigned tasks within delivery schedules.
• Collaborate with business and technical teams across a cross-functional environment.
• Support release deployments, testing, and production implementations.
• Create and execute test plans (white-box/black-box).
• Other duties as assigned.

Skills

MS SQL Server

T-SQL

ETL/ELT

Data warehousing

Dimensional modeling

Query optimization

Performance tuning

Communication skills

Documentation

Problem solving

Education

Bachelor's degree in Information Technology/Computer Science or equivalent

Tools

Azure DevOps

GitHub

PowerShell

Job description

Con Edison Construction is seeking a senior SQL Developer / Database Architect / Data Engineer to design, develop, and optimize data solutions across the enterprise. The role spans database architecture, ETL/ELT, and governance to support critical applications and analytics.

Hybrid work model with collaboration across cross-functional teams. Responsibilities include tuning, data integration, documentation, and contributing to digital transformation programs.