Database Warehouse Analyst jobs in Michigan

Database Warehouse Analyst designs and supports data warehouse systems, maintenance processes, and projects. Designs and writes code for ETL data solutions. Being a Database Warehouse Analyst plans and executes data warehouse implementations following system requirements and anticipated usage. Performs data extraction, ensures data accuracy, troubleshoots, and resolves bugs during data warehouse operations. Additionally, Database Warehouse Analyst analyzes business intelligence data and designs and generates reports. Understands and utilizes ETL tools like Informatica and programming languages like Python. Acts as liaison between information technology and business units. Requires a bachelor's degree. Typically reports to a manager. The Database Warehouse Analyst work is closely managed. Works on projects/matters of limited complexity in a support role. To be a Database Warehouse Analyst typically requires 0-2 years of related experience. (Copyright 2024 Salary.com)

H
CIT - Database Programmer/Analyst
  • Hope College
  • Holland, MI FULL_TIME
  • Position Title
    CIT - Database Programmer/Analyst

    Classification Title
    Administrative Full Time (.75-1.0 FTE)

    Benefits Eligibility
    Benefits Eligibility

    Department
    Computing and Information Technology

    Job Description

    Position Mission and Summary

    Hope College is seeking a Database Programmer/Analyst with a developer background to help us create and maintain efficient integration of data between several software systems while also working to develop data structures that support institutional reporting and analytics. Part of a small team of developers and project managers within the IT department, we want someone who will also collaborate with larger, cross-functional teams to modernize and transform the college’s data, integrations, and business intelligence infrastructure.

    Responsibilities and Outcomes

    Collaboratively with the data and project management teams, you will:

    Develop

    • Developing Extract/Transform/Load (ETL) processes to move data between enterprise systems and business resources.
    • Creating new or changing existing data sources for administrative departments to utilize with business processes and practices.
    • A partner in the implementation/development of new software as directed by management.
    • Constantly learning about rising technologies and aid in determining their appropriate use.
    • Demonstrated Outcomes:
      • Help create new integration processes for the data warehouse and other third party software.
      • Be able to identify key data structures at Hope College.
      • Create foundational reporting data structures in the enterprise reporting platform(s).
      • Collaborate with teams outside of CIT to help new software implementations be successful.


    Maintain

    • Maintaining data integration processes between Ellucian Banner, Slate CRM, and other campus data systems using standard ETL tools.
    • Working to understand and document business processes, data definitions, and existing data structures for the ERP and other third party systems.
    • Assisting in quality assurance efforts to maintain accuracy of data and the data dictionary.
    • Demonstrated Outcomes:
      • In a timely manner, troubleshoot and resolve data integration issues across Hope systems.
      • Provide documentation on processes developed by the employee or support that has been given to other areas of the college.
      • Create and maintain appropriate test strategies for Hope systems.


    IT is a constantly changing profession, and this position reflects that! As newer technologies and best practices surface, the responsibilities of this job description may change depending on new projects you would be working on.

    Hope College CIT has a culture and history of supporting other areas of the college during times of high volume and change. There are times you may be asked to work with other areas of the college. You are someone who embraces this type of work.

    Remote work option of up to two days a week available after initial orientation and training

    Qualifications
    • Qualifications and Core Competencies

      • You are familiar with ERP (Enterprise Resource Planning) systems and databases. Ellucian Banner is the system Hope uses, which is preferred.
      • We would love to see someone that has knowledge of Oracle SQL, Microsoft SQL, and/or ETL experience.
      • Microsoft SSIS is the current integration platform we use. Experience with that would be beneficial, but not required.
      • You are comfortable with Business Intelligence platforms. Argos, Tableau, Cognos, Microsoft Power BI, or similar Business Intelligence reporting experience is a plus.
      • You know programming languages, familiarity with C#, Visual Basic .NET, Google Apps Script, and especially Python are a plus. You are able to navigate through a Linux command line.
      • You know how to use office productivity tools such as Microsoft products or Google Workspace.
      • Analytical Skills: You are able to structure and process qualitative or quantitative data and draw insightful conclusions from it. You love to dig deep into problems and achieve penetrating insights.
      • Attention to Detail: You have a handle on the little things and don’t let details derail or slow down a project.
      • Communication: You are consistent in written and spoken words. You care about being articulate and clear.
      • Creativity/Innovation: When thinking about a problem, you approach the issue in a way that is innovative and new.
      • Efficiency: You care about your time and Hope’s time, you are able to produce significant output with minimal wasted effort.
      • Enthusiasm: This kind of work excites you. You are passionate about your work and are willing to take initiative on both tasks assigned and problems that you recognize.
      • Flexibility/Adaptability: You are agile. When the work calls for it, you can pivot quickly and adjust your priorities as well as cope with change.
      • Honesty/Integrity: You do not cut corners, are ethical and earn trust as well as maintain confidence. You do what is RIGHT, not just what is politically expedient. Speaking plainly and truthfully is important to you.
      • Intelligence: Your grasp of new information is quick and you are able to retain/understand new knowledge in a fast paced environment.
      • Listening skills: It is important to you to let others speak first. Understanding their viewpoints is critical. You listen to understand instead of listen to debate.
      • Openness to criticism and ideas: You often solicit feedback and react calmly to constructive criticism.
      • Teamwork: You are not an island. You reach out to peers and cooperate with supervisors to establish an overall collaborative working relationship.
      • Associate’s Degree or equivalent experience required; Bachelor’s Degree preferred; Computer Science or IT-related major, minor, or coursework preferred.


    Physical Demands
    This position requires remaining in a sitting or standing position for frequent periods of time; uses office machinery such as a computers, printers, copy machines; Occasionally involves moving items over 10 pounds; frequently will move between different offices/workspaces/buildings; and requires effective communication abilities. In the case of temporary or permanent condition(s) that require(s) accommodation(s), reasonable accommodation(s) may be requested.

    Pre-employment Screenings
    All offers of employment are contingent upon a background check. Some positions may have position specific requirements, such as education/licensure/certification verification, a physical, drug screening, credit checks and/or transportation record review.

    Posting Detail Information

    Posting Number
    2023-187SR

    Job Posting Open Date
    12/13/2023

    Job Posting Close Date

    Open Until Filled
    Yes

    Is this position available for sponsorship
    No

    Special Instructions to Applicants


    Documents Needed to Apply

    Required Documents
    • Resume
    • Cover Letter
    Optional Documents

  • 20 Days Ago

