Position: Data Architect

Location: Pittsburgh, PA

Description:
The Data Architect is responsible for putting into place and maintaining the processes and systems to efficiently integrate and effectively make available baseball related data from both external and internal sources in order to provide the backbone of evidence based decision making.

Responsibilities

Primary:

• Responsible for the daily operation, performance, and maintenance of the data assets used within Baseball Operations. 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.
• Evaluate potential data providers and design and implement data models for storage and access to new types of data that integrate with the existing data and application architectures.
• Design, create and maintain reporting structures using SQL Reporting Services and Tableau and participate in one-off research projects to answer specific questions.
• Design and implement data mining processes as a part of predictive modeling in conjunction with the Quantitative Analyst and other staff members.
• Design and implement data mining processes as a part of predictive modeling in conjunction with other staff members.

Secondary:

• Departmentally: Participate in gathering and documenting user requirements for existing and new systems. Understand business processes and required outcomes of the system and creates requirements definition document defining the business use cases.
• Organizationally: Acts as a resource for database and SQL coding projects within the organization. Assist other staff developing SQL scripts, stored procedures, and other database objects where required.
• Industry: Acts as the point of contact with MLB in understanding and planning for future infrastructure needs and changes as the structure and breadth of information changes over time.

Position Requirements

Required:

• Bachelor’s Degree or higher in Computer Science, Information Systems, or equivalent.
• Two years experience administering enterprise level data structures using SQL Server technologies including SQL Reporting Services and SQL Server Integration Services.
• Expert knowledge of SQL and database administration tools. Knowledge of SQL Server replication topologies. Understanding of database documentation and design tools.
• Experience with cloud based architectures and tools including Amazon S3, EC2, Databricks required.
• Experience participating in multiple aspects of the software development life cycle including requirements definition, design, development, testing, and implementation.
• Demonstrated ability to work with users to understand business processes, document system requirements, and develop data structures that meet business objectives.

Desired:

• Experience with Python, .NET..
• Experience with statistical analysis software such as R, SAS, SSPS.
• An understanding of sabermetric techniques for player evaluation strongly preferred.

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

To Apply:
Please apply here.