SQL Developer

BuzzClan LLC; Lewisville (TX); Hybrid; USD 90,000 - 120,000; Full time

Job summary

BuzzClan LLC in Lewisville, TX is seeking a skilled SQL Developer to design, develop, and optimize SQL Server solutions across the enterprise data platform. This role builds and maintains databases, T-SQL code, SSIS packages, SSRS reports, and SSAS models to support business processes, reporting, and analytics.

The ideal candidate has 5+ years of hands-on SQL Server development, strong ETL, reporting, and data integration experience, plus familiarity with Azure data services and DevOps

Qualifications

• 5+ years of hands-on SQL Server development in enterprise environments.
• Experience with Microsoft SQL Server Database, SSIS, SSRS, SSAS.
• Ability to design, develop, and optimize SQL Server database objects and ETL/BI solutions.
• Familiarity with release management and production support processes.
• Experience with cloud data platforms and DevOps practices is a plus.

Responsibilities

• Design, develop, and deliver SQL Server solutions across Database, SSIS, SSRS, and SSAS components.
• Translate requirements into data models, designs, and database solutions.
• Develop, test, and deploy new functionality and enhancements.
• Participate in design/code reviews and unit testing.
• Prepare technical documentation and deployment artifacts.
• Support production deployments and post-deployment validation.
• Design, develop, and optimize SSIS packages and ETL workflows.
• Build SSRS reports, datasets, and subscriptions with performance considerations.
• Develop and maintain SSAS models (MDX/DAX measures).
• Monitor jobs and cube processing; troubleshoot failures and perform RCA.

Skills

SQL development

Data modeling

Performance tuning

ETL development

Reporting and analytics

Release management

Education

Bachelor's degree in Computer Science, Information Technology, Information Systems, Engineering, or related field

Tools

SQL Server

SSIS

SSRS

SSAS

Azure DevOps

Git

Azure Data Factory

Azure SQL

Snowflake

Databricks

Job description

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

Qualifications

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.

Additional Information

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