UC Santa Barbara · 2 hours ago
Data Engineer
United States
Full-time
Remote
Senior Level
$123K/yr - $156K/yr
7+ years expUC Santa Barbara is recognized for excellence in education and is seeking a Data Engineer to support its mission of research and teaching. The role involves managing data services programs, transforming legacy data systems into effective analytics systems, and providing technical leadership in data management.
Higher Education
No H1B
Responsibilities
Applies professional and broadly defined business analysis, data administration, and data design and uses concepts to manage and perform complex assignments
Independently analyzes complex information requirements and documents them using formal data definition techniques and naming standards
Gathers, analyzes, prepares and summarizes information from subject matter experts and technical personnel
Researches relevant problem-domain literature and information standards and develops recommendations for data management solutions including approaches, trends, sources and uses
Implements related business processes, develops logical data models, dimensional data models and schemas for the scope of a project or a component of a project
Develops data mapping specifications and data pipelines
Works closely with users and constituents to provide data solutions
Assigns and verifies work to other resources to ensure successful project execution
Maintains, expands, and improves current data reporting and data infrastructure environments
Develops, optimizes and monitors data pipelines using continuous development and continuous integration best practices
Plans, schedules, tests and coordinates all data platform changes and upgrades through Change Management Requests
Develops solutions to design and monitor customer security permissions, performs audits and monitors usage
Identifies problem areas, recommends solutions and establishes and documents standards
Works closely with users to design, support, improve and maintain Data Warehouse services
Designs, develops, maintains, data catalog, documents and supports clear and effective reporting applications and solutions
Constructs interface prototypes for iterative user testing and verification
Engages with clients to understand scope and criticality of new change requests
Provides customer support as needed
Provides training to developers and users on UCSB data concepts and systems
Administers user privileges in accordance with established security and access policies
Troubleshoots and resolves reporting and data pipeline issues as required
Tracks project time
Provides project status to manager
Meets with supervisor and team
Other duties as assigned
Qualification
Required
Bachelor's Degree in related area
7-9 years: Equivalent experience/training with an emphasis in computer science, data processing, computer information systems, or in a related field
7-9 years: Experience using SQL Server technologies, or comparable database management systems
4-6 years: Experience designing, developing, documenting, and testing (including unit testing and test plan creation) database solutions
4-6 years: Experience analyzing business processes and information systems to ensure systems meet the business needs, and identifying opportunities for system improvement to better align with the business needs
4-6 years: Experience designing and developing data pipeline solutions with SSIS, Python, Informatica or other comparable tools, using continuous development and continuous integration best practices
Preferred
4-6 years: Experience using Snowflake to design and develop data warehouse solutions
1-3 years: Experience with Power BI, or comparable Business Intelligence tools
Demonstrated ability to design highly complex data systems and integrations
Knowledge of relevant application development technologies and tools, including SQL Server, Snowflake, SQL Integration Services, Python, REST API, Visual Studio, Azure DevOps, Git, Power BI
Project management skills to lead the implementation of complex data analytics solutions and other data projects
Expert knowledge of Microsoft SQL Server development, security model, and performance optimization
Expert knowledge of data pipeline methodologies and solutions with Python, SSIS, and/or Informatica
Expert knowledge of data warehousing principles and design concepts
Expert knowledge of Power BI setup, security model, and development
Knowledge with AWS data solutions development
Knowledge with Snowflake development
Ability to learn and adopt new technologies
Ability to communicate well with management, customers, developers within the organization and across UCSB IT organizations
Benefits
Excellent retirement and health
Full Benefits
Company
UC Santa Barbara
UC Santa Barbara is consistently recognized for excellence across broad fields of study.
5001-10000 employees
Funding
Current Stage
Late StageLeadership Team
Dominique Mihaljevic
Co-Founder & President of Association of Multi-Ethnic Persons
Tama Takahashi
Co-founder
Recent News
2025-05-08
Company data provided by crunchbase