at Health Care Service Corporation in Chicago, Illinois, United States
Job Description
At HCSC, we consider our employees the cornerstone of our business and the foundation to our success. We enable employees to craft their career with curated development plans that set their learning path to a rewarding and fulfilling career.
Come join us and be part of a purpose driven company who is invested in your future!
Job Summary
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.
JOB REQUIREMENTS:
* Bachelor's degree and 2 years' experience with data analysis and manipulation OR 4 years' experience with data analysis and manipulation.
* 2 years' experience in SQL or BASIC programming language.
* 2 years of data analysis and information reporting experience.
* Knowledge of relational database concepts, and the creation of queries and reports using SQL or reporting tools (i.e., Cognos).
* 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.
* Requires knowledge and experience in own function; still acquiring higher-level knowledge and skills
* Builds own knowledge of HCSC, business processes and customers
* Solves a range of problems
* Analyzes possible solutions using standard procedures
* Receives a moderate level of guidance and direction
PREFERRED REQUIREMENTS:
* Analytical Thinking: Approaches a problem by using a logical, systematic, sequential approach; makes a systematic comparison of two or more alternatives; notices discrepancies and inconsistencies in available information; identifies a set of features, parameters or considerations to take into account, in analyzing a situation or making a decision; approaches a complex task or problem by breaking it down into its component parts and considering each part in detail; weighs the costs, benefits, risks and chances for success, in making a decision identifies many possible causes for a problem; carefully weighs the priority of things to be done.
* Communication for Results: Fosters two-way communication; recalls others' main points and takes them into account in own communication; checks own understanding of others' communication; elicits comments or feedback on what has been said; maintains continuous open and consistent communication with others.
* Conceptual Thinking: Uses rule of thumb to understand a situation or problem by putting the pieces together, seeing the large picture; identifies patterns or connections between situations that are not obviously related; identifying key or underlying issues in complex situations.
* Information Seeking: Recognizes and interprets the information problem; establishes a plan of search; conducts the search; evaluates the results, and if... For full info follow application link.
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.
