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, will be responsible for supporting the ongoing development
and maintenance of MathWorks data warehousing systems and data
marts; making valuable contributions to the continuous transformation and
improvement of MathWorks information systems; supporting the entire data
development lifecycle, including data profiling, ETL and data model design
and development, testing, and support; working with project teams
and business users to understand their analysis and reporting
requirements and ensure that the design and delivered work meets those user
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; performing
database ETL programming: understanding the source data available and
mapping sources to the target design using tools such as SAP Data
Services; conducting thorough testing of ETL code changes to ensure
quality of data produced; monitoring the DW platform metrics, while
recommending and implementing improvements; assisting the team with
performance tuning for ETL and database processes; and sharing
responsibility for the administration of development, test, and production
environments. 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. Special Requirements: • Demonstrated expertise performing data profiling, designing
and implementing logical and physical data models, including star
schema design and ER models, on MSSQL and MySQL databases. • Demonstrated expertise writing complex stored procedures and
SQL query scripts on MSSQL and MySQL databases to extract,
manipulate and load data. • Demonstrated expertise designing ETL solutions, using SSIS,
SAP, 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 data visualizations --
reports and dashboards -- using Power BI and Tableau. [Expertise may be gained during Graduate program.] For the position listed above, interested candidates may search
by job code 20789 for specific job details and requirements and apply
online on the Careers Page at http://www.mathworks.com/company/jobs
Keywords: The MathWorks, Inc., Somerville , Data Warehouse Developer/Analyst, Engineering , Natick, MA, Massachusetts