-
Data Architecture and ETL Development
-
Leading technical discussion and collaborating with data technology and architecture team. Contribute to designing and implementation of data architecture and technology infrastructure to feed data into various front office applications leveraging Azure data stack (Data factory, Data bricks, ADLS, Synapse)
-
Develop and maintain warehousing leveraging Azure native services and Snowflake
-
Design and build scalable ETL workflows using data bricks and data factory for all data ingestion and retrieval from the data platform
-
Write complex Python, SQL for ETL and data extractions with high performance and easy to manage code
-
Build custom services and workflows to provide functionality when required to complement existing tools, i.e. convert to ingestible formats, call external web services and third-party APIs
-
Create database objects with strong understanding of data modeling
-
Develop and maintain automated build and deployment process for all solutions using cloud tools
-
Production Support and Maintenance
-
As technical support lead, work closely with business systems analysts, SMEs on project and operations to deliver effective support, investigate root causes, recommend changes, and maintain accurate documentation
-
Develop functional specifications and systems configurations documentations to support solution roll out
-
Reverse-engineer, investigate and document data flow for operational procedures and support
-
Evaluate existing data flow and operations, develop process for effective maintenance, monitoring and performance tuning, and recommend improvements for operational efficiency
-
Provide health status of operations within platform with specific support for database and ETL processes
-
Implement Enhancements
-
Partner closely with business users to understand requirements and rapidly prototype reports to maximize end-user involvement and solicit feedback
-
As a technical lead, enhance environment stability by working with others to set up and maintain production configurations. Continuously improving service levels with all business and technical stakeholders
-
Automate manual processes, optimize data delivery, and redesign infrastructure for greater efficiency and scalability
-
Initiate knowledge dissemination of design, coding, and analysis techniques in collaborative manner
-
Facilitate testing of solutions and production implementation planning while performing as a trusted liaison between IT, Investment business stakeholders, and external solution providers
-
Think creatively to design solutions, addressing both business and technical aspects, with a forward-thinking approach to best accommodate future opportunities
-
Incorporate operational risk and systems performance management in all initiatives
-
Design and develop reports and analytical dashboards in Power BI
