Job Description
Must-have skills: data modeling, Oracle SQL , Data Analysis Expressions (DAX), Microsoft Power BI specifically: Data Source Connections/Retrieval/Refreshing, Data Transformation and ETL, Data Modeling Microsoft Dataverse, Quick Measures, gov exp, Microsoft TEAMS, agile.
Requirements:
• Experience in data modeling (5+ years)• Experience in writing Oracle SQL (5+ years)• Experience with Data Analysis Expressions (DAX) (5+ years)• Experience in Microsoft Power BI specifically• Experience with Data Source Connections/Retrieval/Refreshing• Experience with Data Transformation and ETL• Experience with Data Modeling, Microsoft Dataverse, Quick Measures• Bachelor’s degree in computer science or IT related field is requiredPreferred:•Governmental experience•Experience working in Microsoft Teams•Experience working in Agile environment
Responsibilities include but are not limited to the following:
• Conduct data requirement gathering sessions with the H2O-POC project team.
• Understand the data set and model needed to create the data visualization dashboard(s)• Iterate on the data model as new data sets are added.• Ensure acceptance criteria: Approved Data Model and Data Set Definition.• Ensure business user reviews and approves the data set documentation.• Extract, transform, and load (ETL) the data set into the data model.• Document the ETL process, including data flow diagram and narrative