Database Administrator

Job Summary
We are seeking a motivated and detail-oriented Database Administrator to join the St. Louis Cardinals' growing Business Analytics team. This person will be responsible for designing, building, and maintaining automated data pipelines that power reporting, modeling, and analytics across the organization. The ideal candidate has strong SQL and Python skills, experience with Google Cloud Platform (BigQuery and Airflow), and a passion for creating reliable, scalable data infrastructure. This role is a unique opportunity to help modernize how the Cardinals collect, organize, and deliver data for all business operations, including ticketing, marketing, finance, etc.
Key Responsibilities

• Design, build, and maintain ETL/ELT processes to ingest and integrate data from internal and external sources into BigQuery.
• Implement Airflow (and other GCP-native tools) to automate manual data pulls, report updates, and recurring workflows.
• Establish and manage a centralized 'cloud data library' - a well-organized, documented, and accessible source of data to be utilized and accessible to business operations.
• Develop validation checks and monitoring processes to ensure accuracy, completeness, and reliability of datasets.
• Work closely with analysts and IT to translate reporting needs into robust data pipelines.
• Apply cloud data security best practices (e.g., IAM roles, access controls, encryption standards) within GCP.
• Maintain clear process documentation and follow data governance best practices.
  

Qualifications Required

• Bachelor's degree in Computer Science, Data Engineering, Information Systems, or related field.
• 1-3 years of experience in a data engineering or related technical role.
• Proficiency in SQL (querying, optimization, data modeling).
• Proficiency in Python for data processing and automation.
• Experience with Google Cloud Platform (BigQuery, Cloud Storage, Airflow).
• Strong problem-solving skills and attention to detail.
• Understanding of GCP security practices, such as IAM roles, dataset-level permissions, and service account configuration.
• Ability to work both independently and collaboratively in a team environment.
  

Qualifications Preferred

• Experience with R for data analysis or reporting workflows.
• Experience with data migration projects, including extraction, mapping, and validation of legacy data.
• Familiarity with data warehousing concepts and dimensional modeling.
• Exposure to data quality testing, profiling, or anomaly detection.
• Familiarity with APIs, FTP processes, or other data ingestion methods.
• Experience with Git or other version control systems.
• Exposure to CRM, marketing, or ticketing data systems.
• Familiarity with business intelligence tools such as Power BI to support downstream reporting needs.
  

Success Factors

• Curious mindset with a passion for learning new technologies.
• Security-conscious, with a proactive mindset around protecting sensitive data.
• Self-motivated and able to manage multiple priorities.
• Strong communication skills - able to explain technical processes to non-technical stakeholders.
• Organized approach to building sustainable, documented processes.