PlymouthMARecruiter Since 2001
the smart solution for Plymouth jobs

Data Warehouse Developer/Analyst

Company: The MathWorks, Inc.
Location: Natick, MA
Posted on: July 30, 2018

Job Description:

Working under the direction of the Data Warehouse Development Manager 2,

will be responsible for developing and maintaining data warehousing

systems and data marts; working with the rest of the Data Warehouse team

within MathWorks IT to support the data development lifecycle, including

data profiling, ETL and data model design and development,

debugging/testing, support, and delivery of enhancements; profiling and

understanding the large amounts of source data; working with data

providers to fill data gaps and/or to adjust source-system data

structures to facilitate analysis and integration with other company

data; working with stakeholders to understand their systems, processes,

and business needs; identifying opportunities for new insights,

analytics, and reporting solutions; gathering reporting and analysis

requirements and translating into reporting structures data models,

including aggregate tables, pivoted tables, and relational and

dimensional (star-schema) marts; mapping sources to targets using a

variety of tools, including BusinessObjects Data Services/BODI;

designing and developing ETL code to load and transform the source data

from various formats into a SQL database; conducting ETL performance

tuning, troubleshooting, support, and capacity estimation; conducting

thorough testing of ETL code changes to ensure quality of data produced;

and providing day-to-day support to end users interacting with the data.

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 and database modeling.

Special Requirements:

• 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 MSSQL and MySQL databases to extract, manipulate and

load data.

• Demonstrated expertise performing database implementation,

including strategizing data acquisition, archiving recovery, and

designing solutions for Microsoft Business Intelligence and data

warehouse platforms.

• 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.

[Expertise may be gained during Graduate program.]

For the position listed above, interested candidates may search by job

code 19075 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 , 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!

Plymouth RSS job feeds