[Remote] Senior Data Engineer I (Postgres DBA) at OppFi

Remote

OppFi Logo
Not SpecifiedCompensation
Senior (5 to 8 years)Experience Level
Full TimeJob Type
UnknownVisa
FinTech, Financial ServicesIndustries

Requirements

  • 5+ years of related experience working in data teams
  • 3+ years managing product

Responsibilities

  • Hands-on work administering and architecting PostgreSQL Databases in AWS RDS
  • Provision new database instances and update configuration of RDS instances with CI/CD tooling (ie: Terraform)
  • Enforce corporate data security and privacy standards in the PostgreSQL environment
  • High Availability and Disaster Recovery Planning, Drills, and Execution
  • Performance tuning and analysis
  • Data-related monitoring & alerting in Datadog and Cloudwatch
  • User support, Documentation, & Audit support
  • Tool evaluation and testing
  • Capacity planning and budgeting assistance
  • On-call Rotation for Production Support of all Database and ETL Systems
  • Conduct regular tests of the RDS (Postgres) disaster recovery plan and document the results of each quarterly test
  • Architect and support deployment of complex workloads supporting dozens of micro-services
  • Automate common database administration tasks, such as user and environment provisioning
  • Develop and train members of the team in following SOPs for common operational tasks
  • Use Apache Airflow, Hevo, dbt, and Snowflake to make several layers of OppFi data available for reporting, data science, and analytics
  • Develop and document audits and controls to ensure the data meets quality standards and alerts the team when thresholds are breached
  • Support and refine internal Business Intelligence and Data Warehouse environments
  • Collaborate closely with development & internal business teams to build data integrations for our internal applications and services as well as external vendors and partners
  • Operate in close partnership with the platform (DevOps) team to develop and maintain database and ETL infrastructure
  • Contribute energy and opinions to the data engineering team
  • Participate in the hiring process for technology candidates within a well-defined process
  • Promote a culture of testing and data quality improvement within data engineering (ie: unit testing, integration testing, data quality checks, etc)
  • Architect ETL solutions for moving large quantities of data across disparate data stores (inter- or intra-cloud environments)
  • Contribute to and lead solutioning sessions for new initiatives and technological problems
  • Participate in and lead data modeling and schema design using various data modeling methodologies (ie: Data vault, Kimball, etc)

Skills

Key technologies and capabilities for this role

PostgreSQLDBAAWS RDSTerraformCI/CDHigh AvailabilityDisaster RecoveryPerformance TuningDatadogSnowflakeAirflowHevo ETL

Questions & Answers

Common questions about this position

What are the key responsibilities for the PostgreSQL DBA role?

Responsibilities include hands-on PostgreSQL database administration in AWS RDS, provisioning instances with Terraform, enforcing data security, high availability planning, performance tuning, monitoring in Datadog and Cloudwatch, on-call rotation, and disaster recovery testing.

What tools and technologies will I work with in data engineering tasks?

You'll use Apache Airflow, Hevo, dbt, and Snowflake for ETL processes, data warehousing, audits, and making data available for reporting and analytics.

Is this role remote or does it require office presence?

This information is not specified in the job description.

What is the compensation or salary for this position?

This information is not specified in the job description.

What does OppFi's company culture look like?

OppFi fosters a caring, innovative, and inclusive culture with diverse talents and perspectives, emphasizing collaboration, improving 1% every day, and letting the best ideas win.

OppFi

Specialty finance platform for personal loans

About OppFi

OppFi provides a platform that helps community banks offer personal loans to individuals who often struggle to access credit from traditional financial institutions. By partnering with these banks, OppFi enables them to extend credit to underserved Americans, allowing these consumers to improve their financial health. The loans are designed to be accessible and are accompanied by a focus on responsible lending practices. OppFi differentiates itself from competitors by emphasizing transparency and best-in-class customer service, ensuring that clients understand the terms of their loans and feel supported throughout the process. The company's goal is to promote financial inclusion and help individuals rebuild their financial stability.

Chicago, IllinoisHeadquarters
2012Year Founded
$283MTotal Funding
IPOCompany Stage
Fintech, Financial ServicesIndustries
201-500Employees

Benefits

Generous vacation
Insurance benefits
401(k) matching
Employee Assistance Program
Tuition reimbursement
Subsidies for childcare costs, free financial literacy tools, 6 paid weeks of parental leave
Collaborative and supportive company culture

Risks

Increased competition in small business financing could challenge OppFi's market position.
Potential delay in Federal Reserve rate cuts may decrease loan demand.
Integration risks exist with the acquisition of Bitty Advance.

Differentiation

OppFi partners with community banks to extend credit to underserved consumers.
The company emphasizes responsible lending and financial inclusion in its business model.
OppFi offers financial literacy resources through a collaboration with Zogo.

Upsides

Acquisition of Bitty Advance diversifies OppFi's product offerings in small business financing.
Expanded $50 million credit facility supports growth and new product roll-out.
Partnerships with educational platforms enhance customer engagement and retention.

Land your dream remote job 3x faster with AI