Share Email Opening Apply Now
Title

Data Architect 

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

Job Summary

The Data Architect is responsible for building and maintaining 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, and load of all internal and external data. The Data Architect will work closely with other members of the Business Intelligence team to create reporting structures and implement data mining processes for analysis and predictive modeling.

Job Responsibilities

Primary:

  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. Work with CRM partner to ensure accuracy and timeliness of data integrations with ticketing system.
  4. Evaluate potential data providers and design and implement storage models that integrate with the existing data and application architectures.
  5. Collaborate with Manager, Data Visualization to design, create, and maintain reporting structures using Tableau.
  6. Work with Director, CRM and Consumer Insights to augment customer records for segmentation and targeted marketing.
  7. Collaborate with Manager, Quantitative Analytics to design and implement data mining processes and integrate data models into cloud environment.
  8. Work with VP, Strategy to automate all key performance indicator tracking used for strategic initiatives throughout the organization.
  9. Other duties as assigned by management.

Secondary:

  1. Assist with data retrieval for ad-hoc data analysis.
 
Position Requirements

Required:

  1. Bachelor's Degree in Computer Science, Information Systems, or equivalent.
  2. Minimum one (1) year of experience administering enterprise level data structures.
  3. Expert knowledge of SQL and database administration tools.
  4. Minimum one (1) year of experience with API integrations.
  5. Minimum one (1) year of experience with database workflow tools, i.e. Apache Airflow or Argo Workflows.
  6. Minimum one (1) year of experience with cloud-based architectures and tools including Google Cloud Platform.

Desired:

  1. Master’s Degree in Computer Science, Information Systems or equivalent.
  2. Experience with Python.
  3. Experience with ticketing data.
  4. Experience with a CRM system, i.e. Microsoft Dynamics or Salesforce
  5. Experience with statistical analysis software such as R, SAS, SSPS.
 
Location Pittsburgh, PA  
Full-Time/Part-Time Full-Time  
Shift Days  

This position is currently accepting applications.

Apply Now



WE ALSO RECOMMEND

Other Jobs Within Same Category
-- None found --



Other Jobs Within 60 Miles
Assistant, Human Resources in Pittsburgh, PA
Posted on: 7/9/2021
[Apply Now]

Director, Story & Production in Pittsburgh, PA
Posted on: 5/27/2021
[Apply Now]

Coordinator, Social Media in Pittsburgh, PA
Posted on: 6/8/2021
[Apply Now]

Bat Boy, Ball Boy and Clubhouse Assistant in Pittsburgh, PA
Posted on: 3/19/2021
[Apply Now]

Clubhouse Laundry Room Attendant in Pittsburgh, PA
Posted on: 6/4/2021
[Apply Now]



 


 
Click here for technical assistance.