EastHartfordRecruiter Since 2001
the smart solution for East Hartford 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., East Hartford , Data Warehouse Developer/Analyst, Engineering , Natick, MA, Connecticut


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 Connecticut jobs by following @recnetCT on Twitter!

East Hartford RSS job feeds