Job Directory The Mathworks Data Warehouse Developer/Analyst
The Mathworks

Data Warehouse Developer/Analyst The Mathworks
Natick, MA

MathWorks is a developer of mathematical computing software for engineers and scientists.

Companies like The Mathworks
are looking for tech talent like you.

On Hired, employers apply to you with up-front salaries.
Sign up to start matching for free.

About The Mathworks

Job Description

Search for more jobs

Data Warehouse Developer/Analyst

Job Summary

Apply Now

* Job: 21349-DCOL
* Location: US-MA-Natick
* Department: Business Applications and Tools

Working under the direction of the IT Quality Engineering Manager, will be responsible for providing technical support to the MathWorks data warehouse development team and MathWorks change management processes; overseeing the processes required to test ETL code, data, and reporting solutions; developing testing procedures, validating best practices, and ensuring that solutions are ready for deployment to MathWorks production systems; supporting the data warehouse team and MathWorks data providers to analyze business requirements and develop effective test plans; validating source systems and data through data profiling and analysis efforts using SQL; validating source to target mappings using a variety of tools, including Business Objects Data Services/BODI; designing and developing test plans to validate MathWorks data warehouse processes; conducting thorough testing of ETL code changes to ensure quality of data produced; and developing ETL workflows using complex transformations to capture bugs in data and automate the overall quality control process.

Responsibilities

Qualifications

Minimum Qualifications:

Education and Experience:

Master's degree or higher (or foreign education equivalent) in Engineering, Computer Science, or Information Technology and no experience.

OR

Bachelor's degree (or foreign education equivalent) in Engineering, Computer Science, or Information Technology and five (5) years of experience in job offered or five (5) years of experience in data warehouse development and database modeling.

Special Requirements:

* Demonstrated expertise performing data profiling; designing and implementing logical and physical data models, including star schema design and ER models, using SQL on MSSQL, MySQL or Oracle databases; and writing SQL scripts or building ETL jobs to identify and correct bugs.
* Demonstrated expertise writing complex stored procedures and SQL query scripts on MSSQL, MySQL, or Oracle databases to extract, manipulate, and load data.
* Demonstrated expertise designing ETL solutions using SAP or Informatica; performing custom coded ETL programming using SQL; and performing performance optimization of ETL solutions using SAP or Informatica.
* Demonstrated expertise designing data visualizations -- reports and dashboards -- using OBIEE or SAP Business Objects.

[Expertise may be gained during Graduate program.]

Why MathWorks?

It's the chance to collaborate with bright, passionate people. It's contributing to software products that make a difference in the world. And it's being part of a company with an incredible commitment to doing the right thing - for each individual, our customers, and the local community.

MathWorks develops MATLAB and Simulink, the leading technical computing software used by engineers and scientists. The company employs 4500 people in 16 countries, with headquarters in Natick, Massachusetts, U.S.A. MathWorks is privately held and has been profitable every year since its founding in 1984.

About The Mathworks

MathWorks is a developer of mathematical computing software for engineers and scientists.

Headquarters
Size
10000 employees
The Mathworks

1 apple hill drive

Let your dream job find you.

Sign up to start matching with top companies. It’s fast and free.