Database Analyst II

Can be located anywhere in CA, will need to report to one of our offices in San Diego, Riverside, Modesto, Santa Maria, Chico, El Centro, Santa Ana, Merced, Madera, Bakersfield, Rocklin and Sacramento.

UDW Overview:
United Domestic Workers of America, UDW/AFSCME Local 3930 is a statewide labor union that represents more than 225,000 home care and family child care providers in 45 counties in California. Founded in 1979, UDW is a diverse, progressive labor organization that seeks dynamic, committed individuals who will support our members and those for whom they care locally, statewide and at the national level.

UDW is one of California’s largest labor unions. We consistently support and lead important social justice initiatives like fighting for racial justice, income inequality, and affordable health care for all. We are committed to respect and dignity for seniors, people with disabilities, and the children in our care. We fight for better working conditions and fair pay for home care and child care providers, and full funding for life-saving programs like In-Home Supportive Services (IHSS) and subsidized family child care. For more information about UDW, please visit our website at www.udw.org.

Job Information:
Job Title: Database Analyst II
Job Type: Exempt (Salary)
Department: Data and Analytics Department
***Reports to:***Director of Data and Analytics
***Job Location:***California
UDW Office Hours: Monday to Friday 9:00AM to 6:00PM—Hybrid/Remote (In-Person 3 times per week, subject to change)
Salary Range: $90,000.00 to $120,000.00 (depending on experience)

Job Summary:
This position reports directly to the Data Analytics Director on all work assignments and administrative activities. The individual is required to handle multiple priorities within time constraints and to assist other field technical staff with technical problem resolution. The Data Analyst II leads complex data initiatives, database development, automation, and reporting efforts. This role designs and optimizes data systems, mentors junior analysts, and partners with leadership to deliver strategic insights. The position operates with a high degree of independence and technical expertise.

Essential Duties and Responsibilities:

• Design, implement, and optimize secure, efficient, and scalable databases
• Lead complex data collection, transformation, and integration efforts
• Perform heavy data cleaning, validation, and standardization tasks
• Collect, manipulate, clean, and prepare data for use in organizational databases and data platforms
• Develop and maintain advanced SQL scripts, queries, and data procedures
• Administer CRM and membership databases, including system configuration and optimization
• Design automated workflows and data pipelines while ensuring performance and data integrity
• Develop and refine data processes to measure organizational and organizing outcomes
• Produce advanced analytical reports, dashboards, and insights for senior leadership
• Coordinate complex data exchanges between external platforms and internal systems
• Establish and enforce data management standards, documentation, and best practices
• Provide advanced troubleshooting and serve as a subject matter expert for database systems
• Train, mentor, and support Data Analyst I and Data Coordinator staff and non technical users
• Ensure projects are delivered on time and within estimated costs
• Perform other duties as assigned

Supervisory Responsibilities:
None

Knowledge, Skills, and Abilities:

• Design, implement, and optimize secure, efficient, and scalable databases
• Lead complex data collection, transformation, and integration efforts
• Develop and maintain advanced SQL scripts, queries, and data procedures
• Administer CRM and membership databases, including system configuration and optimization
• Design automated workflows and data pipelines while ensuring performance and data integrity
• Develop and refine data processes to measure organizational and organizing outcomes
• Produce advanced analytical reports, dashboards, and insights for senior leadership
• Coordinate complex data exchanges between external platforms and internal systems
• Establish and enforce data management standards, documentation, and best practices
• Provide advanced troubleshooting and serve as a subject matter expert for database systems
• Train, mentor, and support Data Analyst I, Data Coordinator staff, and non technical users
• Ensure projects are delivered on time and within estimated costs
• Strong attention to detail and data accuracy
• Ability to manage multiple tasks and meet deadlines
• Effective written and verbal communication skills
• Ability to work independently and in team environments
• Strong strategic and critical thinking skills.
• Effectively prioritize and multi-task assignments and responsibilities.
• Perform other duties as assigned

Preferred Qualifications:

• Bachelor’s degree in Computer Science, Information Systems, or related field (preferred)
• 3–5+ years of professional data analysis or database experience
• Advanced SQL scripting and database administration experience
• Experience working within the Azure cloud environment
• Experience with data automation and integration tools
• Experience using Data Factory tools
• Experience creating interactive reports using SSRS tools.

Preferred Bilingual Language(s) in:

• Spanish
• Vietnamese
• Korean
• Tagalog
• Russian
• Assyrian
• Somali
• Arabic

Employee Benefits:

• Health Insurance
• Dental Insurance
• Vision Insurance
• Life / AD&D
• Long Term Disability (LTD)
• 401(k) Savings Plan
• Pension Plan
• Paid Vacation Days
• Paid Sick Leave
• Personal Day
• 16 Paid Holidays
• Floating Holiday
• Upskill through eLearning platforms

COVID-19 Vaccination Requirement:
UDW has adopted a COVID-19 vaccination policy to safeguard the health and well-being of our employees. As a condition of employment, our employees are required to be fully vaccinated for COVID-19, unless a reasonable accommodation is approved or as otherwise required by law.

Physical Demands:
The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this position. Reasonable accommodations may be made to enable individuals with disabilities to perform the functions. While performing the duties of this position, the employee is regularly required to talk and hear. The employee frequently is required to use hands or finger, handle, or feel objects, tools or controls. The employee is required to stand; walk; sit; reach with hands and arms; climb or balance; and stoop, kneel, crouch, or crawl. The employee must occasionally lift and/or move up to 25 pounds. Specific vision abilities required by this position include close vision, distance vision, peripheral vision, and the ability to adjust focus. The noise level in the work environment is usually moderate.

Work Environment:
The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. While performing the duties of this job, the employee is primarily exposed to an office-type environment. The employee will frequently work on or around office equipment and furniture. The noise level in the work environment is low to moderate. The employee will frequently work with deadlines under pressure and will occasionally be required to work alone. The employee is occasionally exposed to outdoor environments, which may include exposure to vehicles, moving mechanical parts; vibration; odors, fumes, gasses, smoke, dust, or airborne particles; and outside weather conditions.

Equal Opportunity Employer:
UDW is an equal opportunity employer, and, as such, does not discriminate an employee or applicant based on race, creed, color, age, sex, national origin, marital status, sexual orientation, gender identity, religious affiliation, disability, or any other classification protected from discrimination under applicable law.

Notice of E-Verify Participation:
This employer participates in E-Verify and will provide the federal government with your Form I-9 information to confirm that you are authorized to work in the U.S. If E-Verify cannot confirm that you are authorized to work, this employer is required to give you written instructions and an opportunity to contact Department of Homeland Security (DHS) or Social Security Administration (SSA) so you can begin to resolve the issue before the employer can take any action against you, including terminating your employment. Employers can only use E-Verify once you have accepted a job offer and completed the Form I-9. For more information on E-Verify, or if you believe that your employer has violated its E-Verify responsibilities, please contact DHS (888) 897-7781, dhs.gov/e-verify.

Women, people of color, people with disabilities, and members of the LGBTQIA+ community are strongly encouraged to apply.

To Apply:
All applicants should email their résumé, list of three references, and cover letter to: [email protected].

WHEN APPLYING: Be sure to indicate that you saw this information at Indeed.com.

Pay: $90,000.00 - $120,000.00 per year

Benefits:

• 401(k)
• Dental insurance
• Employee assistance program
• Health insurance
• Life insurance
• Paid time off
• Vision insurance

Application Question(s):

• How many years of professional experience do you have in data analysis, database administration, or database development?
• Do you have a bachelor's degree in Computer Science, Information Systems, or a related field?
• How many years of hands-on experience do you have writing advanced SQL queries, stored procedures, and performing database administration?
• Do you have hands-on experience working within the Microsoft Azure cloud environment?
• Have you used Azure Data Factory to develop, manage, or troubleshoot data pipelines?
• Do you have hands-on experience creating, maintaining, or troubleshooting reports using SQL Server Reporting Services (SSRS)?
• Which data automation or integration tools have you used professionally? Please briefly describe your experience.

Work Location: In person