The Zllius Data Analyst interview guide, interview questions, salary data, and interview experiences.

Zllius Data Analyst Interview Guide

Getting ready for an Data Analyst interview at Zllius? The Zllius Data Analyst interview span across 10 to 12 different question topics. In preparing for the interview:
<ul>
<li>Know what skills are necessary for Zllius Data Analyst roles.</li>
<li>Gain insights into the Data Analyst interview process at Zllius.</li>
<li>Practice real Zllius Data Analyst interview questions.</li>
</ul>
Interview Query regularly analyzes interview experience data, and we've used that data to produce this guide, with sample interview questions and an overview of the Zllius Data Analyst interview.


Getting ready for an Data Analyst interview at Zllius? The Zllius Data Analyst interview span across 10 to 12 different question topics. In preparing for the interview:

- Know what skills are necessary for Zllius Data Analyst roles.
- Gain insights into the Data Analyst interview process at Zllius.
- Practice real Zllius Data Analyst interview questions.

Interview Query regularly analyzes interview experience data, and we've used that data to produce this guide, with sample interview questions and an overview of the Zllius Data Analyst interview.
        

Overview

What Zllius Looks for in a Data Analyst

We've gathered this data from parsing thousands of interview experiences sourced from members.

We've gathered this data from parsing thousands of interview experiences sourced from members.

Zllius Data Analyst Interview Process

Interview Tips

Let’s say your team at Spotify wants to determine if a recently launched feature, curated playlists, has increased user engagement. However Spotify launched the feature without an A/B test.

How would you measure the effect of curated playlists on user engagement?

How would you establish causal inference to measure the effect of curated playlists on engagement without A/B?

Causal Inference Without A/B

A/B Testing & Experimentation

Let’s say we’ve just delivered a product recommendation algorithm to a retail client, and it’s performing well on their current data.

How would you make sure this algorithm remains reliable and effective as the client’s customer preferences and product catalog evolve over the next year?

How would you ensure a delivered recommendation algorithm stays reliable as business data and preferences change?

Algorithm Reliability

ML Ops & Training Pipelines

As part of the financial management in a large corporation, the CFO wants to review the expenses in all departments for the previous financial year (2022).

Write a SQL query to calculate the total expenditure for each department in 2022. Additionally, for comparison purposes, return the average expense across all departments in 2022.

Note: The output should include the department name, the total expense, and the average expense (rounded to 2 decimal places). The data should be sorted in descending order by total expenditure.

<h3>Example:</h3>

Input:

<code>departments</code> table

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td>id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>name</td>
<td>VARCHAR</td>
</tr>
</tbody>
</table>
<code>expenses</code> table

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td>id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>department_id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>amount</td>
<td>FLOAT</td>
</tr>

<tr>
<td>date</td>
<td>DATE</td>
</tr>
</tbody>
</table>
Output:

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td>department_name</td>
<td>VARCHAR</td>
</tr>

<tr>
<td>total_expense</td>
<td>FLOAT</td>
</tr>

<tr>
<td>average_expense</td>
<td>FLOAT</td>
</tr>
</tbody>
</table>

Calculate total and average expenses for each department.

Department Expenses

Zllius Data Analyst Interview Questions

