Data Warehouse Consultant Job Description
Data warehouse consultant
provides support and maintain production SQL Server database systems of different versions including administering database security and SQL Server Reporting Services.
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:
Source System extraction processes for the Data Warehouse using Oracle PL/SQL
Create scripts on database level (T-SQL), C# (application servers), mainly to support the platform MyReports around scheduling, automation
Support platform upgrade and migration from SQL Server 2008 to 2014
Collaborates with IT resources on the creation and maintenance of the content of the data warehouse, establishes and maintains advanced knowledge of data warehouse data structure design, definitions, capabilities, SQL, and data integrity issues, completes metadata assessment and reviews feedback to determine changes, ensures that data definitions are clear and current, and communicates changes to data definitions to all users
Detailed knowledge of transformation strategies to convert different types of database models from one form to another (network, relational, dimensional, and columnar)
Design, development, maintenance and implementation of Big Data class solutions
Development of custom applications, application components and database objects in support of information systems
Participation in projects in the areas of business intelligence and data warehousing
Requirements Analysis – Conduct requirements gathering sessions
Evaluate access paths for data which spans multiple deployed technologies
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:
SQL programming
SQL
ADW and OAC products and service offerings
Any particular industry
Relational database concepts
Data warehouse and analytical solutions
Relevant Oracle products and services within the rapidly evolving PaaS offerings
Transformation strategies to convert different types of database models from one form to another
Especially within Datawarehouse and Business Intelligence area
Agile DW/BI development practices
Desired experience for data warehouse consultant includes:
Understanding of J2EE architectures
Experience with Big Data software and architectures (Apache Hadoop, Hive, Impala, Spark, NoSQL database)
Knowledge of and experience with statistics, modeling and numerical analysis
Experience of the software lifecycle stages, including requirements gathering, analysis and design stages
Good communication (both oral and written) skills, with the ability to peer with technical teams and to abstract to communicate clearly to wider project and customer teams
Responsibility and high self-reliance
Data Warehouse Consultant Examples
1
Data Warehouse Consultant Job Description
Job Description Example
Our growing company is looking for a data warehouse consultant. To join our growing team, please review the list of responsibilities and qualifications.
Responsibilities for data warehouse consultant
- 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
Qualifications for data warehouse consultant
- 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
2
Data Warehouse Consultant Job Description
Job Description Example
Our growing company is looking to fill the role of data warehouse consultant. Please review the list of responsibilities and qualifications. While this is our ideal list, we will consider candidates that do not necessarily have all of the qualifications, but have sufficient experience and talent.
Responsibilities for data warehouse consultant
- 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
Qualifications for data warehouse consultant
- 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
3
Data Warehouse Consultant Job Description
Job Description Example
Our company is looking to fill the role of data warehouse consultant. We appreciate you taking the time to review the list of qualifications and to apply for the position. If you don’t fill all of the qualifications, you may still be considered depending on your level of experience.
Responsibilities for data warehouse consultant
- 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
Qualifications for data warehouse consultant
- 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
4
Data Warehouse Consultant Job Description
Job Description Example
Our innovative and growing company is hiring for a data warehouse consultant. If you are looking for an exciting place to work, please take a look at the list of qualifications below.
Responsibilities for data warehouse consultant
- 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
Qualifications for data warehouse consultant
- 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)
5
Data Warehouse Consultant Job Description
Job Description Example
Our company is hiring for a data warehouse consultant. To join our growing team, please review the list of responsibilities and qualifications.
Responsibilities for data warehouse consultant
- 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
Qualifications for data warehouse consultant
- 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