Senior Campaign Developer

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
o 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.