Senior Data Analyst - Franklin, TN - Full-time / Part-time

At Optum, we are driven to transform health care not just for our own good, but for the greater good. And, with your data reporting and analysis expertise, you can join us on our mission to help make the health care system work better for everyone. As a Data Analyst, you will thrive as you design and architect data warehouse solutions. You will be a primary contributor in developing, testing and deploying key data warehouses or data marts, and you will be working with cutting edge technology.
This role will prepare you for significant career growth as you shift to a gear you didn't know you had in you. So the contributions you'll make as a Data Analyst at Optum, the pride you will feel, the smile that will keep you company on your way home are all ways that you'll know what you do here really matters. It will be important. No, it will not be just important, it will be historic. That's why someday, you will look back at the things you achieved here and realize that you did your life's best work.(sm)
Primary Responsibilities:

Identify data abnormalities that are or could have the ability to impact analytic development and performance
One time data pulls
Develop metrics to provide forecasting of new rule values and FTE needs
Add SQL logic into our Policy and Procedure documents for new analytics and maintenance for existing documents as the analytic logic changes
Code all production analytic revisions while working directly with the Business Analyst on testing the output
Analytic development and implementation into our production environment
Monitor monthly/weekly data loads and kick off all production analytic reruns
Monthly analysis of analytic performance; forecasted vs. actuals
Maintenance of existing analytics to drive maximum performance on output and efficiencies
Weekly management reports outlining work completed and issues encountered
Screen scrape and automation ideation and development as well as maintaining existing automations and scrapes
Populate and analyze monthly data reconciliation to identify potential data issues
Create and maintain reports required for our business partners
Execute all monthly automations, screen scrapes, and waste reductions
Competencies and Best Practices for High Performers:

Breakdown complex problems into individual root causes
In-depth understanding of database structures
Perform data analysis in Tableau and present findings to the management teams
Assist on client calls and serve as subject matter expert on all data fields, values, and adjustment logic
Identify, refine, and develop criteria to successfully increase efficiency of analytic logic
Serve as a team lead in the absence of the Analytics Manager
Subject matter expert on client exclusions
Assist management and sales with product assessments for new business
Train and perform peer SQL and Visual Basic code review
Lead special projects with little to no manager supervision or assistance
Perform all quality assurance steps for new client implementations and file layout changes
Extensive knowledge with more than one data set

Required Qualifications:

3+ years of proven experience as a Data Analyst
3+ Professional IT experience in a large, enterprise environment
5+ years of SQL experience
1+ year of Visual Studio, C++, or other OO language
Must possess excellent written and verbal communication skills and be able to successfully communicate and present ideas to colleagues, clients and senior management
Proficient with Microsoft Excel and Access
Preferred Qualifications:

Health care industry, Medical Claims experience
Process Automation and/or Process Improvement experience
Bachelor’s Degree
Careers with Optum. Here's the idea. We built an entire organization around one giant objective; make the health system work better for everyone. So when it comes to how we use the world's large accumulation of health-related information, or guide health and lifestyle choices or manage pharmacy benefits for millions, our first goal is to leap beyond the status quo and uncover new ways to serve. Optum, part of the UnitedHealth Group family of businesses, brings together some of the greatest minds and most advanced ideas on where health care has to go in order to reach its fullest potential. For you, that means working on high performance teams against sophisticated challenges that matter. Optum, incredible ideas in one incredible company and a singular opportunity to do your life's best work.(sm)
 
Diversity creates a healthier atmosphere: UnitedHealth Group is an Equal Employment Opportunity / Affirmative Action employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, national origin, protected veteran status, disability status, sexual orientation, gender identity or expression, marital status, genetic information, or any other characteristic protected by law.UnitedHealth Group is a drug-free workplace. Candidates are required to pass a drug test before beginning employment.
 
Job Keywords: SAS, SQL, C++, OO, Access, Excel, Healthcare, Claims, Franklin, Tennessee, TN