Instructional Design

Learning & Development

Higher Ed

K-12

Sales

Customer Success

Product Development

Software Engineering

Academic Advising

Marketing

Fully Remote

All Jobs

Companies
About Post a job
Existing employer? Sign in
edtech.com
MathWorks logo

MathWorks

Senior Data Warehouse Developer/Analyst

🇺🇸 Hybrid - Natick, MA

🕑 Full-Time

💰 TBD

💻 Data Science

🗓️ February 13th, 2025

ETL Informatica MSSQL

Edtech.com's Summary

MathWorks is hiring a Senior Data Warehouse Developer/Analyst. This role involves designing, developing, and testing data warehouse software, creating data mart solutions for insights, and handling large data sets. Responsibilities include ETL process development, integrating company data, performance tuning, providing operational support, and mentoring users, with additional duties in providing 24/7 on-call support every two months. 

Highlights 
  • Design, develop, and test data warehouse and data mart solutions.
  • Develop ETL processes using tools like BusinessObjects Data Services.
  • Conduct performance tuning, troubleshooting, and operational support.
  • Support and mentor end users for data needs.
  • Participate in 24/7 on-call support every two months.
  • Requires expertise in ETL solutions, SQL, and BI tools.
  • Expertise in Teradata, DB2, MSSQL, MySQL, and data modeling tools.
  • Requires a Master's with 2 years or a Bachelor's with 6 years of relevant experience.

Senior Data Warehouse Developer/Analyst Full Description

Senior Data Warehouse Developer/Analyst


Job Summary
Working under the direction of the Manager or Senior Team Lead, will be responsible for designing, developing and testing sophisticated data warehouse software; designing and developing data mart solutions to provide MathWorks with valuable customer and product insights; profiling and understanding large amounts of source data, including structured and semi-structured data; collaborating with stakeholders to address data and system gaps and developing integrations with other company data; translating user requirements into data models and data mart designs; designing and developing ETL processes to load data into MathWorks' data marts using a variety of tools, including BusinessObjects Data Services; conducting thorough testing of data mart solutions to ensure quality; conducting performance tuning, troubleshooting and operational support; and providing support and mentoring to end users to support their data needs. Participates in 24/7 on-call support every two months.

Responsibilities
           
Qualifications
Minimum Qualifications:
Education and Experience:
Master’s degree in Engineering, Computer Science, or a closely related field (or foreign education equivalent) and two (2) years of experience in job offered or two (2) years of experience in data warehouse development and database modeling.
OR
Bachelor’s in Engineering, Computer Science, or a closely related field (or foreign education equivalent) and six (6) years of experience in job offered or six (6) years of experience in data warehouse development and database modeling.
 
Special Requirements:
  • Demonstrated expertise designing ETL solutions for data warehouse and data mart loads, including capacity planning, ETL code and performance optimization using SSIS, SAP or Informatica, and implementing data reporting solutions using BI tools.
  • Demonstrated expertise writing complex stored procedures and SQL query scripts on Teradata, DB2, MSSQL or MySQL databases to extract, manipulate and load data.
  • Demonstrated expertise performing database implementation, including strategizing data acquisition, archiving recovery, and designing solutions for business intelligence and data warehouse platforms.
  • Demonstrated expertise designing logical and physical layers of relational and multidimensional SQL Server, Teradata, DB2, and Oracle database models using data modeling tools -- ERStudio or Erwin, and implementing user-based security for underlying database objects.

[Expertise may be gained during Graduate program.]

Similar Jobs

Director of Data Engineering

Chess.com

🇺🇸 Remote - US

Senior Data Analyst

Rutgers University

🇺🇸 New Brunswick, NJ

Data Analytics Team Lead

Old Dominion University

🇺🇸 Norfolk, VA

Senior Data Analyst - Institutional Research

Western Governors University

🇺🇸 Salt Lake City, UT

Senior Insights Analyst

McGraw Hill

🇺🇸 Remote - US