Jr. Database Architect / SQL Developer :: Hybrid in Manhattan, NY
About The Position
The SQL Developer / Database Architect / Data Engineer is a senior technical role responsible for designing, developing, administering, optimizing, integrating, and governing data for the Client Construction organization. This hybrid position combines database architecture and data engineering to support critical business applications, analytics, initiatives, and digital transformation programs. The role develops and supports scalable, secure, highly available database solutions, enterprise data pipelines, integrations, and reporting platforms. It balances planning, hands-on technical work, operational support, and collaboration with stakeholders across business and technical teams. The position also requires clear, appropriately detailed written communications for technical and non-technical audiences.
Requirements
- Bachelor's degree in Information Technology, Computer Science, or a related field, or equivalent experience.
- Five to eight years of MS SQL Server development experience.
- Strong T-SQL programming experience, including complex queries, joins, views, stored procedures, functions, and query optimization.
- Strong experience developing and supporting ETL/ELT processes and enterprise data integrations.
- Experience with data ingestion, incremental loading, data validation, and data quality processes.
- Experience with enterprise data warehousing and dimensional modeling.
- Strong to advanced experience with Microsoft Excel, Word, PowerPoint, and Outlook.
- Experience with SQL Server performance tuning, indexes, index management, and optimization.
- At least six years of hands-on software development and systems integration experience.
- Ability to execute existing SQL queries and interpret, modify, and write scripts and SQL queries.
- Excellent analytical, critical-thinking, and problem-solving skills, including the ability to anticipate and proactively address issues.
- Excellent written and verbal communication skills, including the ability to explain technical concepts to non-technical audiences.
- Ability to prepare concise, sufficiently detailed documentation, deployment plans, status reports, and meeting notes.
- Methodical and organized approach to problem-solving.
Nice To Haves
- Experience with PowerShell scripting and automation.
- Experience with SQL Server administration, security, backup and recovery, and maintenance.
Responsibilities
- 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.
- 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; recommend new or updated standards where gaps exist and identify areas for improvement.
- Document and update technical documentation, operational procedures, and support runbooks as appropriate.
- Take ownership of assigned deliverables, follow through, and adapt to changes in priority.
- Learn and follow the client's policies, procedures, and standards.
- Develop accurate estimates of effort and timelines and complete assignments accurately within approved delivery schedules.
- Assist with query tuning, performance optimization, and schema refinement.
- Assist with SQL Server database administration, including monitoring, maintenance, security, backup verification, and troubleshooting.
- Provide backup database administration support during planned absences, vacations, and off-hours support rotations.
- Work effectively with business and technical teams in a cross-functional, cross-matrixed environment.
- Support release deployments, testing, and production implementations as required.
- Create, document, and execute test plans, including white-box, black-box, positive, and negative testing.
- Perform other duties as assigned, directed, or requested.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Career Level
Senior
