ETL Data Analyst
ETL Data Analyst
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Not Disclosed
Salary Not Disclosed
1 Vacancy
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
Employment Type
Full Time
