Senior Healthcare Economic Consultant - Remote

Optum is a global organization that delivers care, aided by technology to help millions of people live healthier lives. The work you do with our team will directly improve health outcomes by connecting people with the care, pharmacy benefits, data and resources they need to feel their best. Here, you will find a culture guided by inclusion, talented peers, comprehensive benefits and career development opportunities.

Come make an impact on the communities we serve as you help us advance health optimization on a global scale. Join us to start Caring. Connecting. Growing together.

This position supports OCUDM Business delivery through Databricks, Airflow and Snowflake

Positions in this function research and investigate key business problems through quantitative analyses of utilization and healthcare costs data. Provides management with statistical findings and conclusions. Identifies potential areas for medical cost improvements and alternative pricing strategies. Provides data in support of actuarial, financial and utilization analyses.

• Reviews the work of others
• Develop innovative approaches
• Sought out as expert
• Serves as a leader/ mentor

You’ll enjoy the flexibility to work remotely
* from anywhere within the U.S. as you take on some tough challenges. For all hires in the Minneapolis or Washington, D.C. area, you will be required to work in the office a minimum of four days per week.

• Looking for an accomplished Data Analyst to consolidate technical, analytical and reporting skills to cater to the fast-changing needs of the business across the globe and contribute positively towards organization’s corporate vision, mission & goal and hone technical knowledge, experience on continuous basis to take up challenging roles and responsibilities. The data analyst will support the team through development and presentation of reporting and analytics using a variety of data sources and serve as analytics consultant for different level projects
• Interaction with key stakeholders and serve as analytic contact/resource for external business partners to support ongoing data exchange, analysis, reporting, and interpretation of performance results
• Support complex analytic projects leveraging data from multiple sources
• Solid analytical expertise: data analysis, data manipulation, data extraction required
• Work with Health Care Economics Team on continued expansion of data infrastructure needs, updates, and developments
• All data research activities for Health Care Economics Team
• Will provide end-to-end support for ETL related activities
• Will help team formulate strategy to move to cloud technologies

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.

• Graduate degree or equivalent (B.Tech./MCA preferred) with 4+ years of work experience
• Expert in designing and developing ETL Architecture using tools such as Azure Databricks/Apache Spark with development expertise on batch and real time data integration
• Experience in programming using Python, PySpark, SQL in Azure Databricks
• Experience with Orchestration tools (Airflow, Azure Data Factory), Azure Dev Ops and Git Hub

• Experience in writing the Stored Procedures and query performance optimization
• Experience in Cloud data warehouse like Snowflake analytical warehouse
• Experience of Cloud Databases specifically Snowflake (1+ years)
• Experience in relational data processing technology like MS SQL, Data Lake, Spark SQL
• Familiarity with Azure services like Azure functions, Azure Data Lake Store
• Own end-to-end development, including coding, testing, debugging, and deployment
• Provide solutions that are forward thinking in data and analytics
• Experience in Preparing and planning the Test Plans
• Solid Experience in Technical troubleshooting using various tools.
• Experience in Data deep-dive projects.
• Excellent communication and presentation skills
• Experience understanding Requirement mapping document and designing jobs.
• Demonstrated ability to prioritize…