Data Engineer - Peregrine Sports (Portland · OR)
Portland, OR
Junior +1 · Full time
Posted a year ago
Apply

Data Engineer - Peregrine Sports (Portland · OR)

 
Peregrine Sports Jobs
 
Jobs in Portland · OR
 
Facility Operations/Event Staff: Engineering
 
Purpose: The Data Engineer is primarily tasked with assisting in the ongoing efforts to maintain the club’s data infrastructure, develop more efficient data architecture and pipelines, help drive incremental revenue, provide actionable insights to decision makers, and continually develop our understanding of our fans and marketplace. This position requires a high work-ethic, an analytical mind, creative thinking, and a passion for telling stories through data.

Major Responsibilities:
  • Build, maintain, integrate, and troubleshoot data sources, data pipelines, and ETL/ELT processes across all business operations, such as social media data, digital and text message data, ticketing data, CRM data, and other business needed data as required within our data architecture
  • Research and develop API processes for extracting and storing new data feeds
  • Apply a combination of programming languages (SQL, Python, & R) to assist with multiple business functions across the club
  • Create strategies to resolve, clean, enrich, and unify data of various types from disparate data sources and subsequently surface unified data to business applications and users
  • Oversee all aspects of data management operations, including defining and resolving database problems, tuning for performance, and managing storage
  • Collaborate frequently with IT department and other system administrators to implement vendor sourced software, configuring software, customizing, and integrating it with current systems
  • Work closely with data analysts to maintain and create data pipelines and data models to help provide actionable insights for decision makers
  • Research new technologies and methods across data science, data engineering, and data visualization to improve the technical capabilities of the team
  • Develop efforts to maintain, clean, assist, innovate the club’s data architecture
  • Work closely with Analytics and Marketing teams to assist in data segmentation and modeling
  • Support and innovate on-going revenue operations and data modeling efforts
  • Work closely with all departments to dive deep into data and provide executive staff with actionable insights
  • Develop and maintain innovative dashboards and database automations that can easily tell a complex story to decision makers
  • Assist with everyday processes and other long-term projects as assigned
 
Preferred Requirements:
  • Bachelor’s degree in in Computer Science, Data Engineering, Machine Learning, Statistics, Applied Mathematics, Economics, or a related field with focus on computer science, data science, or programming 
  • Minimum of one (1) year of experience with data engineering, ETL processes, and database architecture
  • Advanced working experience with SQL and Python languages
  • Working experience with third-party APIs, especially RESTful APIs, and handling structured/unstructured data (XML, JSON, and natural language text)
  • Experience learning, building, and optimizing ‘big data’ pipelines, architectures and data sets across a variety of source systems 
  • Experience working with Microsoft Dynamics, Microsoft Power Platform, Microsoft COE tools, and Power BI administration preferred
  • Experience with relational OLTP and OLAP SQL systems; Azure SQL Database preferred but not required
  • Experience with data pipeline and workflow management tools; Azure Data Factory preferred but not required
  • Experience working with on-premises SQL server, SSIS, SSRS with an ability to learn Power BI report server
  • Comfort in working with cloud computing and data warehousing environments; Microsoft Azure preferred but not required
  • Technological aptitude; an ability to troubleshoot and learn complex systems to solve problems and questions
  • Team player with a positive attitude, self-confidence, professionalism, resourcefulness, integrity, motivation, and a very strong work ethic
  • Ability to tell a business story from complex data
  • Ability to work gamedays to assist Analytics team as needed 
 
We are an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, national origin, sex, sexual orientation, age, disability, gender identity, marital or veteran status, or any other protected class.
Portland Timbers & Thorns FC
Portland Timbers of MLS and Portland Thorns FC of the NWSL
Size:  51-100 employees
© 2023 Pallet Labs Inc. See privacy policy and terms of service
Get started on Pallet
This community is on Pallet — Where creators turn their community into recruiting networks