ETL Data Analyst Job at innovitusa, Des Moines, IA

cE1tUnBKTXRrK3BoQmx0YkhxRWdyeEdTS0E9PQ==
  • innovitusa
  • Des Moines, IA

Job Description

Hiring: W2 Candidates Only
Visa: Open to any visa type  with valid work authorization in the USA

Qualifications:

  • Extensive experience in conceptual and dimensional data modeling, including star schema design for data warehouses.
  • Strong proficiency in data modeling tools such as Microsoft Visio and/or Erwin.
  • Demonstrated ability to create clear and accurate data documentation, including entity definitions, mappings, and data dictionaries.
  • Strong verbal and written communication skills, with the ability to facilitate discussions and document requirements across technical and non-technical audiences.
  • Experience working with data warehouse teams, including DBEs and DBAs, in enterprise environments.
  • Familiarity with human services programs or public sector data systems is preferred.
  • Knowledge of data governance, metadata, and ETL processes is a plus.

Required skills and experience:

  • Data Analysis (7-9 years of experience)
  • Data Modeling in conceptual data modeling for large, complex system (7-9 years of experience)
  • Data Warehousing (4-6 years of experience)
  • SQL (7-9 years of experience)
  • Microsoft Visio and/or Erwin data modeler (4-6 years of experience)
  • Strong understanding, experience in design dimensional models and data modeling methodologies
  • Excellent verbal and written communication
  • Demonstrated ability to work closely with:
  • Business analysts and program subject matter experts
  • Database Engineers
  • Database Administrators
  • External contractors and project team
  • In addition, the ideal candidate will have skills and experience in:
  • Experience working with public sector, human services, or healthcare data systems (e.g., APD, CAM/CALMS, MMIS)
  • Familiarity with data governance, data cataloging, and metadata management initiatives
  • Experience supporting data warehouse development using  SQL Server Snowflake , or similar platforms

Job Tags

For contractors,

Similar Jobs