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


Satellite TV Technicians/Installers Opportunities
Description: This Home-Based Satellite TV Installer/Technician will have the opportunity to begin and end their business day from home and be the face of Dish in their local community br br Our Home-Based Satellite (more...)
Company: DISH
Location: Taunton
Posted on: 01/21/2019

Hadoop Big Data Engineer
Description: Employer.com is a leader in the e-commerce space for all things home. The Distributed Computing team is looking for smart, passionate and curious people who are excited to help us scale, support and engineering (more...)
Company: Wayfair
Location: Bedford
Posted on: 01/21/2019

Build/ Release Engineer - Sharon
Description: Let companies apply to you, not the other way around. Sign up with Hired to get access to thousands of companies currently hiring release engineers. Want to work for a company
Company: Hired
Location: Sharon
Posted on: 01/21/2019


Elasticsearch / DevOps Engineer - Malden
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
Company: Wayfair
Location: Malden
Posted on: 01/21/2019

Hadoop Big Data Engineer - Nahant
Description: Employer.com is a leader in the e-commerce space for all things home. The Distributed Computing team is looking for smart, passionate
Company: Wayfair
Location: Nahant
Posted on: 01/21/2019

Embedded S/W Engineer
Description: Job Title: Embedded S/W EngineerLocation: Littleton, MADuration: 12 Months Experience Required: 5 YearsJob Description: Supports software development and release activities,
Company: ]]>
Location: Littleton
Posted on: 01/21/2019

Hadoop Big Data Engineer
Description: Employer.com is a leader in the e-commerce space for all things home. The Distributed Computing team is looking for smart, passionate and curious people who are excited to help us scale, support and engineering (more...)
Company: Wayfair
Location: Holbrook
Posted on: 01/21/2019

Sr Engineer or Project Engineer, Gas Engineering - Professional Engineering License Preferred
Description: Location: Southborough, Massachusetts, 01772, United States Posted: 01/15/2019 Position Title: Sr Engineer or Project Engineer, Gas Engineering Southborough - Professional Engineering License Preferred (more...)
Company: Eversource Energy
Location: Southborough
Posted on: 01/21/2019

Sr Industrial Security Engineer
Description: A mutually rewarding experience. Work. Realize your ambitions. And realize there's more to being in business than just making a profit. That's the Employer philosophy. And the opportunity we offer every (more...)
Company: Mars
Location: Boston
Posted on: 01/21/2019

Build/ Release Engineer - Sharon
Description: Let companies
Company: Hired
Location: Sharon
Posted on: 01/21/2019

Log In or Create An Account

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

Boston RSS job feeds