<h3>Job Description</h3><div>Job Description<div>We are seeking Junior Business & Data Analyst's with 6 months to 1 year of experience to become an integral part of our team! You will analyze data to understand business and market trends in order to increase company revenue and efficiency.Multiple job openings, Nationwide. Must be willing to relocate .Candidates must be located in USA.Responsibilities:<ul><li>Use data to understand business patterns and trends</li><li>Analyze internal and external data through quantitative research</li><li>Communicate findings to company through standard and ad hoc reports</li><li>Promote best practices in data analysis and reporting</li><li>Collaborate with cross-functional teams</li></ul>Qualifications:<ul><li>Bachelor's degree</li><li>Knowledge of SQL,statistical tools and business reporting</li><li>Strong problem solving and critical thinking skills</li><li>Strong attention to detail & Good communication</li><li>Ability to prioritize and multitask</li></ul> "Asta CRS, Inc. is an Equal Opportunity Employer M/F/V/D." ASTA CRS is proud to state that we are enrolled with the USCIS for the E-Verification Program .</div>Company Description<div>ASTA Corporate Resource Solutions Inc is one of the Fastest Growing IT Companies in Northern America and the DC Metro Area with its headquarters in Ashburn, Virginia. ASTA CRS is an Information Technology Provider delivering superior quality software development, consulting, and staffing solutions to our client partners. We are 19 Years in this Industry. ASTA CRS services are uniquely positioned to support clients in achieving profound efficiencies and relentlessly delivering results. ASTA CRS is a long-time and trusted resource for its clients and partners. Asta CRS, Inc. is an Equal Opportunity Employer M/F/V/D. ASTA CRS is proud to state that we are enrolled with the USCIS for the E-Verification Program.</div></div><h3>Company Description</h3><div>ASTA Corporate Resource Solutions Inc is one of the Fastest Growing IT Companies in Northern America and the DC Metro Area with its headquarters in Ashburn, Virginia. ASTA CRS is an Information Technology Provider delivering superior quality software development, consulting, and staffing solutions to our client partners. We are 19 Years in this Industry. \r\n\r\nASTA CRS services are uniquely positioned to support clients in achieving profound efficiencies and relentlessly delivering results. ASTA CRS is a long-time and trusted resource for its clients and partners.\r\n\r\nAsta CRS, Inc. is an Equal Opportunity Employer M/F/V/D. ASTA CRS is proud to state that we are enrolled with the USCIS for the E-Verification Program.</div>

Per consolidata azienda operante nel settore farmaceutico, stiamo cercando un Data Analyst.& Reporting Specialist. La persona, nell’ambito della struttura IT, svolgerà indicativamente le seguenti attività:<ul><li>Gestione e analisi dei dati aziendali.</li><li>Operazioni su database per aggiornamenti e modifiche.</li><li>Supporto agli utenti per problematiche di accesso e utilizzo dei dati.</li><li>Predisposizione di reportistica con Excel</li></ul> Requisiti richiesti:<ul><li>Ottima padronanza operativa di Excel.</li><li>Buona conoscenza di Access e del pacchetto MS Office.</li><li>Familiarità con database relazionali e linguaggio SQL.</li><li>Spiccate capacità analitiche</li></ul> Requisiti opzionali:<ul><li>Esperienza maturata nell'analisi dei dati</li><li>Capacità di scrittura di query SQL</li></ul> Completano il profilo curiosità, buone doti comunicative e relazionali, attitudine al problem solving e predisposizione al team working. Sede di lavoro: Roma L'azienda offre assunzione a tempo indeterminato. <a>EgoValeo</a> è la prima società di head hunting specializzata unicamente in profili Information Technology e Engineering. EgoValeo s.r.l. è una società che offre servizi di ricerca e selezione del personale – Aut. Min. n.39/0014503 – iscritta all’Albo delle Agenzie per il Lavoro. L’offerta è rivolta a tutte le persone, nel rispetto del D.Lgs. 198/2006, 215/2003 e 216/2003.I dati saranno trattati ai sensi del Reg. UE 2016/679. Informativa su <a>https://it.egovaleo.com/ats-ev/informativa-privacy.aspx</a>.

