Title: Developer - General - Hybrid
Description:
BASIC FUNCTION:
This position will support client 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.
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 skill
Ability to communicate ideas and results effectively
Ability to manage conflicting priorities and multiple projects concurrently
ACA claims/membership experience
Note :
Hybrid
Mandatory skills:
database design, database development, database administration,
data analysis, analytical reporting, claims, enrollment data,
VBA, Excel,
agile, scrum,
project methodologies, project lifecycle, project deployment,
SQL programming, SQL queries, DDL, DML,
software development lifecycle, unit acceptance testing, Teradata,
business requirements, business solutions, business process,
subqueries, recursive queries, stored procedure,
data accuracy, data quality, data integrity, data sets, data interpret,
aggregate functions, window aggregate functions, ordered analytical functions, ACA claims
VIVA USA is an equal opportunity employer and is committed to maintaining a professional working environment that is free from discrimination and unlawful harassment. The Management, contractors, and staff of VIVA USA shall respect others without regard to race, sex, religion, age, color, creed, national or ethnic origin, physical, mental or sensory disability, marital status, sexual orientation, or status as a Vietnam-era, recently separated veteran, Active war time or campaign badge veteran, Armed forces service medal veteran, or disabled veteran. Please contact us at for any complaints, comments and suggestions.
Contact Details :
Account co-ordinator: Nivas Palanisamy
VIVA USA INC.
3601 Algonquin Road, Suite 425
Rolling Meadows, IL 60008
;/p>