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 BASIC FUNCTION:
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: Anticipates the implications and consequences of situations and takes appropriate action to be prepared for possible contingencies; anticipates possible problems and develops contingency plans in advance; notices trends in the industry or marketplace and develops plans to prepare for opportunities or problems; anticipates the consequences of situations and plans accordingly; anticipates how individuals and groups will react to situations information and plans accordingly.
*Communication for Results: Adapts communication; tailors communication to diverse audiences; reads cues from diverse listeners to assess when and how to change planned communication approach to effectively deliver message; communicates equally effectively at varied organizational levels; understands others underlying needs, motivations, emotions or concerns and communicates effectively despite the sensitivity of the situation.
*Conceptual Thinking: Sees crucial differences between current situation and things that have happened before; quickly identifies the central or underlying issues in a complex situation.
*Information Seeking: Recognizes and interprets the information problem; establishes a plan of search; conducts the search; evaluates the results, and if necessary, iterates through the process again.
*Initiative: Plans work and carries out takes without detailed instructions; makes constructive suggestions; prepares for problems or opportunities in advance; undertakes additional responsibilities; responds to situations as they arise with minimal supervision; creates novel solutions to problems; evaluates new technology as potential solutions to existing problems
*Openness to Learning: Works to improve the performance of oneself and others by pursuing opportunities for continuous learning/feedback; constructively helps and coaches others in their professional development; exhibits a "can-do" approach and inspires associates to excel; develops a team spirit.
*Results Orientation: Focuses on the desired end results of ones own or ones units work; sets challenging goals; focuses effort on the goals, and meets or exceeds them; develops challenging but achievable goals; develops clear goals for meetings and projects; maintains commitment to goals in the face of obstacles and frustrations; finds or creates ways to measure performance against goals; exerts unusual effort over time to achieve a goal; has a strong sense of urgency about solving problems and getting work done.
*Teamwork: Reinforces team members for their contributions; works for solutions that all team members can support; shares expertise with others; seeks opportunities to work on teams as a means to develop experience and knowledge; provides assistance, information, or other support to others, to build or maintain relationships with them.
*Thoroughness: Double-checks the accuracy of information and work product to provide accurate and consistent work; provides information on a timely basis and in a usable form to others who need to act on it; carefully monitors the details and quality of own and others work; expresses concern that things be done right, thoroughly, or precisely; completes all work according to procedures and standards.
*Understanding Environment: Demonstrates awareness of general goals and makes requests.
Relocation assistance will not be provided for this position.
Sponsorship will not be provided for this position.
We encourage people of all backgrounds and experiences to apply. Even if you don't think you are a perfect fit, apply anyway - you might have qualifications we haven't even thought of yet.
Are you being referred to one of our roles? If so, ask your connection at HCSC about our Employee Referral process!HCSC Employment Statement:
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.
Apply on company website