Data Warehouse Analyst ETL Developer

Watercress Financial Group - West Des Moines, IA

Full-time

West Des Moines, IA

About the position

The Data Warehouse Analyst - ETL Developer at Watercress Financial Group LLC is responsible for analyzing and assisting in the development of ETL environments and systems, providing production support for the Data Warehouse and Operational Data Store (ODS) across various business units. This role involves close collaboration with departments such as Risk Management, Finance, Accounting, Marketing, and IT, focusing on implementing new solutions and improving existing processes to enhance data veracity and velocity.

Responsibilities

• Assist with the development lifecycle, including identifying and implementing solutions for Business Analytics, Finance, Accounting, Risk, IT, and Marketing Teams.
• Maintain and enhance the existing operational data store to support the company's primary lines of business.
• Design and implement new data source integrations as business demands dictate.
• Identify key inefficiencies in the global data environment and work with stakeholders to improve data availability and quality.
• Support Accounting and Finance with their GL processes in collaboration with the Manager of ETL and Office Technology.
• Support backend data logistics, compliance, legal, and ethical requirements related to the company's goals.
• Create, test, and deploy additional data integrity processes.
• Troubleshoot and correct data and load errors regularly.
• Support system maintenance, security upgrades, and disaster recovery efforts.
• Perform all other tasks and duties as assigned related to the position.

Requirements

• Completed Associates Degree, Bachelor's Degree or equivalent from an accredited university or a combination of post-secondary education and work experience.
• A minimum of 2 years' experience with ETL and data warehousing at a finance company or bank.
• A minimum of 1 year of experience with MSSQL, SSIS, and SQL development and/or implementation.
• Experience with Accounting and Finance is a strong plus.
• Experience with Dynamics 365 Business Central is a strong plus.
• A working knowledge of Python is required.
• Proficient with Microsoft Office Suite.

Nice-to-haves

• Previous experience in Salesforce is a plus.
• Proficiency with concepts related to Data Management, Data Pipelines, Change Tracking, Operation Data Stores, and Azure Platforms.