Job Summary
- Job : 28731-DCOL
- Location :
- Department :
- Working under the direction of the Manager or Senior Team Lead, will be responsible for designing, developing and testing sophisticated data warehouse software;
- designing and developing data mart solutions to provide MathWorks with valuable customer and product insights; profiling and understanding large amounts of source data, including structured and semi-structured data;
- collaborating with stakeholders to address data and system gaps and developing integrations with other company data; translating user requirements into data models and data mart designs;
- designing and developing ETL processes to load data into MathWorks' data marts using a variety of tools, including BusinessObjects Data Services;
- conducting thorough testing of data mart solutions to ensure quality; conducting performance tuning, troubleshooting and operational support;
and providing support and mentoring to end users to support their data needs. Participates in 24 / 7 on-call support every two months.
Responsibilities
Qualifications
Minimum Qualifications :
Education and Experience :
Master’s degree in Engineering, Computer Science, or a closely related field (or foreign education equivalent) and two (2) years of experience in job offered or two (2) years of experience in data warehouse development and database modeling.
Bachelor’s in Engineering, Computer Science, or a closely related field (or foreign education equivalent) 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, ETL code and performance optimization using SSIS, SAP or Informatica, and implementing data reporting solutions using BI tools.
- Demonstrated expertise writing complex stored procedures and SQL query scripts on Teradata, DB2, MSSQL or MySQL databases to extract, manipulate and load data.
- Demonstrated expertise performing database implementation, including strategizing data acquisition, archiving recovery, and designing solutions for business intelligence and data warehouse platforms.
- Demonstrated expertise designing logical and physical layers of relational and multidimensional SQL Server, Teradata, DB2, and Oracle database models using data modeling tools ERStudio or Erwin, and implementing user-based security for underlying database objects.
Expertise may be gained during Graduate program.
Senior Business Intelligence Analyst Developer, Epic Cogito Certified
Senior Business Intelligence Analyst Developer, Epic Cogito Certified-(3287138). Senior BI Analyst/Developer certified in Epic Cogito. The Senior BI Analyst/Developer, Epic Cogito Certified will report to the Cogito Analytics Manager. Provide expertise in relational databases, report writing tools, ...
Senior Health Data Analyst - Data Onboarding - Veeva Compass
Senior Health Data Analyst on the Data Onboarding Team for Veeva Compass. Data onboarding - onboard health data sources, focused on understanding the supplier data and how it may impact our data network. Veeva Compass is our suite of data products including prescription and medical claims record-lev...
Data Warehouse Analyst- Pipeline
Proven experience as a Data Warehouse Analyst, Data Warehouse Engineer, or similar role. Design, build, and maintain data warehouse systems, ensuring efficient data management and integrity, and supporting data analytics. Responsibilities include developing warehouse architecture, collaborating on d...
Senior Analyst, Fixed Income Data Science - Liberty Mutual Investments
LMI is seeking a talented Senior Analyst to join the Strategy & Rates team within our Global Fixed Income (GFI) unit. The Senior Analyst will support team members, Portfolio Managers, and Traders on a wide variety of special projects ranging from portfolio construction, performance assessment an...
Senior Business Intelligence Analyst Developer
As a Senior BI Analyst/Developer certified in Epic Cogito, you will play a pivotal role in providing analytics insights and developing data solutions to support clinical and business operations. Senior Business Intelligence Analyst Developer-(3290026). Senior Business Intelligence Analyst Developer,...
Senior Data Analyst
Ensures data integrity and compliance by performing data cleansing, data audit and/or data validation. Ensure data integrity and compliance by performing data cleansing, data audit and/or data validation. Provides business process, system support and data quality governance through data coordination...
Senior Analyst, Corporate Actuarial (Actuarial Data Management)
This Senior Analyst position is in the Corporate Actuarial Department at Global Atlantic’s Boston office, reporting to the Head of Actuarial Data Management. The position offers great opportunities to interact with experienced actuaries across multiple functions (modeling, risk, valuation and pricin...
Senior Analytic Data Analyst
The incumbent delivers data profiling, conducts testing and systems validation to troubleshoot data anomalies, monitors data management metrics and data loads. This job understands healthcare data from end-to-end and analyzes raw data and analytic data for the enterprise. Verify analytic data for th...
Senior Data Analyst (Flex Office/Home)
You will bring 5+ years of data analyst experience, along with experience using these tools. You will report to the Senior Manager of Data Analytics. Analyze and address data quality issues, test and analyze impact of system changes to data/reporting infrastructure. You will use data, statistical an...
Senior Data Analyst
The Senior Data Analyst provides advanced-level analysis and reports that support clinical and operational programs and activities; works independently to design and create data models, document data requirements and develop data reporting systems; demonstrates initiative and creativity in accessing...