Data Engineer II

$108,000 - $216,000/Yr

Fanatics - Denver, CO

Full-time

Denver, CO

Food Services and Drinking Places

About the position

As a Data Engineer II at Fanatics Ecosystem (FES), you will play a crucial role in the development, deployment, and management of our data architecture. This position involves building systems and user experiences for internal customers that aggregate customer data from various sources, integrate with third-party systems, and create personalized experiences. You will collaborate with a team of experts to design and implement systems that convert raw data into usable information for data analysts and business users, ensuring a stable and extensible platform at scale.

Responsibilities

• Assist in the design and construction of scalable data management systems, ensuring they meet business requirements and industry practices.
• Design, build, and maintain scalable and robust data pipelines to support analytics, business intelligence, and machine learning models.
• Implement and maintain databases and data processing systems to support data collection, integration, and retention requirements according to company policies.
• Develop and optimize data pipelines, ensuring efficient and error-free data flow across the organization.
• Collaborate with cross-functional teams to understand data needs and implement solutions that enable efficient data analysis and reporting.
• Monitor the performance of data processing and storage systems, resolving any failures and ensuring data accuracy and security.
• Implement data governance and security best practices to ensure data integrity and compliance with relevant regulations.
• Provide technical leadership and mentorship to junior data engineers, promoting a culture of excellence and continuous learning.
• Stay updated with emerging trends and technologies in data engineering, applying new techniques and tools to improve our data ecosystem.

Requirements

• 3-5 years of data engineering experience with a proven track record of helping to design and implement large-scale data solutions.
• Possess a strong foundation in data structures, algorithms, and software engineering principles.
• Demonstrated skills writing SQL queries.
• Familiar with other data languages including R or Python, and tools like Tableau, Microstrategy, Redshift, or Snowflake.
• Knowledgeable about data modeling, ETL development, and data warehousing principles.
• Familiar with SQL and NoSQL databases, including MySQL, PostgreSQL, MongoDB, or Cassandra.
• Solid analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy.
• Excellent communication and collaboration skills.
• Intellectually curious and interested in solving difficult problems.
• Able to effectively communicate complex technical subjects to a variety of audiences.

Nice-to-haves

• Experience with Spark using Scala.
• Experience with Terraform for deploying infrastructure on AWS and Snowflake.
• Experience with Airflow.
• Object-oriented programming and functional programming skills.

Benefits

• Salary range: $108,000 to $216,000, subject to geographical compensation zones.