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


Engineer- Pricing & Profitability Bizcore
Description: L2 PPD Bizcore br br About Us: br br Wayfair is one of the world's largest online destinations for the home. Whether you work in our global headquarters in Boston or Berlin, or in our warehouses (more...)
Company: Wayfair
Location: Winchester
Posted on: 01/18/2019

Engineer- Pricing & Profitability Bizcore
Description: br L2 PPD Bizcore br br About Us: br br Employer is one of the world's largest online destinations for the home. Whether you work in our global headquarters in Boston or Berlin, or in our warehouses (more...)
Company: Wayfair
Location: Marblehead
Posted on: 01/18/2019

Diesel Mechanic Technician
Description: Position Description Friendly work atmosphere Excellent opportunity grow your career Paid state of the art training Please call or text Kaitlin at 401-209-9468 for more information We are currently hiring (more...)
Company: Ryder.
Location: Stoneham
Posted on: 01/18/2019


Vice President, Engineering
Description: MediaMath is seeking a leader to transform our engineering culture, to grow and develop our people, and to build the greatest tech possible. We are seeking an individual who thrives on describing a vision (more...)
Company: MediaMath
Location: Cambridge
Posted on: 01/18/2019

Elasticsearch / DevOps Engineer
Description: Employer.com is growing rapidly and we're looking for people who are excited to help us grow our distributed systems platforms. As a member of the Distributed Systems team you will be empowered to design (more...)
Company: Wayfair
Location: Milton
Posted on: 01/18/2019

Full Stack Engineer - JavaScript/Angular, Node
Description: Our client is a Boston-based financial investment firm that serves over twenty million customers. They employ tens of thousands of individuals and manage trillions of dollars in assets. With almost a (more...)
Company: Eliassen Group
Location: Boston
Posted on: 01/18/2019

iOS Staff Engineer
Description: Employer Story Employer's founders, Steve Conine and Niraj Shah, kick-started
Company: Wayfair
Location: Wilmington
Posted on: 01/18/2019

Engineer- Pricing & Profitability Bizcore
Description: br L2 PPD Bizcore br br About Us: br br Employer is one of the world's largest online destinations for the home. Whether you work in our global headquarters in Boston or Berlin, or in our warehouses (more...)
Company: Wayfair
Location: Chestnut Hill
Posted on: 01/18/2019

Director Process Development - Process Engineering
Description: As part of Amgen's Process Development organization, Drug Product Technologies DPT continuously strives to be a leader in delivering superior and high-quality aseptic drug product processes presentations (more...)
Company: Amgen
Location: Cambridge
Posted on: 01/18/2019

Engineer 2, Process Development
Description: Downstream Process Engineer/Scientist Position summary: GreenLight Biosciences is seeking an exceptional, highly-motivated Downstream Process Engineer/Scientist with expertise in industrial-scale purification (more...)
Company: Greenlight Biosciences
Location: Medford
Posted on: 01/18/2019

Log In or Create An Account

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

Boston RSS job feeds