About Position: We are seeking a seasoned data professional with over 10 years of experience in data analysis and data warehousing. The ideal candidate will be responsible for analyzing large datasets to uncover actionable insights, collaborating with cross-functional teams, and ensuring data integrity across the pipeline. This role demands strong SQL skills, proficiency in ETL tools, and familiarity with cloud data ecosystems and orchestration tools. <ul><li>Role: Data Analyst</li><li>Location: All Persistent Locations</li><li>Experience: 10+ years</li><li>Job Type: Full Time Employment</li></ul> What You'll Do: <ul><li>Analyze large datasets to identify trends, patterns, and insights that support business decision-making.</li><li>Collaborate with data engineers, business analysts, and stakeholders to understand data needs and deliver solutions.</li><li>Ensure data integrity, accuracy, and consistency throughout the data pipeline</li><li>Optimize SQL queries and data models for performance and scalability.</li><li>Document data definitions, processes, and workflows for transparency and knowledge sharing.</li><li>Support data governance and compliance initiatives.</li></ul> Expertise You'll Bring: <ul><li>10+ years of experience in data analysis and data warehousing.</li><li>Excellent analytical, profiling, problem-solving, and communication skill</li><li>Strong proficiency in SQL and experience with data warehouse platforms (e.g., Teradata, Snowflake,)</li><li>Good Knowledge in all Business analyst processes</li><li>Hands-on experience with ETL tools (e.g., DataStage, INFORMATICA, Talend etc.).</li><li>Familiarity with cloud data ecosystems (AWS, Azure, GCP).</li><li>Familiarity with the Orchestration or Scheduling tools (Airflow)</li></ul> Benefits: <ul><li>Competitive salary and benefits package</li><li>Culture focused on talent development with quarterly promotion cycles and company-sponsored higher education and certifications</li><li>Opportunity to work with cutting-edge technologies</li><li>Employee engagement initiatives such as project parties, flexible work hours, and Long Service awards</li><li>Annual health check-ups</li><li>Insurance coverage: group term life, personal accident, and Mediclaim hospitalization for self, spouse, two children, and parents</li></ul> Values-Driven, People-Centric & Inclusive Work Environment: Persistent Ltd. is dedicated to fostering diversity and inclusion in the workplace. We invite applications from all qualified individuals, including those with disabilities, and regardless of gender or gender preference. We welcome diverse candidates from all backgrounds. <ul><li>We support hybrid work and flexible hours to fit diverse lifestyles.</li><li>Our office is accessibility-friendly, with ergonomic setups and assistive technologies to support employees with physical disabilities.</li><li>If you are a person with disabilities and have specific requirements, please inform us during the application process or at any time during your employment</li></ul> Let’s unleash your full potential at Persistent - <a>persistent.com/careers</a> “Persistent is an Equal Opportunity Employer and prohibits discrimination and harassment of any kind.”

