Database Analyst II

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., * 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, 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.

• 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, * 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., * 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.

• 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., * 401(k)

• Dental insurance
• Employee assistance program
• Health insurance
• Life insurance
• Paid time off
• Vision insurance

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.