HI ,
My Name is Dushyant Singh and I am a Senior Technical Recruiter at Intellicept. I am reaching out to you on an exciting job opportunity with one of our clients.

SQL Developer

Location: Chicago, IL (onsite/hybrid) Dallas is ok-LOCAL

Contract

NO H1B/CPT

Please fill the table below when you send the resume

BASIC FUNCTION:

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;

Healthcare experience

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 togenerate 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

Many Thanks
Dushyant Singh