BP Job Postings: Boston Crimson Sox Sr. Knowledge Engineer

Sr. Knowledge Engineer, Baseball Techniques

Apply for This Job

DEPARTMENT OVERVIEW

Members of the Baseball Techniques group on the Boston Crimson Sox are targeted on designing, constructing, and refining the software program and knowledge pipelines used inside Baseball Operations. These instruments and functions are an integral a part of the decision-making course of, are immediately built-in within the workflows of all departments inside Baseball Operations, and supply an environment friendly, constant, and accessible expertise when interacting with our inside knowledge sources and functions.

POSITION OVERVIEW

The Boston Crimson Sox are in search of a Senior Knowledge Engineer, Baseball Techniques who’s a hands-on database professional chargeable for administering and optimizing large-scale SQL environments, constructing sturdy knowledge pipelines, and making certain high-performance entry to crucial baseball operations knowledge throughout on-prem and cloud platforms.

The best candidate thrives in a fast-paced setting, is comfy managing each fashionable Snowflake-based pipelines and legacy SQL Server programs, and brings a robust sense of possession to delivering scalable, environment friendly, and maintainable knowledge options that immediately impression decision-making all through Baseball Operations. This function is central to the reliability and evolution of the Crimson Sox’s knowledge infrastructure, supporting analysts, builders, and programs engineers throughout participant analysis, baseball sciences, and scouting domains.

RESPONSIBILITIES

Administer and optimize Snowflake and SQL Server environments, together with warehouse sizing, question tuning, and entry management insurance policies

Develop sturdy knowledge transformation pipelines, leveraging knowledge from each APIs and file-based sources

Leverage instruments like dbt, Snowpipe, and Snowpark for knowledge transformations

Design, handle, and monitor knowledge pipelines that transfer structured and unstructured knowledge from Azure Blob Storage into Snowflake, making certain reliability, efficiency, and cost-efficiency

Keep and modernize legacy SQL Server knowledge pipelines, bettering efficiency by way of question optimization, indexing methods, and useful resource tuning

Contribute to the infrastructure design and software program lifecycle phases—together with technical design, testing, implementation, and high quality assurance

Present proactive assist for crucial manufacturing programs, resolving pipeline or efficiency points rapidly and successfully

Companion with software program builders, analysts, and different stakeholders to assist analytical, operational, and reporting wants throughout Baseball Operations

Take part in code critiques, structure discussions, and DevOps greatest practices with the info engineering and software program improvement groups

COMPETENCIES

Aptitude and talent to use tutorial or utilized expertise in software program improvement or knowledge engineering associated area.

A sophisticated understanding of recent databases, SQL and question optimizations, saved procedures, views, and different db objects

In a position to design knowledge options to permit for cost-effective, scalable, quick, and versatile options to assist front-end improvement, analyst work, and knowledge well being and monitoring wants

In a position to choose up rapidly and assume each creatively and critically to unravel issues

A primary understanding of up to date baseball and/or sports activities evaluation and improvement practices

A team-player that collaborates successfully with technical and non-technical stakeholders

ADDITIONAL QUALIFICATIONS

Bachelor’s diploma in Pc Science, Software program Engineering, Pc Engineering, or a associated technical area

3-5 years of expertise in an information engineering or knowledge platform function with a give attention to database efficiency and pipeline reliability

Sturdy SQL improvement and optimization abilities, together with expertise with saved procedures, indexing, and question tuning in SQL Server

Palms-on expertise administering and creating in Snowflake, together with warehouse scaling, role-based entry, and utilization monitoring

Proficiency in constructing and sustaining knowledge pipelines from Azure Blob Storage to Snowflake, utilizing instruments like dbt, Snowpipe (or equal)

Stable understanding of ELT/ETL ideas and knowledge structure greatest practices throughout cloud and hybrid programs

Familiarity with DBT for knowledge transformation and modeling is strongly most popular

Expertise with GraphQL is a plus however not required

Capacity to work autonomously and as a group in a quick paced setting.

Excessive degree of consideration to element with the flexibility to multi-task successfully.

Snug working remotely when required and utilizing Zoom, Groups, Slack, Trello, and different instruments to speak with all group members.

Excessive diploma of professionalism and talent to keep up confidential data.

Wonderful organizational and time administration abilities.

Along with the above necessities, all roles inside Baseball Operations are anticipated to successfully show our common competencies associated to drawback fixing, teamwork, readability of communication, and time administration, together with embodying our tradition of honesty, humility, relentlessness, and dedication to DEIB.

Apply for This Job