Senior SQL Developer

Job Title: SQL Developer (Data Platform & Applications)
Location: Hybrid/Lewisville, TX
Pay range: $55/hr - $65/hr on (W2/C2C)
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:
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.