Job summary
Job post source
This job is directly from Two Circles
Job overview
The Analytics Engineer at Two Circles plays a critical role in managing and optimizing data processes to support audience and revenue growth for sports and entertainment clients.
Responsibilities and impact
The role involves writing SQL scripts, developing and optimizing ETL pipelines, maintaining data warehouses, ensuring data quality, supporting machine learning model development, and collaborating with internal and external teams to enhance reporting products.
Experience and skills
Candidates must have strong SQL skills, knowledge of Python, experience with data warehouses and ETL tools like Amazon Redshift, familiarity with cloud platforms AWS and Azure, automation and scripting experience, and good communication skills.
Work environment and culture
Two Circles values teamwork, data-driven solutions, and effective communication across departments and with clients in a global sports and entertainment environment.
Company information
Two Circles is a global company with nearly 1000 employees across 14 offices, serving over 900 clients including major sports and entertainment brands like the English Premier League, Red Bull, and Nike.
Unique job features
The role offers the opportunity to work with advanced data technologies and contribute to high-profile sports and entertainment projects worldwide.
Company overview
Two Circles is a data-driven sports marketing agency that specializes in helping sports organizations grow their audiences and revenues through the use of data analytics and digital marketing strategies. They work with sports teams, leagues, and federations to optimize fan engagement, improve commercial performance, and enhance the overall sports experience. Founded in 2011, Two Circles has rapidly grown to become a key player in the sports industry, leveraging insights from data to create personalized fan experiences and drive business growth. The company generates revenue by offering consulting services and implementing data-driven solutions tailored to the unique needs of each client.
How to land this job
Tailor your resume to highlight your expertise in SQL script writing, ETL pipeline development, and database optimization, emphasizing your experience with AWS and relational databases like Amazon Redshift to align with Two Circles' core technical needs.
Showcase your ability to work collaboratively across teams and with external clients by emphasizing strong communication skills and examples of cross-departmental project involvement, as this role requires consultation and stakeholder engagement.
Apply through multiple channels including Two Circles' official corporate careers page and LinkedIn to maximize your application visibility and ensure you are considered through all available avenues.
Connect with current Two Circles employees in the analytics or data engineering teams on LinkedIn, initiating conversations with ice breakers such as commenting on recent projects Two Circles has done in sports analytics or asking about their experience working on the Kore platform.
Optimize your resume for ATS by incorporating keywords from the job description like 'SQL script writing,' 'ETL processing,' 'AWS,' 'data warehousing,' and 'automation' to ensure your application passes automated screening effectively.
Leverage Jennie Johnson's Power Apply feature to automate and customize your applications across platforms, identify relevant LinkedIn contacts for networking, and optimize your resume for ATS, allowing you to focus more time on preparing for interviews and upskilling.
Jennie Johnson works for you!
Here’s what we do to make sure you’re successful:
Targeted Resume Revamp:
We expertly craft your resume to navigate Applicant Tracking Systems (ATS) and showcase your qualifications, making you stand out as a top-tier candidate.
Job Description Dissection:
Unpack the job posting with expert analysis, ensuring your application hits every key requirement.
Bespoke Cover Letter:
Capture the attention of hiring managers with a personalized cover letter that highlights how your skills align perfectly with the job's needs.
Interview Mastery:
Prepare for interviews like a pro with likely questions, strategic answers, and insightful questions for you to ask, setting you apart as an informed candidate.
Direct Application Insights:
Receive tailored advice on the best places to apply, ensuring your applications are seen by the right employers.
Skills and Gaps Assessment:
Identify and close critical skills gaps to position yourself as the best-fit candidate for your ideal job.
Personalized Email Pitch:
Make a memorable first impression with an email template crafted to engage potential employers and initiate meaningful conversations.
In-depth Research Guide:
Leverage comprehensive research tools to gather effective insights on companies, industry trends, and role-specific challenges.
Detailed Company Analysis:
Gain in-depth understanding of your prospective employer, giving you the edge in applications and interviews.
Strategic Candidate Overview:
Understand your unique value and why companies would want to interview you, highlighting your background and positioning.