BASIC FUNCTION:
This position will support Client's Individual and Family Market Risk Adjustment division. The incumbent will be responsible for the planning, development, analysis, and implementation of procedures and/or processes to ensure accurate claims and enrollment data are submitted to the government;
Primary duties may include, but are not limited to:
• Support and experience full project / software development lifecycle
• Analyze business requirements and assist in designing business solutions
• Perform unit acceptance testing of solutions developed by IT team
• Perform post-implementation verification after project deployment
• Write SQL queries to illustrate the issue or test the solutions
• Assist in the documentation of business processes
• Develop and maintain optimized data warehouses
• Design and develop data warehouses on Teradata using utilities such as Fast Load, Multi Load, Fast export, BTEQ.
• Use SQL programming (DDLs, DMLs, aggregate/window aggregate/ordered analytical functions) in the creation and maintenance of the data mart
• Use complex correlated subqueries, recursive queries, stored procedures to support the data mart
• Develop and maintain management reporting dashboards
• Write SQL queries to generate the output for the reporting dashboards
• Optimize or enhance the reporting dashboards using VBA or other programming languages
• Perform data analysis, data profiling and research to support business initiatives or solve data issues
• Perform root cause analysis of errors and recommend solutions
• Manipulate large data sets and interpret results using data aggregation functions
• Validate data to ensure accuracy, quality and integrity
• Collaborate with internal and external partners in establishment, design and execution of business rules
• Demonstrate ownership and accountability on assigned projects
• Work with minimal supervision
• Contribute to best practices.
Additional Job Description
• Advanced SQL programming skills.
• Experience with Teradata or other database systems
• Experience in database design/development, database administration, and business intelligence
• Experience in data analysis and analytical reporting
• Proficiency with advanced Excel features and techniques; VBA skills desired
• Familiarity with agile/scrum or other project methodologies
• Strong analytical and problem solving skills
• Strong leadership and collaboration skills
• Ability to communicate ideas and results effectively
• Ability to manage conflicting priorities and multiple projects concurrently
• ACA claims/membership experience
