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 SSIS & ADF
21. Strong in MS 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.
Job Description
28. Experience in Lakehouse architecture preferred.
29. Experience with Cloud technologies – AWS, Snowflake is preferred.
30. Deep understanding of one or more source/version control systems. Develops branching and merging
strategies.
31. Working understanding of Web API, REST, JSON.
32. Working understanding of unit testing creation.
33. Bachelor’s Degree is required, and/or a minimum of four (4) + related work experience.
34. To adhere to the Information Security Management policies and procedures.