Delivery data leader Job at Promantis Inc
Overview
Delivery data leader with exposure/experience in Snowflake, Talend, BI etc
Remote Position.
Role & Responsibilities at job :
Delivery :
Training :
Requirement :
Behavioral Competency :
Qualification :
- Solution Development
- Architecting, Planning and Implementation of end-to-end Data Warehouse and Business Intelligence systems utilizing best practices from Data Architecture, Data Integration and Data Management areas.
- Establish data standards and templates to improve quality and integrity of data
- Design Backup and Recovery Policy for the Enterprise Data warehouse (EDW)
- Integration of diverse data sources with the EDW.
- Developing Analysis Model for the business subject areas.
- Exposure in Talend & Informatica.
- Identify and understand Source Data Systems. Map Source System Data to EDW Data Model.
- Design and develop extraction, transformation, and load (ETL) processes.
- Define and capture Meta Data and rules associated with ETL processes.
- Query Tuning for performance.
- Use Business Intelligence tools and OLAP to generate cubes and analytical reports on large volumes of data
- Defining Strategy and Architecture for systems involving Data Warehouse, ETL, BI Reporting, Data Marts, ODS, Data Governance, Data Quality, Meta Data Management etc. Assist in effort estimation for new projectsproposals.
- Develop and implement standards, procedures and best practices for data maintenance, reconciliation and exception management.
- Demonstrate technical leadership
Delivery :
- Ensure delivery of technical engagements by exceeding customer expectations.
- Provide expert consultation for EDW architecture and best practices to customers and internal employees.
- Prepare ETL and BI Estimation and Pricing for customer and internal projects
- Lead small to medium size projects, and manage the execution by planning project activities, assigning tasks to team, tracking and monitoring the tasks, and working with close coordination with the project manager.
Training :
- Provide training and support for EDW customers; educate customers on the value of EDW
- Business Development
- Need to actively contribute to Pre-Sales BD for custom solution designing as per customer requirement
- Author solutions for current and potential customer concerns, including responding to RFPs and developing white papers.
Requirement :
- Overall 9+ years of experience in technical leadership in data warehousing and Business Intelligence areas. Must have designed and implemented Data Warehouse and Business Intelligence solution as a lead Architect for at least 2 end-to-end large scale systems.
- Should have successfully done 1-2 end to end DW implementations in Pharma or Life Sciences Business domains
- Experience in architecting, optimizing, & maintaining large enterprise databases.
- Extensive knowledge of dimensional modelling, Star & Snowflake schema designs, Data Mining methodologies, and latest in the field such as XML Warehousing, In-memory & column-store DBMS, cloud based DW design.
- Experience in ETL data integration tools like Informatica, MSFT SSIS, Oracle Data Integrator, Data Stage, Ab Initio.
- Expert knowledge of SQL and PLSQL
- Knowledge of SQL (Query) tuning using Oracle specific constructs, optimizing batch process as well tuning various ETL jobs.
- Knowledge in Data Analysis & Logical Data Modelling
- Business analysis capability to work with HLDD, LLDD and other design documents (Oracle and SQL an advantage)
- Should have experience in developing data dictionaries and data library
- Ability to classify the data that is required for business integration and reporting application
- Good to have experience in OLAP Cube designing
- Good to have experience working on BI Tools like Microstrategy, Tableau, Qlikview
Behavioral Competency :
- Proven ability to handle multiple projects while meeting deadlines and documenting progress towards those deadlines.
- Excellent communication skills (must be able to interface with both technical and business leaders in the organization)
- Ability to be a self-starter and can provide leadership
- Strong analytical skills to solve and model complex business requirements are a plus
Qualification :
- Bachelor's degree in computer science or related field.
- TOGAF Certification would be big plus
- Experience working on PharmaLife Sciences projects will be a plus
- A minimum of 8 years of relevant Data Management and DW-BI design and architecture experience (BI solution design experience will be preferred).
Job Details Open Until Filled Recruitment Manager Michael R Job Code JPC - 936 Required Hours/Week 40 Experience 10-15 Years Required Documents Resume Primary Skills ETL,Data modelling,OLAP,Oracle data engineer Zip Code N/A Work Authorization N/A Contact Person Details Jayanthan Sidharth Technical Recruiter N/A sidharth.j@promantisinc.com
Please Note :
blog.nvalabs.org is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, blog.nvalabs.org provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, Site.com is the ideal place to find your next job.