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