SQL Server Database Architect, JR. - Onsite NYC at Randstad Digital New York, NY

Randstad Digital

New York (NY)

On-site

USD 87,000 - 90,000

Part time

6 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

The SQL Developer / Database Architect / Data Engineer at Con Edison Construction in New York is a senior technical role responsible for design, ETL/ELT, administration, optimization, integration, and governance of the organization’s data to support critical applications and digital initiatives.

You will develop and optimize SQL Server procedures, design ETL/ELT processes, manage data ingestion and quality, document procedures, and collaborate with cross‑functional teams to deliver reliable data

Qualifications

  • 5–8 years of MS SQL Server development experience.
  • Strong T-SQL and query optimization skills.
  • Experience with ETL/ELT and enterprise data integrations.
  • Experience with data ingestion, validation, and quality processes.
  • Knowledge of enterprise data warehousing and dimensional modeling.
  • Excellent communication and teamwork abilities.
  • Bachelor's degree in IT, CS, or related field.

Responsibilities

  • Develop, maintain, and optimize SQL Server procedures, views, and functions.
  • Design and support ETL/ELT processes for enterprise data integration.
  • Lead data ingestion, incremental load, validation, and quality processes.
  • Document deployments, runbooks, and technical specs.
  • Assist with query tuning, performance optimization, and schema refinement.
  • Provide DBA support, security, backups, and maintenance.

Skills

MS SQL Server
T-SQL
ETL/ELT
Data warehousing
Data governance
Problem solving
Communication skills

Education

Bachelor's degree

Tools

Azure DevOps
GitHub
PowerShell
SQL Server

Job description

job summary:

The SQL Developer / Database Architect / Data Engineer is a senior technical role responsible for the design, ETL/ELT, administration, optimization, integration, and governance of the Con Edison Construction organization data. This hybrid position combines database architecture, and data engineering functions to support critical business applications, analytics, initiatives, and digital transformation programs.

What You Will Be Doing

Develop, maintain, and optimize SQL Server stored procedures, views, functions, and advanced T-SQL solutions. 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. Independently analyze, solve, and correct data, ETL, and database-related issues, providing end-to-end problem resolution. Maintain database objects, schema changes, and scripts using version control systems such as Azure DevOps and GitHub. Follow established team standards. For any gap, recommend new or updated standards and proactively identify areas for improvement. Document and update technical documentation, operational procedures, and support runbooks when appropriate. Take ownership, support, and follow-through of assigned deliverables, adjusting well to changes in priority. Demonstrate a willingness and commitment to learn Con Edison's policies, procedure and standards. Develop accurate estimates of effort and timelines. Ensure that all assignments are completed accurately and within approved delivery schedules. Assist with query tuning, performance optimization, and schema refinement. Assist with SQL Server database administration activities, including monitoring, maintenance, security, backup verification, and troubleshooting. Serve as a backup resource for database administration support during planned absences, vacations, and off-hours support rotations. Work closely and effectively with business and technical teams in a cross-functional and cross-matrixed business and technical environment. Support release deployment activities, testing, and production implementations as required. Create, document, and execute test plans, including white-box testing, black-box testing, positive and negative testing. Other duties may be assigned, directed, or requested.

What You Will Need

Bachelor's degree (Information Technology, Computer Science, or related field) or equivalent experience is required. Five (5) to eight (8) years of MS SQL Server development experience is required. Strong T-SQL programming experience, including complex queries, joins, views, stored procedures, functions, and query optimization are required. Strong experience developing and supporting ETL/ELT processes and enterprise data integrations is required. Experience with data ingestion, incremental loading, data validation, and data quality processes is required. Experience with enterprise data warehousing and dimensional modeling is required. Strong to advanced experience in Microsoft Excel, Word, PowerPoint, and Outlook is required. Experience with SQL Server performance tuning, indexes, index management, and optimization is required[SC1] Experience with PowerShell scripting and automation is a plus Experience with SQL Server administration, security, backup/recovery, and maintenance is a plus Excellent analytical, critical-thinking, and problem-solving skills, with the ability to anticipate and proactively address issues, required. Must have excellent communication skills, both written and verbal. Ability to effectively present technical concepts and information to non-technical audiences. Ability to prepare concise yet sufficiently detailed written communications, including documentation, deployment plans, status reports, and meeting notes, for both technical and non-technical audiences.[SC2] A methodical and organized approach to problem-solving.

location: New York, New York

job type: Contract

salary: $63 - 65 per hour

work hours: 9am to 6pm

education: Bachelors

responsibilities:

