• US Citizen

• Green Card

• EAD (OPT/CPT/GC/H4)

• H1B Work Permit

• Corp-Corp

• W2-Permanent

• W2-Contract

• Contract to Hire

• Consulting/Contract

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 16th Aug 2024

 1. 4-7 years overall experience in Data Integration, Data Architecture, Data Modeling, and implementation.

 2. 4-7 years of full lifecycle data warehousing experience.

 3. In depth hands-on experience designing, implementing, and troubleshooting ETL/ELT processes.

 4. Knowledge of relational database designs and concepts including normalization and dimensional models.

 5. Knowledge of state longitudinal data systems and preparing them for technological advancements and features.

 6. Experience with Apache Airflow and creating DAGs to move data from source to target.

 7. Experience with Python coding.

 8. Develop system/integration test plans and scenarios for data loads and extracts.

 9. Manage and monitor production and non-production ETL sessions.

10. Ability to coordinate and work with network and other system administration teams to isolate resource bottlenecks (bandwidth/network, CPU, memory, disk/storage). 11. Good knowledge of applicable data privacy practices and laws (FERPA).

12. Knowledge of different standards in the Education domain CEDS, ED-FI, SIF.

13. Familiarity with student academic performance data and education data concepts.

14. BI knowledge: 3-5 years in BI from ETL perspective.

15. Ability to observe steps and ascertain success of step or failure and root cause of step(s).

16. Direct experience in implementing enterprise data management processes, procedures, and decision support.

17. Experience in Dimensional Modeling.

18. Experience with Snowflake a plus.

19. Experience with modern data management in the cloud, preferably AWS (e.g., RDS, Dynamo, S3).