Find Jobs
IT Senior Data Warehousing Analyst
Troy, Michigan
Contract To Hire Position
It appears that you have already applied to this job.
Applied on September 18, 2020
Job Id #42952 Posted August 21, 2020

IT Data Warehousing Analyst
4-6 month
Contract - potential CTH

 Under the general direction of the Project Manager, Manager, or the Director, develops and enhances a data warehouse environment which includes data design, database architecture, metadata and repository creation. Provides direction and guidance to less experienced team members. Reviews data loaded into the data warehouse for accuracy. Responsible for the development, maintenance, and support of an enterprise data warehouse system and corresponding data marts. Troubleshoots and tunes existing data warehouse applications. Conducts research into new data warehouse applications and determines viability for adoption. Assists in establishing development standards. Evaluates existing subject areas stored in the data warehouse. Incorporates existing subject areas into an enterprise model. Creates new or enhanced components of the data warehouse.The responsibilities also include troubleshooting application issues and/or data issues when they arise. The Senior Data Warehousing Analyst is a leader in an IT team that is accountable for production support (including on-call duties in a 24x7 environment) as well as new projects.The ideal candidate will have significant experience using analytical skills to seek out, research and evaluate a variety of options to provide clients with high quality solutions that promote efficiency and enterprise-wide standardization. Must demonstrate the ability to mediate and bridge the relationship between technical and business stakeholders without compromising the needs of the solution users and the strategic goals of the organization.PRINCIPAL DUTIES AND RESPONSIBILITIES:· Subject matter expert (SME) in one or more applications’ capabilities and features for users, owners, and administrators of solutions.· Keeps abreast of new Tools & Technology and functionalities across the application(s).· Assists with developing the methods and procedures required to identify whether current business goals and objectives meet organizational needs.· Facilitates meetings with clients to gather and document requirements and explore potential solutions.TITLE: IT Senior Data Warehousing Analyst / Solution Architect Page: 2 of 3· Analyzes and documents client's business requirements and processes and communicates these requirements by constructing conceptual data and process models, including data dictionaries and volume estimates from organization.· Collaborates with work teams, departments, system leadership, staff, other IT groups, and technology vendors to define needs and facilitate solutions.· Provides input into developing and modifying systems to meet client needs and develops business specifications to support these modifications.· Creates test scenarios and develops test plans to be used in testing the business applications in order to verify that client requirements are incorporated in to the system design.· Assists in analyzing testing results throughout the project.· Participates in technical reviews and inspections to verify 'intent of change' is carried out through the entire project.· Assists in coordinating business analyst tasks on information technology projects, problem tickets and provide support to other team members.· Provides support, escalation response to production problem issues/errors. Performs root cause analysis and application resolution.· Provides on call second-level escalation response for client issues and problem tickets· Assists in providing time estimates for project related tasks.· Lead and conduct conference room pilots and demonstrations.· Demonstrate solutions to client in a workshop setting.· Promotes teamwork and leads by example.· Assignment of work and development of less experienced team members.· Ensure proper documentation and on-time delivery of all functional artifacts and deliverables.
Skills: · 7 years of applicable work experience required; 5 years applicable experience in a Healthcare setting preferred. Preferred technical experience includes strong knowledge of state-of-the-art software engineering approaches in design, build, test, debugging problems, and ongoing technical support, and ability to articulate examples of workflows and processes associated with that experience.· Experience with Epic Clarity and Epic Cogito is preferred.· Deep expertise with Microsoft Windows Server, SQL Server, TFS, SharePoint, .Net and SSIS technologies.· Experience with Unix operating systems and Oracle database is preferred.· Good understanding of HIPAA data Privacy and Security requirements.· Previous supervisory experience preferred.· Ability to be flexible and work analytically in a problem-solving environment.· Good organizational, multi-tasking, and time-management skills.· Excellent communication (written and oral) and interpersonal skills.· Proven ability to work independently and as a team member.· Experience with the System Development Life Cycle (SDLC). KNOWLEDGE, SKILLS AND ABILITIES REQUIRED:Must meet or exceed core customer service responsibilities, standards and behaviors as outlined in the HFHS’ Customer Service Policy and summarized below:? Communication ? Ownership? Understanding ? Motivation? Sensitivity ? Excellence? Teamwork ? RespectMust practice the customer skills as provided through on-going training and in-servicesMust possess the following personal qualities:? Be self-directed? Be flexible and committed to the team concept? Demonstrate teamwork, initiative and willingness to learn? Be open to new learning experiences? Accepts and respects diversity without judgment? Demonstrates customer service valuesWORKING CONDITIONS: Normal office environment with minimal exposure to noise, dust, or extreme temperatures
Keywords:
Education: Bachelor’s degree required; Advanced degree preferred.
Skills and Experience:
Required Skills:
DATA WAREHOUSING
SELF-DIRECTED
SUBJECT MATTER EXPERT
PROBLEM-SOLVING
SQL
Additional Skills:
DATA WAREHOUSE
DATABASE
DATABASE ARCHITECTURE
DOCUMENTATION
EPIC
HIPAA
INSPECTIONS
LIFE CYCLE
MAINTENANCE
METADATA
MICROSOFT WINDOWS
SDLC
SECURITY
SHAREPOINT
SME
SOFTWARE ENGINEERING
SQL SERVER
SYSTEM DEVELOPMENT
TECHNICAL SUPPORT
TEST PLANS
TRAINING
UNIX
B2B SOFTWARE
CUSTOMER SERVICE ORIENTED
DATABASES
MICROSOFT SHAREPOINT
MS SQL SERVER
PROJECT MANAGER

Horizontal is proud to be an Equal Opportunity and Affirmative Action Employer. We seek to provide employment opportunities to talented, qualified candidates regardless of race, color, sex/gender including gender identity and/or expression, national origin, religion, sexual orientation, disability, marital status, citizen status, veteran status, or any other protected classification under federal, state or local law.

In addition, Horizontal will provide reasonable accommodations for qualified individuals with disabilities. If you need to request a reasonable accommodation in order to complete the application or interview process, please contact hr@horizontal.com.

All applicants applying must be legally authorized to work in the country of employment.

Upload Your Resume

We accept .DOC, .DOCX, .PDF up to 10 MB.

We do not accept scanned documents, images, or resumes containing images and/or icons.

Password must contain:
  • minimum 10 characters

  • 1 uppercase letter

  • 1 lowercase letter

  • 1 numeric character

  • 1 special character (such as !, %, @, #)

  • Passwords match

EQUAL OPPORTUNITY EMPLOYMENT SURVEY

What is your gender?

What is your ethnicity? Select all that apply

What is your Veteran / U.S. Military Status?

Do you have a disability?

You are considered to have a disability if you have a physical or mental impairment or medical condition that substantially limits a major life activity, or if you have a history or record of such am impairment or medical condition.

Horizontal is proud to be an Equal Employment Opportunity/Affirmative Action Employer providing a drug-free workplace.

Success!

You have saved your first job! To see all your Saved Jobs, click here. Or continue scrolling through jobs and bookmark openings that catch your eye and apply for those jobs later.

Return to Job Search
Close
X
Cookies help us improve your website experience.
By using our website, you agree to our use of cookies.
Confirm