Sr. Information Engineer, Baseball Techniques
Location: Boston, MA, United States
Division: Baseball Operations
Standing: Full-time
DEPARTMENT OVERVIEW:
Members of the Baseball Techniques staff 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 instantly built-in within the workflows of all departments inside Baseball Operations, and supply an environment friendly, constant, and accessible expertise when interacting with our inner knowledge sources and functions.
POSITION OVERVIEW:
The Boston Crimson Sox are looking for a Senior Information Engineer, Baseball Techniques who’s a hands-on database professional accountable 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 perfect candidate thrives in a fast-paced surroundings, is comfy managing each fashionable Snowflake-based pipelines and legacy SQL Server techniques, and brings a powerful sense of possession to delivering scalable, environment friendly, and maintainable knowledge options that instantly affect decision-making all through Baseball Operations. This position is central to the reliability and evolution of the Crimson Sox’s knowledge infrastructure, supporting analysts, builders, and techniques 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, enhancing efficiency via 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 help for crucial manufacturing techniques, resolving pipeline or efficiency points rapidly and successfully
- Companion with software program builders, analysts, and different stakeholders to help analytical, operational, and reporting wants throughout Baseball Operations
- Take part in code opinions, structure discussions, and DevOps greatest practices with the info engineering and software program improvement groups
COMPETENCIES
- Aptitude and talent to use educational or utilized expertise in software program improvement or knowledge engineering associated discipline.
- A sophisticated understanding of contemporary databases, SQL and question optimizations, saved procedures, views, and different db objects
- Capable of design knowledge options to permit for cost-effective, scalable, quick, and versatile options to help front-end improvement, analyst work, and knowledge well being and monitoring wants
- Capable of choose up rapidly and suppose 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 Laptop Science, Software program Engineering, Laptop Engineering, or a associated technical discipline
- 3-5 years of expertise in an information engineering or knowledge platform position with a deal with 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 growing 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 techniques
- Familiarity with DBT for knowledge transformation and modeling is strongly most popular
- Expertise with GraphQL is a plus however not required
- Capability to work autonomously and as a staff in a quick paced surroundings
- Excessive degree of consideration to element with the flexibility to multi-task successfully
- Comfy working remotely when required and utilizing Zoom, Groups, Slack, Trello, and different instruments to speak with all staff members
- Excessive diploma of professionalism and talent to take care of confidential info
- Glorious organizational and time administration abilities
Along with the above necessities, all roles inside Baseball Operations are anticipated to successfully exhibit 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.
Along with the above necessities, all roles inside Baseball Operations are anticipated to successfully exhibit 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.
To Apply:
To use, please comply with this hyperlink.
The content material on this posting was created and offered solely by the Boston Crimson Sox.