ETL Developer

ETL Developer

Developer

Remote

Asset Management Banking

JO-2109-1365

Reporting to the Head of Data Management, the Senior ETL Developer is responsible for the design, development and maintenance of our data and reporting marts and zones and the data transformations from the Enterprise Data Warehouse (EDW), Marts and downstream consuming applications.

Designing and developing architectures for efficient and scalable data transformations inbound to the EDW and outbound to consuming data stores and systems within Azure and the BP Enterprise Data Architecture.

Provides subject matter expertise in addressing projects and issues that encompass a wide range of internal and external systems (Core banking, Wealth, Trust, Data Warehousing), components, and processes.

Work closely with Enterprise Data Management and Reporting team members such as Data Analysts, Report Developers, QA, Release Management and other software engineers to develop and release new capabilities as well as research technical requirements and resolve issues.

Troubleshoot and resolve technical issues with data migration and transformation within the Microsoft Azure environment such as DataBricks, Data Factory, bespoke code, and other applications in the Development. Test and Production environments. Perform production deployments.

Ensure the quality, completeness, security, privacy, and integrity of data throughout the data lifecycle, especially from Data Lake through downstream data delivery and reporting.

Implement code changes and follow DART's control process including code check in, code reviews, jira issue updates.

Leverages industry best practices data transformation and processing techniques, tools and coding languages, data models, query optimizations & analytics; share same with team.

Extend and maintain the EDW/Mart zone such that they enable self-service capabilities for business power users to self-upload, analyze and report on governed data assests.

Serve as lead developer to ensure all standards and polices are implemented, maintained and enforced.

Qualifications:

• 10+years' Application Development/Engineering experience across a diverse technology base.
• Demonstrated understanding and successful application of proven database design principles such as: requirements analysis, data normalization, data modeling, risk management and quality assurance and for OLTP and OLAP database systems.
• Demonstrated expertise with relational databases (SQL server, Oracle), star schemas required.
• 5+years' experience with Microsoft ETL and data transformation technologies including but not limited to SQL Server database, SSIS SSRS and SSAS and their application within the Microsoft Azure environment and tools such as Data Bricks.
• Hands on experience and expertise in SQL, Python, Scala, Java.
• 3+ Years developing in Microsoft Azure, AWS or Google Cloud.
• Working knowledge of Spark, Lamda, Kafka.
• Strong direct Data Modeling experience using Relational, Dimensional and other approaches related to SQL and NoSQL databases.
• Experience with MongoDB, Sybase, Exadata, and HBase.
• Financial Services experience in Banking and/or Lending, Investment Management. and/or Advisory is a requirement.
• An understanding of AI/ML applications is required and experience a plus.
• Experience with BI tools such as Tableau is a plus.