Business Analyst Sql R Python Jobs in New York (NOW HIRING)

Company Description

Mars United Commerce is a global commerce marketing practice that aligns people, technology, and intelligence to make the business of our clients better today than it was yesterday. Our worldwide capabilities coalesce into four key disciplines - Strategy & Analytics, Content & Experiences, Digital Commerce, and Retail Consultancy - that individually deliver unmatched results for clients and collectively give them an unparalleled network of seamlessly integrated functions across the entire commerce marketing ecosystem. These disciplines are powered by our industry-leading technology platform, Marilyn, which helps marketers understand the total business impact of their commerce marketing activation, enabling them to make better decisions, create connected experiences, and drive stronger, measurable results. Learn more at https://www.marsunited.com/.

Job Description

We're seeking a Business Analyst. Part of the overall Analytics Group, the Business Analytics team is responsible for performing descriptive and prescriptive analytics, client reporting and relationships, as well as cross-functional integration.  They analyze a variety of different data to derive insights, identify trends and patterns from model outputs, and provide actionable recommendations. Additionally, they answer client questions and ensure the insights align with business objectives, write and approve proposals and findings, oversee all Analytic deliverables, and help drive the growth of the department. Candidates must reside within a commutable distance of our Detroit (Troy), New York or Chicago office for a hybrid work schedule. 

• Core Responsibilities: Marketing Science, Ad-hoc Reporting, A/B Testing, Insights & Recommendations, Trend & Seasonality Analysis, Post Campaign Analysis, Advanced Analytics, etc.

• Primary Tools: Google Suite, Azure Synapse, PowerBI, Nielsen, Circana, Numerator

PRIMARY RESPONSIBILITIES:

The Business Analyst is responsible for analyzing business processes, synthesizing data, and providing actionable insights to support business decisions. This role requires strong analytical skills, attention to detail, and the ability to communicate complex findings clearly and concisely. Specifically, the Business Analyst will:

 

• Partner with Analytics Engineering, Data Science, Strategic Planning, and other functions in the business. 

• Contribute to the development of the Analytics capability for the business.

• Work closely with cross-functional agency and client teams to define analytic needs and recommend methodologies, with the ability to execute independently.

• Collaborate with internal partners to improve workflows and data quality within defined areas.

• Implement a data visualization process to aid in the data quality checking process.

• Synthesize data from a variety of sources, including Circana, Nielsen, Numerator, media vendors, customer-specific POS, shopper loyalty databases, consumer survey research, and category management tools, to identify and prioritize business-building opportunities.

• Assist in the creation of, and own the creation of, client-ready reports with a focus on visual storytelling.

• Conduct business process analysis and identify areas for improvement.

• Develop business requirements and specifications for new systems and processes.

• Facilitate communication between business stakeholders and technical teams to ensure alignment on project goals.

• Support wider agency initiatives.

• Show up - be accountable, take responsibility, and get back up when you are down.

• Make stuff.

• Share so others can see what's happening.

SKILLSETS REQUIRED:

• A Bachelor's degree in Business Administration, Data Analytics, Computer Science, or a directly related field.

• Minimum of 1-5 years of experience working with data; experience in consumer marketing, retail, and CPG industries is a plus.

• Passion for data and analytics and the value of data-driven decision-making.

• Ability to tell a visual story that leads to results and decision-making.

• Detail-oriented with the ability to handle multiple clients and projects simultaneously.

• Ability to work proactively and efficiently with a very high level of quality.

• Team player with strong relationship-building, communication, and presentation skills.

• Knowledge of digital and/or marketing analytics is preferred but not required.

• Experience working with IRI or Nielsen data is preferred.

• Strong Microsoft Office Suite (Word, Excel, and PowerPoint) skills.

• Experience with Tableau, Power BI, or any similar data visualization tools is a plus.

• Experience in Python and R is a plus.

• Basic proficiency in SQL is a must. 

• Strong analytical thinking and problem-solving skills.

• Ability to develop business requirements and translate them into technical specifications.

Additional Information

The Power of One starts with our people! To do powerful things, we offer powerful resources.

Our best-in-class wellness and benefits offerings include:Paid Family Care for parents and caregivers for 12 weeks or moreMonetary assistance and support for Adoption, Surrogacy and FertilityMonetary assistance and support for pet adoptionEmployee Assistance Programs and Health/Wellness/Comfort reimbursements to help you invest in your future and work/life balanceTuition AssistancePaid time off that includes Flexible Time off Vacation, Annual Sick Days, Volunteer Days, Holiday and Identity days, and moreMatching Gifts programsFlexible working arrangements'Work Your World' Program encouraging employees to work from anywhere Publicis Groupe has an office for up to 6 weeks a year (based upon eligibility)Business Resource Groups that support multiple affinities and alliances

The benefits offerings listed are available to eligible U.S. Based employees, are reviewed on an annual basis, and are governed by the terms of the applicable plan documents.

We also offer medical and voluntary benefits to our freelancers and temporary employees. Voluntary benefit options include supplemental medical insurance, transportation, and parking benefits, legal benefits, pet insurance, and auto and home insurance.

You must be actively employed for 90 consecutive calendar days in order to be eligible for Publicis medical and voluntary benefits. You will also be eligible to participate in the Publicis 401(k) Plan after you complete 1,000 work hours in a consecutive 12-month period.

Mars United Commerce is an Equal Opportunity Employer. Our employment decisions are made without regard to actual or perceived race, color, ethnicity, religion, creed, sex, sexual orientation, gender, gender identity, gender expression, pregnancy, childbirth and related medical conditions, national origin, ancestry, citizenship status, age, disability, medical condition as defined by applicable state law, genetic information, marital status, military service and veteran status, or any other characteristic protected by applicable federal, state or local laws and ordinances.

If you require accommodation or assistance with the application or onboarding process specifically, please contact USMSTACompliance@publicis.com.

All your information will be kept confidential according to EEO guidelines.

 Compensation Range: USD $55,765.00 - USD $85,878.00/Annually. This is the pay range the Company believes it will pay for this position at the time of this posting. Consistent with applicable law, compensation will be determined based on the skills, qualifications, and experience of the applicant along with the requirements of the position, and the Company reserves the right to modify this pay range at any time. Temporary roles may be eligible to participate in our freelancer/temporary employee medical plan through a third-party benefits administration system once certain criteria have been met. Temporary roles may also qualify for participation in our 401(k) plan after eligibility criteria have been met. For regular roles, the Company will offer medical coverage, dental, vision, disability, 401k, and paid time off. The Company anticipates the application deadline for this job posting will be 7/18/2026.Employment Type: FULL_TIME