Senior Associate, FP&A, Modeling & Analytics
Ankura
PMPTableau
Staff Engineer – Finance Data Specialist
GEICO
full-time
Posted on:
Location Type: Hybrid
Location: San Francisco • California • 🇺🇸 United States
Visit company websiteSalary
💰 $115,000 - $260,000 per year
Job Level
Lead
Tech Stack
AirflowAmazon RedshiftApacheAzureCloudERPETLInformaticaOracle
About the role
- Leverage your strong Functional and Technical systems expertise to drive towards the right solutions to support Finance’s current and future needs
- 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 technologies, and approaches for data transformation using ETL/ELT tools such as Informatica, DBT, etc.
- Experience working with cloud data solutions (Delta Lake, Iceberg, Hudi, Snowflake, Redshift or equivalent)
- Develop high-quality, accurate data visualizations and reports using tools like Power BI and Apache Superset to support data-driven business decisions
- 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
- Deep knowledge of Power BI administration (workspaces, capacities, security, governance) and Power Platform administration (environments, Dataverse, flows, apps)
- Advanced knowledge of business intelligence tools (strong preference for Power BI) and ETL tools (strong preference for DBT)
- Strong understanding of identity, access management, and compliance in Microsoft 365 and Azure AD
- Experience architecting CI/CD pipelines for Power BI solutions (Azure DevOps or GitHub)
- Strong understanding of identity, access management, and compliance in Microsoft 365 and Azure AD.
- Experience with enterprise orchestration tools such as Airflow is preferred
- 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
- Good understanding of accounting process and reporting expectations to partner with Finance teams
Benefits
- 401K savings plan vested from day one that offers a 6% match
- performance and recognition-based incentives
- tuition assistance
- mental healthcare benefits
- fertility and adoption assistance
- workplace flexibility
- GEICO Flex program, which offers the ability to work from anywhere in the US for up to four weeks per year
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
Finance SystemsERP solutionsFP&A applicationsFinance Data LakeDimensional Data ModelingPower BIETL toolsCI/CD pipelinesbusiness intelligence toolsdata transformation
Soft skills
collaborationcommunicationanalytical skillsprocess improvementleadershiporganizational skillsproblem-solvingalignmentbest practices sharinggovernance
