Note: The job is a remote job and is open to candidates in USA. United HealthCare Services, Inc is a leading healthcare organization, and they are seeking a Senior Data Analyst to enhance their reporting and data management processes. The role involves conducting various reporting tasks, gathering requirements, and automating processes to improve efficiency and data accuracy.
Responsibilities
- Conduct daily, weekly, and monthly reporting to Accounting, Treasury, Sales, and other business partners
- Gather business and technical requirements for new reporting needs and enhancements
- Build SQL/SSIS/SSRS/Power BI based processes and queries aligned with defined requirements
- Test and validate reporting processes to ensure accuracy, performance, and alignment with business logic
- Automate report generation and delivery using tools such as SQL, Power BI, SSIS or SSRS to various stakeholder groups to ensure timely and consistent insights and to improve efficiency and reduce manual effort
- Implement job scheduling for data imports from files and other databases
- Identify and implement improvements in standard reporting processes and capabilities, including upgrades to current software versions and migration to a virtual database
- Identify and implement opportunities for improved controls and audits around commissions payments
- Perform data validation and quality checks to ensure accuracy and consistency across data and reports
- Automate manual and time-consuming processes to improve efficiency and reduce operational overhead
- Calculate and pay non-standard commissions not currently supported by ICM application
- Reconcile and adjust quarterly 1099 files before submission to Tax
- Perform regular database maintenance, including performance tuning, indexing, and archiving to ensure optimal reporting efficiency
- Address and resolve database vulnerabilities in collaboration with IT and security teams to ensure compliance and data protection
- Maintain documentation for reporting processes, data definitions, and business rules to ensure transparency and continuity
Skills
- Bachelor's degree in Computer Science, Data Science, Information Technology or related field
- Five (5) years of progressive, post baccalaureate experience in the job offered or a Data Analyst-related occupation
- Write efficient queries to extract and transform data for reporting
- Advanced SQL (joins, CTEs, window functions)
- Excel, advanced formulas, pivot tables, Power Query, and VBA
- SQL Server Reporting Services (SSRS), design paginated reports, parameterized and drill-down reports, subscriptions and report automation
- Power BI integration with SQL Server to automate reports
- Schedule and maintain recurring reports using Visual Studio
- SQL Server Integration Services (SSIS) for ETL workflows
- Import/export data using BCP, BULK INSERT, and linked servers
- Work with flat files, Excel, and APIs
- Maintain clear documentation for report logic, data sources, and business definitions
- Query optimization and execution plans
- Index tuning and statistics management
- Identify and resolve deadlocks and blocking
Benefits
- UnitedHealth Group offers a full range of comprehensive benefits, including medical, dental and vision, as well as matching 401k and an employee stock purchase plan.
Company Overview
Company H1B Sponsorship