Job Summary
We are seeking a skilled Data Analyst to join the Data Services Reporting team, specializing in SQL Server T-SQL development and business intelligence solutions. The role involves designing, developing, and maintaining complex stored procedures, ad hoc scripts, and SQL Server Reporting Services (SSRS) reports to support business operations and decision-making. The ideal candidate will have strong SQL Server development, reporting, data analysis, and performance optimization skills, along with the ability to translate business requirements into technical solutions. This is a remote position, with occasional travel required as needed.
Key Responsibilities
• Design, develop, and optimize complex stored procedures for data extraction, transformation, and reporting.
• Write efficient T-SQL queries using 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.
• Document data models, stored procedures, reports, and developed solutions.
• Manage source code using Microsoft Visual Studio with Team Foundation Server (TFS).
• Participate in code reviews and ensure adherence to development standards.
• Maintain comprehensive technical documentation to support solution quality and maintainability.
Required Qualifications
• Bachelor's degree in Computer Science, Information Systems, or a related field preferred.
• 5+ years of experience in SQL Server development and reporting.
• Advanced proficiency in SQL Server T-SQL, stored procedures, functions, and performance tuning.
• Strong experience developing SSRS RDL reports, including parameters and data sources.
• Proven track record of developing complex stored procedures and SSRS reports.
• Familiarity with Visual Studio and TFS, including source control, branching, and collaborative development.
• Strong understanding of relational database concepts and data modeling.
• Ability to analyze complex data relationships and business logic.
• Strong analytical thinking, problem-solving, and troubleshooting skills.
• Excellent communication skills and the ability to collaborate with technical and business stakeholders.
• Ability to work remotely and travel occasionally when required.
Preferred Qualifications
• Experience working with healthcare or insurance industry data systems.
• Knowledge of ETL processes and data warehousing concepts.
• Understanding of database design principles and normalization.
• Ability to adapt to changing business requirements in a fast-paced, collaborative environment.
• Commitment to continuous learning and maintaining high standards of code quality and maintainability.
Notes:
Mandatory Areas
Must Have Skills - Data Analyst
Skill 1 - 6 + Years of exp in Data Analyst
Skill 2 - 5 + Years of Exp in SQL Server development and reporting
Skill 3- 5+ Years in T-SQL development and SSRS reports
Good To have Skills -
Skill 1 - Yrs of Exp -N/A
Skill 2 - Yrs of Exp -N/A
Skill 3 - Yrs of Exp -N/A
Skill 4 - Yrs of Exp -N/A
Mandatory if Applicable
Domain Experience (If any ) - N/A
Must have Certifications -N/A
Location - Remote (Candidate should be fine for Travel if required, occasionally)
Onsite Requirement - NA
Number of days onsite - NA
If Onsite - Office Address - NA