At Zelis, we Get Stuff Done. So, let's get to it!A Little About UsZelis is modernizing the healthcare financial experience across payers, providers, and healthcare consumers. We serve more than 750 payers, including the top five national health plans, regional health plans, TPAs and millions of healthcare providers and consumers across our platform of solutions. Zelis sees across the system to identify, optimize, and solve problems holistically with technology built by healthcare experts - driving real, measurable results for clients.A Little About YouYou bring a unique blend of personality and professional expertise to your work, inspiring others with your passion and dedication. Your career is a testament to your diverse experiences, community involvement, and the valuable lessons you've learned along the way. You are more than just your resume; you are a reflection of your achievements, the knowledge you've gained, and the personal interests that shape who you are.Position OverviewThe Healthcare Data Analyst will be responsible for analyzing and managing healthcare repricing claim data, with a focus on various pricing methodologies including Medicare, Medicaid, and commercial reimbursements. This role involves leveraging data to ensure accurate and efficient claim processing, offer insights into contract performance, and communicate results to both internal and external stakeholders.What you'll do:* Analyze and interpret healthcare claim data to support/recommend decision-making processes.* Analyze and interact with data in SQL tables.* Utilize Excel for data manipulation, analysis, and reporting.* Understand claim payment methodologies such as Medicare, Medicaid, and Commercial Reimbursement.* Create visualizations and dashboards to present data findings (Tableau experience is a plus).* The ability to multi-task and work on multiple assignments will be required.* This individual must also demonstrate clear and concise communication both verbally and in writing. Including sales, client facing teams and clients* Actively contribute innovative ideas and support ad hoc projects, including time-sensitive requests* Maintains awareness of and ensure adherence to ZELIS standards regarding privacy.* Keep abreast of issues to identify enhancements and process improvement opportunitiesWhat you'll bring to Zelis:* 2+ years of experience in healthcare data analysis.* 1+ years in claim reimbursement methodologies (Medicare, Medicaid, Commercial)* Experience with Tableau is a bonus but not required.* Excellent communication and collaboration abilities.* Consistently demonstrate ability to act and react swiftly to continuous challenges and changes* Excellent follow through, attention to detail, and time management skills* Ability to manage projects simultaneously and achieve goals* Strong initiative, self-directed and self-motivation* Strong organization and project / process management skills* Excellent analytical skills with data and analytics related solutions* Ability to think and act strategically, and as well as execute tactically with bias toward action* Demonstrated leadership ability with cross-functional teams, knows how to get things done both through formal channels and the informal network* Financial modeling and strong analytic skills* Strong excel skills required* Demonstrated ability to evaluate and balance team and individual workloads through effective time management, prioritization, and organizational skills* Creative problem-solving skills, leveraging insights and input from other parts of an organization* Proficient in SQL (Select, Joins, CTE, Sub Queries)* Proficiency other Microsoft Office products - Outlook, Word, Excel, PowerPoint, SharePoint, Teams* Strong analytical skillsPlease note at this time we are unable to proceed with candidates who require visa sponsorship now or in the future.Location and Workplace FlexibilityWe have offices in Atlanta GA, Boston MA, Morristown NJ, Plano TX, St. Louis MO, St. Petersburg FL, and Hyderabad, India. We foster a hybrid and remote friendly culture, and all our employee's work locations are based on the needs of the position and determined by the Leadership team. In-office work and activities, if applicable, vary based on the work and team objectives in accordance with Company policies.Base Salary Range$59,000.00 - $79,000.00At Zelis we are committed to providing fair and equitable compensation packages. The base salary range allows us to make an offer that considers multiple individualized factors, including experience, education, qualifications, as well as job-related and industry-related knowledge and skills, etc. Base pay is just one part of our Total Rewards package, which may also include discretionary bonus plans, commissions, or other incentives depending on the role.Zelis' full-time associates are eligible for a highly competitive benefits package as well, which demonstrates our commitment to our employees' health, well-being, and financial protection. The US-based benefits include a 401k plan with employer match, flexible paid time off, holidays, parental leaves, life and disability insurance, and health benefits including medical, dental, vision, and prescription drug coverage.Equal Employment OpportunityZelis is proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.We welcome applicants from all backgrounds and encourage you to apply even if you don't meet 100% of the qualifications for the role. We believe in the value of diverse perspectives and experiences and are committed to building an inclusive workplace for all.Accessibility SupportWe are dedicated to ensuring our application process is accessible to all candidates. If you are a qualified individual with a disability or a disabled veteran and require a reasonable accommodation with any part of the application and/or interview process, please email TalentAcquisition@zelis.com.DisclaimerWe are an equal opportunity employer, and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, gender identity, national origin, disability status, protected veteran status, or any other characteristic protected by law.The above statements are intended to describe the general nature and level of work being performed by people assigned to this classification. They are not to be construed as an exhaustive list of all responsibilities, duties, and skills required of personnel so classified. All personnel may be required to perform duties outside of their normal responsibilities, duties, and skills from time to time.

