SQL Developer

Job Title: SQL Developer (Data Platform & Applications)

Location: Lewisville TX (Hybrid)

Contract

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.

Qualifications :

Education Experience and Other Requirements

Education

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

Additional Information :

All your information will be kept confidential according to EEO guidelines.

Remote Work :

No

Employment Type :

Contract