ETL Data Analyst

Hiring : W2 Candidates Only

Visa : Open to any visa type with valid work authorization in the USA

• Collaborate with CAM / CALMS contractors and ORRAI DBEs andDBAs to gather and clarify data requirements.
• Develop a comprehensive conceptual data model that defines key business entities relationships and data domains for the CAM system.
• Translate the conceptual model into a dimensional model (star schema) suitable for data warehouse integration.
• Design and document fact and dimension tables in alignment with data warehousing best practices.
• Develop mapping documentation between CAM system data and the designed star schema to support ETL planning and implementation.
• Create and maintain a detailed data dictionary for all modeled entities attributes and business rules following ODHS metadata standards.
• Facilitate workshops and meetings to validate models with stakeholders and ensure shared understanding.
• Use tools such as Microsoft Visio or Erwin to produce clear and maintainable diagrams and documentation.
• Ensure all deliverables align with ORRAIarchitecture data governance practices and metadata frameworks.
• Provide support and consultation as the data structures move through the logical and physical implementation phases in the ODHS data warehouse .

Qualifications :

Required skills and experience :

Key Skills

Data Analytics,Microsoft Access,SQL,Power BI,R,Data Visualization,Tableau,Data Management,Data Mining,SAS,Data Analysis Skills,Analytics

Employment Type : Full Time

Experience : years

Vacancy : 1