BostonRecruiter Since 2001
the smart solution for Boston jobs

Data Warehouse Developer/Analyst

Company: The MathWorks, Inc.
Location: Natick, MA
Posted on: August 12, 2019

Job Description:

Working under the direction of the Data Warehouse Developer/Analyst - Senior Team Lead 3, will be responsible for
supporting the ongoing development and maintenance of data warehousing systems and data marts; making
contributions to the continuous transformation and improvement of MathWorks information systems; 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, testing, and support; working with project teams and
business contacts to understand their analysis and reporting requirements, and ensuring the design and delivered
solution meets those needs; working closely with the data warehouse team to translate business requirements and
logical data models into working databases, including relational and dimensional (star-schema) designs;
understanding the source data available and mapping sources to the target design using a variety of ETL tools,
including SAP Data Services; conducting thorough testing of ETL code changes to ensure quality of data produced;
making changes to Business Objects universes to reflect changes made to marts; monitoring the data warehouse
platform metrics and recommending and implementing improvements; assisting the team with performance tuning for
ETL and database processes; and owning and maintaining the data refresh processes in the test environments.

Education and Experience:

Master’s degree or higher (or foreign education equivalent) in Engineering, Computer Science, Management
Information Systems, or Information Systems and no experience.

OR

Bachelor’s degree (or foreign education equivalent) in Engineering, Computer Science, Management Information
Systems, or Information Systems and five (5) years of experience in job offered or five (5) years of experience in data
warehouse development.

Special Requirements:

• Demonstrated expertise performing data profiling; designing and implementing logical and physical data models,
including star schema design and ER models, using SQL on MSSQL or Oracle databases; and writing SQL scripts
and building ETL jobs to identify and correct bugs.
• Demonstrated expertise writing complex stored procedures and SQL query scripts on MSSQL or MySQL
databases to extract, manipulate and load data; and designing logical and physical layers of relational and
multidimensional SQL server database models using ERStudio.
• Demonstrated expertise designing ETL solutions using SSIS, SAP, SAS DI, Informatica, or DataStage; performing
custom coded ETL programming using SQL; performing capacity planning for database storage; and performing
performance optimization of ETL solutions.
• Demonstrated expertise designing SAP business objects, Tableau, or SAS BI reports for business users; and
gathering requirements from business users and converting to technical specifications.

[Expertise may be gained during Graduate program.]

For the position listed above, interested candidates may search by job code 21618 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


Build/ Release Engineer
Description: Let companies apply to you, not the other way around. Sign up with Hired to get access to thousands of companies currently hiring build and release engineers. Want to work for a company you love Are (more...)
Company: Hired
Location: Wenham
Posted on: 08/19/2019

Senior Mechanical Engineer
Description: Permanent position: Senior Mechanical Engineer needed for a full-time opportunity in the Wilmington, MA area. The Senior Mechanical Engineer will be responsible for leading prototyping, conceptualization,
Company: Randstad Engineering
Location: Wilmington
Posted on: 08/19/2019

Senior SSO Engineer
Description: What you'll be doing... br br The Single Sign On SSO team is part of Chief Information Security Organization CISO . The SSO team provides Authentication and Authorization services to internal Verizon (more...)
Company: Verizon
Location: Boston
Posted on: 08/19/2019


Energy Engineer
Description: Permanent position: Immediate opening for an Energy Modeler working for an Engineering Consulting firm the Boston, MA area. br br Responsibilities for the Energy Engineer
Company: Randstad Engineering
Location: Boston
Posted on: 08/19/2019

Solutions Engineer - Service Platform, Direct Service & Claims
Description: Technologist - Service Platform, Direct Service Claims We are looking for a Technologist to develop and architect our service platform for the Direct Service Claims portfolio in our Digital organization. (more...)
Company: Liberty Mutual Insurance
Location: Boston
Posted on: 08/19/2019

Build/ Release Engineer
Description: Let companies apply to you, not the other way around. Sign up with Hired to get access to thousands of companies currently hiring build and release engineers. Want to work for a company you love Are (more...)
Company: Hired
Location: Braintree
Posted on: 08/19/2019

Build/ Release Engineer
Description: Let companies apply to you, not the other way around. Sign up with Hired to get access to thousands of companies currently hiring build and release engineers. Want to work for a company you love Are (more...)
Company: Hired
Location: Mattapan
Posted on: 08/19/2019

Optics Engineer
Description: Permanent position: Our client is looking to hire a Electro-Optics Engineer for their new facility in the Boston, MA area. This Electro-Optics Engineer will be responsible for the design, development, (more...)
Company: Randstad Technologies
Location: Andover
Posted on: 08/19/2019

Front-End Engineer
Description: Let companies apply to you, not the other way around. Sign up with Hired to get access to thousands of companies currently hiring front-end developers. Want to work for a company you love Are you a Front-End (more...)
Company: Hired
Location: Malden
Posted on: 08/19/2019

Quality Engineer PM Consultant I
Description: job summary: br br QMS Project Manager Needed in Andover, MA br br Support Business Group QMS team by preparing the QMS for a manufacturing site change. br br location: Andover, Massachusetts (more...)
Company: Randstad Technologies
Location: Andover
Posted on: 08/19/2019

Log In or Create An Account

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

Boston RSS job feeds