SQL Developer

E-Solutions; United States; On-site; USD 90,000 - 130,000; Full time

Job summary

E-Solutions is looking for a skilled Data Engineer to design, develop, and maintain SQL Server databases and ETL solutions. The ideal candidate will have strong experience with Microsoft SQL Server, SSIS, and Azure data services including Azure Data Factory and Databricks.

This role entails optimizing complex T SQL queries, ensuring data integrity, and developing scalable data pipelines. We encourage individuals from diverse backgrounds to apply as part of our commitment to equal employment opportunities.

Qualifications

• 5+ years of experience with Microsoft SQL Server.
• Hands-on expertise in SSIS package development.
• Strong analytical and problem-solving skills.

Responsibilities

• Design and maintain SQL Server databases and solutions.
• Develop, support, and optimize SSIS packages.
• Build and manage ETL solutions using Azure tools.

Skills

Microsoft SQL Server

SSIS Package Development

T SQL

Data Pipeline Development

Azure Data Services

Problem-Solving

Education

Bachelor’s degree in computer science or related field

Tools

Azure Data Factory

Databricks

SQL Server Agent

BIDS/SSDT

Job description

Responsibilities

• Design, develop, deploy, and maintain SQL Server databases and data solutions.
• Develop and support SSIS packages for data ingestion, transformation, and integration.
• Create, schedule, monitor, and troubleshoot SQL Server Agent Jobs.
• Build and maintain ETL solutions using BIDS/SSDT.
• Write and optimize complex T SQL queries, stored procedures, functions, and views.
• Diagnose and resolve data issues, job failures, and performance bottlenecks.
• Ensure data accuracy, integrity, and reliability across systems.
• Design, implement, and maintain scalable and reliable data pipelines using Azure Data Factory, Databricks, and Synapse Analytics. Microsoft Fabric
• Ensure that data is secure and meets all regulatory compliance standards, including role-based access control (RBAC) and data encryption in Azure environments.
• Develop and configure monitoring and alerting mechanisms to proactively enhance performance and optimize data systems.
• Troubleshoot and resolve data-related issues in a timely manner.
• Stay up to date with the latest trends and best practices in data engineering and cloud computing.
• Produce clear, concise technical documentation for all developed solutions.

Requirements

• Strong experience with Microsoft SQL Server (2016 or later preferred).
• Hands‑on expertise in SSIS package development and deployment.
• Solid knowledge of SQL Server Agent Jobs, scheduling, alerts, and monitoring.
• Experience in using BIDS / SSDT for ETL and database development.
• Advanced proficiency in T SQL, including performance tuning and query optimization.
• Understanding of relational database design, indexing strategies, and constraints.
• Experience troubleshooting ETL failures and data inconsistencies.
• Familiarity with source control and deployment practices for database/ETL artifacts.
• Strong analytical and problem‑solving skills.
• Ability to work independently in a fast‑paced environment.
• Experience with Azure data services, including Azure Data Factory, Azure Databricks and Azure Data Lake Storage.
• Experience in data modeling, data architecture, and implementing ETL/ELT solutions.
• Knowledge of data modeling, data warehousing, and big data technologies.
• Experience with data governance and security best practices.
• Excellent problem‑solving skills and attention to detail.
• Strong communication and collaboration skills.
• Bachelor’s degree in computer science, Information Systems, or related field.

Preferred

• Experience with Microsoft Fabric and Azure Synapse.

Disclaimer

E-Solutions provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, disability, genetic information, marital status, amnesty, or status as a covered veteran in accordance with applicable federal, state and local laws. We especially invite women, minorities, veterans, and individuals with disabilities to apply. EEO/AA/M/F/Vet/Disability.