MathWorks Senior Data Warehouse Developer in Natick, Massachusetts
Senior Data Warehouse Developer
Apply Now (/company/jobs/apply/applynow?jobpostingid=24470&stid=24470&)
Department:Infrastructure and Architecture (/company/jobs/teams-roles/softwaredevelopment.html#infrastructure)
The Infrastructure, Architecture, and Tools team is looking for a motivated, fast-learning candidate to drive the design and development of data analytics tools and reports. You will be joining a fast-paced, dynamic software development team that is constantly solving new and challenging problems. We support the internal continuous integration system and many web-based applications that are the backbone of our Software Development process. You'll be working with internal teams to understand their data analysis and reporting needs in order to design, develop, and enhance our department's Data Warehouse. This role is responsible for supporting the entire Data Warehouse lifecycle, including gathering requirements, data profiling, design, development, testing, ongoing support and enhancements. You’ll be using data gathered from our internal systems to help us improve our Software Development process and to evolve our applications to meet the needs of the entire Development Organization.
Be the link between data providers and the Development Data Warehouse to ensure data integrity and to respond to changes from the data providers’ applications.
Work with data providers to ensure source data collected can support the Infrastructure team’s needs.
Profile and understand large volumes of source data, including structured and unstructured data. Sources will include MySQL, SQL Server, flat files, and the Cloud.
Design and develop ETL code using scriptinglanguages such as Perl and Python.
Regularly conduct ETL and database performance tuning. Look for ways to improve the overall performance of the system.
Identify opportunities to leverage existing metrics and develop new ones to help move the organization forward by identifying waste in our Development processes.
Create and maintain a system that helps ad-hoc metrics providers move to a more robust and sharable reporting interface.
Develop metrics and processes to ensure quality standards are met on new and existing data.
Establish service level agreements and best practices with Business Partners for reports and ad-hoc analysis.
- A bachelor's degree and 7 years of professional work experience (or a master's degree and 5 years of professional work experience, or a PhD degree, or equivalent experience) is required.
5+ years experience in business / intelligence, business analysis
Experience SQL coding/querying skills in SQL Server and/or MySQL
Experience with Data Warehouse design
Experience with one or more ETL tools such as Talend, Data Services, Data Integrator, Informatica, SSIS, etc.
Experience with Business Intelligence tools such as Microsoft Power BI, Tableau, or Business Objects.
Experience with large relational data sets, including load performance, query performance, archiving, etc.
Experience working with unstructured or semi-structured data, and time series data
Ability to provide total analytic support which includes data extraction from multiple sources, synthesizing and aggregating data and developing reports
Ability to clearly explain technical and analytical information (verbally, written, and in presentation format).
Experience with Python a plus
Experience with MATLAB a plus