Two Circles

Database Administrator

• Manage and support mission-critical SQL Server environments across Production, QA, and Development.
• Install, configure, and maintain enterprise-wide SQL Server instances (2016 and higher).
• Perform Windows Server administration (2016/2019/2022) and manage OS/SQL Server patching via AWS tools (SSM, RunCommand).
• Configure and manage SQL Server AlwaysOn availability groups and failover clustering.
• Optimize database performance through query optimization, index tuning, and execution plan analysis.
• Manage backup/restore processes and perform point-in-time recovery.
• Administer database security, users, roles, and permissions, including AWS IAM roles and permissions.
• Develop and maintain SSIS packages and SSRS reports.
• Monitor and rightsize infrastructure using tools like CloudWatch and NewRelic.
• Understand and configure ODBC clients and HAProxy as needed.
• Perform capacity planning, forecasting, and proactive performance tuning.
• Conduct root cause analysis for outages and performance issues.
• Automate tasks using T-SQL scripts, SQL Agent jobs, and basic PowerShell scripting.
• Troubleshoot connectivity and network issues, including TCP/IP, DNS resolution, and hostname configuration.
• Use Performance Monitor (Perfmon) to monitor OS-level metrics (CPU, memory, disk I/O).
• Basic understanding of Windows Firewall rules, VPN access, and private vs public network configurations.
• Experience with AWS services (RDS, S3, DynamoDB, EC2, IAM); Azure experience is a plus.

Database Administrator – 10-month Contract

Project Manager

• Own delivery of CRM Consulting engagements from kick-off through completion
• Develop and maintain clear project plans, timelines, and milestones
• Ensure delivery remains on track across scope, time, and dependencies
• Manage a portfolio of CRM Consulting projects, prioritizing the most complex and high-impact engagements
• Maintain visibility across all active projects, identifying risks and dependencies early
• Provide structured updates and clear reporting on delivery status
• Act as the primary point of contact for day-to-day delivery matters with clients
• Lead regular status updates, ensuring clarity, transparency, and proactive communication
• Support consultants in maintaining strong client relationships through structured delivery
• Coordinate across CRM consultants, data teams, and internal product teams
• Manage dependencies across multiple stakeholders, including geographically distributed teams
• Track project budgets, burn rate, and overall delivery health
• Identify and flag scope changes and delivery risks early
• Establish and evolve consistent delivery standards, practices, and frameworks across CRM Consulting engagements

Project Manager, CRM Consulting

Engineer

• Own the architectural direction for streaming data ingestion from GCP into AWS
• Design resilient ingestion frameworks including error handling, retry strategies, monitoring, and failure isolation
• Implement distributed processing pipelines using Spark / PySpark or similar frameworks
• Data Warehousing & DBT Leadership
• Create and maintain scalable data warehouses and associated ETL/ELT processes using DBT models in Amazon Redshift
• Design and implement DBT projects including macros, tests, documentation, and reusable modeling patterns
• Conduct Redshift query and DBT performance tuning to optimize warehouse efficiency and cost
• Engineering Standards & Quality
• Define and enforce best practices for:
• Data modeling
• Version control (Git-based workflows)
• CI/CD pipelines for DBT deployments
• Automated testing at model, transformation, and pipeline levels
• Ensure robust testing is embedded into every DBT model (schema tests, custom tests, data validation checks)
• Lead code reviews and architectural design reviews
• AWS Platform & Big Data Tooling
• Work with AWS services including Redshift, S3, Glue, Step Functions, Lambda (Python), Athena, and EMR

Big Data DBT, Redshift Engineer – Contract

Producer

• Lead creative and production delivery across sports/entertainment focused clients, operating as both producer and hands-on shooter where required.
• Manage the end-to-end production process, collaborating closely with clients, creative teams and client services to ensure exceptional content delivery.
• Take ownership of filming on smaller shoots. Confidently managing agile, run-and-gun setups while maintaining high production value.
• On larger productions, work alongside Directors of Photography, camera operators and wider crew, contributing editorial direction while supporting technical execution.
• Ensure consistency in quality, style and tone across diverse client projects, particularly within sports narratives.
• Coordinate deliverables to align with production schedules and client objectives (formats, cutdowns, vertical edits, teasers, etc.).
• Lead and mentor a team of video assistant producers, editors, and motion graphics designers across multiple concurrent projects.
• Ideate, create and execute innovative video concepts that drive engagement and meet client KPIs, particularly across social platforms.
• Contribute to pitching and new business opportunities with creative insight and production expertise.

Shooting Producer

Operations

• Working with project managers to create project plans managing client, supplier and internal deadlines
• Oversee production workflow of bespoke marketing materials
• Quality control of bespoke marketing materials pre-& postproduction
• Sourcing of physical and digital materials needed for design production
• Managing & building relationships with a range of external suppliers
• Budget management, auditing of materials and tracking stock movement
• Work with logistics companies to track and ensure fast and effective delivery of materials
• Ad hoc admin tasks for the team
• Support internal sales team alongside project managers

Commercial Operations Executive – Entry-Level

Backend Engineer

• Design, build, and test scalable data platform solutions in Azure, leveraging tools like ADF, Databricks, and Function Apps, using Python.
• Develop high-quality data products, ensuring efficiency, reliability, and performance across our data pipelines.
• Collaborate closely with product and marketing teams to deliver data-driven insights and solutions that provide high business value.
• Write clean, maintainable code following best practices and development frameworks, ensuring robust data engineering standards.
• Continuously improve and optimize data workflows, monitoring performance and implementing enhancements to drive innovation.

