Description

Responsibilities

• Design, develop, and optimize complex stored procedures for data extraction, transformation, and reporting
• Write efficient T-SQL queries including multi-table joins, subqueries, window functions, and conditional logic
• Create and maintain ad hoc scripts for data analysis, troubleshooting, and special reporting requests
• Develop and implement data validation and quality assurance procedures
• Optimize query performance through indexing strategies and execution plan analysis
• Design and develop RDL reports using SQL Server Reporting Services (SSRS)
• Create interactive dashboards, parameterized reports, and data visualizations
• Implement complex report parameters, datasets, and data sources
• Develop drill-through reports and nested report structures
• Optimize report performance and manage report deployment
• Analyze complex datasets to identify trends, patterns, and business insights
• Translate business requirements into technical specifications and data solutions
• Collaborate with business users to understand reporting needs and deliver actionable insights
• Perform data profiling, validation, and cleansing activities
• Develop documentation for data models, procedures, and reports
• Manage source code using Microsoft Visual Studio with TFS (Team Foundation Server)
• Participate in code reviews and ensure adherence to development standards
• Maintain comprehensive documentation for all developed solutions

Qualifications

• Required
  • Advanced proficiency with SQL Server, including T-SQL, stored procedures, functions, and performance tuning
  • Strong experience with SSRS RDL report development, parameters, and data sources
  • Familiarity with Microsoft Visual Studio and TFS for source control, branching, and collaborative development
  • Ability to analyze complex data relationships and business logic
  • Strong analytical thinking and troubleshooting capabilities
  • 5+ years of experience in SQL Server development and reporting
  • Proven track record of developing complex stored procedures and SSRS reports
  • Strong understanding of relational database concepts and data modeling
  • Excellent communication skills and ability to work with both technical and business stakeholders
• Preferred
  • Bachelor's degree in Computer Science, Information Systems, or related field
  • Experience with healthcare or insurance industry data systems
  • Knowledge of ETL processes and data warehousing concepts
  • Understanding of database design principles and normalization

Key Skills

Education

Bachelor's degree