Senior Campaign Developer

Role Description The Community and State, Program Orchestration – Manager Data Analytics will work with C 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 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.