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