ZipRecruiter

Log In

1

Data Warehousing Jobs (NOW HIRING)

Revinate

Data Warehouse Engineer

Atlanta, GA · On-site +1

$110K - $120K/yr

Build and maintain a data warehouse (e.g., BigQuery). * Use business intelligence tools (e.g., Looker) to establish data models and create. What You'll Bring * Bachelors degree in relevant field * At ...

Together AI

Data Warehouse Engineer

San Francisco, CA

$130K - $170K/yr

We're looking for an early-career Data Warehouse Engineer with strong fundamentals and high growth potential to grow into a technical lead over time. You'll contribute to designing and operating our ...

Revinate

Data Warehouse Engineer

Atlanta, GA · On-site +1

$110K - $120K/yr

Build and maintain a data warehouse (e.g., BigQuery). * Use business intelligence tools (e.g., Looker) to establish data models and create. What You'll Bring * Bachelors degree in relevant field * At ...

Together AI

Data Warehouse Engineer

San Francisco, CA

$130K - $170K/yr

We're looking for an early-career Data Warehouse Engineer with strong fundamentals and high growth potential to grow into a technical lead over time. You'll contribute to designing and operating our ...

Trilyon, Inc.

Data Warehouse Analyst

Tallahassee, FL · On-site

The ideal candidate will have strong experience in data warehousing, ETL/ELT processes, Informatica tools, and business intelligence platforms, along with a passion for data-driven decision-making ...

next page

Showing results 1-20

All JobsData Warehousing Jobs

Data Warehousing information

What is data warehousing?

Data warehousing is the process of collecting, storing, and managing large volumes of data from different sources in a central repository, called a data warehouse. This centralized storage allows organizations to analyze historical data, generate reports, and make informed business decisions. Data warehouses are optimized for query and analysis rather than transaction processing, and they often use specialized tools and technologies to ensure data is consistent, reliable, and easily accessible for business intelligence purposes.

What are the key skills and qualifications needed to thrive as a Data Warehousing professional, and why are they important?

To thrive in Data Warehousing, you need expertise in data modeling, SQL, ETL processes, and a solid background in computer science or information systems. Familiarity with data warehouse platforms like Amazon Redshift, Snowflake, or Microsoft SQL Server, as well as ETL tools such as Informatica or Talend, and relevant certifications are highly valued. Strong analytical thinking, problem-solving abilities, and effective communication skills help professionals collaborate and deliver actionable insights. These competencies are crucial for ensuring data integrity, optimizing storage solutions, and supporting informed business decisions.

What skills are needed for data warehousing?

Data warehousing professionals need strong skills in database management, SQL, and data modeling. Knowledge of ETL (Extract, Transform, Load) processes, data integration tools, and familiarity with cloud platforms like AWS or Azure are also important. Additionally, analytical skills and understanding of business intelligence concepts enhance effectiveness in this role.

What is the difference between Data Warehousing vs Data Analyst?

AspectData WarehousingData Analyst
Primary RoleDesigning, building, and managing data storage systemsAnalyzing data to generate insights and reports
Skills & CertificationsSQL, ETL tools, database management, data modelingSQL, data visualization, statistical analysis, Excel
Work EnvironmentData warehouses, database servers, cloud platformsBusiness units, reporting tools, dashboards
Industry UsageIT, data engineering, business intelligenceMarketing, finance, operations, business analysis

While Data Warehousing focuses on creating and maintaining data storage systems, Data Analysts utilize these systems to interpret data and support decision-making. Both roles often collaborate but serve different functions within data management and analysis processes.

What does a data warehouse do?

A data warehousing professional manages the design, development, and maintenance of data warehouses, which are centralized systems that store large volumes of integrated data from multiple sources. Their role involves data modeling, ETL (extract, transform, load) processes, and ensuring data quality to support business intelligence and analytics. Skills in SQL, data modeling, and tools like Tableau or Power BI are often essential in this field.

What are data warehouse jobs?

Data warehouse jobs involve designing, developing, and maintaining data storage systems that aggregate and organize large volumes of data for analysis and reporting. These roles typically require skills in SQL, data modeling, ETL processes, and familiarity with tools like Amazon Redshift, Snowflake, or Microsoft SQL Server. Professionals in this field support business intelligence and decision-making processes by ensuring data accuracy and accessibility.

What are the typical challenges faced by professionals in data warehousing roles when integrating data from multiple sources?

Professionals in data warehousing often face challenges such as ensuring data consistency and quality when integrating data from various sources, which may use different formats and standards. Other common hurdles include handling large volumes of data efficiently, maintaining data security and compliance, and managing the complexity of ETL (Extract, Transform, Load) processes. Collaboration with business analysts, IT teams, and data engineers is essential to accurately define requirements and troubleshoot integration issues. Successfully navigating these challenges requires strong problem-solving skills and a solid understanding of both business needs and technical solutions.

What is the highest paying job in a warehouse?

In data warehousing, the highest paying roles are typically senior data architects or data engineering managers, who oversee data infrastructure and strategy. These positions often require advanced skills in database systems, cloud platforms, and data modeling, and they can command salaries significantly higher than entry-level or operational roles.
More about Data Warehousing jobs
What cities are hiring for Data Warehousing jobs? Cities with the most Data Warehousing job openings:
What are the most commonly searched types of Data Warehousing jobs? The most popular types of Data Warehousing jobs are:
What states have the most Data Warehousing jobs? States with the most job openings for Data Warehousing jobs include:
What job categories do people searching Data Warehousing jobs look for? The top searched job categories for Data Warehousing jobs are:
Data Warehousing jobs near you
Data Warehouse Engineer

Data Warehouse Engineer

Mississippi Gulf Coast Community College

