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.
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.
All your information will be kept confidential according to EEO guidelines.