BostonRecruiter
the smart solution for Boston 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., Boston, 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


Other Engineering Jobs


Engineering Manager
Description: Are you an Engineering Manager You will be responsible for planning, directing and coordinating activities in the fields of engineering. We will also rely on you to provide design, research, and development (more...)
Company: Hired
Location: Marblehead
Posted on: 08/17/2018

Professional A/C Mechanics - Grow Your Business With HomeAdvisor (Some
Description: Professional A/C Mechanics - Grow Your Business With HomeAdvisor Some Over 25
Company: HomeAdvisor
Location: Somerville
Posted on: 08/17/2018

Professional A/C Mechanics - Grow Your Business With HomeAdvisor (Cran
Description: Professional A/C Mechanics - Grow Your Business With HomeAdvisor Cran Over 25
Company: HomeAdvisor
Location: Cranston
Posted on: 08/17/2018


Professional A/C Mechanics - Grow Your Business With HomeAdvisor (Belm
Description: Professional A/C Mechanics - Grow Your Business With HomeAdvisor Belm Over 25
Company: HomeAdvisor
Location: Belmont
Posted on: 08/17/2018

Professional A/C Mechanics - Grow Your Business With HomeAdvisor (Hyde
Description: Over 25 million homeowners have trusted HomeAdvisor to help them find
Company: HomeAdvisor
Location: Hyde Park
Posted on: 08/17/2018

Professional A/C Mechanics - Grow Your Business With HomeAdvisor (Mars
Description: Over 25 million homeowners have trusted HomeAdvisor to help them find
Company: HomeAdvisor
Location: Marshfield
Posted on: 08/17/2018

DevOps Engineer
Description: Are you a DevOps Engineer You will be responsible for designing, implementing and maintaining production systems. You will also leverage configuration management to implement and maintain infrastructure, (more...)
Company: Hired
Location: Brookline
Posted on: 08/17/2018

College Graduates - Lead Blockchain Engineer ($120k)
Description: This candidate will participate in the full development cycle of the Crosby blockchain network and will join the
Company: CrosbyNYC
Location: Worcester
Posted on: 08/17/2018

Professional A/C Mechanics - Grow Your Business With HomeAdvisor (Ando
Description: Professional A/C Mechanics - Grow Your Business With HomeAdvisor Ando Over 25
Company: HomeAdvisor
Location: Andover
Posted on: 08/17/2018

Professional A/C Mechanics - Grow Your Business With HomeAdvisor (Leom
Description: Professional A/C Mechanics - Grow Your Business With HomeAdvisor Leom Over 25
Company: HomeAdvisor
Location: Leominster
Posted on: 08/17/2018

Log In or Create An Account

Username:
Password:
 

Forgot password?


Find us on Facebook

Find us on LinkedIn

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

Boston RSS job feeds