Perkinston, MS • On-site

Other

Posted 25 days ago

Job description

Position Information
Job Title Data Warehouse Engineer Job Description
GENERAL STATEMENT OF FUNCTION:
The Data Warehouse Engineer is responsible for extracting, transforming, and data processing by developing/managing the corresponding database tables. The individual must be proficient in database engineering and have expertise in SQL/PL-SQL. The individual maintains and writes PL-SQL procedures and functions and ensures the warehoused tables update via a Cron schedule on the Linux-based server. Data from the warehoused tables are used in internal, state and federal reports. The position requires a high amount of independent technical work and ongoing communication with the Executive Vice President of Technology & Research.
Job Duties
SPECIFIC DUTIES & RESPONSIBILITIES
Engineering Tables in the Data Warehouse:
1. Creates the database tables used to store the extracted and transformed data which are subsequently used as drivers of reports and dashboards. These tables are updated on a cron schedule on the Linux server using SQL and shell scripts to automate the process. As needs arise for new fields to be added to the tables, the Data Warehouse Engineer will code these fields, update all prior records to include the new data, and ensure the fields are populated automatically going forward.
2. Responsible for the organizational framework that standardize the process of data collection, storage, transformation, distribution, and usage.
3. Builds massive reservoirs for data and develop, construct, test, and maintain architectures and data processing systems.
Extracting Data:
4. Writes SQL queries and PL-SQL procedures and functions to extract data from multiple sources, including the Oracle database-based Banner student information system and excel spreadsheets. Extraction from survey data spreadsheets and subsequent data transformation and loading utilizes scripting in R which are written and maintained by the Data Warehouse Engineer. Custom projects based on extracted data and extracting data to the planning system in Oracle Application Express are also the responsibility of the Data Warehouse Engineer.
Maintaining Tables in the Data Warehouse:
5. Responsible for ensuring the data are updated and troubleshooting any technical issues that may arise in the data warehouse tables. Monitor the system performance by performing regular tests and integrating new features.
Verification & Validation of Data Elements:
6. Assembles data from multiple sources, cleans and analyzes complex datasets in areas, including but not limited to: internal data requests, survey research, ad hoc research projects, assessments and evaluation, program/institutional accreditation, and state/federal reporting. Interprets the data with accuracy and presents key findings to internal and external stakeholders in a clear and concise manner.
Consultation:
7. Designs and coordinates various ad hoc research projects based off of institutional need, facilitates the administration of assessments, and creates comprehensive evaluation plans.
General Responsibilities
8. Responsible for analyzing and reporting data to meet state, federal and accreditation deadlines.
9. Ensures that all reports and generated output are delivered with accuracy and by the established deadline.
10. Provides ongoing training, support and educational opportunities to our employees on IR related topics and promotes a culture of assessment at the institution. Prepares and presents employee development
educational sessions based off employee needs and the individual's area of expertise.
11. Works cooperatively and effectively with other college staff members, faculty and administration. Practices excellent customer service in their daily interaction with stakeholders.
12. Ability to work within strict deadlines. Able to work effectively in a high-pressure environment.
13. Assumes responsibility for special assignments initiated by the administration or our stakeholders.
14. High-level productive programmer who has a passion for designing and maintaining a data warehouse.
15. Works well with individuals from diverse backgrounds and personalities.
16. Adheres to all policies, procedures, and laws governing the employees of the institution.
17. Perform other duties as assigned by the Executive Vice President of Technology & Research.
Mandatory Qualifications
MANDATORY: (M1) Master's degree in Computer Engineering, Computer Science, Computer Programming, or a related field requiring database architecture (M2) Relevant coursework or significant work experience developing a database and proficiency in Oracle required. (M3) Demonstrated experience or have the experience to build reservoirs of data. (M4) Excellent oral and written communication skills; demonstrates the ability to communicate complex findings in a concise manner. (M5) Excellent time management and organizational skills.
Desirable Qualifications
DESIRABLE: (D1) A Ph.D. or significant progress towards a terminal degree, in Computer Engineering, Computer Science, Computer Programming, or a closely related field requiring database architecture or data analysis from a regionally accredited institution of higher education. (D2) Strong background and technical skills working with Ellucian Banner, FTP, SSH, Linux, Crontab, Shell Scripting, SQL, PL-SQL, R, Oracle Application Express (APEX), Windows Batch Scripting
EEO Statement
Mississippi Gulf Coast Community College is an Equal Opportunity Employer and welcomes students and employees without regard to race, color, religion, national origin, sex, pregnancy, age, or qualified disability in its programs and activities. For further information, contact the Compliance Officer P.O. Box 609, Perkinston, Mississippi, 39573, telephone number 601-528-8735, email address compliance@mgccc.edu.
The College:
The Mississippi Gulf Coast Community College District serves a four-county area with three major campuses, the Community Campus and four centers including: Perkinston Campus, Perkinston, MS; Harrison County Campus, Gulfport, MS; Jackson County Campus, Gautier, MS. Additionally, Mississippi Gulf Coast Advanced Manufacturing and Technology Center, Gulfport, MS; Keesler Center, Biloxi, MS; West Harrison Center, Long Beach, MS; and George County Center, Lucedale, MS.
State and regional associations accredit Mississippi Gulf Coast Community College, and several programs are accredited nationally. Offerings include academic, technical degree, vocational skill and adult continuing education programs.
Classification Administration
Posting Detail Information
Open Date 06/20/2022 Close Date Open Until Filled Yes Special Instructions to Applicants For more information on the position, please contact (Name, Address, Phone, and Email):
Adam Swanson
Executive Vice President, Technology & Research
10298 Express Drive. Gulfport 39503
228-897-4377
adam.swanson@mgccc.edu

Apply