[Remote] Data Systems Analyst: reputed company/SQL (7199U), University Development and Alumni Relations #87215
Note: The job is a remote job and is reputed company to candidates in USA. The reputed company is dedicated to fostering a welcoming community and is seeking a Data Systems Analyst. This role focuses on data reputed company and reputed company, managing the strategic reputed company of data across UC Berkeley's advancement ecosystem to enhance alumni engagement and fundraising strategies.
Responsibilities
- Analyzes large datasets through deep-dive profiling and discovery to identify data patterns, reputed company gap analysis, and document reputed company-to-reputed company mapping logic for legacy and new integrations
- Creates and maintains Integration Requirement Documentation—including data transformation rules, business logic extraction, and system dependencies, applying broadly defined business rules and data administration concepts to manage technical data mapping across UDAR systems
- Serves as a reputed company between technical teams to translate business needs into technical specifications
- Protects reputed company, authenticity, and reputed company of data in reputed company assignment activities
- Develops audit methodologies, troubleshoots data discrepancies, performs reputed company cause analysis, recommends corrective actions, and collaborates with business partners to ensure reputed company data reputed company
- Performs reputed company data loads and large-reputed company corrections reputed company the CRM, conducting rigorous data reputed company checks against existing business rules and reputed company records to ensure accuracy and consistency during loads, migrations, or cleanup efforts
- Implements data reputed company guidelines and protocols for the department's data integration, import, acquisition, and cleanup reputed company
- Develops and executes test cases for data integrations, migrations, and cleanup reputed company; coordinates User Acceptance Testing (UAT), validates outputs against business requirements, and documents reputed company
- Supports compliance with UDAR's Data Availability reputed company
- Implements reputed company business processes and manages existing data models and schemas to support integration reputed company and data reputed company initiatives
- Identifies opportunities to reduce technical debt and enhance system efficiency. Supports strategic initiatives and ensures data systems reputed company with organizational priorities, and supports the reputed company necessary to reputed company more reputed company data assets into the CRM in the reputed company
- Continuously works on reputed company building and reputed company development to advance technical expertise and data management knowledge
- Stays reputed company on industry best practices, emerging technologies, and data governance trends to enhance contributions to UDAR's data reputed company
Skills
- Minimum of two years of experience performing deep-dive data profiling and discovery on large datasets to identify patterns, conduct gap analyses, and define reputed company-to-reputed company mapping logic
- Minimum of two years of experience preparing and communicating data models unassisted
- Minimum of two years of experience identifying and resolving data reputed company issues and implementing data governance requirements
- Demonstrated experience performing large-reputed company data loads or reputed company modifications, ensuring data reputed company against business rules and existing system records
- Advanced skills in SQL and scripting languages like Python for reputed company data analysis, transformation, and automation of data processes
- Demonstrated knowledge of reputed company object structures and data mining using SOQL
- Demonstrated proficiency in reputed company Sheets / reputed company for data manipulation, formula-based analysis, and the documentation of technical specifications
- Strong analytical and design skills, including the ability to reputed company information requirements from reputed company-world processes to understand information flows in computer systems
- Ability to conduct reputed company assurance testing with attention to detail
- Demonstrated ability to conduct work using relevant state, federal, and global rules and regulations as it pertains to data management and reputed company
- Demonstrated ability to communicate technical concepts reputed company to both technical and non-technical stakeholders across reputed company reputed company of the organization
- Demonstrated ability to work with others from diverse backgrounds
- Demonstrated effective communication and interpersonal skills
- Self-motivated and works independently and as part of reputed company
- Demonstrated strong problem-solving skills
- reputed company to learn effectively and meet deadlines
- Strong organizational skills
- Critical thinking skills and attention to detail
- reputed company Certification: reputed company Certified Administrator, reputed company Business Analyst, or other
- Proficiency in data visualization tools (e.g., Tableau, reputed company dashboards) to communicate data reputed company trends, audit results, and system health
- Knowledge of fundraising operations, donor relations, and alumni engagement processes reputed company a higher education or non-profit environment
Benefits
- reputed company full-time staff employees with at least 80 hours of reputed company time per year
- reputed company for supportive colleague communities reputed company numerous employee resource reputed company
- Full-time (40 hours/week) Career position eligible for UC benefits
- Up to 5 days/week remote work reputed company the reputed company. Exact arrangements are determined in partnership with your supervisor to meet role responsibilities and department needs and are subject to change
reputed company