Job Summary
Receives general direction and is competent to work at the highest level of analysis and design on data and analytics projects. The position requires demonstrated skills leveraging traditional data technologies. The applicant is expected to have a good understanding of PostgreSQL, SQL, PL/SQL and Relational Database programming concepts.
In this role you will work to deliver data solutions leveraging PostgreSQL. You will utilize your skills and expertise in data management best practices for business need analysis, business requirements analysis, assisting users with data source identification and analysis, writing PostgreSQL and testing of Queries, Batches and Reports. Create and maintain documentation as required for projects, especially recording and tracking project requirements and tasks.
Technical Skills Required
- Demonstrated knowledge of PostgreSQL; 1 year preferred
- Demonstrated SQL programming and development; 3 years preferred
- Proficient in PL/SQL
- Solid understanding of database and SQL
- Intermediate Python experience
- Experience with Universal Database Tools. Experience with DBeaver a plus
- Proficient in MS Excel and Word
- Experience with document composition and management tools a plus
- 1-3 years of overall software related technical analysis experience
- 1-3 years of hands-on solid experience with data analysis, mapping and transformation
- Regulated industry (financial services or healthcare experience preferred)
- Scripting experience is a plus, but not required.
- Power BI experience a plus
Qualifications and Skill
- Bachelor’s degree in Computer Science or a related field
- Innovative, collaborative, and team-oriented, yet practical in devising custom solutions or new features applicable to client demand
- Professional work experience using SQL to work large data sets including high proficiency writing queries for more complex data extraction and transformation tasks.
- Excellent verbal, written and interpersonal skills
- Excellent organizational and analytical skills
- Ability to plan, organize, and prioritize multiple projects independently to meet deadlines and complete tasks in an accurate manner
Other Requirements
- This is a full-time position 100% onsite in Oakland, CA
In addition to the total annual compensation which will be in the range of $93,000 to $96,000, based on 2,080 hours per year this position includes an excellent benefit package with 2 employer paid retirement plans:
Carpenters Health and Welfare Trust Fund for California – health and welfare coverage for the employee and eligible dependents, 100% covered by employer contributions – the current contribution rate is $14.37 per hour or $25,003.80 per year
- Medical – Kaiser or Anthem Blue Cross
- Dental – Delta Dental
- Vision – Kaiser or Vision Service Plan (VSP)
- Prescription – Kaiser or Express Scripts
- Employee Assistance Program (EAP) – Anthem Blue Cross
- Eligibility is based on an hour bank and would typically begin 4 months after your employment begins
Pension Plan for Carpenter Funds Administrative Office of Northern California, Inc. – a defined benefit plan with a 5 year vesting period which will provide monthly payments to you for life during your retirement
Carpenters Annuity Trust Fund for Northern California – a defined contribution plan – current rate subject to change is $4.83 per each hour worked based on 2,080 hours per year for an estimated annual benefit amount of $10,046.40
Northern California Carpenters 401(k) Plan – which you are able to participate in and make pre-tax or after-tax contributions to as soon as your employment begins
Basic Life AD&D Insurance – 1 x annual earnings paid to your beneficiary upon your death
In addition,
Carpenters Vacation, Holiday and Sick Leave Trust Fund for Northern California – included as part of your gross compensation stated above, this plan pays out an annual benefit in January of all contributions received on your behalf, during the prior Plan Year (August 1st to July 31st) – current rate, subject to change is $3.43 per each hour worked based on 2,080 hours per year for an estimated annual benefit amount of $7,134.40
11 Paid Holidays per year:
- New Year’s Day
- Martin Luther King Jr. Day
- Presidents’ Day
- Memorial Day
- Independence Day
- Labor Day
- Thanksgiving Day
- Day after Thanksgiving Day
- Christmas Eve
- Christmas Day
- 1 Floating Holiday of your choice – during the 1st Calendar year following the Calendar year in which you were a CFAO employee on December 1st
Paid Sick Leave – 8 hours accrued per month
Paid Vacation:
- upon hire you will begin to accrue 2 weeks’ vacation per year
- after 5 years of continuous service you will begin to accrue 3 weeks’ vacation per year
- after 10 years of continuous service you will begin to accrue 4 weeks’ vacation per year
- after 18 years of continuous service you will begin to accrue 5 weeks’ vacation per year
Our office is located at 265 Hegenberger Road, Suite 100, Oakland, CA 94621-1480. We have plenty of free parking, are located close to public transportation and we also have electric vehicle charging available on site.
The CFAO is an equal opportunity employer and makes employment decisions on the basis of qualifications, merit and business needs. We want to have the best available person in every job.
The CFAO is committed to complying with all applicable laws providing equal employment opportunities to individuals regardless of race (including natural hair and protective hairstyles), color, religion and religious creed (including religious dress and grooming practices), sexual orientation, marital status, age (40 years and over), national origin, ancestry, citizenship, physical or mental disability (including HIV and AIDS, medical condition, including cancer, genetic characteristics or information, requests for medical leave), sex/gender (including pregnancy, childbirth, breastfeeding and medical conditions related to pregnancy, childbirth or breastfeeding and/or related medical conditions), reproductive health decision making, gender identity, gender expression, transgender status, and military and/or veteran status, or any other consideration made unlawful by federal, state or local laws. This commitment applies to all persons involved in the operations of the company and prohibits unlawful discrimination by any employee of the CFAO, including Supervisors, Managers, Directors and co-workers.
Employment is contingent upon successful completion of a background check.
Applicants must be authorized to work for ANY employer in the U.S. We are unable to sponsor or take over sponsorship of an employment Visa at this time.
Job Type: Full-time
Pay: $93,000.00 - $96,000.00 per year
Benefits:
- 401(k)
- AD&D insurance
- Dental insurance
- Dependent health insurance coverage
- Health insurance
- Life insurance
- Paid holidays
- Paid sick time
- Paid time off
- Prescription drug insurance
- Retirement plan
- Vision insurance
People with a criminal record are encouraged to apply
Work Location: In person
