Data Warehouse Specialist jobs in Des Moines, IA

Data Warehouse Specialist performs technical administration duties for the development and maintenance of data warehouses. Provides technical support and coordination during warehouse design, testing and movement to production. Being a Data Warehouse Specialist acts as a liaison between engineers, data architects, programmers, and analysts. Implements and enforces standards and procedures to ensure data is managed consistently and properly integrated within the warehouse. Additionally, Data Warehouse Specialist manipulates and combines data from various sources to enlarge and enhance the data warehouse. Requires a bachelor's degree. Typically reports to a manager or head of a unit/department. The Data Warehouse Specialist work is generally independent and collaborative in nature. Contributes to moderately complex aspects of a project. To be a Data Warehouse Specialist typically requires 4 -7 years of related experience. (Copyright 2024 Salary.com)

D
Senior Data Warehouse Analyst
  • Delta Dental of Iowa
  • Johnston, IA FULL_TIME
  • Description

    Come Smile with Us!


    Are you a seasoned data warehouse expert looking to make a change? Join our team as a Senior Data Warehouse Analyst, where your expertise will drive impactful insights to support our mission-driven initiatives. You will be a significant contributor in the design, development and implementation of Delta Dental’s data warehouse and business intelligence environment. This is an opportunity to serve as a key technical resource within the data and reports team and as an advocate to both business and technical employees regarding data warehouse benefits and best practices, as applicable. 


    Your primary responsibility will be to drive the continued maturity of the company’s warehouse environment through the design, implementation and ongoing enhancement of data warehouse constructs within a SQL server environment. Key to that effort is the analysis and definition of a flexible and robust data model which is neutral with respect to the choice of data analysis approach and toolset. In this role, you will enjoy the flexibility of a hybrid working environment, blending the benefits of remote work with collaborative opportunities in our office space.


    Why Delta Dental of Iowa?

    For your smile. For your health. For your community.


    At Delta Dental of Iowa, we’re more than just a dental and vision insurance company. Improving health and wellness is at the center of everything we do. As a not-for-profit, we aim to build stronger communities by investing in actions that promote and improve health. Delta Dental of Iowa invests 40% of our dollars directly back into the communities we serve.


    Come see why we are passionate about "Bringing Smiles" to our customers. Our team enjoys competitive pay and benefits, an awesome "One Team" approach, and a company culture that fosters "Exceptional Quality Service" and "Leadership at All Levels." Together, we can make a difference – not only in Iowa but across the country.

      

    Essential Functions and Principal Accountabilities: 

    • Drive the continued maturity of company’s warehouse environment through the design, implementation, and ongoing enhancement of data warehouse constructs within a SQL server environment.
    • Provide analysis and definition of a flexible and robust data model which is neutral with respect to the choice of data analysis approach and toolset.
    • Lead large complex projects with limited direction.
    • Work with stakeholders and users to define a robust dimensional model for a data warehouse which is accessible to a variety of front-end tools accessing it. 
    • Document warehouse data models from both logical and physical perspectives.
    • Implement those models through table creation and maintenance in SQL Server.
    • Strong participation in defining and implementing corporate data strategy and data management standards/conventions. Includes the collection and maintenance of metadata.
    • Facilitate communication between and understanding among stakeholders, business users, data warehouse developers, and report developers.
    • Ensure data integrity and quality for the data within the organization.
    • Gain a thorough understanding of multiple source systems and how those data elements are represented within the data warehouse.
    • Identify software, tools, and techniques that have potential to advance the state of Business Intelligence across the company.
    • Provide outstanding support to the business areas for data needs. This includes ad-hoc data requests/analysis, user support, etc.
    • Responsible for ensuring upgrades are applied to environments.
    • Responsible for ensuring backups occur and monitoring them.
    • Lead database recovery efforts if failure was to occur.
    • Ensure cycles are meeting SLAs and if not recommend and implement improvements.
    • Provide on-call support when necessary.
    • Perform other duties as assigned.

    Requirements


    1. Bachelor’s degree in computer science, information systems, or related technology field or equivalent experience.
    2. 8 years of experience designing and building Data Warehouse structures, processing, and reports, implemented using one or more enterprise-grade database products (SQL Server, Oracle, etc.).
    3. Advanced skills in logical and physical data modeling, database queries, stored procedures, and data mapping.
    4. Deep knowledge and experience with data warehouse best practices at the enterprise level. Able to articulate the value of those practices to a technical or non-technical audience.
    5. Proficient with ETL concepts and implementation.
    6. Development in Business Intelligence software, including the construction of complex reports based on warehouse data.
    7. Experience with any/all of the following would be a plus, but not essential: Data Quality and/or Master Data concepts and implementation; Business Objects Universe design and report development; Power BI endorsed datasets and report development; and/or Data Warehouse development in SSIS and SSRS.
    8. Proven analytical and problem-solving skills.
    9. Demonstrated ability to balance and prioritize responsibilities toward meeting established deadlines. All within a dynamic,      project-oriented environment.
    10. Ability to lead large complex projects with limited direction. 
    11. Insurance industry experience is preferred.

     

    Delta Dental of Iowa is an Affirmative Action and Equal Opportunity Employer committed to providing equal employment opportunity for all persons without unlawful regard of race, color, religion, sex, sexual orientation, gender identity, age, national origin, individuals with disabilities, protected veteran status, or any other legally protected basis.


    EEOC Poster 


  • 1 Month Ago

