Share Email Opening
Title

Database Administrator 

EOE Statement We are an equal employment opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veteran status or any other characteristic protected by law.  
Description

The Pirates Why

The Pittsburgh Pirates are a storied franchise in Major League Baseball who are reinventing themselves on every level. Boldly and relentlessly pursuing excellence by:

  • purposefully developing a player and people-centered culture;
  • deeply connecting with our fans, partners, and colleagues;
  • passionately creating lifetime memories for generations of families and friends; and
  • meaningfully impacting our communities and the game of baseball.

At the Pirates, we believe in the power of a diverse workforce and strive to create an inclusive culture centered in Passion, Innovation, Respect, Accountability, Teamwork, Empathy, and Service.

Job Summary

The Database Administrator is responsible for maintaining and overseeing the database structures used for data storage and retrieval within the business operations of the Pirates. This position will utilize best practices for extraction, transformation, cleansing, backfilling, and load of all internal and external data into the Pirates cloud-based data warehouse. The Database Administrator is also responsible for updating and maintaining the scheduling for all business intelligence data processes.

Responsibilities:

  1. Oversee the daily operation, performance, and maintenance of the data assets used within business operations and makes use of Pirates' standards and industry best practices to implement efficient and high-performance access to data.
  2. Design, create, and extend processes for data extraction, transformation, cleansing, and load to and from internal and external data sources for both structured and unstructured data.
  3. Monitor and maintain database structure relationships, inclusive of index management/optimization.
  4. Identify and mitigate field/table redundancy in data warehouse.
  5. Develop new and upkeep existing API/FTP/Scraping processes. Clean, normalize, and properly integrate data into data warehouse in an accessible way.
  6. Maintain, update, and build all Business Intelligence scheduled data processes, maintaining relationships with vendors to backfill missing or incomplete data.
  7. Work with Director, CRM & Consumer Insights and Pirates data partners to ensure accuracy and timeliness of data integrations with ticketing system.
  8. Collaborate with Director, Enterprise Systems to ensure processes comply with internal firewalls and securities.
  9. Identify opportunities to regularly share commonly used data to business leaders.
  10. Other duties as assigned by management.
  11. Assist with data retrieval for ad-hoc data analysis.
  12. Collaborate with Manager, Data Visualization to design, create, and maintain reporting structures using Tableau.
 
Position Requirements

Required:

  1. Bachelor's Degree in Computer Science, Information Systems, or equivalent.
  2. Experience administering enterprise-level data structures.
  3. Knowledge of SQL and database administration tools.
  4. Experience with API integrations.
  5. Experience with cloud-based architectures and tools including Google Cloud Platform.
  6. Experience with command line interface and Linux.

Desired:

  1. Master’s Degree in Computer Science, Information Systems or equivalent.
  2. Experience with database workflow tools, i.e. Apache Airflow, Argo Workflows, or Crontab.
  3. Experience with Python.
  4. Experience with ticketing data.
  5. Experience with a CRM system, i.e. Microsoft Dynamics or Salesforce.
  6. Experience with statistical analysis software such as R, SAS, SSPS.
  7. Application Development Skills
 
Location Pittsburgh, PA  
Full-Time/Part-Time Full-Time  
Shift Days  

This position is currently not accepting applications.

To search for an open position, please go to http://PittsburghPirates.appone.com



WE ALSO RECOMMEND

Other Jobs Within Same Category
-- None found --



Other Jobs Within 60 Miles
Seasonal Assistant, Youth Baseball & Softball in Pittsburgh, PA
Posted on: 3/18/2024
[Apply Now]

Minor League Operations Assistant in Pittsburgh, PA
Posted on: 11/2/2023
[Apply Now]

Software Engineer in Pittsburgh, PA
Posted on: 2/8/2024
[Apply Now]

Performance Sous Chef in Pittsburgh, PA
Posted on: 3/2/2024
[Apply Now]

PNC Park Security in Pittsburgh, PA
Posted on: 3/8/2024
[Apply Now]



 


 
Click here for technical assistance.