SQL Developer

Net2Source (N2S); Lewisville (TX); Hybrid; USD 90,000 - 125,000; Full time

Job summary

Net2Source (N2S) in Lewisville, TX is seeking a SQL Developer focused on Data Platform & Applications. The role involves designing, developing, and optimizing SQL Server databases, T-SQL code, SSIS packages, SSRS reports, and SSAS models to support key business processes and analytics.

You will translate business requirements into data models and technical designs, deliver new functionality, and participate in code reviews and deployments.

Qualifications

• Bachelor's degree in computer science or a related field is required.
• 5+ years of hands-on SQL Server development in enterprise environments.
• Experience with SSIS, SSRS, SSAS and T-SQL development.
• Knowledge of Azure data services and cloud data platforms is a plus.
• Experience delivering enhancements through formal release processes.

Responsibilities

• Design, develop, and optimize SQL Server solutions across Database, SSIS, SSRS, and SSAS.
• Translate requirements into technical designs, data models, and database solutions.
• Develop, test, and deploy new functionality and enhancements.
• Participate in design/code reviews and unit testing for quality.
• Prepare technical documentation including data mapping and deployment artifacts.
• Support production deployments and post-deployment validation.
• Troubleshoot data integrity and performance issues; provide RCA when needed.

Skills

SQL development

ETL development

SSRS reporting

SSIS integration

SSAS analytics

Performance tuning

Data modeling

MDX/DAX

Education

Bachelor's degree in computer science or related field

Tools

Azure DevOps

Git

Azure Data Factory

Azure SQL

Snowflake

Databricks

Job description

Job Title: SQL Developer (Data Platform & Applications)

Location: Lewisville, TX (Hybrid)

Position Summary

We are seeking a highly skilled and detail-oriented SQL Developer to design, develop, and optimize business-critical SQL Server solutions across the enterprise data platform. This role is responsible for building and enhancing SQL Server databases, T-SQL code, SSIS integration packages, SSRS reports, and SSAS analytical models that support key business processes, reporting, and analytics.

Roles and Responsibilities

SQL Development & Solution Delivery

• Design, develop, and deliver SQL Server solutions across Database, SSIS, SSRS, and SSAS components.
• Translate business and functional requirements into technical designs, data models, and database solutions.
• Develop, test, and deploy new functionality as well as enhancements to existing solutions.
• Participate in design reviews, code reviews, and unit testing to ensure quality and adherence to standards.
• Prepare technical documentation, including data mapping, data flow, and deployment artifacts.
• Support production deployments, release activities, and post-deployment validation.

SQL Server Database Development

• Design, develop, and optimize SQL Server database objects, including:
• Tables
• Views
• Stored Procedures
• Functions
• Indexes
• Complex T-SQL Queries
• Implement application business logic within stored procedures, functions, and T-SQL code.
• Performance tune queries and stored procedures using execution plan analysis and indexing strategies.
• Develop enhancements to existing queries, stored procedures, and database objects.
• Deliver database changes through source control and standard change and release processes.
• Troubleshoot and resolve data integrity, performance, and application-related database defects.

SSIS & ETL Development

• Design, develop, and deploy SSIS packages and ETL workflows for enterprise data movement.
• Build control flow, data flow, and transformation logic in line with development standards.
• Implement error handling, logging, restartability, and data validation within packages.
• Enhance and optimize existing SSIS packages for performance, reliability, and maintainability.
• Troubleshoot and resolve data load failures and package execution issues.

SSRS Report Development

• Design, develop, and deploy SQL Server Reporting Services (SSRS) reports, datasets, and subscriptions.
• Build parameterized, drill-through, and performance-optimized report designs.
• Deliver report enhancements and modifications requested by business users.
• Investigate and resolve report execution failures and performance issues.
• Develop and maintain SQL Server Analysis Services (SSAS) multidimensional and tabular models.
• Build measures, KPIs, hierarchies, and calculations using MDX or DAX.
• Configure and tune cube processing, partitions, and refresh schedules.
• Ensure analytical models accurately reflect underlying business data.
• Investigate and resolve cube processing failures and data discrepancies.
• Provide production support for SQL Server databases, SSIS packages, SSRS reports, and SSAS models, including participation in an on-call rotation as required.
• Investigate, troubleshoot, and resolve production incidents and data issues within agreed SLA commitments.
• Perform Root Cause Analysis (RCA) on recurring incidents and implement permanent code-level fixes.
• Monitor scheduled jobs, ETL loads, report subscriptions, and cube processing, and remediate failures.
• Recommend improvements to database design, ETL processes, reporting, and monitoring to improve stability and operational efficiency.
• Apply approved data fixes, service requests, and production validations as needed.

Education, Experience, and Other Requirements

Education

Bachelor's degree in computer science, Information Technology, Information Systems, Engineering, or a related field.

Experience

• 5+ years of hands-on SQL Server development experience in enterprise environments.
• Experience developing with:
• Microsoft SQL Server Database
• SQL Server Integration Services (SSIS)
• SQL Server Reporting Services (SSRS)
• SQL Server Analysis Services (SSAS)
• Experience designing and building database objects, ETL packages, reports, and analytical models.
• Experience delivering enhancements, service requests, and defect fixes through a formal release process.
• Experience supporting solutions in production, including Root Cause Analysis and release support.

Preferred Experience

• Experience with Azure DevOps, Git, or other source control and release management tools.
• Experience with cloud data platforms such as Azure Data Factory, Azure SQL, Snowflake, or Databricks.
• Familiarity with ITIL processes including Incident, Problem, and Change Management.
• Experience working in Agile or DevOps environments.
• Advanced SQL Server performance tuning and query optimization skills.