SQL Developer – General

Role- SR Developer – General

Location – Chicago, IL -Hybrid- Local only

Duration – 6 Months

MOI - Video

USC and GC only genuine

Strong Linkedin

Must have recent Healthcare payor experience

JOB FUNCTION:

This position will support clients 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 and analytical dashboards

• Write SQL queries to generate the output for the reporting dashboards

• Optimize or enhance the processes using PowerBI, Alteryx, Python or other languages/tools

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

Job Description

• ACA claims/membership experience

• 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, PowerBI, Alteryx, Python, and other analytical and visualization tools.

• Proficiency with advanced Excel features and techniques.

• 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 thrive in a dynamic environment with tight deadlines and competing priorities

Thanks & Regards

Sahit Kashyap

Sr. Technical Recruiter

Phone: 571-416-8784 EXT : 377

Email: Sahit.kashyap@largetontech.com

LARGETON INC.

13800 Coppermine Rd, Herndon, VA 20171

Disclaimer: 

Largeton is an equalopportunity employer. There

is no discrimination based on race, colour,religion, sex, national origin, age,

disability, or any other protected status.

If you believe you have been treated unfairly, please contact our HR department

at hr@largeton.com.