Data Engineer

Who We Are:

Southern California Public Radio (SCPR) is a member-supported public media network whose mission is to strengthen the civic and cultural bonds that unite Southern California's diverse communities by providing the highest quality news and information service on air at LAist 89.3, online at LAist.com and through LAist Live Programming & Events. Since our founding in 1999, SCPR has been a fast growing, innovative, multi-platform public service newsroom. Every day, our staff helps audiences catch up on the latest headlines, solve the complexities of life in Southern California, and connect curious communities to one another.

Position Summary:

As the Data Engineer, this role will play a key role in the delivery of powerful data-driven products that enable innovative audience insights across livestreaming, podcasts, award-winning news website, mobile app, and live events, as we build toward a new model of subscription membership and unification across our channels.

Compensation:

The salary for this opportunity will be no less than $87,694 annualized and no more than $120,000 annualized. Exact salary determined by experience and education related to the role, organizational compensation structure, budget and internal equity.

Position Responsibility:

• Program in SQL, Python, integrating cloud services APIs to automate the processing of analytics, transactional, and marketing data from different networks.
• Serve as the data wrangler and ETL expert for the company.
• Ingest, transform, cleanse and augment internal and external data assets.
• Leverage a range of cloud services, ETL frameworks and libraries, such as AWS (EC2, RDS, S3, Lambda, Athena), MySQL, Python, Pandas, Apache Airflow, and Google Cloud, BigQuery, additional work in Azure Cloud Services and PowerBI, to surface analytics to guide business decisions.
• Integrate with media distributor APIs for analytics from live-streaming, podcasts, Apple and Google News, and an array of social networks, and marketing providers.
• Construct custom metrics and audience models toward actionable insights and product requirements.
• Build unique, custom dashboards in Data Studio to drive organization priorities

Required Education and Experience:

• Bachelor's degree in Computer Science or related field.
  • Alternatively, 5+ years relevant experience with history of skills progression and demonstrated accomplishments.
• Minimum 2+ years in experience specifically in data engineer or ETL developer roles.
• 2+ years in SQL: Programming complex queries, dynamic SQL, stored procedures, user defined functions, performance tuning.
• 2+ years in ETL: Data pipelines, ETL concepts and frameworks (DST), data-oriented cloud architecture, data warehousing, scalable technologies (such as column Redshift and BQ).
• 2+ years in data-oriented cloud services: Preferably AWS or Google Cloud.
• 1+ years API integration with media or marketing services.
• 1+ years with Python and/or Golang.
• 1+ years with Linux command line, shell scripting and Git.

Reporting to this Position: None

Physical Demands and Working Conditions

• Must be able to perform the essential duties of the position with or without reasonable accommodation
• Physical Demands:
  • May be required to work from home
  • Required to walk, sit, and stand; reach with hands and arms; balance, stoop, kneel, or crouch
  • Frequent use of hands for data entry/keystrokes and simple grasping.
  • Required to move about in an office environment and sit for extended periods of time
  • Frequent use of hands for data entry/keystrokes and simple grasping
• Working Conditions:
  • Moderate noise level
  • Occasional exposure to prevalent weather conditions

Southern California Public Radio (LAist 89.3/LAist.com/LAist Studios) is diverse in race, ethnicity, language, culture, social class, national origin, religious and political belief, age, ability, gender, gender identity, and sexual orientation in addition to other markers protected by law.

At SCPR, we strive to create an inclusive environment where we all feel pride in who we are and what we do. We are encouraged to show up as we are - always embracing and recognizing that our diversity is what brings us together. Our fundamental commitment to diversity:

• Enriches SCPR and provides an atmosphere in which all human potential is valued
• Promotes learning through interactions among people of different backgrounds and many perspectives, and
• Enables the organization to prepare all employees to promote social responsibility, equity, freedom, and productive citizenship in a global society

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, national origin, protected veteran status, disability status, sexual orientation, gender identity or expression, marital status, genetic information, or any other characteristic protected by law.

We are committed to hiring a breadth of diverse professionals and encourage you to apply.