Data Analyst

Role Description

Who We Are
Born digital, UST transforms lives through the power of technology. We walk alongside our clients and partners, embedding innovation and agility into everything they do. We help them create transformative experiences and human-centered solutions for a better world. UST is a mission-driven group of 29,000+ practical problem solvers and creative thinkers in more than 30 countries. Our entrepreneurial teams are empowered to innovate, act nimbly, and create a lasting and sustainable impact for our clients, their customers, and the communities in which we live. With us, you’ll create a boundless impact that transforms your career—and the lives of people across the world.

Opportunity

• Database Development & T-SQL Programming
• Create and maintain 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
• Report Development & SSRS
• 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
• Data Analysis & Business Intelligence
• 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
• Version Control & Team Collaboration
• 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

• Bachelor's degree in Computer Science, Information Systems, or related field preferred
• 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 Qualifications

• Experience with healthcare or insurance industry data systems
• Knowledge of ETL processes and data warehousing concepts
• Understanding of database design principles and normalization

What You Need

• SQL Server: Advanced proficiency with T-SQL, stored procedures, functions, and performance tuning
• SSRS: Strong experience with RDL report development, parameters, and data sources
• Visual Studio/TFS: Familiarity with source control, branching, and collaborative development
• Data Analysis: Ability to analyze complex data relationships and business logic
• Problem Solving: Strong analytical thinking and troubleshooting capabilities

Benefits

• Paid vacation, sick leave, and holidays
• 401(k) Retirement Plan with employer matching
• Medical, dental, and vision insurance
• Short- and long-term disability benefits
• Health Savings Account (HSA) and Flexible Spending Account (FSA)

Work Environment

Compensation can differ depending on factors including but not limited to the specific office location, role, skill set, education, and level of experience. UST provides a reasonable range of compensation for roles that may be hired in various U.S. markets as set forth below.

Equal Employment Opportunity Statement

UST is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, status as a protected veteran, or any other applicable characteristics protected by law. We will consider qualified applicants with arrest or conviction records in accordance with state and local laws and “fair chance” ordinances.