Akkodis is seeking a Sr Data Analyst for a Contract job with a client in Mclean VA Ideally looking for applicants with a solid background in the financial services industry . Sr Data Analyst Need Sr data analyst with Project management experience(40% DA & 60% PM) Location: McLean, VA hybrid Rate Range: $78.30/hour to $80/hour on W2 /c2C The rate may be negotiable based on experience, education, geographic location, and other factors. <ul><li>Some project management skills (set up meetings, create agenda, take notes, follow up, report status)</li><li> Communication up to Sr Director level frequently</li><li> Python – google slides/sheets and docs – she needs someone to be able to follow and execute the code and make modifications</li><li> SQL - Snowflake</li><li> AWS (S3)</li><li> Databricks</li><li> Tableau</li><li> Some project management skills (set up meetings, create agenda, take notes, follow up, report status)</li><li> Communication up to Sr Director level frequently</li></ul> If you are interested in this role, then please click APPLY NOW. For other opportunities available at Akkodis, or any questions, feel free to contact me at 3039422431 /soma.chakraborty@akkodisgroup.com.Equal Opportunity Employer/Veterans/DisabledBenefit offerings available for our associates include medical, dental, vision, life insurance, short-term disability, additional voluntary benefits, an EAP program, commuter benefits, and a 401K plan. Our benefit offerings provide employees the flexibility to choose the type of coverage that meets their individual needs. In addition, our associates may be eligible for paid leave including Paid Sick Leave or any other paid leave required by Federal, State, or local law, as well as Holiday pay where applicable. Disclaimer: These benefit offerings do not apply to client-recruited jobs and jobs that are direct hires to a client.To read our Candidate Privacy Information Statement, which explains how we will use your information, please visit <a>https://www.akkodis.com/en/privacy-policy</a>.The Company will consider qualified applicants with arrest and conviction records in accordance with federal, state, and local laws and/or security clearance requirements, including, as applicable:· The California Fair Chance Act· Los Angeles City Fair Chance Ordinance· Los Angeles County Fair Chance Ordinance for Employers· San Francisco Fair Chance Ordinance

Aroma360 is a boutique Scent Marketing and Branding company that specializes in providing the highest-quality essential oil-based scenting solutions to businesses and individuals all around the world. As the only full-service scent company, Aroma360 guides clients from concept and development to strategic implementation while priding themselves on exceptional customer service every step of the way. Aroma360 is continuously raising the bar for healthy scenting solutions in the industry! Position OverviewWe are seeking a Senior Data Analyst with strong technical expertise and sharp business acumen to join our fast-growing Miami-based team. This role is designed for someone who can ramp up quickly and is familiar with our existing data and analytics stack—Google Cloud Platform (GCP), Tableau, and Postgres. This analyst position is broader in scope, requiring cross-functional support across various business verticals—including marketing, operations, and finance. The ideal candidate is not only technically proficient (writing SQL queries, building dashboards) but also capable of engaging with stakeholders to translate business needs into actionable data strategies. Key Responsibilities<ul><li>Retrieve, clean, and organize data from various platforms, including GCP, BigQuery, Postgres, and Shopify, transforming it into curated analytics datasets.</li><li>Analyze performance metrics to identify trends, growth drivers, and areas for optimization across departments such as Marketing, Finance, and Operations.</li><li>Build and maintain interactive Tableau dashboards using advanced data visualization best practices.</li><li>Support multiple business units by delivering custom insights and analyses that inform strategic decisions.</li><li>Partner with cross-functional stakeholders to understand their goals and translate them into scalable analytical solutions.</li><li>Present clear, compelling insights and recommendations to both technical and non-technical audiences.</li><li>Collaborate with the VP of Data Analytics to support strategic initiatives and departmental goals.</li><li>Proactively identify data integrity issues and implement improvements to ensure accuracy and reliability.</li><li>Perform other duties as directed.</li></ul> Qualifications<ul><li>Bachelor’s degree in STEM, Economics, Business Analytics, or a related field.</li><li>4–6 years of experience in business intelligence, analytics, or data engineering roles.</li><li>Proven experience working with GCP (BigQuery), Postgres, Tableau, and SQL. Python is a plus.</li><li>Demonstrated ability to work across multiple business verticals, such as marketing, operations, and finance.</li><li>Strong business acumen—able to connect technical analysis to real-world business outcomes.</li><li>Excellent data cleaning, transformation, and organizational skills.</li><li>Skilled communicator, capable of distilling complex data into clear, actionable insights.</li><li>Self-starter with high attention to detail and the ability to thrive in a fast-paced, high-growth environment.</li></ul> Benefits<ul><li>Comprehensive health coverage, including dental and vision insurance.</li><li>Life insurance for peace of mind.</li><li>Paid time off to recharge.</li><li>401(k) plan for long-term financial security.</li><li>Employee discounts on our premium products and services.</li><li>Paid training and professional development opportunities.</li><li>Fun and engaging company events.</li></ul> Our organization is an equal opportunity employer and does not discriminate against any candidate on the basis of race, color, religion, sex, sexual orientation, gender identity, national origin, veteran or disability status, or any other legally protected characteristics. We are committed to promoting diversity, equity, and inclusion in our workplace and welcome candidates from all backgrounds to apply for any open positions.

