KPBS Data Engineer

KPBS Data Engineer

Req No: 2023-15081
Category: Radio/TV/Multimedia
Type: Full-Time Contract
Salary: $7,083.33/mo - $10,833.33/mo
Close Date: 4/3/2023

Overview
Under the general direction of the Director of Digital, the Data Engineer is primarily responsible for integrating data from various CRM applications (iMIS (CRM), Eventbrite, Google Ads, Google Analytics, PBS, NPR) and other data sources into the software data warehouse (Snowflake) and customer data platform (Lytics).

This position will assist the Data Analyst in maintaining databases that house marketing and analysis data; working with subject matter experts in various departments at KPBS, working with staff on data creation policies and procedures and performing data quality checks, as needed. The position will be the lead on problem-solving technical issues within the Snowflake Data Warehouse and will work across departments to ensure the effectiveness of Key Performance Indicators within the organization.

The Data Engineer will provide program implementation and policy creation guidance and support. This includes responsibility for the monitoring of data quality, data governance, data access, data cleaning, data validity and timely consumption and delivery of the data to and from various endpoints.

Perks you'll enjoy as a member of #teamKPBS

- Working on a college campus & in public media (access to campus facilities and staff discounts, farmer's market Tuesday's, tons of eateries, community events, entertainment)

- Hybrid schedule, remote work flexibility & casual work attire

- Paid time off on your birthday (can take on any day)

- 10 vacation days and 13 holidays off (enjoy 4+ days off over winter break)

- Enjoy a 'beautiful day in the neighborhood' with local employee discounts

- Opportunity drawings to attend SDSU basketball games, local concerts, and events

- Free wellness classes & programs

- Monthly pop-up events for staff & KPBS swag

- Full benefits packages that are unmatched (medical, dental, vision, life)

- Sick leave accruals and paid leave options

- On-site childcare at a discounted rate

- Opportunities for continued learning and professional development

- Flexible spending account(s)

- Employee assistance program

- Matching and voluntary retirement savings plan

Salary range is $7,083.33/mo - $10,833.33/mo ($85,000 - $130,000/yr).


Responsibilities
The following information is intended to be representative of the work performed by incumbents in this position and is not all-inclusive. The omission of a specific duty or responsibility will not preclude it from the position if the work is similar, related, or a logical extension of position responsibilities. Job descriptions may be changed at any time based on the needs of the department.

Data Management & Development (35%)

• Build, manage and maintain data pipelines for data integration (ELT/ ETL)
• Perform data quality checks and clean ups at various data collection and storage touchpoints
• Ensure security of data during transit and at rest
• Transform data for use in marketing and analytics applications

Data Administration (35%)

• Perform as the lead administrator role for the Snowflake Data Warehouse
• Act as the lead for problem-solving technical issues within or related to the Data Warehouse
• Work across departments to ensure effective data usage in the organization
• Create and maintain data policies that will ensure accuracy of reports and usage of data for marketing

Project Implementation (15%)

• Work across departments to gather requirements, implement various projects as they arise

Support and Staff Training (10%)

• Support Data Analyst by providing data for use in analysis, managing connections to BI applications, dashboard creation, etc.
• Lead periodic trainings for Snowflake users
• Train support staff on data creation policies and procedures, business process creation and other activities that impact the quality and usefulness of data collected
• Convene and lead workgroups, create/implement policies and monitor and oversee the data quality across multiple systems
  

Other Duties as Assigned (5%)


Qualifications
MINIMUM EDUCATION

• Bachelor’s degree in computer science, information systems, business administration or similar field. Additional or equivalent years’ of work experience may be substituted for the required education on a year for year basis.

MINIMUM EXPERIENCE

• Four-years of related work experience in data engineering; developing data pipelines

PREFERRED EXPERIENCE

• 2-3 years of which involve SQL database administration;
• 3-4 years of which include experience developing, maintaining and administering software applications on the linux operating system

KNOWLEDGE & ABILITIES

• Demonstrated experience with data integration toolsets (i.e Airflow)
• Demonstrated experience with writing and maintaining Data Pipelines
• Demonstrated ability of good scripting, including Bash scripting and Python
• Demonstrated experience with cloud technologies such as AWS, GCP, Azure
• Demonstrated experience designing and working on complex data systems from design to delivery
• Knowledge of and familiarity with Data Modeling techniques such as dimensional modeling and Data Warehousing standard methodologies and practices
• Knowledge of SQL and ability to create queries to extract data and build performant datasets
• Demonstrated expertise in using Snowflake cloud data warehouse including administration of roles, security, stages, etc.
• Ability to integrate with 3rd party APIs
• Ability to problem solve with strong attention to detail; excellent analytical and communication skills
• Ability to work individually and as a part of a team
• Ability to interact effectively with co-workers, vendors and consultants
• Ability to understand and follow posted work rules and procedures
• Ability to relate well to others within the project environment.
• Ability to display motivation and strong interpersonal skills
• Ability to communicate effectively, both orally and in writing
• Ability to display organization, meet deadlines, display detail orientation, possess good judgment and common sense
• Ability to demonstrate a high level of cross-cultural sensitivity

ADDITIONAL APPLICANT INFORMATION:

• The COVID-19 vaccine is required by the CSU for all SDSU Research Foundation employees as a condition of employment. Should you be offered a position, you will be required to provide proof of vaccination status. Individuals who obtain an approved medical or religious exemption on file will be required to complete regular COVID-19 testing
• A background check (including a criminal records check) and Livescan (fingerprint) must be completed satisfactorily before any candidate can be offered a position with SDSU Research Foundation/KPBS
• San Diego State University Research Foundation is an EEO/AA/Disability/Vets Employer

To apply, visit https://careers-sdsurf.icims.com/jobs/15081/kpbs-data-engineer/job?in_iframe=1




jeid-e780d93be0fffa44bb1f639644dcfaf6