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