Invitae makes it easy to access your genetic information, so you can take control of your health.
Austin, TX

Finance Operations Data Engineer at Invitae

| Remote
Sorry, this job was removed at 5:39 a.m. (CST) on Saturday, February 12, 2022
Find out who’s hiring remotely
See all Remote jobs
Apply Now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.

Role Description

The Operations Data Engineer will lead the ongoing maintenance and enhancement of our finance data warehouse and will help to support its integration with other enterprise data assets for analytics use cases. The Finance Operations Data Engineer will work closely with business leaders, functional leaders, organizational units, and subject matter experts to ensure the health of the finance reporting platform. The Operations Data Engineer will be responsible for executing the day-to-day configuration, production support, integration, maintenance, administration, and improvement of the finance data warehouse.  This includes technical management and administration of SQL environments and business intelligence tools and technologies.  This role is approximately 90% technical and 10% business.

The Position
We are looking for a unique individual who has finance business acumen combined with SQL, ETL, Tableau Desktop, PostgreSQL DBA, Snowflake, Terraform, AWS RDS, JSON, and CloudWatch technical expertise.

Key aspects of the role include:

  • Manage and synthesize large amounts of data into useful information using pgAdmin, BI analytical tools, or external application tools and Tableau to  illustrate findings, analyze trends and report results
  • Review query performance, enhance and optimize code where necessary
  • Data modeling to visualize database structure
  • Create database triggers for automation
  • Create table indexes to improve database performance
  • Write views, stored procedures, and PL/pgSQL functions
  • Determine what data must be returned to the application and write queries for it
  • Perform database administration including table design and normalization, and database backups and recovery
  • Supports the monthly close and reporting process by assisting the team with the preparation of revenue journal entries and account analysis reporting
  • Develop Tableau and/or Looker reports
  • Monitor changes in upstream and downstream applications impacting the warehouse and apply changes to ETL logic where applicable

Minimum Qualifications

  • At least 2 years PostgreSQL DBA experience
  • 8-10+ years of experience with hands-on roles in database administration, BI tools, finance, or related fields.
  • Experience working in the financial services industry or supporting an internal, corporate finance function
  • BA/BS in Computer Science or related field
  • Experience in pgAdmin database engineering/optimization including strong expertise in SQL best practices, queries, and frameworks
  • Experience in BI tools, processes, and data optimization (Tableau and Looker preferred)
  • Basic financial acumen
  • Proven ability to design and implement new processes and facilitate user adoption
  • Strong understanding of the platform, with the ability to build custom apps and objects, formula fields, workflows, custom views, and other content of intermediate complexity
  • Strong understanding of database best practices and functionality
  • Strong data management abilities
  • A documented history of successfully driving projects to completion
  • A demonstrated ability to understand and articulate complex requirements
  • Experience using PostgreSQL 
  • Strong analytical and problem-solving skills, with demonstrated intellectual and analytical rigor

Desired Qualifications

    • Proficiency with Tableau, Looker
    • Proficiency with Python
    • Experience using a variety of database technologies such as Postgres and Snowflake
    • Experience with SOX controls and compliance
    • Experience developing financial reporting solutions
    • Working knowledge of financial systems
    • Experience in life science, healthcare industries, or diagnostics segment

Location: Preference is San Francisco but remote U.S. location ok

At Invitae, we value diversity and provide equal employment opportunities (EEO) to all employees and applicants without regard to race, color, religion, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status. We will consider for employment qualified applicants with criminal histories in a manner consistent with the requirements of the San Francisco Fair Chance Ordinance.


See More
Apply Now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.

Where we are

Situated in Austin's Central Business District, one block West of the Texas State Capitol.

Technology we use

  • Engineering
    • C#Languages
    • C++Languages
    • JavaLanguages
    • JavascriptLanguages
    • PHPLanguages
    • PythonLanguages
    • SqlLanguages

What are Invitae Perks + Benefits

Invitae Benefits Overview

At Invitae, our employees are the key to our continued success. Our culture is one of our most important strengths. A set of commitments we make to each other and to our customers to build a world-class organization in service of our mission. That is why Invitae proudly offers comprehensive perks and benefits program with choice and flexibility in mind.

Friends outside of work
Eat lunch together
Intracompany committees
Daily sync
Team owned deliverables
Team based strategic planning
Group brainstorming sessions
Open office floor plan
Dedicated Diversity/Inclusion Staff
Unconscious bias training
Diversity manifesto
Mean gender pay gap below 10%
Diversity Employee Resource Groups
Hiring Practices that Promote Diversity
Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Disability Insurance
Dental Benefits
Vision Benefits
Health Insurance Benefits
Life Insurance
Pet Insurance
Wellness Programs
Team workouts
Mental Health Benefits
Retirement & Stock Options Benefits
Company Equity
Employee Stock Purchase Plan
Performance Bonus
Child Care & Parental Leave Benefits
Generous Parental Leave
Flexible Work Schedule
Remote Work Program
Family Medical Leave
Adoption Assistance
Return-to-work program post parental leave
Vacation & Time Off Benefits
Unlimited Vacation Policy
Paid Holidays
Paid Sick Days
Perks & Discounts
Beer on Tap
Casual Dress
Commuter Benefits
Company Outings
Free Daily Meals
Game Room
Stocked Kitchen
Some Meals Provided
Happy Hours
Pet Friendly
Recreational Clubs
Home Office Stipend for Remote Employees
Professional Development Benefits
Job Training & Conferences
Diversity Program
Lunch and learns
Cross functional training encouraged
Promote from within
Mentorship program

More Jobs at Invitae