About the position
GEICO is seeking Finance Data specialists to support the build out of a Finance Data Warehouse/Lake by partnering with both Finance and Technology teams to redesign the way they use their technologies in managing GEICO's business. This individual must have strong functional and technical Finance Systems background to partner with the Business ensuring effective discussions to drive the capture, transformation, and utilization of Finance data to meet Business goals. The Staff Engineer, Finance Data Specialist will report to the Senior Manager of Finance Data & Analytics and will provide solutions on how to build out, maintain, and support a Finance Data repository to support FP&A processing and analytics while also supporting the larger Finance organization's need for Finance data. The Finance Data Specialist will work with multiple Finance and Technology leaders to support the build out the company's Finance Data Warehouse/Lake to provide a central repository for all Financial related transactions so it can be a reconciled source of truth for processing and the source for Revenue and Expense analytics. This role is also accountable to support the delivery of technology solutions that will support FP&A Planning/Budgeting, financial reporting, Revenue/Expense Analytics, and the build out of the Finance Data Warehouse to become a reconciled source to allow the GL to become a 'thin' ledger.
Responsibilities
- Leverage your strong Functional and Technical systems expertise to drive towards the right solution to support the department and GEICO's current and future needs
- Engage in cross-functional collaboration throughout the entire software lifecycle
- Support design sessions with peers to ensure systems are well designed, efficient, and meet Business expectations
- Collaborate with Finance Leaders within the FP&A, Controllers, Financial Reporting, and Finance QA & Systems team along with the Data Engineering and Finance Technology leaders to ensure organizational goals are met
- Have a deep understanding of a few Finance functions to support the establishment of a vision and technology roadmap to build out a Finance Data Lake/Warehouse
- Have a good understanding of finance data lake/mart with Data processing/data transformation using ETL/ELT tools such as Informatica, DBT, etc.
- Experience with designing, developing, implementing, and maintaining solutions for data ingestion and transformation projects
- Experience working with cloud data solutions (Delta Lake, Iceberg, Hudi, Snowflake, Redshift or equivalent)
- Support the development of a roadmap and then work towards implementing Revenue and Expense Analytical solutions
- Support and try to influence customers and stakeholders, and work through divergent expectations
- Support the implementation of a strong control and governance framework and maintain it for SOX and Audit reviews
- Support Business and Technology discussions at various levels to ensure alignment towards long term goals of Finance and Technology
- Analyze and translate business and functional specifications and change requests into technical specifications
- Share best practices and improve processes within and across teams
Requirements
- 15+ years of Finance Systems experience with industry leading ERP solutions (e.g. implementing and supporting Oracle; Workday; SAP or PeopleSoft)
- 3+ years of experience in implementing and supporting FP&A applications (Preferred)
- 3+ years working with or supporting a Finance Data Lake/Warehouse/Mart along with various Financial Reporting tools
- Good understanding of Dimensional Data Modeling
- Strong working knowledge of Data processing/data transformation using ETL/ELT tools such as Informatica, DBT, etc.
- Strong working knowledge of SQL and the ability to write, debug and optimize SQL queries and ETL jobs
- Experience working with Financials via the major vendors (e.g. PeopleSoft; Oracle EBS; Oracle Cloud; Workday; or SAP)
- Finance domain expertise to be able to work with senior Finance leaders to interpret their process and functional needs into system solutions
- Good understanding of FP&A Budgeting, Planning, and forecasting processes
- Experience in implementing or supporting Revenue or Expense analytical solutions via tools such as Power BI, Tableau, etc.
- Good understanding of accounting process and reporting expectations to partner with Finance teams
- Ability to communicate and work directly with users across Technology and Finance
- Sound understanding of project management techniques, methodologies, and best practices
- Strong problem-solving abilities
- Ability to excel in a fast-paced environment
- Knowledge and experience with the software development life cycle
- Ability to work independently and in a team-oriented collaborative environment
Benefits
- Comprehensive Total Rewards program that offers personalized coverage tailor-made for you and your family's overall well-being.
- Financial benefits including market-competitive compensation; a 401K savings plan vested from day one that offers a 6% match; performance and recognition-based incentives; and tuition assistance.
- Access to additional benefits like mental healthcare as well as fertility and adoption assistance.
- Supports flexibility- We provide workplace flexibility as well as our GEICO Flex program, which offers the ability to work from anywhere in the US for up to four weeks per year.
