Senior Data Warehouse Developer/Analyst
Resumen del empleo
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.
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.
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.
- 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.]
It's the chance to collaborate with bright, passionate people. It's the opportunity to accelerate the pace of discovery, innovation, and learning in engineering and science. And it’s a commitment to doing the right thing—for each individual, our customers, and the local community. We cultivate an enjoyable, participatory, and rational environment that champions individual growth, appreciates diversity, encourages initiative, values collaboration, shares success, and rewards excellence.
MathWorks develops MATLAB and Simulink, the leading technical computing software used by engineers and scientists. The company employs more than 6,000 people in 16 countries, with headquarters in Natick, Massachusetts, USA. MathWorks is privately held and has been profitable every year since its founding in 1984.
YOU + MathWorks = Unlimited Possibilities
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 EEO is the Law poster and its supplement.
The pay transparency policy is available here.
MathWorks participates in E-Verify. View the E-Verify posters here.