OaklandRecruiter Since 2001
the smart solution for Oakland jobs

Data Analyst/Database Specialist

Company: SEIU LOCAL 1021
Location: Oakland
Posted on: January 15, 2022

Job Description:

We are currently seeking an experienced Data Analyst/Database Specialist to join our team in Oakland, CA 94607

About Us:
SEIU Local 1021 represents nearly 60,000 employees in local governments, non-profit agencies, health care programs, and schools throughout Northern California. We are a diverse, member-driven organization. We are looking for energetic, hard-working staff who are committed to real change, who believe in the value of work and the value of public services, and who want to be part of the team that wins for workers, their families, and their communities.


While using existing technologies to meet the enterprise database needs of a large membership organization, the Data Analyst/Database Specialist will be a key player in shaping the union's future data systems. Tracking and use of membership data is critical to the multiple campaigns of the union. Database reporting and analysis is a key element of this position. Our UnionWare membership database currently uses several reporting mechanisms including its native reporting features, Excel, Microsoft Power BI and SharePoint PBI embed, so an in-depth understanding of Excel and Microsoft Power BI are essential requirements for this position.

Duties and responsibilities

The Data Analyst/Database Specialist will also be responsible for training of staff on various software packages, including UnionWare and Microsoft Office, and should be able to present information either in a remote session or in person in a manner that is appropriate to the trainee's level of understanding. The ideal candidate will possess strategic vision in designing both the content and delivery methods in order to produce effective learning outcomes.

The Data Analyst/Database Specialist will also be expected to perform the tasks of other IT Team members at a general level of competence when others are not available. This would include ability to diagnose simple desktop/laptop problems (e.g., dead power supply, loose boards or cable connections, file or application corruption), and perform basic tasks such as application installation or desktop troubleshooting with a minimum of external support. Ability to assist off-site staff with problem detection and resolution remotely.

Works independently, managing multiple deadlines. Reports to I.T.Director, and works closely with Membership Department. Good interpersonal skills, able to communicate with people at all levels of IT comprehension. Able to translate from expressed needs of various constituencies into deliverable reports, dashboards, labels, and spreadsheets. Attention to detail and ability to handle sensitive information discreetly.

The candidate should be able to analyze the processes and procedures involved in the flow of information through the Local. They will be required to document workflow, and provide tools, in the form of software requirements and procedures, to improve the accuracy, efficiency and accountability of task completion by staff.

  • An understanding of relational database principles; data dependencies; performance tuning and normalization of data are needed. Willingness to work irregular and long hours, including weekends and holidays, to attend required evening and weekend events/meetings.
  • Extensive travel may be required, primarily within Northern California.Skills and Abilities
    • High level expert working knowledge and skills in Microsoft Excel
    • Good working knowledge and experience with Data Analysis Expressions (DAX) framework specifically in the context of Power BI
    • Experience with modern integration API standards such as RESTful, web hooks, JSON parsing and understanding of HTTP requests and mechanics
    • Microsoft Power BI Desktop, PBI embed, Azure PBI service and the entire ecosystem required to launch a fully functional end-to-end reporting solution based on Power BI
    • Microsoft SQL Server
    • Azure Analysis Services as data warehousing hosting platform
    • Ability to work effectively with minimum supervision
    • Ability to effectively handle multiple tasks
    • Superior understanding of data structures and elements; queries and mechanics of a typical database
    • Excellent data analysis skills
    • On-prem DB gateway infrastructure and Azure DB replication techniques
    • Ability to train and support end users with all aspects of data retrieval, formatting and basic data manipulation in Excel or Word
    • Ability to engage and experience in DB architecture level design projects for creating data scalable infrastructure to satisfy business needsEducation and Experience:
      • Prior work experience with labor organizations
      • Experience with Microsoft Power BI and all of the components associated with its ecosystem in a hybrid cloud and on-prem environment
      • Experience with Union Ware and/or union membership database systems.Company Offers:
        • Competitive salary will be commensurate with experience and education
        • Comprehensive benefits package availablePlease submit your resume via the 'Apply Now' button

          Hiring: We are committed to hiring staff who reflect our membership and model the unity and equity that we seek to create in our country. For example, women, LGBTQI, people of color, and immigrants are strongly encouraged to apply.

          Equal Opportunity Employer: SEIU Local 1021 is an equal opportunity employer and encourages applications from qualified candidates of all races, ethnicities, ages, sexes, sexual orientations, marital statuses, religions, or who have a disability. Local 1021 is committed to ensuring fair treatment of applicants and employees and actively enforces policies against discrimination and sexual harassment.

Keywords: SEIU LOCAL 1021, Oakland , Data Analyst/Database Specialist, IT / Software / Systems , Oakland, California

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category

Log In or Create An Account

Get the latest California jobs by following @recnetCA on Twitter!

Oakland RSS job feeds