Data Engineer – Azure, Databricks, Python

• **Who we are**
• We are Two Circles. We are a Sports & Entertainment Marketing business. We grow audiences and revenues. We do that by knowing fans best. We work with clients to help them understand & influence what their fans are doing – the way fans spend their money, the events that fans attend, the channels fans respond to, the content fans watch and more. And we use the understanding this gives us to help our clients grow. Grow their audiences and grow their revenues - both direct to consumer and business to business revenues. Our platforms and services are trusted by over 900 clients globally, including the English Premier League, Red Bull, UEFA, VISA, the NFL, Nike and Amazon. We are almost 1000 people, based out of 14 offices, and we deliver work for sports and entertainment businesses of all shapes and sizes all over the world.
• **What you will do**
• We're looking for a talented Software Engineer to join our squad of >100 Engineers, working on our Audience Intelligence Platform You will be helping to build and evolve the web applications and services that power how teams, leagues, and organizations interact with fan insight and marketing intelligence. In this role, you'll work with modern frontend and backend technologies to design, build, and optimize scalable web applications and APIs, enabling marketing and BI teams to unlock the full potential of our platform. If you're passionate about software engineering, enjoy collaborating in a fast-paced environment, and want to make an impact in the sports industry, we’d love to hear from you!
• Your role will be varied and evolve as quickly as you can learn and develop. Your initial duties will involve:
• - Design, build, and test scalable web applications and APIs using modern frontend technologies (HTML5, CSS3/SCSS, JavaScript/TypeScript) and backend frameworks (C#, .NET, ASP.NET MVC & Web API).
• - Develop high-quality software components and services, ensuring efficiency, reliability, performance, and maintainability across our platform.
• - Collaborate closely with product and marketing teams to deliver data-driven insights and solutions that provide high business value.
• - Write clean, maintainable code following best practices and development frameworks, ensuring robust data engineering standards.
• - Continuously improve and optimize data workflows, monitoring performance and implementing enhancements to drive innovation.
• - Develop web applications that visualize audience segmentation and campaign performance metrics
• - Build APIs and dashboards that expose fan behavior analytics to marketing teams

Software Engineer, .Net

• **What you will do**
• We're looking for a talented Data Engineer to join our squad of >100 Data & BI Engineers, working on our Audience Intelligence Platform. You will be helping to build the leading data management and analytics platform for the sports industry. In this role, you'll work with cutting-edge technologies to design, build, and optimize scalable data solutions, enabling teams, leagues, and organizations to unlock the full potential of their data. If you're passionate about data engineering, enjoy collaborating in a fast-paced environment, and want to make an impact in the sports industry, we’d love to hear from you!
• Your role will be varied and evolve as quickly as you can learn and develop. Your initial duties will involve:
• - Design, build, and test scalable data platform solutions in Azure, leveraging tools like ADF, Databricks, and Function Apps, using Python.
• - Develop high-quality data products, ensuring efficiency, reliability, and performance across our data pipelines.
• - Collaborate closely with product and marketing teams to deliver data-driven insights and solutions that provide high business value.
• - Write clean, maintainable code following best practices and development frameworks, ensuring robust data engineering standards.
• - Continuously improve and optimize data workflows, monitoring performance and implementing enhancements to drive innovation.

Lead Data Engineer – Azure, Databricks, Python

Frontend Engineer

• Write clean, and reusable code following best practices whilst helping to define coding standards and team conventions.
• Be an advocate for developer experience and have a keen interest in continually improving it.
• Encouraging a blameless culture of continuous improvement and technical excellence.
• Leading and influencing the technical design, architecture and development of digital projects.
• Work closely with Engineering Managers, Engineering Leads and Product Managers to understand problems and define technical scope for global sports properties.
• Setting up software development frameworks for release management, automation, code quality and source control.
• Providing technical leadership, mentoring and guidance to other Two Circles engineers.
• Keeping up to date on emerging technologies and trends in sports technology.

Frontend Developer – Contract

Business Analyst

• Running, attending and contributing to workshops with clients, partners and vendors to gather inputs and information that help solve client problems.
• Producing documentation including detailed user stories, user story maps, process flows, wiki pages, and requirements documents.
• Producing and contributing to client-facing slide decks and documents to help bring clarity to complex problem spaces.
• Supporting data analysis activities to inform product requirements and key decision making.
• Working as part of a cross functional Agile team in the delivery of digital products.
• Attending and, at time, facilitating regular agile ceremonies such as sprint planning, stand-ups, retrospectives and showcases, with opportunities to facilitate as your confidence grows.
• Building great relationships with client stakeholders, ensuring they are kept informed and consulted during projects.
• Bringing alignment between business objectives, user experience and technical delivery.
• Continuously searching for ways to improve both client and internal processes.

Business Analyst – Contract

Graphics Designer

• A good knowledge of Adobe Creative Suite, especially Photoshop, Illustrator and InDesign
• A basic understanding of After Effects/Premiere Pro (not compulsory but a bonus)
• Art-working for print and digital assets
• An understanding of motion graphics and/or 3D skills (not compulsory but a bonus)
• Some experience using Webflow or Figma would be beneficial
• Some experience developing bespoke sales materials including print brochures, digisites and presentations