T
Data Specialist
  • Tractor Zoom
  • Des Moines, IA FULL_TIME
  • About Tractor Zoom We are committed to helping leaders in agriculture make data-driven decisions when it comes to buying, selling, financing, and insuring heavy equipment. Tailored to each business’ u...
  • 2 Days Ago

A
Warehouse Worker - Anytime Pay
  • Amazon Warehouse
  • Bondurant, IA FULL_TIME
  • Amazon Sortation Center Warehouse Associate Job Overview You’ll be part of the dedicated Amazon team that is the first stop on the journey from the warehouse. Our fast-paced, physical roles take place...
  • 3 Days Ago

S
Warehouse Specialist
  • Seneca Tank
  • Des Moines, IA FULL_TIME
  • SENECA TANK JOB DESCRIPTION JOB TITLE: Warehouse Specialist DEPARTMENT: Warehouse FLSA STATUS: Non-Exempt REPORTS TO: Dealership Manager CREATED/REVISED: Summary: Reporting to the Dealership Manager, ...
  • 11 Days Ago

A
Amazon Warehouse Team Member - Anytime Pay
  • Amazon Warehouse
  • Grimes, IA FULL_TIME
  • Shift: Wed, Thu, Fri, Sat 01:20am - 11:50am Duration: FULL_TIME Start Date: 2023-06-28 Amazon Delivery Station Warehouse Associate Job Overview You’ll be part of the dedicated Amazon team at the deliv...
  • 18 Days Ago

D
Data Administration Team Lead
  • Data Intensity
  • Gachibowli, IA FULL_TIME
  • As a Senior Database Administrator with Data Intensity, your goal will be to provide consistent, high-quality service and support to our customers. You will be expected to maintain a high level of com...
  • 18 Days Ago

Filters

Clear All

Filter Jobs By Location
  • Filter Jobs by companies
  • More

0 Data Warehouse Specialist jobs found in Des Moines, IA area

T
Warehouse Supervisor - Des Moines, IA
  • The Judge Group
  • Des Moines, IA
  • Job Description Warehouse Supervisor - Des Moines, IAThis is a full-time, exempt level position.This position is respons...
  • 3/18/2024 12:00:00 AM

M
Warehouse Technician
  • MetroNet Inc.
  • Des Moines, IA
  • ** Warehouse Technician** **Job Category****:** Maintenance **Requisition Number****:** WAREH003962 Showing 1 location *...
  • 3/18/2024 12:00:00 AM

I
Warehouse Associate - 15/hr!
  • Intoxalock
  • Des Moines, IA
  • **Warehouse Associate - 15/hr!** **Department:** I-Operations **Location:** Des Moines, IA **Receiving Associate - Des M...
  • 3/18/2024 12:00:00 AM

T
Temporary Bookkeeper / Front Office Staff
  • Teamsters Local 90 (General Team & Truck Drivers Helpers Warehousemen Local #90)
  • Des Moines, IA
  • Job Description Job Description Description Teamsters Local 90 is seeking a Temporary Front Office Staff / Bookkeeper sp...
  • 3/18/2024 12:00:00 AM

J
Part Time Work From Home Typing / Data Entry Clerk - Remote
  • Jobconversion, LLC
  • Des Moines, IA
  • Work From Home Data Entry Jobs - Part-Time, Full Time - Ages 16+ We are seeking individuals who are looking for part-tim...
  • 3/17/2024 12:00:00 AM

I
.Net Tech Lead
  • Indotronix International Corporation
  • Des Moines, IA
  • Pay Rate:- W2 Rate $ 59.70 Will not consider candidates unless they are willing to be onsite day 1 relocated or local to...
  • 3/16/2024 12:00:00 AM

W
SAP Functional Analyst (Sales & Distribution)
  • Woodgrain
  • West Des Moines, IA
  • Job Title: SAP Functional Analyst - Sales & Distribution (SD) Location: Corporate Satellite Office Lawrenceville, Georgi...
  • 3/16/2024 12:00:00 AM

D
Senior Database Developer
  • Delta Dental of Iowa
  • Johnston, IA
  • Job Type Full-time Description Come Smile with Us! Are you a seasoned data warehouse expert looking to make a change? Jo...
  • 3/15/2024 12:00:00 AM

Des Moines (/dɪˈmɔɪn/ (listen)) is the capital and the most populous city in the U.S. state of Iowa. It is also the county seat of Polk County. A small part of the city extends into Warren County. It was incorporated on September 22, 1851, as Fort Des Moines, which was shortened to "Des Moines" in 1857. It is on and named after the Des Moines River, which likely was adapted from the early French name, Rivière des Moines, meaning "River of the Monks". The city's population was 217,521 as of the 2017 population estimate. The five-county metropolitan area is ranked 89th in terms of population in ...
Source: Wikipedia (as of 04/11/2019). Read more from Wikipedia
Income Estimation for Data Warehouse Specialist jobs
$109,116 to $134,526
Des Moines, Iowa area prices
were up 0.8% from a year ago

Data Warehouse Specialist in Albany, GA
Are you an experienced, highly motivated Data Warehouse Specialist? Do you like to work in a dynamic and dedicated team of IT professionals? Then this might be a role for you.
December 31, 2019
Data Warehouse Specialist in Charleston, WV
The main role of the incumbent is to perform the design, development, implementation, and management of an enterprise data warehouse solution for the Global IP Platform.
January 18, 2020
Data Warehouse Specialist in Lancaster, PA
·          provide continuity in all major data warehousing solution decisions.
January 07, 2020