Data Engineer - Azure Platform (6-8 yrs)

Job Purpose :

Responsible for delivering senior-level innovative, compelling, coherent software solutions for our consumer, internal operations and value chain constituents across a wide variety of enterprise applications through the creation of discrete business services and their supporting components.

Job Description / Duties and Responsibilities :

1. Designs, develops and delivers solutions that meet business line and enterprise requirements.

2. Participates in rapid prototyping and POC development efforts.

3. Advances overall enterprise technical architecture and implementation best practices.

4. Assists in efforts to develop and refine functional and non-functional requirements.

5. Participates in iteration and release planning.

6. Informs efforts to develop and refine functional and non-functional requirements.

7. Demonstrates knowledge of, adherence to, monitoring and responsibility for compliance with state and federal regulations and laws as they pertain to this position.

8. Strong ability to produce high-quality, properly functioning deliverables the first time.

9. Delivers work product according to established deadlines.

10. Estimates tasks with a level of granularity and accuracy commensurate with the information provided.

11. Works collaboratively in a small team.

12. Excels in a rapid iteration environment with short turnaround times.

13. Deals positively with high levels of uncertainty, ambiguity, and shifting priorities.

14. Accepts a wide variety of tasks and pitches in wherever needed.

15. Constructively presents, discusses and debates alternatives.

16. Takes shared ownership of the product.

17. Communicates effectively both verbally and in writing.

18. Takes direction from team leads and upper management.

19. Ability to work with little to no supervision while performing duties.

20. Proficient in ADF & good in Databricks

21. Strong in MS SQL & Azure SQL

22. Hands on experience in Data Lake

23. Hands-on experience in data mart and data warehousing including variant schemas (Star, Snowflake).

24. 5+ years of experience with advanced queries, stored procedures, views, triggers, etc.

25. 5+ years of experience of performance tuning queries.

26. 5+ years of experience of both DDL and DML.

27. 5+ years of experience designing enterprise database systems using Microsoft SQL Server/Azure SQL preferred.

28. Hands-on experience in Data Migration

29. Experience in Lakehouse architecture preferred.

30. Experience with SSIS is must.

31. Deep understanding of one or more source/version control systems. Develops branching and merging strategies.

32. Working understanding of Web API, REST, JSON.

33. Working understanding of unit testing creation.

34. Bachelor's Degree is required, and/or a minimum of four (4) + related work experience.

35. To adhere to the Information Security Management policies and procedures.