The Role
Design, develop, optimize, and support SQL Server databases, T-SQL objects, ETL workflows, and enterprise data pipelines. Reverse engineer legacy code and data flows, troubleshoot production issues, improve performance, ensure data quality, support integrations and deployments, and document technical processes. Collaborate with business analysts, architects, and application teams on data solutions, modernization, testing, and production support.
Summary Generated by Built In
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.
Skills Required
- 8+ years of experience in SQL Server development, data engineering, or ETL development
- Strong hands-on experience with SQL Server and T-SQL
- Experience 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 with query tuning, performance optimization, and SQL Server troubleshooting
- 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
- Bachelor's degree in Computer Science, Information Systems, Engineering, or a related field
- 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
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
Anblicks is a Cloud Data Analytics Company based out of Dallas, TX, with offices in USA, India, and Australia. Since 2004, Anblicks has been helping customers by bringing value to their data and implementing modern data architecture and advanced analytics solutions in the cloud.