At Collective Health, we're transforming how employers and their people engage with their health benefits by seamlessly integrating cutting-edge technology, compassionate service, and world-class user experience design.The Analytics team is a data-driven team focused on unlocking insights that improve member outcomes and drive business performance. Our team sits at the intersection of data, strategy, and execution. The Analytics team reports directly to the Vice President, Data Engineering, Analytics, and AI in Product Development.In this role, you will lead complex data analyses to support clinical, operational, and financial decisions, and play a key role in developing data products that shape strategic direction. You will collaborate across departments, mentor junior analysts, and work directly with business stakeholders. If you're passionate about using data to make a meaningful impact in healthcare, you'll find a home here.What you'll do:* Design, build, and deliver sophisticated analyses on medical cost, utilization, membership, quality, pharmacy, and network performance.* Translate business questions into analytic plans and communicate results in a clear, actionable manner to both technical and non-technical audiences.* Develop and maintain dashboards, reports, and data visualizations using Looker and other BI tools.* Support internal stakeholders (e.g., Product, Clinical, Network, Finance) by generating insights that inform strategy and operational improvements.* Identify opportunities to automate manual reporting and create scalable analytic assets.* Provide quality assurance and peer review of analytic deliverables.* Mentor junior analysts and contribute to the development of analytics standards, documentation, and best practices.To be successful in this role, you'll need:* 8+ years of experience in data analytics, preferably in healthcare, health tech, or a related industry.* Proven ability to work with complex, large-scale datasets-including querying, QA, summarizing, visualizing, and communicating insights.* Strong SQL skills with a track record of writing efficient, scalable queries for analysis and reporting.* Experience with more than one coding language and business insights tooling with Looker.* Demonstrated project management skills, with the ability to prioritize tasks, manage timelines, and drive cross-functional collaboration.* Strong communication skills, with the ability to translate technical findings into clear, actionable recommendations for non-technical stakeholders.* To partner with data engineering to develop and maintain data models that support analytics, reporting, and business intelligence across clinical and insurance domains.* To champion data quality by conducting regular audits, identifying inconsistencies, and supporting governance practices that ensure data integrity.* To collaborate with cross-functional teams-including clinical leaders, product managers, and strategy partners-to surface insights that guide program design and business decisions.* To be self-sufficient, intellectually curious and take ownership for everything you do.Pay Transparency StatementThis is a hybrid position based out of one of our offices: San Francisco, CA, Plano, TX, or Lehi, UT. Hybrid employees are expected to be in the office two days per week.#LI-hybridThe actual pay rate offered within the range will depend on factors including geographic location, qualifications, experience, and internal equity. In addition to the salary, you will be eligible for stock options and benefits like health insurance, 401k, and paid time off. Learn more about our benefits at https://jobs.collectivehealth.com/benefits/.San Francisco, CA Pay Range$134,500-$168,750 USDLehi, UT Pay Range$107,635-$134,000 USDPlano, TX Pay Range$117,500-$147,000 USDWhy Join Us?* Mission-driven culture that values innovation, collaboration, and a commitment to excellence in healthcare* Impactful projects that shape the future of our organization* Opportunities for professional development through internal mobility opportunities, mentorship programs, and courses tailored to your interests* Flexible work arrangements and a supportive work-life balanceWe are an equal opportunity employer and value diversity at our company. We do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status. Collective Health is committed to providing support to candidates who require reasonable accommodation during the interview process. If you need assistance, please contact recruiting-accommodations@collectivehealth.com.Privacy NoticeFor more information about why we need your data and how we use it, please see our privacy policy: https://collectivehealth.com/privacy-policy/.

