Share Email Opening 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: 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. 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. Work with CRM partner to ensure accuracy and timeliness of data integrations with ticketing system. Evaluate potential data providers and design and implement storage models that integrate with the existing data and application architectures. Collaborate with Manager, Data Visualization to design, create, and maintain reporting structures using Tableau. Work with Director, CRM and Consumer Insights to augment customer records for segmentation and targeted marketing. Collaborate with Manager, Quantitative Analytics to design and implement data mining processes and integrate data models into cloud environment. Work with VP, Strategy to automate all key performance indicator tracking used for strategic initiatives throughout the organization. Other duties as assigned by management. Secondary: Assist with data retrieval for ad-hoc data analysis.   Position Requirements Required: Bachelor's Degree in Computer Science, Information Systems, or equivalent. Minimum one (1) year of experience administering enterprise level data structures. Expert knowledge of SQL and database administration tools. Minimum one (1) year of experience with API integrations. Minimum one (1) year of experience with database workflow tools, i.e. Apache Airflow or Argo Workflows. Minimum one (1) year of experience with cloud-based architectures and tools including Google Cloud Platform. Desired: Master’s Degree in Computer Science, Information Systems or equivalent. Experience with Python. Experience with ticketing data. Experience with a CRM system, i.e. Microsoft Dynamics or Salesforce 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 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 Controller in Pittsburgh, PA Posted on: 9/15/2022 [Apply Now] Systems Tech Lead, Research & Development in Pittsburgh, PA Posted on: 7/5/2022 [Apply Now] Manager, Season Ticket Service in Pittsburgh, PA Posted on: 8/29/2022 [Apply Now] Ticket Office Assistant in Pittsburgh, PA Posted on: 9/9/2022 [Apply Now]

Click here for technical assistance.