DATA WAREHOUSE CONSULTANT SKILLS, EXPERIENCE, AND JOB REQUIREMENTS

Published: October 11, 2024 – The Data Warehouse Consultant excels in ETL processes, data warehouse design, and development, utilizing tools like Informatica and BI tools such as Business Objects. This role requires strong data modeling skills in Enterprise and Dimensional Models, along with expertise in MPP databases like Teradata, focusing on design, performance tuning, and complex programming. Additionally, the consultant has a deep understanding of data quality processes, data analysis for insights, and proficiency in writing complex SQL queries.

Essential Hard and Soft Skills for a Standout Data Warehouse Consultant Resume
  • SQL
  • ETL Tools
  • Data Modeling
  • Data Warehousing Concepts
  • Business Intelligence Tools
  • Database Management
  • Data Visualization
  • Cloud Technologies
  • Performance Tuning
  • Data Governance
  • Communication
  • Problem-Solving
  • Analytical Thinking
  • Attention to Detail
  • Adaptability
  • Team Collaboration
  • Time Management
  • Critical Thinking
  • Client Management
  • Project Management

Summary of Data Warehouse Consultant Knowledge and Qualifications on Resume

1. BS in Computer Science with 5 years of Experience

  • Strong technical skills in Microsoft SQL Server and the Microsoft BI stack (SSIS, SSAS, SSRS).
  • Previous experience working on cloud environments such as Azure, Snowflake, GCP, or Synapse
  • Strong ETL and data migration capability, with Azure Data Factory or SSIS.
  • Broad understanding of Database structures, stored procedures, triggers, patterns and design.
  • Strong dimensional and relational data modeling skills.
  • Previous exposure to BI reporting or data visualization tools such as SSRS, PowerBI, QlikView or Tableau
  • Ability to understand and build high-level functional requirements to specification.
  • Innovative thinker with the ability to learn new concepts quickly.
  • Strong data modeling concepts, and ability to design and deliver greenfield Data Warehouse projects.
  • Team player, willing to help others, and share ideas and concepts for problem-solving.

2. BS in Information Technology with 6 years of Experience

  • Experience manipulating large sets of health-related data
  • Experience with employer plan designs - medical, drug, behavioral health, lost time, etc.
  • Experience with analytic deliverable review and financial reporting validation, quality control and reconciliation
  • Experience using data warehouse decision support tools such as IBM/Truven, Cotiviti, HDMS, Artemis, Springbuk or other similar vendors
  • Experience with Medical, Eligibility and Pharmacy claim coding patterns including CPT, DRG, ICD10 and other industry standard classifications
  • Experience handling multiple priorities
  • Experience building data-based reports/models/tools/processes and experience with any mix of the following - MS Excel and Power Pivot, SQL/SQL Server
  • Working experience reporting Automation using Python/R or similar scripting
  • Experience with big data systems including Hue, Impala, Hive, Spark, AWS or Microsoft Azure platform experience
  • Experience with other business objects-based tools - Tableau, Power BI

3. BS in Information Systems with 4 years of Experience

  • Work experience in similar or directly related functions, preferably in insurance or financial services.
  • Demonstrate advanced knowledge of relational databases such as Oracle, DB2, SQL Server, Teradata, and Snowflake,
  • Demonstrate advanced knowledge of ELT and ETL development. SSIS and Matillion programming experience
  • Advanced SQL querying skills.
  • Experience working with semi/unstructured data
  • Experience working with data modeling
  • Ability to work independently under general supervision with considerable latitude for un-reviewed actions or decisions.
  • Excellent interpersonal and communications skills, excellent problem-solving skills, and the self-motivation to improve skills and abilities.
  • Demonstrate professionalism and preferably an understanding of the insurance business.
  • Innovative thinker with the ability to learn new concepts quickly.

4. BS in Statistics with 7 years of Experience

  • Strong ETL (Informatica)/DWH design, design, and development experience.
  • Experience with Reporting/BI Tools (preferably BO), and Data Analytics.
  • Strong Data Modeling skills - Enterprise Data Model (OLTP) and Dimensional modeling. 
  • Well-versed with principles, techniques, and best practices of data modeling.
  • Strong Skills in MPP Database (preferably Teradata) including database design, performance tuning, writing complex DB programs, etc.
  • Demonstrate proficient skills in the analysis and resolution of application performance problems.
  • Strong SQL skills in at least one DB technology i.e. Teradata or any other database like Oracle, or UDB.
  • Full understanding of the processes of data quality, data cleansing, data transformation and data modeling
  • Ability to understand and analyze the data to find patterns and valuable Business Insights
  • Ability to write complicated yet efficient SQL queries and stored procedures
  • Knowledge of different financial instruments like Equities, Options, Futures, etc.
Relevant Information
Data Warehouse Developer Skills, Experience, and Job Requirements
Data Warehouse Analyst Skills, Experience, and Job Requirements
Data Warehouse Architect Skills, Experience, and Job Requirements
Senior Data Warehouse Architect Skills, Experience, and Job Requirements