Senior Data Warehouse Developer/Analyst

Job Summary

Apply Now

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.]

You and MathWorks

为什么选择MathWorks?

在这里,您将遇到聪明,热忱的同事。我们的软件改变了世界,而您也将为此贡献力量。您将作为公司的一员,见证公司践行承诺,“做正确的事”,服务于每个人,每个客户盒当地社区。

MathWorks开发了MATLAB和Simulink,为工程师和科学家提供全球领先的科学计算软件。公司在16个国家和地区拥有6500多名员工,总部位于美国马萨诸塞州内蒂克市。MathWorks是一家私营公司,自1984年成立以来,连年盈利至今。

YOU + MathWorks = Unlimited Possibilities

面板导航

加入我们的人才网

接收个性化的工作机会提醒、事件和公司动态。

Talent Network

Apply Now

Contact us if you need reasonable accommodation because of a disability in order to apply for a position.

The MathWorks, Inc. is an equal opportunity employer. We evaluate qualified applicants without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status, and other protected characteristics. View the EEOC Know Your Rights poster.

MathWorks participates in E-Verify. View the E-Verify posters here.