Senior Data Engineer

Company: Fair Financial Corp.
Location: Santa Monica
Posted on: February 18, 2021

Job Description:

The Analytics Team partners with stakeholders to measure and provide insights to test, confirm, and debunk assumptions. As a Senior Data Engineer, your skills will lean toward the architecture of our current data stack; building and maintaining reliable and performant data pipelines. Our data stack consists of: We are especially focused on reusable and clean data modeling, so strong SQL experience is required and knowledge of concepts such as Kimball-style data warehousing is a plus. We are also power users of DBT, so if DBT is something you know or are interested in, we may be a good fit for you. Responsibilities:

• Work regularly and collaboratively with other members of the analytics team to build data pipelines and dimensional models within the data warehouse
• Develop a context of our business and analytics goals to guide development of our data architecture Required Qualifications:
  • 4+ years experience writing SQL
  • 4+ experience writing Python or comparable language to extract and transform data
  • 2+ years experience modeling data in a cloud data warehouse (Snowflake, Redshift, Big Query, etc)
    
    Preferred Qualifications:
    • Experience using DBT is a plus, however not required. We use and love DBT
    • An inclusive culture that values diversity and providing equal support and platform to all employees
    • 100% coverage of medical, dental and vision benefits for employees AND their families
    • Up to four months 100% paid parental leave
    • 100% Remote work optional (up to you!)
    • Remote work stipend and paid-for office supplies
    • Unlimited vacation
    • 401(k) (non-matched)
    • Stock options
    • Paid-for LinkedIn and other learning programs
    • Employee referral bonus It's Fair's policy to provide equal opportunity in employment to all employees and applicants for employment. No person will be discriminated against in employment because of race, color, religion, gender, gender expression, gender identity, sex, medical condition (as defined by California law and which includes pregnancy or childbirth), national origin, age, physical or mental disability, political activity or affiliation, ancestry, marital status, protected veteran status, citizenship status, sexual orientation, genetic information, taking or requesting statutorily protected leave, or any other legally protected status where there is no bona fide occupational qualification or legitimate business reason for the differing treatment. In addition, Fair prohibits harassment on any of the bases listed above or any other characteristics protected under federal, state or local laws. U.S. Equal Opportunity Employment Information (Completion is voluntary) Individuals seeking employment at Fair are considered without regards to race, color, religion, national origin, age, sex, marital status, ancestry, physical or mental disability, veteran status, gender identity, or sexual orientation. You are being given the opportunity to provide the following information in order to help us comply with federal and state Equal Employment Opportunity/Affirmative Action record keeping, reporting, and other legal requirements. Completion of the form is entirely voluntary. Whatever your decision, it will not be considered in the hiring process or thereafter. Any information that you do provide will be recorded and maintained in a confidential file. Gender Are you Hispanic/Latino? Race & Ethnicity Definitions If you believe you belong to any of the categories of protected veterans listed below, please indicate by making the appropriate selection. As a government contractor subject to Vietnam Era Veterans Readjustment Assistance Act (VEVRAA), we request this information in order to measure the effectiveness of the outreach and positive recruitment efforts we undertake pursuant to VEVRAA. Classification of protected categories is as follows: A "disabled veteran" is one of the following: a veteran of the U.S. military, ground, naval or air service who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Secretary of Veterans Affairs; or a person who was discharged or released from active duty because of a service-connected disability. A "recently separated veteran" means any veteran during the three-year period beginning on the date of such veteran's discharge or release from active duty in the U.S. military, ground, naval, or air service. An "active duty wartime or campaign badge veteran" means a veteran who served on active duty in the U.S. military, ground, naval or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense. An "Armed forces service medal veteran" means a veteran who, while serving on active duty in the U.S. military, ground, naval or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985. Veteran Status Form CC-305 OMB Control Number 1250-0005 Expires 05/31/2023 Voluntary Self-Identification of DisabilityWhy are you being asked to complete this form? We are a federal contractor or subcontractor required by law to provide equal employment opportunity to qualified people with disabilities. We are also required to measure our progress toward having at least 7% of our workforce be individuals with disabilities. To do this, we must ask applicants and employees if they have a disability or have ever had a disability. Because a person may become disabled at any time, we ask all of our employees to update their information at least every five years. Identifying yourself as an individual with a disability is voluntary, and we hope that you will choose to do so. Your answer will be maintained confidentially and not be seen by selecting officials or anyone else involved in making personnel decisions. Completing the form will not negatively impact you in any way, regardless of whether you have self-identified in the past. For more information about this form or the equal employment obligations of federal contractors under Section 503 of the Rehabilitation Act, visit the U.S. Department of Labor's Office of Federal Contract Compliance Programs (OFCCP) website at www.dol.gov/ofccp . How do you know if you have a disability? You are considered to have a disability if you have a physical or mental impairment or medical condition that substantially limits a major life activity, or if you have a history or record of such an impairment or medical condition. Disabilities include, but are not limited to:
      • Autism
      • Autoimmune disorder, for example, lupus, fibromyalgia, rheumatoid arthritis, or HIV/AIDS
      • Blind or low vision
      • Cancer
      • Cardiovascular or heart disease
      • Celiac disease
      • Cerebral palsy
      • Deaf or hard of hearing
      • Depression or anxiety
      • Diabetes
      • Epilepsy
      • Gastrointestinal disorders, for example, Crohn's Disease, or irritable bowel syndrome
      • Intellectual disability
      • Missing limbs or partially missing limbs
      • Nervous system condition for example, migraine headaches, Parkinson's disease, or Multiple sclerosis (MS)
      • Psychiatric condition, for example, bipolar disorder, schizophrenia, PTSD, or major depression Disability Status 1 Section 503 of the Rehabilitation Act of 1973, as amended. For more information about this form or the equal employment obligations of Federal contractors, visit the U.S. Department of Labor's Office of Federal Contract Compliance Programs (OFCCP) website at www.dol.gov/ofccp . PUBLIC BURDEN STATEMENT: According to the Paperwork Reduction Act of 1995 no persons are required to respond to a collection of information unless such collection displays a valid OMB control number. This survey should take about 5 minutes to complete.

Keywords: Fair Financial Corp., Santa Monica , Senior Data Engineer, Engineering , Santa Monica, California