Accelerating the pace of engineering and science
| Careers at MathWorks |
Senior Data Warehouse Developer
Job Summary
The Senior Data Warehouse Developer works closely with the business areas and with the rest of the data warehouse team within MathWorks IT. 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.
Responsibilities
As a Senior Data Warehouse Developer you will work to gather business reporting requirements and translate them into data mart designs and working Business Objects Universes. Specifically, you will:
- Gather and translate reporting requirements into working data model designs.
- Understand the source data available and map sources to the target design using a variety of tools, but primarily using Business Objects Data Services, formerly Data Integrator.
- Work closely with other members of the data warehouse team to translate functional/technical specifications and logical data models into working databases, including relational and dimensional (star-schema) designs.
- Conducts ETL performance tuning, troubleshooting, support, and capacity estimation.
- Conducts thorough testing of ETL code changes to ensure quality of data produced.
- Design and maintain the Business Objects Universes.
- Provide day-to-day support and mentoring to end users.
Required Qualifications
- A bachelor's degree and 7 years of professional work experience, or master's degree and 5 years of professional work experience, or a PhD degree is required.
- Experience with Data Warehouse
Preferred Qualifications
- Experience with Business Intelligence tools such as Crystal, Business Objects, Microsoft SSRS, or Oracle OBIEE.
- Direct experience with BI or DW projects over the full development lifecycle.
- Expert SQL coding/querying skills.
- Experience with relational database design/modeling; prior experience with modeling tools such as ERstudio or ERwin is desirable.
- Experience leading projects.
- Experience with software industry a plus
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 2500 people in 15 countries, with headquarters in Natick, Massachusetts, U.S.A. MathWorks is privately held and has been profitable every year since its founding in 1984.