Senior Data Warehouse Developer
Company: The MathWorks, Inc.
Location: Natick, MA
Posted on: February 24, 2020
Job Description:
Working under the direction of the Development Applications
Manager 2, will be responsible for designing and developing data analytics tools and reports; supporting the
internal continuous integration system and web-based applications; working with internal teams to understand their
data analysis and reporting needs in order to design, develop, and enhance organizational data warehouse and data
marts; supporting the entire data warehouse lifecycle, including requirements gathering, data profiling, design,
development, testing, ongoing support and enhancements; using data gathered from the internal systems to help improve
product development process and to evolve MathWorks applications to meet the needs of Development; serving as the
link between data providers and the Development Data Mart to ensure the right data is in the warehouse and is updated
as changes occur in the data providers applications; working with the data providers to ensure source data collected
can support the Infrastructure teams needs; profiling and understanding large volumes of source data, including
structured and unstructured data, from MySQL, SQL Server, flat files, and the Cloud sources; designing and developing ETL
code using Perl and Python scripting languages; conducting ETL and database performance tuning to improve
overall performance; identifying opportunities to leverage existing metrics and developing new metrics to help move the
organization forward by identifying waste in processes; creating and maintaining a system that helps ad-hoc metrics
providers move to a more robust and sharable reporting interface; developing metrics and processes to ensure quality
standards are met on new and existing data; and establishing service level agreements and best practices with
Business Partners for reports and ad-hoc analysis. Education and Experience: Masters degree or higher (or foreign education equivalent) in
Engineering or Computer Science and two (2) years of experience in job offered or two (2) years of experience in data
warehouse development and database modeling. OR Bachelors degree (or foreign education equivalent) in
Engineering or Computer Science and six (6) years of experience in job offered or six (6) 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 -- strategizing data acquisition, archiving recovery,
and designing solutions for data warehouse platforms -- and ETL code and performance optimization using SSIS and
Informatica. Demonstrated expertise developing and optimizing database
objects -- indexes, triggers, functions, and stored procedures; writing stored procedures and SQL query scripts on
MSSQL and MySQL databases to extract, manipulate and load data; and implementing data reporting solutions using
BI tools and TSQL programming. 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 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 23461 for specific job details and requirements and apply online on the Careers Page at
http://www.mathworks.com/company/jobs
Keywords: The MathWorks, Inc., Plymouth , Senior Data Warehouse Developer, Engineering , Natick, MA, Massachusetts