NantucketRecruiter Since 2001
the smart solution for Nantucket jobs

Data Warehouse Developer/Analyst

Company: The MathWorks, Inc.
Location: Natick, MA
Posted on: March 23, 2020

Job Description:

Working under the direction of the Senior Data Warehouse Developer - Senior Team Lead, will be responsible for designing, developing, and enhancing enterprise data warehouse and data marts; working with MathWorks stakeholders to understand their data analysis and reporting needs; supporting the entire data warehouse lifecycle, including gathering business requirements, data profiling, design, development, testing, ongoing support and enhancements; profiling and understanding large volumes of source data, including structured and unstructured data from MySQL, SQL Server, flat files, and Cloud sources; working with data providers to ensure source data collected can support marketing needs and can be integrated with other company data; gathering business requirements and developing data models that meet those requirements; conducting data model design reviews to help adoption of new models and changes to existing models; designing and developing ETL code using a variety of tools including SAP Data Services; documenting code to assist others in understanding what has been built; regularly conducting ETL and database performance tuning and improving overall performance; supporting and troubleshooting developed code; conducting thorough unit and integration tests to ensure the highest quality results; working with users to develop solutions using BusinessObjects, Power BI, and Tableau; and providing day-to-day support to data consumers and other team members.

Education and Experience:

Masters degree or higher (or foreign education equivalent) in Engineering, Computer Science, or Management Information Systems and no experience.

OR

Bachelors degree (or foreign education equivalent) in Engineering, Computer Science, or Management 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 performing data profiling, designing and implementing logical and physical data models, including star schema design and ER models, on an Oracle, MSSQL, or MySQL database.

• Demonstrated expertise designing ETL solutions using SAP Data Services or Informatica; 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 BusinessObjects, PowerBI, Tableau or OBIEE.

[Expertise may be gained during Graduate program.]

For the position listed above, interested candidates may search by job code 23588 for specific job details and requirements and apply online on the Careers Page at http://www.mathworks.com/company/jobs

Keywords: The MathWorks, Inc., Nantucket , Data Warehouse Developer/Analyst, Engineering , Natick, MA, Massachusetts


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 Massachusetts jobs by following @recnetMA on Twitter!

Nantucket RSS job feeds