Senior Data Warehouse Developer

Job ID : 68 - Advertised : 2011-05-18 - Closing Date: 4749-04-13 or to apply
Company Name : MathWorks
  Approximate Salary: Negotiable
Location : Natick,Massachusetts   Country : United States
Industry : IT-Software/Software Services   Position Type : Full-Time
Experience Level : 8 Years   Education Level : Bachelors Degree

MathWorks, a fast-paced leading edge software company, is actively recruiting for individuals with ETL development and Business Intelligence skills for our Data Warehouse group.

Title:  Senior Data Warehouse Developer / Analyst

Location:  US-Natick, MA – 17 miles from Boston

Percent Travel:  None to Minimal


Job Summary:

The Senior Data Warehouse Developer / Analyst is the implementation expert for our Data Warehouse group. He/she works with our analysts to understand the user needs and assist in the design of physical databases to support the requirements. He/she is the primary ETL developer, using ETL and SQL tools to transform source data into target data models. This role also provides secondary technical support for the BI environment.


To apply, please go to:



  •  ETL programming: Understand the source data available and map sources to the target design using a variety of tools, but primarily using the ETL tool of choice (BusinessObjects Data Services, formerly Data Integrator).
  •  Works closely with the data warehouse team to translate functional/technical specifications and logical data models into working databases, including relational and dimensional (star-schema) designs. Design-related tasks will focus on logical and physical data models for the history-tracking data warehouse and related data marts.
  •  Works with the DW analyst and project teams to understand analysis and reporting requirements and ensures that their work product meets those user needs. Conducts ETL performance tuning, troubleshooting, support, and capacity estimation.
  •  Conducts thorough testing of ETL code changes to ensure quality of data produced.
  •  Assists in the support of the BI environment, including BusinessObjects and Crystal. May include technical support, team advising/support, as well as end-user support with understanding the data available in the warehouse and marts.
  •  Develops, adheres to, and is a proponent for Data Warehouse development standards, including ETL standards and best practices.



  •  BS degree and 8+yrs of experience, or MS and equivalent professional work experience
  •  4+ years of experience coding and administrating an ETL tool such as BusinessObjects Data Integrator/Services (BODI), Informatica, or Ascential
  •  4+ years of experience with database modeling for the purpose of reporting, including relational and dimensional modeling exposure
  •  Expert SQL skills (Oracle PL/SQL or MS TSQL), including stored procedure programming
  •  Experience in systems analysis is required
  •  Foundational knowledge in Windows 2003/2008 Server, MS SQL Server tuning, MS Analysis Services, TCP/IP, and x86 hardware
  •  Prior experience with a BI tool (implementation, reporting, administration) such as OBIEE, Cognos, BusinessObjects, Brio, or Crystal is desirable
  • Prior experience with developing ETL standards is desirable
  • Data Quality and Profiling exposure is desirable
  • Basic project management skills
  • Excellent written and verbal communication skills


To apply, please go to:


IT at MathWorks:

MathWorks is a highly successful company that heavily leverages IT to strategic advantage for our development and business areas.  MathWorks IT is a worldwide team of bright, motivated, high performing people, who build and implement solutions that improve our business.  We’re always looking for innovative technologies or processes that improve the way we design, develop, deploy and support IT solutions.

We have the time, funding, and culture to “do the right thing”:  As a privately-held company committed to continuous improvement, we have requirements driven -- not budget driven -- decision making processes.  We give ourselves the time to design solutions right and have implemented an IT follow-the-sun support model leveraging the expertise of our worldwide IT staff.

Want to work in a place that has a culture that fosters collaboration, information sharing, ongoing training and challenging work, so you can grow your expertise?  MathWorks is it.   We have a modern and sophisticated IT environment, and are already realizing the benefits of virtualization, mobile computing, SOA, enterprise data warehousing, cloud computing, and modern web application frameworks such as Ruby on Rails.

MathWorks has excellent facilities with modern offices, meeting spaces and computing tools that enable you to get your job done, plus a full selection of sugary, caffeinated and healthier choice beverages to keep you going.   Join us, and take your IT career to a whole new level!


Additional opportunities at MathWorks:

You may also be interested in, or know of someone for, the following job opportunities:

Oracle EBS Developer / Analyst; Natick, MA:

Senior Data Warehouse Analyst; Natick, MA: