Data Warehouse Consultant Job Description
Data Warehouse Consultant Duties & Responsibilities
To write an effective data warehouse consultant job description, begin by listing detailed duties, responsibilities and expectations. We have included data warehouse consultant job description templates that you can modify and use.
Sample responsibilities for this position include:
Data Warehouse Consultant Qualifications
Qualifications for a job description may include education, certification, and experience.
Education for Data Warehouse Consultant
Typically a job would require a certain level of education.
Employers hiring for the data warehouse consultant job most commonly would prefer for their future employee to have a relevant degree such as Bachelor's and Master's Degree in Technical, Computer Science, Engineering, Information Technology, Mathematics, Management, Business, Leadership, Finance, Science
Skills for Data Warehouse Consultant
Desired skills for data warehouse consultant include:
Desired experience for data warehouse consultant includes:
Data Warehouse Consultant Examples
Data Warehouse Consultant Job Description
- ETL systems using Information Builder Data-Migrator
- Reports, analysis and dashboards using TIBCO Spotfire and Information Builder’s Web Focus & Info Assist
- Automation of source system data extraction processes and data loading of the BI Data Warehouse
- Create system documentations using Visio
- The consultant will adhere to application development standards, including, but not limited to, project management methodology, SDLC (software development life cycle), Enterprise Architecture standards and the IT governance process
- Consultant / Data Warehouse developer in the SCRUM/Agile project
- Support in data processing for topics like for example SNOW, ServiceCo
- Plan and build a full security concept in order to cope with legal restrictions, mainly from the SNOW side but as well for other topics like HR-Reporting, EWFM
- Has a good understanding of how to automate proper system checks and balances
- Support the data warehouse design and integration efforts, ETL including data sourcing and transformation, logical/physical modeling, Solution Development and tuning
- 5+ years of experience in BI Tools, including Qlikview and/or Cognos
- Degree or equivalent in Software Engineering or similar technical discipline
- Experience in developing custom applications
- English sufficient for communication and reading
- Solid Exposure to Modeling tool
- Exposure to ETL tools
Data Warehouse Consultant Job Description
- Develop and maintain up-to-date knowledge of ADW and OAC products and service offerings
- Propose performant designs and tuning solutions
- Responsible for the coordination and oversight of Data Warehouse / Submission requests required to support Health Plan operations, its Clients and trading partners
- Responsible for the coordination of day to day operational performance needs (ex
- Support content development for deliverable artifacts to deliver client value and meet contractual obligations, and that align to delivery timelines and budgets
- Consult and contribute to the design and architecture of client data warehouse
- Work with both business and technical teams to define requirements, make recommendations on approach and provide guidance to the technical team
- At times, get involved with hands-on technical work
- Instructs, directs and reviews the work of less experienced data warehouse analysts
- Acts as team leader for large-scale, complex projects and sets and communicates common goals and directions for team
- Knowledge of Hadoop ecosystem - HDFS, Hbase, Hive, Sqoop, Spark
- Understanding of BI Reporting Tools (QlikView ) a plus
- Big Data Development skills
- Ability to prioritize assignments, handle shifting deadlines and work independently in a team environment
- Excellent ability to translate business requirements
- BOE reporting experience
Data Warehouse Consultant Job Description
- Analyzes highly complex business user needs, documents information requirements, facilitates the identification of potential gaps in available data and collaborates with business areas to determine best means for acquiring the data needed
- In-depth experience of engineering/reverse engineering business/technical requirements into the appropriate data model (conceptual, logical, physical) for the situation
- Hands-on experience/practical knowledge using data profiling and visualization technologies such as I, Talent, Python, Java, Hadoop (Sqoop, HIVE, HBASE), IDQ, AXON, EIC, Teradata, ETL, and Tableau
- Experience using Python or JAVA framework to create and maintain data quality rules through a data quality governance process
- Has a strong understanding of enterprise data management frameworks to be able to find a root cause of a data anomaly
- Hands-on experience working within an Structured Agile Framework Environment and using JIRA and Confluence
- Assist in maintaining a clean, organized warehouse environment at all times Comply with all applicable laws / regulations, company policies / procedures
- Works with business leaders to identify and develop metrics and visualizations that will track performance and highlight potential inefficiencies
- Partners with business teams to gather, document and maintain business requirements that will inform data modeling decisions
- Required strong analytical acumen with the ability to uncover insights and create stories by seamlessly integrating a variety of data sources
- Experience with healthcare administration platforms and EMR systems (Facets, NextGen, Cerner)
- Prefer knowledge/background in the following subject areas
- Provider Capitation
- Metadata development
- 5-7+ years of experience as technical expert centered around a technology, technologies or a portfolio of applications
- 5+ years of experience in designing and creating DataMart, Data warehouse using Star & Snowflake Schemas
Data Warehouse Consultant Job Description
- Experience with relational databases, OLAP Cubes and data warehousing (Oracle, DB2, Hadoop) preferred
- Experience in data mining and root cause analysis preferred
- Data Warehouse Solutions Architect experience
- QA capabilities and diagnosis on existing database installations
- Ability to lead colleagues and small teams
- Design an extensible data model that reflects the business and supports the analytical objectives we are trying to achieve
- Review project documentation which outlines the required data elements in the source for extraction to the Data Warehouse
- Define the processes from identified Data Sources/Elements into a manageable subset of data for extraction
- Perform complex analysis and design across multiple database platforms and technologies
- Specify data points for extraction and recommend any required data sets and elements to improve delivered data products
- 4+ years of experience with TIBCO Spotfire
- 3+ years of experience in developing, and maintaining end-to-end ETL data pipeline using IBI Data Migrator
- 4+ years of experience in creating technical documentation for new and existing DW, DM and ETL systems
- 3+ years of experience in developing data warehouse systems in Workers’ Compensation Insurance industry (for both underwriting and Claims) including medical billing systems
- 2+ years of experience with Innotas
- Provide in-depth systems analysis, design and development for existing mainframe Teradata Enterprise Data Warehouse (EDW), which is a client data warehouse used for reporting & metrics across the company globally (North America, Latin America, Europe, Asia/Pacific)
Data Warehouse Consultant Job Description
- Design an automated, scalable, extensible ETL / ELT process to pull data from the source systems and transform it into the analytical model
- Design, build, and test on premises and cloud-based data warehouse and pipelines
- Develop data integrations between internal and external data environments
- Document data warehouse design plan, topography, and use cases
- Conduct JAD sessions to gather or confirm requirements
- Develop Use Cases, test cases and scripts
- Evaluate and assist team in ETL and database performance tuning
- Brief high-level summaries of JAD sessions to PM on at least a weekly basis, or more often if required
- Notify PM of concerns or questions regarding information shared in JAD sessions
- Working with customers on building the use cases for ADW
- The EDW supports applications that are highly integrated with other client systems, and contain numerous internal and external dependencies and interfaces
- Position also includes analysis of issues/questions, design/development and launch of changes, participation in testing with Enterprise Release Management (ERM), projects, other applications, handling multiple tasks with varying deadlines, and being flexible to changing priorities
- Data Stage or similar ETL technology
- Teradata, DB2, data warehousing environment
- Strong drive for results and ability to work independently and respond to changing priorities
- Experience in DataStage or similar ETL technology