Senior SQL Server Developer / Data Engineer
Job Description
Experience
8+ Years
Location
TBD / As Applicable
Job Summary
We are seeking a highly skilled Senior SQL Server Developer / Data Engineer with 8+ years of experience and strong expertise in SQL Server, T-SQL, and ETL/data integration. The ideal candidate should have hands-on experience in designing, developing, optimizing, and supporting enterprise database solutions and data pipelines. This role requires strong analytical and troubleshooting skills, a solid understanding of data movement and transformation, and the ability to reverse engineer existing code and legacy implementations to support enhancements, production support, and modernization initiatives.
Key Responsibilities
Design, develop, and maintain complex T-SQL stored procedures, functions, views, and triggers.
Build, enhance, and support ETL workflows for data extraction, transformation, and loading.
Analyze and reverse engineer existing SQL Server code, database objects, and legacy data flows to understand business logic and system dependencies.
Develop and optimize SQL queries and database objects for performance, scalability, and maintainability.
Support data integration and synchronization across multiple source and target systems.
Troubleshoot and resolve issues related to ETL jobs, SQL Server performance, and production data pipelines.
Ensure data quality, reconciliation, and consistency across systems.
Work closely with business analysts, architects, and application teams to understand requirements and implement effective data solutions.
Participate in unit testing, system testing, deployment, and production support activities.
Prepare and maintain technical documentation for mappings, workflows, stored procedures, data flows, and operational processes.
Support release and deployment activities across multiple environments.
Follow development standards, coding best practices, and governance processes.
Required Skills
8+ years of experience in SQL Server development, data engineering, or ETL development.
Strong hands-on experience with SQL Server and T-SQL.
Expertise in developing stored procedures, functions, views, triggers, and complex SQL queries.
Strong understanding of ETL concepts, including extraction, transformation, loading, data mapping, and workflow orchestration.
Experience in query tuning, performance optimization, and troubleshooting in SQL Server.
Good understanding of data warehousing concepts, including staging, ODS, and dimensional models.
Ability to reverse engineer existing code, understand legacy business logic, and support migration or modernization initiatives.
Experience in data validation, reconciliation, and root cause analysis.
Ability to support critical production processes and resolve data-related issues.
Strong analytical, problem-solving, and communication skills.
Ability to work independently and collaboratively within a team environment.
Nice to Have / Preferred Skills
Experience with Databricks, Microsoft Fabric, and Salesforce.
Experience with CI/CD implementation using DACPAC-based deployments.
Familiarity with version control systems and deployment automation.
Exposure to cloud-based data engineering and modern data platforms.
Experience with enterprise data migration, modernization, or platform transformation initiatives.
Familiarity with API-based and file-based integrations.
Knowledge of scheduling and orchestration tools.
Education
Bachelor’s degree in Computer Science, Information Systems, Engineering, or a related field.
Ideal Candidate Profile
Strong in SQL Server development and ETL implementation.
Experienced in building and supporting enterprise-grade database and data integration solutions.
Able to reverse engineer and understand existing code and legacy data processes.
Comfortable working on both development and production support activities.
Strong collaborator who can work across technical and functional teams.
Capable of delivering reliable and scalable data solutions in a fast-paced environment.