The SQL Developer / Database Architect / Data Engineer is a senior technical role responsible for the design, ETL/ELT, administration, optimization, integration, and governance of the Con Edison Construction organization data. This hybrid position combines database architecture, and data engineering functions to support critical business applications, analytics, initiatives, and digital transformation programs. What You Will Be Doing Develop, maintain, and optimize SQL Server stored procedures, views, functions, and advanced T-SQL solutions. 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. Independently analyze, solve, and correct data, ETL, and database-related issues, providing end-to-end problem resolution. Maintain database objects, schema changes, and scripts using version control systems such as Azure DevOps and GitHub. Follow established team standards. For any gap, recommend new or updated standards and proactively identify areas for improvement. Document and update technical documentation, operational procedures, and support runbooks when appropriate. Take ownership, support, and follow-through of assigned deliverables, adjusting well to changes in priority. Demonstrate a willingness and commitment to learn Con Edison's policies, procedure and standards. Develop accurate estimates of effort and timelines. Ensure that all assignments are completed accurately and within approved delivery schedules. Assist with query tuning, performance optimization, and schema refinement. Assist with SQL Server database administration activities, including monitoring, maintenance, security, backup verification, and troubleshooting. Serve as a backup resource for database administration support during planned absences, vacations, and off-hours support rotations. Work closely and effectively with business and technical teams in a cross-functional and cross-matrixed business and technical environment. Support release deployment activities, testing, and production implementations as required. Create, document, and execute test plans, including white-box testing, black-box testing, positive and negative testing. Other duties may be assigned, directed, or requested. What You Will Need Bachelor's degree (Information Technology, Computer Science, or related field) or equivalent experience is required. Five (5) to eight (8) years of MS SQL Server development experience is required. Strong T-SQL programming experience, including complex queries, joins, views, stored procedures, functions, and query optimization are required. Strong experience developing and supporting ETL/ELT processes and enterprise data integrations is required. Experience with data ingestion, incremental loading, data validation, and data quality processes is required. Experience with enterprise data warehousing and dimensional modeling is required. Strong to advanced experience in Microsoft Excel, Word, PowerPoint, and Outlook is required. Experience with SQL Server performance tuning, indexes, index management, and optimization is required Experience with PowerShell scripting and automation is a plus Experience with SQL Server administration, security, backup/recovery, and maintenance is a plus Excellent analytical, critical-thinking, and problem-solving skills, with the ability to anticipate and proactively address issues, required. Must have excellent communication skills, both written and verbal. Ability to effectively present technical concepts and information to non-technical audiences. Ability to prepare concise yet sufficiently detailed written communications, including documentation, deployment plans, status reports, and meeting notes, for both technical and non-technical audiences.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

SQL Server Integration Engineer - Hybrid NYC
SQL Server Integration Engineer - Hybrid NYC

Randstad Digital • New York (NY)

On-site
USD 90,000 - 96,000
Medical insurance
Prescription
Dental
+5
Senior SQL Data Architect & ETL Engineer
Senior SQL Data Architect & ETL Engineer

Randstad Digital • New York (NY)

On-site
USD 87,000 - 90,000
Senior Database Architect & Data Platform Engineer
Senior Database Architect & Data Platform Engineer

Compunnel Inc. • New York (NY)

On-site
USD 140,000 - 190,000
Senior SQL Developer & Data Engineer – ETL/ELT, SQL Server & BI
Senior SQL Developer & Data Engineer – ETL/ELT, SQL Server & BI

Seneca Resources • New York (NY)

Hybrid
USD 76,000 - 90,000
Hybrid schedule (3 onsite / 2 remote)
Competitive pay: $55–$65/hr W2
Long‑term contract potential
Senior SQL Server DBA
Senior SQL Server DBA

Aegistech • New Jersey

Hybrid
USD 120,000 - 170,000
SQL Server Developer / Data Engineer
SQL Server Developer / Data Engineer

ZealHire Inc. • Villa Park (IL)

Hybrid
USD 110,000 - 150,000
Software Engineer - 302913
Software Engineer - 302913

DNI (Delaware Nation Industries) • Aiken (SC)

On-site
USD 80,000 - 100,000
Covers 100% of employee benefit premiums
Matching 401K
Short- and Long-Term Disability
+3
SQL developer
SQL developer

Dellfor Technologies • Newark (NJ)

On-site
USD 54,000 - 66,000
Referral bonus
On the job support
Travel allowance
+2
SQL developer
SQL developer

Dellfor Technologies • Honolulu (HI)

On-site
USD 54,000 - 66,000
Starting salary with regular increments
Referral bonus
Travel allowance
+2
M - 7/24 - 804326 - Sr SQL Developer - Richmond, VA (Hybrid - Local to Richmond candidates only)
M - 7/24 - 804326 - Sr SQL Developer - Richmond, VA (Hybrid - Local to Richmond candidates only)

Focused HR Solutions, LLC • Richmond (VA)

Hybrid
USD 120,000 - 150,000