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

Carpenter Funds Administrative Office of Northern California, Inc. jobs

Data Analyst-SQL Programmer II

Never Miss a New Opportunity