SQL Developer (Data Platform & Applications)

Job Title: SQL Developer (Data Platform & Applications)

Location: Hybrid/Lewisville, TX

Duration 11 Months

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.
• Validate report data accuracy against source systems.
• Deliver report enhancements and modifications requested by business users.
• Investigate and resolve report execution failures and performance issues.

SSAS Model Development

• 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.

Production Support & Problem Management

• 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.