3x/week onsite in Hoboken, NJContract to Jan 31st plus possible extensions, potential conversion to full time employee Must Haves:<ul><li>3+ years of relevant analytical experience, in media, marketing analytics, or consumer insights (agency, brand, publisher, or research side)</li><li>Background in media reporting types and campaign performance metrics</li><li>Proficiency in SQL for querying large datasets and optimizing data workflows</li><li>Expertise in dashboarding tools like Tableau or Power BI</li><li>Advanced Excel skills</li><li>Strong communication and presentation skills to bridge technical insights with non-technical stakeholders</li><li>Ability to identify insights, deep dive into data, and translate findings into actionable recommendations</li></ul> Plusses:<ul><li>Experience with retail media platforms (e.g., Lowe’s, Best Buy, Amazon, Petco, Meta)</li><li>Python for data manipulation, modeling, and exploratory analysis</li><li>Exposure to social media marketing</li><li>Experience with Google Cloud Platform (GCP) or equivalent cloud environments</li></ul> Job Description:Our top retail client is seeking a Marketing Analyst to join their Media Insights Team, supporting strategic decision-making for their beverage portfolio. This role requires a unique blend of technical expertise and strategic thinking. The ideal candidate will be comfortable working with advanced analytics tools like Python and SQL to build predictive models and uncover consumer behavior trends, while also being able to interpret media performance drivers, attribution results, and translate insights into actionable recommendations for stakeholders. They should be adept at connecting analytical outputs to broader business impact, client use cases, and optimization strategies. Strong communication skills are essential, as this role serves as a bridge between data science and business teams, helping to translate complex data into clear, compelling narratives that inform marketing decisions.<ul><li>Building predictive models and analyzing consumer behavior trends using Python and SQL</li><li>Managing scalable data pipelines and hosting analytical workflows on Google Cloud Platform (GCP)</li><li>Developing Tableau dashboards to automate reporting and visualize key insights</li><li>Evaluating marketing impact by comparing campaign performance and analyzing cross-channel behavior for customers like Pepsi, Red Bull, etc.</li><li>Interpreting attribution results and articulating media performance drivers to stakeholders</li><li>Delivering actionable insights that inform client use cases and guide future campaign optimization</li></ul>

