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.
- 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.
qualifications:
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.
skills:
backup,black-box testing,data ingestion,data validation,complex queries,Database,dimensional modeling,ETL,GitHub,Information Technology,Computer Science,Azure DevOps,Microsoft Excel,Outlook,PowerPoint,SQL Server,MS SQL Server,SQL Server performance,Word,performance optimization,query tuning,query optimization,SQL,SQL Server administration,stored procedures,version control systems,SQL Server database administration,T-SQL,white-box testing,PowerShell scripting,analytical,written communications,critical-thinking,organized approach,problem resolution,problem-solving skills,problem-solving,methodical,Independently,proactively,automation,data quality,database administration,maintenance,meeting notes,maintain data,security,warehousing,technical documentation,test plans,testing
Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.
At Randstad Digital, we welcome people of all abilities and want to ensure that our hiring and interview process meets the needs of all applicants. If you require a reasonable accommodation to make your application or interview experience a great one, please contact HRsupport@randstadusa.com.
Pay offered to a successful candidate will be based on several factors including the candidate's education, work experience, work location, specific job duties, certifications, etc. In addition, Randstad Digital offers a comprehensive benefits package, including: medical, prescription, dental, vision, AD&D, and life insurance offerings, short-term disability, and a 401K plan (all benefits are based on eligibility).
This posting is open for thirty (30) days.
