Position: Miami Marlins Baseball Operations Data Architect

Location: Miami

Description:

The Data Architect will assist in the modeling, housing, and integration of baseball data from a wide variety of sources. This position will be responsible for creating enterprise database systems and setting standards for operations, programming, security, and backup. It will involve construction of large relational databases, integrating new systems with existing applications, and refining system performance and functionality within the Microsoft SQL Server platform to enhance the information retrieval and analysis capabilities of the Baseball Operations department.

Responsibilities:

• Perform data modeling and requirements gathering for Microsoft SQL Server database implementation.
• Develop high-performing, scalable solutions including schema design, storage engines, indexing strategies, SQL tuning, ETL processes and Stored Procedures to integrate disparate data sources into a unified system.
• Understand the format, definitions, limitations, and content of external and internal data feeds.
• Reconcile differences across data sources and consolidate into a single master repository to ensure “single version of the truth” consistency across applications and reports.
• Develop processes ensuring data standards, security, stewardship, lineage, and metadata management.
• Develop and document database architectures, schemas, physical structure, functional capability, security, backup, and recovery specifications.
• Support data and reporting requirements for a variety of applications, analysts, and end-users in the Baseball Operations department.
• Provide technical and strategic advice for the creation and implementation of new data standards, databases, products, and vendors.

Qualifications:

• Some familiarity with baseball and sabermetrics preferred.
• Ability to communicate technical concepts to individuals with diverse and non-technical baseball background.
• Knowledgeable about software development best practices and long-term maintainability of code.
• Ability to effectively diagnose, isolate, and resolve complex problems pertaining to data infrastructure and integrity.
• Strong work ethic, attention to detail, and ability to self-direct.
• Ability to work evenings, weekends, and holidays during the season.
• Bachelor’s degree in computer science, information technology, computer engineering, or equivalent professional experience required. Master’s degree a plus.
• At least 5 years of experience required, with preferable experience with architecture and design responsibilities in a large and challenging database environment.
• Extensive knowledge of Microsoft SQL Server (2005, 2008 with migration to 2012), Transact-SQL and third-party transformation middleware such as Scribe required.
• Demonstrated data modeling ability required.
• Experience designing, implementing, and managing large data warehouses and cubes in Microsoft SQL Server Analysis Services required.
• Advanced knowledge in query development, including SQL, MDX, and stored procedures required.
• Experience using XML and JSON formatted data strongly preferred.
• Experience supporting or using statistical and/or data mining applications strongly preferred.
• Business intelligence, data warehousing, or OLAP experience preferred.
• Experience in a .NET programming language preferred.
• Experience with a scripting language (Perl, Python, Ruby, etc.) a plus.
• Knowledge of other database platforms (PostgreSQL, Oracle) a plus.
• Familiarity with any application development and/or web technologies a plus.

Compensation:
This position is compensated.

To Apply:
Interested applicants can email their materials to marlinsbaseballjobs@gmail.com.