Job Title: Systems AnalystLocation: Smithfield RI Overview:We are looking for a highly motivated Systems Analyst to join one of our agile development squads to provide analytical excellence in building and maintaining data in enterprise database platforms. The data infrastructure is going through significant growth, and this is an opportunity to take a leading role in shaping data capabilities in this area. The work involves gathering requirements, data analysis, solution design, and production rollout activities on data lakes. Key Responsibilities:<ul><li>Gather and document objectives, use cases, requirements, and specifications for database and data projects.</li><li>Perform detailed data analysis to research, document, and model existing and future systems.</li><li>Conduct source-to-target data mappings and support ETL workflows.</li><li>Design and implement dimensional models and star schemas for reporting and analytics.</li><li>Collaborate with product owners, developers, and other squads, actively participating in design discussions.</li><li>Translate technical needs into clear requirements for non-technical stakeholders.</li><li>Work on large-scale database creation, from MDM sources to modeling, and support backend database projects.</li><li>Support production rollout activities for enterprise data platforms.</li></ul> Required Expertise and Skills:<ul><li>8+ years of experience with business-critical, enterprise-wide data applications.</li><li>Expert-level SQL (daily hands-on work in data).</li><li>Strong scripting experience in Python.</li><li>Proven track record with data modeling (dimensional modeling, star schemas).</li><li>Experience with Snowflake and exposure to AWS S3 and Oracle.</li><li>Strong data analysis skills, including the ability to research and document systems.</li><li>Experience with ETL projects.</li><li>Excellent problem-solving, critical thinking, and interpersonal communication skills.</li><li>Ability to thrive in ambiguous, fast-paced environments.</li><li>Strong collaboration skills to work across multiple teams.</li><li>Familiarity with Agile methodologies (Kanban, SCRUM) is a plus.</li></ul>

<h3>Job Description</h3><div>Job Description<div>Job Summary:The ERP Data Analyst is responsible for the administration, optimization, and ongoing improvement of the Enterprise Resource Planning (ERP) system. This role collaborates closely with multiple departments to ensure the ERP system effectively supports business operations. Key responsibilities include resolving technical issues, analyzing data for informed decision-making, and implementing system enhancements that promote data accuracy, security, and accessibility.Essential Duties and Responsibilities:<ul><li>Lead the implementation, management, and routine maintenance of the ERP system to ensure optimal functionality and efficiency.</li><li>Collaborate with cross-functional teams to understand business needs and recommend ERP system improvements.</li><li>Support data analysis and reporting by developing tools and techniques that ensure data accuracy, completeness, and legitimacy.</li><li>Monitor ERP system performance and manage timely updates and upgrades.</li><li>Stay current on emerging technologies and industry trends to identify and implement enhancements that support business performance.</li><li>Provide user training and ongoing support to ensure effective ERP system use.</li><li>Develop and maintain comprehensive documentation for system processes and user training.</li><li>Serve as the primary point of contact between the organization and ERP vendors, facilitating issue resolution and minimizing operational disruptions.</li><li>Conduct routine audits to maintain data integrity and system efficiency.</li><li>Assist Shared Services in managing system security, including user access and protocol adherence.</li></ul><ul><li>Perform other duties as assigned</li></ul>Education and Experience:<ul><li>Bachelor’s degree in Information Technology, Computer Science, or a related field.</li><li>Demonstrated experience with ERP systems (Acumatica experience preferred).</li><li>Project management experience is a plus.</li><li>Proficient in system troubleshooting and documentation.</li></ul> Job Knowledge, Skills and Abilities:<ul><li>Strong analytical and problem-solving skills.</li><li>Strategic thinking with the ability to align system functionality with business goals.</li><li>Excellent interpersonal communication, with collaboration skills.</li><li>High attention to detail and the ability to manage multiple priorities effectively.</li></ul>Supervisory Responsibilities:<ul><li>None</li></ul>Physical Demands:<ul><li>Must be able to sit, stand, and move throughout the facility.</li><li>Occasional lifting required, up to 25 pounds.</li></ul>Personal Protective Equipment:<ul><li>Safety Glasses while in plant environment.</li><li>Safety Shoes at all times</li><li>Hearing protection while in plant environment</li></ul>Work Environment:<ul><li>Combination of office, plant and outdoor settings.</li><li>Exposed to various elements, including extreme heat & cold, while moving between buildings.</li><li>Exposed to loud noise levels while in the plant environment.</li></ul></div></div>

Question	Topic	Difficulty	Ask Chance
Causal Inference Without A/B	A/B Testing & Experimentation	Medium	Very High
Algorithm Reliability	ML Ops & Training Pipelines	Hard	Very High
Department Expenses	SQL	Medium	Very High