Data Engineer

TEKsystems • Santa Barbara, CA

122d • $115,000 - $145,000

About The Position

Experienced Data Engineer to join the team in our Technology department. As a Data Engineer, you will deliver a World Class Experience by developing and maintaining solutions to transfer, ingest, transform, model, and store Bank data, as well as any application using or processing that data. The Data Engineer will apply broad technical knowledge of technology and industry trends to lead the development, implementation, and maintenance of high risk/critical data solutions in a complex Microsoft, Azure, and Python environment.

Requirements

• Bachelor’s degree in data engineering field, or equivalent work experience, required.
• 5-8 years of experience in data engineering building end-to-end SQL and Python data solutions required.
• 5-8 years of experience building and managing data warehouse infrastructure platforms required.
• 5-8 years of experience building and managing orchestration and scheduling infrastructure platforms required.
• 5-8 years of experience building and managing BI and reporting infrastructure platforms required.

Nice To Haves

• 10-15 years of experience in ETL processes including ingestion via APIs preferred.
• 10-15 years of experience in business intelligence and analytics preferred.
• Experience working with version control, SDLC, and Data Governance best practices preferred.

Responsibilities

• Design, build, maintain and secure a Microsoft based data warehouse and orchestration platform that includes MS SQL Servers and Azure.
• Design, build, maintain and secure a Business Intelligence platform that includes PowerBI and Tableau.
• Design, build and maintain SQL Databases and Azure Storage.
• Design, build and maintain Python scripts for data pipeline jobs.
• Design, build and maintain Stored Procedures, queries and tables for Data Warehouse.
• Design, build and maintain Tableau or PowerBI reports.
• Design, build and maintain the Orchestration and scheduling of data jobs.
• Build process maps and flows for all jobs and services.
• Troubleshoot and remediate all data related incidents including root cause analysis.
• Collaborate with lines of business and other departments to understand data reporting needs and maximize use of reporting tools.
• Follow change and SDLC process.
• Responsible for ensuring our warehouse and business intelligence tool have the most current, accurate and relevant data possible for our customers.
• Continuously improving the quality, availability, usability, integrity and security of our data platform.
• Assist in maintaining documentation for internal procedures and inventory.

Benefits

• 3 weeks of vacation
• 9 sick days
• 5% 401k match
• 8%-10% annual bonus based on performance of the company
• Paid hours to volunteer in community
• Expected 3% annual raise and review
• Flexible hybrid work environment

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: Bachelor's degree
• Number of Employees: 5,001-10,000 employees