Data Warehouse Analyst

The Ohio State University Columbus , OH 43216

Posted 2 months ago

Screen reader users may encounter difficulty with this site. For assistance with applying, please contact hr-accessibleapplication@osu.edu. If you have questions while submitting an application, please review these frequently asked questions.

Current Employees and Students:

If you are currently employed or enrolled as a student at The Ohio State University, please log in to Workday to use the internal application process.

Welcome to The Ohio State University's career site. We invite you to apply to positions of interest. In order to ensure your application is complete, you must complete the following:

  • Ensure you have all necessary documents available when starting the application process. You can review the additional job description section on postings for documents that may be required.

  • Prior to submitting your application, please review and update (if necessary) the information in your candidate profile as it will transfer to your application.

Job Title:

Data Warehouse Analyst

Department:

Health System Shared Services | Information Warehouse

Job Description

POSITION SUMMARY

Under direct supervision, assists in the data design, database architecture, metadata and repository creation. Designs and develops Extract-Transform-Load (ETL) processes for the data warehouse. Reviews data loaded into the data warehouse for accuracy. Assists in the troubleshooting and tuning of existing data warehouse applications. Assists in the development, maintenance, and support of an enterprise data warehouse system and corresponding data marts. Assists in creating new or enhanced components of the data warehouse.

Minimum Education Required

Bachelor's Level Degree

Required Qualifications

  • A college degree in Computer Science or equivalent combination of education and experience

  • Typically has 0-4 years of experience in Information Technology (preferably experience in Data Warehousing)

  • Experience interacting with customers to gather and understand their business and technical requirements

  • Experience with data modeling tools (ERStudio preferred)

  • Experience querying relation database management systems - Microsoft SQL Server 2017 and above preferred

  • Hands on experience in ETL tools, Microsoft SQL Server Integration Services (SSIS) 2014 or above or similar tools is preferable

  • Work experience in developing technical and user documentation.

  • Knowledge and experience with hospital systems and business practices

  • Stay abreast of technological trends as well as healthcare technology trends

Additional Information:

Location:

Ackerman Rd, 640 (2432)

Position Type:

Regular

Scheduled Hours:

40

Shift:

First Shift

Final candidates are subject to successful completion of a background check. A drug screen or physical may be required during the post offer process.

Thank you for your interest in positions at The Ohio State University and Wexner Medical Center. Once you have applied, the most updated information on the status of your application can be found by visiting the Candidate Home section of this site. Please view your submitted applications by logging in and reviewing your status. For answers to additional questions please review the frequently asked questions.

The Ohio State University is an equal opportunity employer.

All qualified applicants will receive consideration for employment without regard to age, ancestry, color, disability, ethnicity, gender identity or expression, genetic information, HIV/AIDS status, military status, national origin, race, religion, sex, gender, sexual orientation, pregnancy, protected veteran status, or any other basis under the law.

Applicants are encouraged to complete and submit the Equal Employment Identification form.


icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Business Analyst Data Warehouse

Nationwide Children's Hospital

Posted 3 weeks ago

VIEW JOBS 9/13/2022 12:00:00 AM 2022-12-12T00:00 <p>Overview</p><p>Business Analyst - Data Warehouse</p><p>The Business Analyst is responsible for gathering and understanding clinical and business customer requirements that define the overall architecture of systems. This position will directly support the IS Applications Architect design team which provides the discipline to ensure that investments in process, information and technology support the hospital's strategic goals. This position must have a broad view of enterprise systems and infrastructures, and should have a strong understanding of the healthcare business and an understanding of healthcare technologies. The Business Analyst assists in the development of a long term strategic vision that is used as a context for short-term tactical decisions. The Business Analyst supports the Applications team to create solutions that have affordable and sustainable IT architectures that solve business problems. A Business Analyst should look for interoperable solutions that optimize resources and produce required outcomes. The Business Analyst assists in researching and promoting new technology and industry best practices. The Business Analyst also facilitates change to maximize value and minimize effort.</p><p>The Business Analyst will be responsible for providing leadership, guidance, and direction to Information Services management, staff and business leaders.</p><p>Schedule: (Full-time, Benefits Eligible)</p><p>Location:</p><p>Near East Office Building431 S. 18th StreetColumbus, Ohio 43205</p><p>Why Nationwide Children's Hospital?</p><p>The moment you walk through our doors, you feel it. When you meet our patient families, you believe it. And when you talk with anyone who works here, you want to be part of it. Welcome to Nationwide Children's Hospital, Where Passion Meets Purpose.</p><p>Here, Diversity, Equity and Inclusion are integrated into our core values and practices. We are passionate about building, sustaining and evolving an inclusive and equitable environment. We are seeking individuals who live these values and want to share their experiences and efforts in support of our collective mission.</p><p>We're 14,000 strong. And it takes every one of us to improve the lives of the kids we care for, and the kids around the world we'll never meet. Kids who live healthier, fuller lives because of the knowledge we share. We know it takes a Collaborative Culture to deliver on our promise to provide the very best, innovative care and to foster new discoveries, made possible by the most groundbreaking research. Anywhere.</p><p>Ask anyone with a Nationwide Children's badge what they do for a living. They'll tell you it's More Than a Job. It's a calling. It's a chance to use and grow your talent to make an impact that truly matters. Because here, we exist simply to help children everywhere.</p><p>Nationwide Children's Hospital. A Place to Be Proud.</p><p>Responsibilities</p><ul><li><p>Create and modify existing templates to clearly document business requirements, business cases, new project requests, and all the functional and non-functional requirements.</p></li><li><p>Develop requirements documentation in accordance with industry standard and NCH IS specific methodologies.</p></li><li><p>Assist in documenting business requirements to provide detailed cost estimates for new Capital requests and operating funded requests.</p></li><li><p>Creates business case, project charter, business requirements documentation, traceability matrix, presentations, use cases, story cards, and other business analyst documentation deliverables to drive decisions, scope approvals, build, testing, and funding approvals.</p></li><li><p>Assists project managers as needed on defining current and future state process maps, business requirement documentation, and identifying measurable project goals that aligns with the business objectives.</p></li><li><p>Facilitate meetings to detail out current and future state business processes, functional and non-functional requirements, stakeholder needs assessments, and cost/benefit analysis to align information technology solutions with business strategies.</p></li><li><p>Conduct the analysis of business processes and user needs, defines business requirements, and assists in the recommendation of appropriate solutions.</p></li><li><p>Responsible for smaller work streams, on large, complex, and program level projects.</p></li><li><p>Organize and facilitate testing and RFP processes.</p></li></ul><p>Qualifications</p><p>KNOWLEDGE, SKILL AND ABILITIES REQUIRED</p><ul><li><p>3 to 5 years of experience in requirements analysis, project management, and systems implementations.</p></li><li><p>One to three years previous healthcare experience desirable</p></li></ul><p>EOE/M/F/Disability/Vet</p><br> Nationwide Children's Hospital Columbus OH

Data Warehouse Analyst

The Ohio State University