Sr Informatics Consultant

This position is responsible for gathering and assessing business information needs and preparing system requirements. Performs analyses, development and evaluation of data mining in a data warehouse environment which includes data design, database architecture, metadata and repository creation. Uses data mining and data analysis tools. Reviews and validates data loaded into the data warehouse for accuracy. Generates ad hoc reports and regular datasets or report information for end-users using system tools and database or data warehouse queries and scripts. Integrates data from multiple sources to produce requested or required data elements. Programs and maintains report forms and formats, information dashboards, data generators, canned reports and other end-user information portals or resources. May create specifications for reports based on business requests. Interacts with user community to produce reporting requirements. Provides technical consulting to users of the various data warehouses and advises users on conflicts and inappropriate data usage. Responsible for prototyping solutions, preparing test scripts, and conducting tests and for data replication, extraction, loading, cleansing, and data modeling for data warehouses. Maintains knowledge of software tools, languages, scripts, and shells that effectively support the data warehouse environment in different operating system environments. Possesses working knowledge of Relational Database Management Systems (RDBMS) and data warehouse front-end tools. Must have an extensive knowledge of data warehouse and data mart concepts.


•Bachelor Degree and 4 years experience with data analysis and manipulation OR 6 years experience with data analysis and manipulation to include experience in leading and management of project tasks.
•5 years experience in SQL or other BASIC programming language.
•6 years of data analysis and information reporting experience, including 3 years obtaining an understanding of information repository issues and concepts.
•Experience in JAD (joint application design) facilitation or other requirements gathering techniques.
•Demonstrated ability to communicate technical concepts to non-technical audiences both in written and verbal form.
•Experience in development implementations, data modeling, or data mapping efforts.
•Experience creating clear and concise project documentation.
•Knowledge of relational database concepts, and the creation of queries and reports using SQL or reporting tools (i.e., Cognos).
•Understanding of data elements as they relate to data quality requirements.
•Strong analytical, conceptual and root cause analysis skills.
•Ability to work on multiple projects simultaneously both independently and as part of a team to accomplish goals.
•Strong interpersonal, presentation, verbal, written and communication skills.
•Experience using statistical concepts with an ability to apply to informatic reporting.
•Requires specialized depth and/or breadth of expertise
•Interprets internal or external business issues and recommends best practices
•Takes initiative to solve complex problems; takes an outside in perspective to identify innovative solutions
•Works independently, with guidance in only the most complex situations
•May lead functional teams or projects
•or decisions to support this awareness; knows how to use the formal and informal systems to get things done.


•Analytical thinking.
•Communication for results.
•Conceptual thinking.
•Information seeking.
•Openness to learning.
•Results oriented.
•Teamwork mindset.

HCSC is committed to diversity in the workplace and to providing equal opportunity and affirmative action to employees and applicants. We are an Equal Opportunity Employment / Affirmative Action employer dedicated to workforce diversity and a drug-free and smoke-free workplace. Drug screening and background investigation are required, as allowed by law. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or protected veteran status.
Requirements: Expertise Information Technology Job Type Full-Time Regular Location IL - Chicago, TX - Richardson

Meet Some of HCSC's Employees

Allison M.

Internal Auditor

Allison audits operational and financial data throughout the business, helping to expose and mitigate risks, ensure compliance, and add value to HCSC’s operations as a whole.

Rosa Y.

Claims Examiner

Rosa works to process claims that stop due to system edits—researching the edits, correcting the errors, and completing the claims to help members and providers get paid.

Back to top