At Dearborn, our employees are the cornerstone of our business and the foundation to our success. We empower employees with curated development plans that foster growth and promote rewarding, fulfilling careers.
Join HCSC and be part of a purpose-driven company that will invest in your professional development.
Job Summary
This position is responsible for gathering and assessing business enhancement needs and preparing system requirements. Create test plans and test cases, conduct testing and coordinate deployment with it. Perform analysis, development and evaluation of data mining in a data warehouse environment; including data design. Use data management tools to review and validate data loaded into the data warehouse for accuracy. Investigate problems and develop recommendations for resolution. Generate ad hoc reports and regular datasets or report information for end-users using system tools and database or data warehouse queries. Research, document business rules for each network partner. Provide technical consulting to users of the data warehouses and advises users on conflicts and inappropriate data usage. Responsible for extraction, loading, and fixing data issues. Responsible for the maintenance of network partner provider data load in database management tool. Establish detailed process documentation and validation best practices for all data processes.
Required Job Qualifications:
- Bachelor degree and 3 years of data analysis and manipulation OR 8 years of data analysis and manipulation.
- 3 year experience in SQL or VBA
- Experience with relational database concepts, and the creation of queries and reports using SQL or reporting tools.
- Analytical, conceptual and root cause analysis skills.
- Experience working or multiple projects simultaneously both independently and as part of a team to accomplish goals.
- Clear and concise verbal and written communication and people skills.
- Experience developing reports using software such as Microsoft Excel, Microsoft Access.
- Strong problem-solving skills and critical thinking ability.
- Schedule driven and focused on best quality data delivery with keen eye for details.
- Project management and leadership skills.
- Organized and methodical with good time management skills.
- Ability to work independently and as a team player.
- Ability to manage conflicting priorities and multiple projects concurrently.
Preferred Job Qualifications:
- Healthcare Industry experience.
Are you being referred to one of our roles? If so, ask your connection at HCSC about our Employee Referral process!
Dearborn Group Employment Statement:
We are an Equal Opportunity Employment / Affirmative Action employer dedicated to providing an inclusive workplace where the unique differences of our employees are welcomed, respected, and valued. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, protected veteran status, or any other legally protected characteristics.
Base Pay Range$53,500.00 - $118,100.00
Top Skills
What We Do
Dearborn Group is the trade name for Dearborn Life Insurance Company. Since 1969, we have been providing ancillary benefits to employer groups across the country.
When combined with medical coverage, our suite of employer-paid and voluntary insurance solutions—life, short- and long-term disability, vision, critical illness and accident insurance—creates a comprehensive benefits package and gives employers, their employees, and their families complete peace of mind.
Dearborn Group insurance products are issued by Dearborn Life Insurance Company, 701 E. 22nd St. Suite 300, Lombard, IL 60148.