Senior Payer Informatics Analyst - SQL Developer - Deerfield, IL OR Telecommute
UnitedHealth Group
Atlanta Georgia
United States
Information Technology
(No Timezone Provided)
Combine two of the fastest-growing fields on the planet with a culture of performance, collaboration and opportunity and this is what you get. Leading edge technology in an industry that's improving the lives of millions. Here, innovation isn't about another gadget, it's about making health care data available wherever and whenever people need it, safely and reliably. There's no room for error. Join us and start doing your life's best work.(sm)
Surgical Care Affiliates (SCA), a leader in the outpatient surgery industry, strategically partners with health plans, medical groups and health systems across the country to develop and optimize surgical facilities. SCA operates more than 210 surgical facilities, including ambulatory surgery centers and surgical hospitals, in partnership with approximately 7,500 physicians. For more information on SCA, visit .
SCA is currently accepting applications for a Senior Analyst position on its fast-paced and innovative Catalyst team. Key areas of focus include supporting health plan engagement and new product innovation, featuring SCA's lower-cost, high-quality facilities and history of surgeon partnership.
You'll enjoy the flexibility to telecommute* from anywhere within United States as you take on some tough challenges.
Primary Responsibilities:
- Serve as co-system administrator on the team's dedicated analytics server, regularly providing insights on database design/performance and resource requirements in a changing environment
- Represent the team as SME and thought partner whenever Catalyst data is used for reporting
- Design, build, and maintain innovative tools that serve to collect and report team input on a variety of complex initiatives
- Load, cleanse, and report on claims data sourced from external vendors
- Train and provide support to Analytics team on writing TSQL queries on internal data
- Create custom views of enterprise data sources for reporting in SSRS, Tableau, Excel,
- Gather detailed reporting requirements from the team and translate them into practice
- Closely interact with IT department concerning changes in enterprise data sources, modifying existing reports when necessary in a self-directed manner
You'll be rewarded and recognized for your performance in an environment that will challenge you and give you clear direction on what it takes to succeed in your role as well as provide development for other roles you may be interested in.
Required Qualifications:
- Bachelor's degree or equivalent work experience
- 4+ years of relevant work experience
- 4+ years of proficiency in SQL Server, (including a firm understanding of T-SQL functions / stored procedures and security settings that utilize Active Directory groups)
- Experience with loading external flat file data using both Integration Services and the SQL Server Import/Export Wizard
- Extreme attention to detail through demonstrated consistency in TSQL scripts and report design
- Demonstrated proficiency in SQL Server, including a firm understanding of T-SQL functions/stored procedures and security settings that utilize Active Directory groups
- Demonstrated ability to design and build innovative tools that are tailored to end-user needs and serve to collect, store, and report user input in a SQL Server environment
- Ability to identify patterns in, and discern relationships between, externally provided data tables without support from the table source vendor
- Ability to absorb & retain communicated requirements, anticipating additional customer needs and proactively developing solutions to meet them
- Ability to deconstruct existing processes, document key components, and make modifications that maintain relevance in a changing data environment
- Ability to discern if/when non-standard issues require exceptions from established structure
- Ability to travel - up to 10%
Preferred Qualifications:
- Experience with Tableau, inclusive of Initial SQL execution, calculated measures, and using stored procedures as data sources
- Healthcare industry experience
- Intermediate proficiency in Excel, including experience with VBA
EEO Statement
We value Diversity, Inclusion, and Belonging at Surgical Care Affiliates: SCA is an Equal Employment Opportunity employer, and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex (including pregnancy), age, national origin, disability and genetic information, or any other characteristic protected by law.
UnitedHealth Group requires all new hires and employees to report their COVID-19 vaccination status.
Careers with Optum. Here's the idea. We built an entire organization around one giant objective; make health care 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)
Colorado Residents Only: The salary range for Colorado residents is $64,800 to $116,000. Pay is based on several factors including but not limited to education, work experience, certifications, etc. In addition to your salary, UnitedHealth Group offers benefits such as, a comprehensive benefits package, incentive and recognition programs, equity stock purchase and 401k contribution (all benefits are subject to eligibility requirements). No matter where or when you begin a career with UnitedHealth Group, you'll find a far-reaching choice of benefits and incentives.
*All Telecommuters will be required to adhere to UnitedHealth Group's Telecommuter Policy.
Diversity creates a healthier atmosphere: OptumCare and its affiliated medical practices are Equal Employment Opportunity/Affirmative Action employers 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.
OptumCare and its affiliated medical practices is a drug-free workplace. Candidates are required to pass a drug test before beginning employment.
Job keywords: Senior Payer Informatics Analyst, SQL Developer, SQL Server, T-SQL, Telecommute, Telecommuting, Telecommuter, Work From Home, Work At Home, Remote, WAH, Deerfield, IL, Illinois
Senior Payer Informatics Analyst - SQL Developer - Deerfield, IL OR Telecommute
UnitedHealth Group
Atlanta Georgia
United States
Information Technology
(No Timezone Provided)
Combine two of the fastest-growing fields on the planet with a culture of performance, collaboration and opportunity and this is what you get. Leading edge technology in an industry that's improving the lives of millions. Here, innovation isn't about another gadget, it's about making health care data available wherever and whenever people need it, safely and reliably. There's no room for error. Join us and start doing your life's best work.(sm)
Surgical Care Affiliates (SCA), a leader in the outpatient surgery industry, strategically partners with health plans, medical groups and health systems across the country to develop and optimize surgical facilities. SCA operates more than 210 surgical facilities, including ambulatory surgery centers and surgical hospitals, in partnership with approximately 7,500 physicians. For more information on SCA, visit .
SCA is currently accepting applications for a Senior Analyst position on its fast-paced and innovative Catalyst team. Key areas of focus include supporting health plan engagement and new product innovation, featuring SCA's lower-cost, high-quality facilities and history of surgeon partnership.
You'll enjoy the flexibility to telecommute* from anywhere within United States as you take on some tough challenges.
Primary Responsibilities:
- Serve as co-system administrator on the team's dedicated analytics server, regularly providing insights on database design/performance and resource requirements in a changing environment
- Represent the team as SME and thought partner whenever Catalyst data is used for reporting
- Design, build, and maintain innovative tools that serve to collect and report team input on a variety of complex initiatives
- Load, cleanse, and report on claims data sourced from external vendors
- Train and provide support to Analytics team on writing TSQL queries on internal data
- Create custom views of enterprise data sources for reporting in SSRS, Tableau, Excel,
- Gather detailed reporting requirements from the team and translate them into practice
- Closely interact with IT department concerning changes in enterprise data sources, modifying existing reports when necessary in a self-directed manner
You'll be rewarded and recognized for your performance in an environment that will challenge you and give you clear direction on what it takes to succeed in your role as well as provide development for other roles you may be interested in.
Required Qualifications:
- Bachelor's degree or equivalent work experience
- 4+ years of relevant work experience
- 4+ years of proficiency in SQL Server, (including a firm understanding of T-SQL functions / stored procedures and security settings that utilize Active Directory groups)
- Experience with loading external flat file data using both Integration Services and the SQL Server Import/Export Wizard
- Extreme attention to detail through demonstrated consistency in TSQL scripts and report design
- Demonstrated proficiency in SQL Server, including a firm understanding of T-SQL functions/stored procedures and security settings that utilize Active Directory groups
- Demonstrated ability to design and build innovative tools that are tailored to end-user needs and serve to collect, store, and report user input in a SQL Server environment
- Ability to identify patterns in, and discern relationships between, externally provided data tables without support from the table source vendor
- Ability to absorb & retain communicated requirements, anticipating additional customer needs and proactively developing solutions to meet them
- Ability to deconstruct existing processes, document key components, and make modifications that maintain relevance in a changing data environment
- Ability to discern if/when non-standard issues require exceptions from established structure
- Ability to travel - up to 10%
Preferred Qualifications:
- Experience with Tableau, inclusive of Initial SQL execution, calculated measures, and using stored procedures as data sources
- Healthcare industry experience
- Intermediate proficiency in Excel, including experience with VBA
EEO Statement
We value Diversity, Inclusion, and Belonging at Surgical Care Affiliates: SCA is an Equal Employment Opportunity employer, and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex (including pregnancy), age, national origin, disability and genetic information, or any other characteristic protected by law.
UnitedHealth Group requires all new hires and employees to report their COVID-19 vaccination status.
Careers with Optum. Here's the idea. We built an entire organization around one giant objective; make health care 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)
Colorado Residents Only: The salary range for Colorado residents is $64,800 to $116,000. Pay is based on several factors including but not limited to education, work experience, certifications, etc. In addition to your salary, UnitedHealth Group offers benefits such as, a comprehensive benefits package, incentive and recognition programs, equity stock purchase and 401k contribution (all benefits are subject to eligibility requirements). No matter where or when you begin a career with UnitedHealth Group, you'll find a far-reaching choice of benefits and incentives.
*All Telecommuters will be required to adhere to UnitedHealth Group's Telecommuter Policy.
Diversity creates a healthier atmosphere: OptumCare and its affiliated medical practices are Equal Employment Opportunity/Affirmative Action employers 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.
OptumCare and its affiliated medical practices is a drug-free workplace. Candidates are required to pass a drug test before beginning employment.
Job keywords: Senior Payer Informatics Analyst, SQL Developer, SQL Server, T-SQL, Telecommute, Telecommuting, Telecommuter, Work From Home, Work At Home, Remote, WAH, Deerfield, IL, Illinois