ConcordNHRecruiter Since 2001
the smart solution for Concord 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 2,

will be responsible for profiling and analyzing large amounts of source

data; collaborating 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

analyze 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 Business Objects

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 and

mentoring to end users who are 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 and TSQL

programming.

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

• Demonstrated expertise architecting SQL Server for inter-

operation of diverse platforms; developing and optimizing database

objects -- indexes, triggers, functions, and stored procedures; and

developing front-end applications for data entry using VB.NET and stored

procedures.

[Expertise may be gained during Graduate program.]

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

code 20793 for specific job details and requirements and apply online on

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

Keywords: The MathWorks, Inc., Concord , Data Warehouse Developer/Analyst, Engineering , Natick, MA, New Hampshire


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 New Hampshire jobs by following @recnetNH on Twitter!

Concord RSS job feeds