Data Analyst Python Sql Jobs in Columbus, OH (NOW HIRING)

At Allstate, great things happen when our people work together to protect families and their belongings from life’s uncertainties. And for more than 90 years, our innovative drive has kept us a step ahead of our customers’ evolving needs. From advocating for seat belts, air bags and graduated driving laws, to being an industry leader in pricing sophistication, telematics, and, more recently, device and identity protection. 

Job Description

Arity is a part of the Allstate Corporation, which means we have the same innovative drive that keeps us a step ahead of our customers’ evolving needs. We collect and analyze enormous amounts of data in order to provide cutting-edge solutions to companies invested in transportation.
The Team
Advertising data analytics team empowers the intelligence and efficiency of Arity Marketing Platform, which enables marketers to find their best customers wherever they are in their journey. Our goal is to empower marketers to reach prospects and display relevant messaging based on how, when, and where they drive. The team is responsible for optimizing the in-house marketing platform for advertisers and publishers, as well as our revenue, throughout all funnels. To achieve this, not only do we need to look for inefficiencies on the platform including individual campaigns, but also how to grow and scale the platform to gain more revenue. This means we need to find a cost-effective way to rapidly deploy, test and iterate algorithms on our platform. This team is also fully integrated within a cross-functional scrum structure including product owners, software engineers, account management/AdOps team, and other talents to collaborate with to achieve the same business goals
The Role
As a Senior Data Analyst for ad operations, you are responsible for monitoring and optimizing our digital advertising campaigns on Arity marketing platform. You will closely work with the account management/AdOps team to understand the campaign goals and dig into the data to look for insights to make recommendation to optimize the campaign. You will design A/B testing to measure the effectiveness of the optimization. You also need to work with data scientists to provide operational insights for building automated solutions using machine learning and AI algorithms so that you can leverage them in running the campaign wherever necessary.

Key Responsibilities

Your day-to-day looks like:

• Monitor and optimize programmatic campaigns using real-time and historical data signals

• Diagnose performance issues across supply, demand, and delivery systems; recommend targeted interventions

• Design and evaluate A/B and multivariate experiments, integrating sensor-based features into test frameworks

• Collaborate cross-functionally with AdOps, Product, and Data Science to operationalize optimization strategies at scale

• Contribute to the development of automated decisioning systems for campaign management (e.g., budget allocation, bidding adjustments)

• Partner with data scientists to translate business problems into ML-driven solutions (e.g., propensity models, bidding optimization, segmentation)

• Drive the evolution from manual campaign management to automated, intelligence-driven optimization systems

Required Qualifications

• Bachelor’s degree

• 4+ years of experience in data analysis, campaign optimization, or programmatic advertising

• Strong proficiency in SQL and Python for large-scale data analysis

• Solid understanding of programmatic advertising ecosystem and KPIs (CPM, CPC, win rate, CPA, ROAS)

• Experience designing and analyzing experiments (A/B testing, causal inference methods)

• Strong problem-solving and analytical thinking skills with a focus on driving measurable outcomes

• Ability to communicate insights effectively to both technical and non-technical stakeholders 

Preferred Qualifications

• Familiarity with machine learning concepts and collaborating on production ML systems

• Experience with cloud data platforms (e.g., BigQuery) and data pipeline development

• Experience building semantic layers or analytical models for scalable reporting

• Experience leveraging AI-powered coding assistants to enhance productivity

At Arity, great things happen when our people work together.

That’s why when you join our team, we make sure it isn’t just a job — it’s an opportunity. One that takes your skills and pushes them to the next level. One that encourages you to challenge the status quo. And one where you can impact the future for the greater good.  

You’ll do all this in a flexible environment that embraces connection and belonging. And with the recognition of several inclusivity and diversity awards, we’ve proven that Allstate empowers everyone to lead, drive change and give back where they work and live.

Skills

Data Analytics, Digital Advertising, Programmatic Advertising, Python (Programming Language), Structured Query Language (SQL)

Compensation

Compensation offered for this role is 75,100.00 - 126,325.00 annually and is based on experience and qualifications.

The candidate(s) offered this position will be required to submit to a background investigation.

Joining our team isn’t just a job — it’s an opportunity. One that takes your skills and pushes them to the next level. One that encourages you to challenge the status quo. One where you can shape the future of protection while supporting causes that mean the most to you. Joining our team means being part of something bigger – a winning team making a meaningful impact.

Allstate generally does not sponsor individuals for employment-based visas for this position.

Effective July 1, 2014, under Indiana House Enrolled Act (HEA) 1242, it is against public policy of the State of Indiana and a discriminatory practice for an employer to discriminate against a prospective employee on the basis of status as a veteran by refusing to employ an applicant on the basis that they are a veteran of the armed forces of the United States, a member of the Indiana National Guard or a member of a reserve component.

For jobs in San Francisco, please click “here” for information regarding the San Francisco Fair Chance Ordinance.

For jobs in Los Angeles, please click “here” for information regarding the Los Angeles Fair Chance Initiative for Hiring Ordinance.

To view the “EEO Know Your Rights” poster click “here”. This poster provides information concerning the laws and procedures for filing complaints of violations of the laws with the Office of Federal Contract Compliance Programs.

To view the FMLA poster, click “here”. This poster summarizing the major provisions of the Family and Medical Leave Act (FMLA) and telling employees how to file a complaint.

It is the Company’s policy to employ the best qualified individuals available for all jobs. Therefore, any discriminatory action taken on account of an employee’s ancestry, age, color, disability, genetic information, gender, gender identity, gender expression, sexual and reproductive health decision, marital status, medical condition, military or veteran status, national origin, race (include traits historically associated with race, including, but not limited to, hair texture and protective hairstyles), religion (including religious dress), sex, or sexual orientation that adversely affects an employee's terms or conditions of employment is prohibited. This policy applies to all aspects of the employment relationship, including, but not limited to, hiring, training, salary administration, promotion, job assignment, benefits, discipline, and separation of employment.

Allstate provides a comprehensive technology setup, including a laptop, monitors, headset, keyboard, and mouse. Employees eligible to work from home also receive a monthly connectivity reimbursement to help offset internet costs.

When working from home, you must have a dedicated, private workspace free from distractions, along with appropriate desk and seating. Reliable internet is required, with minimum speeds of 50 MB download and 5 MB upload.