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., Attleboro , Data Warehouse Developer/Analyst, Engineering , Natick, MA, Massachusetts