Role Description
The Community and State, Program Orchestration – Manager Data Analytics will work with C&S HEDIS measure owners as a Senior Workflow / Alteryx Developer in the C&S Workflow Programming Team, utilizing advanced analytics. The role requires solid programming skills to develop, implement, and maintain Medicaid workflows and reporting of programs as required by the Community and State Program Orchestration team.
Work Schedule (40 hours/week):
-
8 hours Monday - Friday w/no weekends, no holidays, no overtime
-
Flexibility to work remotely from anywhere within the U.S.
Primary Responsibilities:
-
Develop and maintain complex workflows using Alteryx software
-
Collaborate with business partners to design, build and code cross-channel communications using Alteryx and Snowflake platforms
-
Serve as the technical lead on projects; translate and convey business solutions and strategies into system and database architecture
-
Design and build strategies, processes and technology solutions that support business needs and align with industry best practices
-
Create and translate complex SQL queries to support ad-hoc business requests
-
Identify data solutions to support complex campaigns, including Snowflake, flat files and data warehouses
-
Develop & lead Medicaid – Medication Adherence program development, implementation, and quality monitoring
-
Develop and manage reporting solutions and delivery – both planning and design of new solutions to support CNS workflows, as well as ongoing change management, production support, monitoring, and accountability for those solutions
-
Liaison with UHG IT for the purpose of maintaining and updating programs that have been, or will be, moved to a production environment through an agile SDLC
-
Serve as the primary liaison to technology partners for data requests, issue escalation and resolution; troubleshoot technical issues and provide technical support to business partners
-
Maintain and update the workflow automation environment to ensure optimization
-
Develop and maintain best practices and standard operating procedures for workflows
-
Develop and maintain data preparation and audit/validation routines to support system performance and accuracy
-
Participate in quality assurance, software testing, and documentation efforts
-
Encourage processes that increase productivity by improving people, process, tools, and technology; mentor and train staff on efficient and effective use of Snowflake/Alteryx techniques
-
Comply with and promote work measurements, production methods and standards
-
Collaborate with cross-functional teams and other CNS analytics leads on the strategic use of data for modeling and reporting
-
Maintain and enhance CNS-related data warehouses/marts and develop ad-hoc data mining analysis to support business decisions; manage cleansing, accuracy, and ongoing maintenance of data warehousing activities
Qualifications
-
Bachelor’s degree in engineering or 5+ years of engineering experience in the healthcare industry
-
5+ years of experience working in the Healthcare industry as a Developer in SQL
-
5+ years of experience with SQL and RDBMS systems
-
5+ years of experience working with Campaign Management platforms (Alteryx (preferred), Adobe Campaign, Unica, Alterian, Eloqua, etc.)
-
3+ years of experience working with Alteryx ETL Designer
-
3+ years of experience with workflow design and development
-
5 years of experience in a data quality review process (e.g., Data QA, UAT, etc.)
-
4+ years of experience in automation and optimization of workflows
-
4+ years of experience with Snowflake / Cortex, Databricks
-
5+ years of experience with requirements gathering and analysis techniques
Preferred Qualifications
-
Experience with or understanding HEDIS measures; knowledge of HEDIS and Star Quality Specifications
-
Familiarity with CMS Star Ratings
-
Experience with or understanding of the Medicaid and Retirement and/or Community and State lines of business
-
Advanced Snowflake SQL query and programming experience, with the ability to create and modify stored procedures in Snowflake Database
-
Proficient in Python, Databricks, UNIX, Linux
-
Proficiency in programming languages (.Net / C++ / C# / Java / Python)
-
Experience with Python and R programming
-
Proficiency in scripting (Batch / Shell / JavaScript)
-
Proficiency in dashboard and data visualization tools (Tableau / Power BI / Cognos / Business Objects)
-
Knowledge of ETL applications (SSIS / Alteryx / Informatica)
-
Experience developing, implementing, and supporting production BI reporting
-
Experience with business intelligence tools and software
-
Advanced Proficiency with MS Office and Excel
Soft Skills
-
Proven ability to meet deadlines when given multiple projects and priorities in a fast-paced environment
-
Proven motivated self-starter with curiosity, attention to detail, and ability to effectively handle change
-
Competent to work on complex projects independently
-
Ability to think strategically (outside-the-box) and provide creative solutions
-
Ability to frame problems and opportunities to present solutions
Benefits
-
Comprehensive benefits package
-
Incentive and recognition programs
-
Equity stock purchase
-
401k contribution (all benefits are subject to eligibility requirements)
Application Deadline
This will be posted for a minimum of 2 business days or until a sufficient candidate pool has been collected. Job posting may come down early due to volume of applicants.