ETL Developer

Application Development, Database design, SQL, Oracle, Star Schemas, ETL, Microsoft Azure, AWS, Google Cloud, Best practices
Full Time
Depends on Experience

Job Description

Want to support a firm that views their technology as a competitive advantage?  Great environment and group of people to work with.  If you are exploring new roles, let’s connect.

  • 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.
Dice Id : 10514640
Position Id : 2109-1365
Originally Posted : 2 months ago
Have a Job? Post it

Similar Positions

IT Business Intelligence Developer / Analyst
  • E-Business International, Inc.
  • Houston, TX, USA
Data Warehouse Developer - G
  • Next Step Systems
  • West Chester, PA, USA
Database Developer IV
  • DriveTime
  • Tempe, AZ, USA
Data Engineer, Enterprise Data Warehouse - M
  • Next Step Systems
  • Chicago, IL, USA
BI Developer - Hybrid remote
  • The Edgewater Group LLC
  • Warren, NJ, USA
ETL Developer
  • Fulcrum Digital, Inc.
  • Clearwater, FL, USA
IT Data and Analytics Developer
  • Korn Ferry/Arconic RPO
  • Bettendorf, IA, USA
Direct Hire - Data Engineer
  • Guardian Info Group
  • Tampa, FL, USA
Senior Business Intelligence Engineer
  • DriveTime
  • Tempe, AZ, USA
Senior Power BI Developer
  • ComTec Information Systems
  • Houston, TX, USA