Analyst at Two Circles in New York, NY

Summary: Two Circles is a Sports & Entertainment Marketing business that focuses on understanding and influencing fan behavior to help clients grow their audiences and revenues. The Analyst will support data-driven consulting engagements, blending technical work with collaboration among internal stakeholders and potential client interactions. Responsibilities: - Write optimized SQL queries to support dashboards, reporting, automated workflows, and ad-hoc analysis - Assist in building and maintaining ETL processes, including ingesting, transforming, and validating data from multiple sources - Support the design and development of Tableau dashboards and other data visualizations - Investigate data discrepancies, troubleshoot issues, and contribute to data quality improvements - Contribute to documentation for scripts, data flows, and analytical processes - Work closely with internal consulting and technical teams to understand business requirements and translate them into scalable analytical solutions - Analyze and define tasks, data flows, dependencies, and timelines for assigned work - Support broader reporting and analytics initiatives across the team, contributing ideas and identifying opportunities for improvement - Participate in internal preparation for client meetings, insights presentations, and technical reviews - Over time, develop the skills and confidence to interact directly with client stakeholders, explaining findings and supporting problem-solving conversations Required Qualifications: - Strong command of SQL and relational database concepts - Experience building visualizations using Tableau (or similar BI tools) - Foundational understanding of ETL concepts and willingness to support pipeline development - Exposure to Python for data manipulation, automation, or analysis - Excellent communication skills - able to explain complex concepts clearly to technical and non-technical audiences - Strong analytical, organizational, and problem-solving skills - Ability to work autonomously, manage deadlines, and collaborate effectively within a team environment - Proactive mindset with a desire to continuously learn and improve Preferred Qualifications: - Familiarity with AWS or other cloud platforms - Experience with CRM platforms (e.g., Salesforce, Microsoft Dynamics) - Understanding of sports industry dynamics or database marketing concepts - Experience working with automated workflows or scripting for process efficiency Required Skills: SQL, Relational databases, Tableau, ETL processes, Python, Analytical skills