W
Application Database Analyst
  • WAYNE RESA
  • Wayne, MI FULL_TIME
  • Application Database Analyst (Job ID: 23458)Please see the links below for more information!Job Posting - https://www.applitrack.com/resa/onlineapp/admin/BrowseFile.aspx?id=447516Job Description - htt...
  • 1 Day Ago

M
Sr Database Analyst Programmer
  • MyMichigan Health
  • Midland, MI CONTRACTOR
  • SummaryUnder general direction provides technical expertise in the implementation and maintenance of relational database systems in support of related applications. Resolves complex database and appli...
  • 1 Month Ago

D
Student Loan Program Analyst 12
  • Departmental Analyst 9-P11
  • Lansing, MI FULL_TIME
  • Salary $27.67 - $40.44 Hourly Location Lansing, MI Job Type Permanent Full Time Remote Employment Flexible/Hybrid Job Number 2701-24-21-6 Department Treasury Opening Date 04/15/2024 Closing Date 4/29/...
  • Just Posted

I
Student Assistant
  • Info. Tech Programmer Analyst 12 - Process Analyst...
  • Jackson, MI FULL_TIME
  • Salary $10.33 - $27.06 Hourly Location Jackson, MI Job Type Non Career Job Number 1901-24MD-147DOC-JXN Department Civil Service Commission Opening Date 04/19/2024 Closing Date 4/26/2024 11:59 PM Easte...
  • Just Posted

S
Departmental Analyst 9-12 (Veteran Service Officer - Wayne County)
  • Student Loan Program Analyst 12
  • Dearborn, MI FULL_TIME
  • Salary $23.90 - $40.44 Hourly Location Dearborn, MI Job Type Permanent Full Time Job Number MVAA-24-111 Department Military and Veterans Affairs Opening Date 04/15/2024 Closing Date 4/29/2024 11:59 PM...
  • Just Posted

T
Warehouse Analyst
  • TekWissen ®
  • Milan, IL
  • Job Title: Warehouse Analyst Duration: 18 Months Location: Milan, IL, 61264 Job Type: Contract Work Type: Onsite Note: V...
  • 4/26/2024 12:00:00 AM

D
Warehouse Analyst
  • Do & Co Ag
  • Queens Village, NY
  • We have an incredible opportunity for a dynamic, inspirational Warehouse Analyst to join our New York team In case you d...
  • 4/26/2024 12:00:00 AM

I
Warehouse Analyst
  • ICONMA, LLC
  • Milan, IL
  • Our Agriculture Equipment Client is looking for an experienced Warehouse Analyst in Milan, IL Description Responsible fo...
  • 4/26/2024 12:00:00 AM

C
Warehouse Analyst
  • Compunnel Inc.
  • Woodland, CA
  • The purpose of this position is: The manufacturing / warehouse Associate will be responsible for the day to day manufact...
  • 4/25/2024 12:00:00 AM

L
Warehouse Analyst
  • LX Pantos America, Inc
  • Englewood Cliffs, NJ
  • Company Name: LX Pantos America, Inc. Job Title: Warehouse Analyst Grade/Title: Manager (G3A) CORE ROLES & RESPONSIBILIT...
  • 4/25/2024 12:00:00 AM

D
Warehouse Analyst
  • DO & CO AG
  • Queens, NY
  • We have an incredible opportunity for a dynamic, inspirational Warehouse Analyst to join our New York team. In case you ...
  • 4/22/2024 12:00:00 AM

L
Warehouse Analyst
  • Lx Pantos America Inc
  • Englewood Cliffs, NJ
  • Company Name LX Pantos America, Inc. Job Title Warehouse Analyst Grade/Title Manager (G3A) CORE ROLES & RESPONSIBILITIES...
  • 4/22/2024 12:00:00 AM

C
Warehouse Analyst
  • Compunnel Inc.
  • Woodland, CA
  • The purpose of this position is: The manufacturing / warehouse Associate will be responsible for the day to day manufact...
  • 4/22/2024 12:00:00 AM

Michigan consists of two peninsulas that lie between 82°30' to about 90°30' west longitude, and are separated by the Straits of Mackinac. The 45th parallel north runs through the state—marked by highway signs and the Polar-Equator Trail—along a line including Mission Point Light near Traverse City, the towns of Gaylord and Alpena in the Lower Peninsula and Menominee in the Upper Peninsula. With the exception of two small areas that are drained by the Mississippi River by way of the Wisconsin River in the Upper Peninsula and by way of the Kankakee-Illinois River in the Lower Peninsula, Michigan...
Source: Wikipedia (as of 04/11/2019). Read more from Wikipedia
Income Estimation for Database Warehouse Analyst jobs
$66,306 to $85,028