- Urbandale, Iowa, United States
- Full-time · Director
- 12+ years
Supports the Corporate Financial Data and Analysis function by designing, maintaining, and modernizing the finance data architecture, reporting platforms, and analytical environments used by Corporate Finance, operating units, actuarial, information technology, and other enterprise stakeholders.
Responsibilities
- Design, develop, maintain, and support finance data architecture, data warehouse structures, ETL/ELT processes, scripts, queries, reports, dashboards, cubes, and analytical environments.
- Participate in Databricks modernization efforts by helping identify legacy finance data processes to migrate, refactor existing data jobs, validate results between legacy and Databricks environments, support workflow orchestration, and help establish scalable data processing patterns.
- Assist with the transition from legacy SQL Server, DataStage, SSIS, OAS, Essbase, and other existing data processes toward Databricks and modern lake house-based architecture.
- Support AI and automation initiatives by helping prepare trusted finance data, define business rules, identify exception-handling opportunities, improve metadata and semantic definitions, and enable self-service analytics, AI-assisted inquiry, and governed data access.
- Provide ongoing production support for Oracle Essbase, Oracle Analytics Server, PeopleSoft warehouse data, Vena integrations, BDW reporting processes, and related financial reporting platforms.
Requirements
- Bachelor’s degree or equivalent; preferably in actuarial science, math or computer science