PlymouthMARecruiter Since 2001
the smart solution for Plymouth jobs

Senior Data Warehouse Developer

Company: The MathWorks, Inc.
Location: Natick, MA
Posted on: February 24, 2020

Job Description:

Working under the direction of the Development Applications Manager 2, will be responsible for designing and

developing data analytics tools and reports; supporting the internal continuous integration system and web-based

applications; working with internal teams to understand their data analysis and reporting needs in order to design,

develop, and enhance organizational data warehouse and data marts; supporting the entire data warehouse lifecycle,

including requirements gathering, data profiling, design, development, testing, ongoing support and enhancements;

using data gathered from the internal systems to help improve product development process and to evolve MathWorks

applications to meet the needs of Development; serving as the link between data providers and the Development Data

Mart to ensure the right data is in the warehouse and is updated as changes occur in the data providers applications;

working with the data providers to ensure source data collected can support the Infrastructure teams needs; profiling

and understanding large volumes of source data, including structured and unstructured data, from MySQL, SQL Server,

flat files, and the Cloud sources; designing and developing ETL code using Perl and Python scripting languages;

conducting ETL and database performance tuning to improve overall performance; identifying opportunities to leverage

existing metrics and developing new metrics to help move the organization forward by identifying waste in processes;

creating and maintaining a system that helps ad-hoc metrics providers move to a more robust and sharable reporting

interface; developing metrics and processes to ensure quality standards are met on new and existing data; and

establishing service level agreements and best practices with Business Partners for reports and ad-hoc analysis.

Education and Experience:

Masters degree or higher (or foreign education equivalent) in Engineering or Computer Science and two (2) years of

experience in job offered or two (2) years of experience in data warehouse development and database modeling.

OR

Bachelors degree (or foreign education equivalent) in Engineering or Computer Science 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 -- strategizing data acquisition, archiving recovery, and designing solutions for data warehouse platforms --

and ETL code and performance optimization using SSIS and Informatica.

Demonstrated expertise developing and optimizing database objects -- indexes, triggers, functions, and stored

procedures; writing stored procedures and SQL query scripts on MSSQL and MySQL databases to extract, manipulate

and load data; and implementing data reporting solutions using BI tools and TSQL programming.

Demonstrated expertise designing logical and physical layers of relational and multidimensional SQL Server

database models using ERStudio; and implementing user-based security for underlying database objects.

Demonstrated expertise designing data visualizations -- reports and dashboards -- using Power BI and Tableau.

[Expertise may be gained during Graduate program.]

For the position listed above, interested candidates may search by job code 23461 for specific job details and

requirements and apply online on the Careers Page at http://www.mathworks.com/company/jobs

Keywords: The MathWorks, Inc., Plymouth , Senior Data Warehouse Developer, Engineering , Natick, MA, Massachusetts


Didn't find what you're looking for? Search again!

I'm looking for
in category
within


Log In or Create An Account

Get the latest Massachusetts jobs by following @recnetMA on Twitter!

Plymouth RSS job feeds