LawrenceMARecruiter Since 2001
the smart solution for Lawrence jobs

Data Warehouse Developer/Analyst

Company: The MathWorks, Inc.
Location: Natick, MA
Posted on: December 28, 2018

Job Description:

Working under the direction of the Data Warehouse Development Manager,

will be responsible for supporting the ongoing development and

maintenance of MathWorks data warehousing systems and data marts; making

valuable contributions to the continuous transformation and improvement

of MathWorks information systems; supporting the entire data development

lifecycle, including data profiling, ETL and data model design and

development, testing, and support; working with project teams and

business users to understand their analysis and reporting requirements

and ensure that the design and delivered work meets those user needs;

working closely with the data warehouse team to translate business

requirements and logical data models into working databases, including

relational and dimensional (star-schema) designs; performing database

ETL programming: understanding the source data available and mapping

sources to the target design using tools such as SAP Data Services;

conducting thorough testing of ETL code changes to ensure quality of

data produced; monitoring the DW platform metrics, while recommending

and implementing improvements; assisting the team with performance

tuning for ETL and database processes; and sharing responsibility for

the administration of development, test, and production environments.

Education and Experience:

Master’s degree or higher (or foreign education equivalent) in

Engineering, Computer Science, or Information Systems and no experience.

OR

Bachelor’s degree (or foreign education equivalent) in Engineering,

Computer Science, or Information Systems and five (5) years of

experience in job offered or five (5) years of experience in data

warehouse development.

Special Requirements:

• Demonstrated expertise performing data profiling, designing and

implementing logical and physical data models, including star schema

design and ER models, on MSSQL and MySQL databases.

• Demonstrated expertise writing complex stored procedures and SQL

query scripts on MSSQL and MySQL databases to extract, manipulate and

load data.

• Demonstrated expertise designing ETL solutions, using SSIS, SAP,

Informatica or DataStage; performing custom coded ETL programming using

SQL; performing capacity planning for database storage; and performing

performance optimization of ETL solutions.

• 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 20789 for specific job details and requirements and apply online on

the Careers Page at http://www.mathworks.com/company/jobs

Keywords: The MathWorks, Inc., Lawrence , Data Warehouse Developer/Analyst, 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!

Lawrence RSS job feeds