Gain Theory · 4 hours ago
Principal Data Analyst
New York, New York, United States
Full-time
Onsite
Lead/Staff
$100K/yr - $110K/yrGain Theory is a leading global marketing effectiveness and foresight consultancy. As a Principal Data Analyst, you will manage and analyze data, ensuring quality and integrity while collaborating with clients and mentoring junior analysts.
AnalyticsConsultingInformation Technology
Responsibilities
Manage data extraction, manipulation and validation
Manage data extraction, manipulation, validation, and interrogation using SQL, Python, and other relevant tools
Build data QA insights relevant to the project
Ensure that all data is systematically checked and passes all QA steps
Execute and update data pipelines
Building and maintaining data ingestion and transformation pipelines using all the tools that Gain Theory has at your disposal
Build data ingestion and transformation pipelines using available tools, including Python scripting for data processing and automation
Working with fellow data analysts to building scalable solutions using ETL/ELT pipelines
Propose better approaches to help improve internal procedures including new methodology, etc
Share techniques and ideas with the wider data community
Initiate and engage with internal project meetings, ensure there is an agenda
Ensure that project meeting action points are collated and shared with the team
Guide and support junior analysts, providing training on tools and best practices
Qualification
Required
Comfortable working with large amounts of data in a cloud ecosystem
Proficient with SQL and ETL processes, and experience driving robust QA processes
Experience with data interrogation, cleaning, and processing using Python
Extreme attention to detail a must
Strong interpersonal and communication (written and oral) skills
Team-oriented attitude
Capacity to learn new skills and master new tools
Ability and desire to lead junior team members through mentorship and example setting
Can lead requirements gathering, project planning, and implementation of projects developed with DCOE leads
Has project management skills including planning tasks and deliverables, managing timelines and risks, managing team resource allocation, and overseeing multiple simultaneous projects
Ability to manage and motivate Gain Theory team members and to teach concepts or technologies that are developed
Organized, detail-oriented, QA-focused
Preferred
Snowflake experience a plus
Experience with data manipulation/visualization tools (e.g., Excel, Tableau)
R experience a plus
Understanding or experience of business marketing and media a plus
Experience with DBT is highly valuable
Company
Gain Theory
Marketing foresight consultancy bringin together data, analytics, tech solutions + insights to facilitate predictive business decisions
Founded in 2015
201-500 employees
H1B Sponsorship
Gain Theory has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (2)
2024 (1)
2023 (1)
2022 (4)
2021 (6)
2020 (8)
Funding
Current Stage
Growth StageLeadership Team
Shawn O'Neal
CEO North America
Monica Ziobro-Schwartz, CPA
Global Chief Financial Officer
Recent News
Company data provided by crunchbase