Database Warehouse Analyst jobs in Grand Rapids, MI

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

  • 14 Days Ago

A
Amazon XL Warehouse Associate
  • Amazon Warehouse
  • Caledonia, MI PART_TIME,OTHER
  • Shift: Flexible Shifts Duration: Seasonal Start Date: 2024-04-17 Amazon XL Warehouse Associate Job Overview You’ll be part of the Amazon warehouse team that handles the big stuff – those unique custom...
  • 25 Days Ago

A
Amazon Warehouse Worker - Anytime Pay
  • Amazon Warehouse
  • Caledonia, MI FULL_TIME
  • Shift: Thu, Fri, Sat 06:30pm - 07:00am Duration: REDUCED_TIME Start Date: 2023-06-08 Amazon Fulfillment Center Warehouse Associate Job Overview You’ll be part of the Amazon warehouse team that gets or...
  • 23 Days Ago

A
Warehouse Worker - Anytime Pay - Day Shifts Available
  • Amazon Warehouse
  • Caledonia, MI FULL_TIME
  • Amazon Fulfillment Center Warehouse Associate Job Overview You’ll be part of the Amazon warehouse team that gets orders ready for customers relying on Amazon services. Our fast-paced, physical roles t...
  • 7 Days Ago

M
Team Leader- USA
  • Mountain Warehouse
  • Grand Rapids, MI OTHER
  • * 50% employee discount* * monthly bonus program * employee referral incentive *leading outdoor retailer* About the role Our Team Leaders support the management team with the everyday running of a bus...
  • 1 Month Ago

M
Team Leader
  • Mountain Warehouse
  • Grand Rapids, MI FULL_TIME
  • * 50% employee discount* *monthly bonus program* employee referral incentive *leading outdoor retailer* About the role Our Team Leaders support the management team with the everyday running of a busy ...
  • 1 Month Ago

Filters

Clear All

Filter Jobs By Location
  • Filter Jobs by companies
  • More

0 Database Warehouse Analyst jobs found in Grand Rapids, MI area

W
Inventory Specialist
  • WALGREENS
  • Grand Rapids, MI
  • Responsible for executing, monitoring, and training inventory best practices and standard operating procedures for the e...
  • 4/19/2024 12:00:00 AM

A
Supervisor, Operations I
  • ArcBest
  • Grand Rapids, MI
  • Now is your chance to join one of the country's largest and most trusted LTL carriers: ABF Freight is looking for new te...
  • 4/19/2024 12:00:00 AM

U
CDL-A OTR Team Drivers - Top Team Pay + Great Benefits
  • U.S. Xpress
  • Grand Rapids, MI
  • U.S. Xpress is Now Hiring CDL-A OTR Team Drivers! CDL-A Teams: Top Team Pay in the Nation & Up To $15,000 Sign-On Bonus/...
  • 4/19/2024 12:00:00 AM

K
CDL-A Truck Driver - Multiple Routes Available + Competitive Pay
  • KAG Specialty Products
  • Grand Rapids, MI
  • Now Seeking CDL-A Company Drivers! Local, Regional and OTR Routes Available - Excellent Benefits KAG Specialty Products,...
  • 4/19/2024 12:00:00 AM

W
Warehouse Associate
  • Walmart
  • Grand Rapids, MI
  • **Job Summary:** As a Warehouse Associate at Walmart, you will play a crucial role in the efficient operation of the dis...
  • 4/19/2024 12:00:00 AM

U
CDL-A Delivery Driver (Grand Rapids)
  • US Foods, Inc.
  • Grand Rapids, MI
  • BECOME A US FOODS® DRIVER! Ready to build a career with a company that’s leading the foodservice industry? We help YOU m...
  • 4/18/2024 12:00:00 AM

A
Delivery Driver (Part-Time)
  • Autozone
  • Grand Rapids, MI
  • Come be a part of an energizing culture rooted in people and a commitment to delivering WOW! customer service. If you ar...
  • 4/18/2024 12:00:00 AM

A
Business Intelligence Architect
  • Akkodis
  • Grand Rapids, MI
  • Akkodis is working with a top client that is looking to hire a skilled Business Intelligence Architect to their team to ...
  • 4/17/2024 12:00:00 AM

Grand Rapids is the second-largest city in Michigan, and the largest city in West Michigan. It is on the Grand River about 30 miles (48 km) east of Lake Michigan. As of the 2010 census, the city population was 188,040. In 2010, the Grand Rapids metropolitan area had a population of 1,005,648, and the combined statistical area of Grand Rapids-Muskegon-Holland had a population of 1,321,557. Grand Rapids is the county seat of Kent County. A historic furniture-manufacturing center, Grand Rapids is home to five of the world's leading office furniture companies, and is nicknamed Furniture City. Its ...
Source: Wikipedia (as of 04/11/2019). Read more from Wikipedia
Income Estimation for Database Warehouse Analyst jobs
$65,164 to $83,564
Grand Rapids, Michigan area prices
were up 1.3% from a year ago