Prepare for and practice interview questions from Aquent.

Aquent Interview Questions

Aquent Interview Guides

Let’s say that your company is running a standard control and variant AB test on a feature to increase conversion rates on the landing page. The PM checks the results and finds a .04 p-value.

How would you assess the validity of the result?

Experiment Validity

Let’s say we have a table with an <code>id</code> and <code>name</code> fields. The table holds over 100 million rows and we want to sample a random row in the table without throttling the database.

Write a query to randomly sample a row from this table.

Input:

<code>big_table</code> table

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

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

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

Write a query to randomly sample a row from a big table.

Random SQL Sample

Suppose there exists a new airline named Jetco that flies domestically across North America. Jetco recently had a study commissioned that tested the boarding time of every airline, and it came out that Jetco had the fastest average boarding times of any airline.

What factors could have biased this result, and what would you look into?

What could potentially bias the average boarding time in favor of an airline that only flies domestically?

What could potentially bias the average boarding time in favor of an airline that only flies domestically?

Boarding Times Bias

A new airline came out as the fastest average boarding times compared to other airlines.  What factors could have biased this result and what would you look into?

Aquent Salaries by Position

Job Title: Performance Marketing AnalystClient Location: Central London - Hybrid (3 days on-site)Starting: April 2023 Salary/Pay Rate: up to £74.000 per annum, pro rata (PAYE)Hours: Full-timeDuration: 12 months Are you passionate about deciphering data to drive marketing excellence? Do you thrive on optimising digital media channels for maximum lead generation impact? If so, we may have a role for you! We're seeking an experienced Performance Marketing Analyst to join our fintech client's team for 12 months contract, offering up to £74.000 per annum, pro rata (PAYE). Key Responsibilities:<ul><li>Holistic Data Analysis: Dive deep into digital media channel data, providing a comprehensive view of the company's accountant-focused media regularly.</li><li>ROI Measurement: Evaluate the Return on Investment (ROI) of online advertising campaigns and uncover the influence of "Above the Line" media in driving leads to our Sales Team.</li><li>Performance Insights: Collaborate with the Performance Marketing Team to deliver insightful recommendations for optimizing media spend and driving high-quality leads.</li><li>KPI Reporting: Report on marketing and Sales Key Performance Indicators (KPIs), offering a nuanced understanding of performance by campaign and audience type.</li><li>Attribution Modeling: Explore and implement digital attribution models, ensuring accurate, data-driven attribution to our digital channels.</li><li>Dashboard Creation: Build intuitive dashboards to enable a comprehensive understanding of cross-channel demand generation effectiveness, recommending actionable improvements.</li><li>Lead Pipeline Streamlining: Work closely with the Sales Operations team and global partners to streamline our lead pipeline and establish a robust lead scoring model.</li><li>Lead Lifecycle Optimisation: Collaborate with the Sales Team to comprehend drivers behind lead quality and optimise the lead lifecycle management for improved conversion rates.</li><li>Data Integration: Assist in integrating various lead data sources and seamlessly stitching them together across our database systems.</li></ul> Skills and Qualifications: <ul><li>Experience in SQL, and Tableau or Python</li><li>Hands-on experience in marketing analysis, lead scoring, attribution modeling, or similar quantitative insights for enhancing marketing performance.</li><li>Strong understanding of diverse marketing channels, including SEM strategies, PPC, Digital Media campaigns, OOH, and in-person events, as well as the ad tech ecosystem.</li><li>Exceptional stakeholder management skills with the ability to build partnerships and influence effectively.</li><li>Proficient in connecting multiple data sources to unveil meaningful insights and patterns.</li></ul> If you are ready to make a significant impact and shape the future of our client's marketing efforts, apply now! Join us in the exciting journey of optimising our digital presence and driving unparalleled success in lead generation. The next steps will be shared with shortlisted candidates by EOD on Wed 4th Sept 2024. We're looking forward to hearing from you! Client Description:Our Client is a global technology platform that specialises in overcoming the world’s most important financial challenges. Their products and services are driven by artificial intelligence, and their accounting software is one of their most recognisable creations. Considered one of the top companies to work for, they are proud of their company culture and entrepreneurial spirit. Aquent is dedicated to improving inclusivity & is proudly an equal opportunities employer. We encourage applications from under-represented groups & are committed to providing support to applicants with disabilities. We aim to provide reasonable accommodation for any part of the employment process, to those with a medical condition, disability or neurodivergence.

Overview Placement Type: Temporary Salary (USD): $63.00 to $70.00 an hour. Start Date: 09.23.2024 What You'll Do: <ul> <li>Will interpret written requirements and technical specifications for software solutions to business problems.</li> <li>Will develop software based on the technical specifications.</li> <li>Will analyze and investigate problems with software solutions that have been reported by clients and document the results of their investigation(s).</li> <li>Will perform maintenance of software and correct defects that have been identified during the maintenance process.</li> <li>Will run unit tests on software they create, implement test plans, test harnesses and document the test results.</li> <li>Will investigate and suggest solutions to defects and problems with software solutions that have been detected during testing.</li> <li>Must have the ability to work in a fast-paced environment and possess strong written and verbal communication skills.</li> </ul> Skills Required: <ul> <li>6-10 years of experience in a similar capacity</li> <li>At least 6 years' experience developing enterprise class applications using .NET and C#,.</li> <li>Full stack development experience including C#, SQL, Angular, REST Working knowledge of SOLID principles, 12-Factor App, and design patterns</li> <li>At least 3 years of experience working in Agile - Scrum teams</li> <li>Experience or knowledge of Continuous Integration and Continuous Delivery Experience or knowledge of database design and development (SQL and NoSQL)</li> <li>Experience or knowledge with Cloud Foundry, AWS, Azure, or GCP Strong ability to design, code, and debug applications in various software languages</li> </ul> Personal Characteristics: <ul> <li>A commitment to high ethical standards and integrity, demonstrated through action Strong communication skills High-energy, positive, entrepreneurial in spirit Goal-oriented and results-driven</li> <li>Self-starter; takes initiative and can work independently Well-organized and disciplined with high attention to detail Direct, plain-spoken; conveys a genuine and authentic demeanor</li> <li>Possesses a "Can do" attitude and a team player.</li> <li>Significant experience transforming teams through technology, organization, culture, process and business change management</li> <li>Ability to work hands on members of an agile project team to inspire and motivate all levels of staff towards both tactical and strategic delivery goals</li> <li>Outstanding performer, persistent and pro-active leader, detailed oriented, and driven to exceed expectations</li> <li>Skilled communicator with exceptional written, verbal, presentation, and facilitation skills</li> </ul> The target hiring compensation range for this role is $63.00 to $70.00 an hour. Compensation is based on several factors including, but not limited to education, relevant work experience, relevant certifications, and location. About Aquent Talent: Aquent Talent connects the best talent in marketing, creative, and design with the world's biggest brands. Our talent get access to amazing benefits like subsidized health, vision, and dental plans, paid sick leave, and retirement plans with a match. We also offer free online training through Aquent Gymnasium . More information on our awesome benefits ! Aquent is an equal opportunity employer. We evaluate qualified applicants without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status, and other legally protected characteristics. We're about creating an inclusive environment-one where different backgrounds, experiences, and perspectives are valued, and everyone can contribute, grow their careers, and thrive. You will want to read this fine print. Part of our mission is to take care of you, so we offer the best benefits. Unlike other staffing companies, we provide talent with the same benefits that our CEO gets. This includes: <ul> <li>A choice of three major medical plans (including vision coverage) plus dental insurance</li> <li>Paid sick leave for all hourly talent in the U.S. and Canada</li> <li>401(k) with a match and immediate vesting</li> <li>Exclusive employee discounts through Promo Code: Aquent</li> <li>Access to hundreds of professional development courses through Aquent Gymnasium</li> </ul> Client Description Are you ready to join a prestigious financial services firm that prioritizes client success and innovation? Our client is a leading provider of investment and wealth management services, known for its commitment to transparency, integrity, and personalized advice. With a focus on empowering clients to achieve their financial goals, our client offers a dynamic and collaborative work environment. Join us in our mission to help individuals and families build a brighter financial future.

Overview Placement Type: Temporary Salary (USD): $59 to $65/hr Start Date: 09.10.2024 Our client has embraced big data technologies to enable data-driven decisions. They are looking to expand their Software & Data Engineering team to keep pace. As a Data Engineer - Consumer, you will work with a variety of talented teammates and be a driving force for building first-class data solutions for Technology and its business partners by building and improving data products for consumer behavior events from our experiences. Join us in our client's mission to bring inspiration and innovation to every athlete in the world! In this role, you will have both the freedom and the responsibility to make a significant impact on our systems. We are looking for someone who is passionate about Dev and Data Ops. You will have an opportunity to improve support processes, increase observability, reduce cost, and improve efficiency. Role Responsibilities: <ul> <li>Build and incorporate automated unit tests and participate in integration testing efforts</li> <li>Troubleshoot data issues and perform root cause analysis</li> <li>Work across teams to resolve operational & performance issues</li> <li>Propose solutions and designs to reduce performance issues and improve efficiency</li> <li>Perform cost analysis across data products</li> </ul>Some combination of these qualifications and technical skills will position you well for this role:<ul> <li>BS degree in Computer Science or related field or experience in lieu of degree</li> <li>Programming experience in Python or Scala, preferred.</li> <li>Experience building domain-driven Microservices</li> <li>Experience with data modeling in different data stores</li> <li>Experience working with Big Data processing frameworks such as Spark, Hive, etc.</li> <li>Experience working with Big Data streaming frameworks such as Nifi, SparkStreaming, Flink, etc.</li> <li>Experience working with Big Data streaming services such as Kinesis, Kafka, etc.</li> <li>Experience with performance and scalability tuning</li> <li>Experience working in a public cloud environment, particularly AWS</li> <li>Familiarity with practices like Continuous Development, Continuous Integration, and Automated Testing</li> <li>Familiarity with Git and version control</li> </ul>These are the characteristics that we strive for in our own work, and we would love to hear from candidates who embody some of them:<ul> <li>Desire to work collaboratively with your teammates to come up with the best solution to a problem</li> <li>Proven experience and ability to deliver results on multiple projects in a fastpaced agile environment</li> <li>Excellent problem-solving and interpersonal communication skills</li> <li>Strong desire to learn and share knowledge with others</li> </ul> Not sure if this is you? We're hiring at all experience levels, and we're particularly interested in having a diverse team with a broad set of skills and viewpoints. If this seems like your dream job, but you're not sure if you qualify, apply anyway! We'll carefully consider every applicant that takes the time to apply for this specific position. We'll either move forward with you, find other teams that are good fits, keep in touch for later opportunities, or thank you for your time. We are an equal opportunity employer and value diversity. We do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status. We will ensure that individuals with disabilities are provided reasonable accommodation to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment. Please contact us to request accommodation. The target hiring compensation range for this role is $59.39 to $65.99 an hour. Compensation is based on several factors including, but not limited to education, relevant work experience, relevant certifications, and location. About Aquent Talent: Aquent Talent connects the best talent in marketing, creative, and design with the world's biggest brands. Our eligible talent get access to amazing benefits like subsidized health, vision, and dental plans, paid sick leave, and retirement plans with a match. We also offer free online training through Aquent Gymnasium . More information on our awesome benefits ! Aquent is an equal-opportunity employer. We evaluate qualified applicants without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status, and other legally protected characteristics. We're about creating an inclusive environment-one where different backgrounds, experiences, and perspectives are valued, and everyone can contribute, grow their careers, and thrive.

Our global Learning and Ed-Tech client is looking for a remote, contract to perm, Paid Media Marketing Analyst to join their team ASAP:
*A background check must be complete/cleared prior to starting this assignment*
Paid Media Marketing Analyst –
We are searching for an exceptional and highly-skilled Paid Media (PPC) Marketing Analyst who is experienced in search & social paid advertising, savvy working with data, and creative in producing clickable/engaging marketing content.
You will actively execute comprehensive PreK-12 search and social PPC campaigns. This opportunity requires a deep in-depth knowledge of paid search and paid social media advertising tactics as well as the ability to coordinate, research, and produce impactful marketing content for deployment across multiple platforms (Google Ads, Facebook, Instagram, YouTube, X, and LinkedIn).
This role will report to the Manager of Social Media + Search PPC Marketing, and as a collaborative team, will be an influential part of the Social Media + Search PPC Marketing team. 
Here is what you will get to do:
<ol>
<li>
Search Ads + Social Ads Campaign Development & Execution
<ul>
<li>
Help lead in the development of search and social media campaigns/projects across functional teams that deliver stated business goals (e.g. Execute search and social media ad campaigns encompassing management, production, posting, and online conversations across multiple social networking platforms). 
</li>
<li>
Actively engage with online communities via social networks, including routing inquiries for customer service, encouragement/support, and conversational engagement to promote corporate messaging and increase brand awareness
</li>
</ul>
</li>
</ol>
<ol start="2">
<li>
Search and Social Ad Analysis and Reporting
<ul>
<li>
Responsible for developing strategies to optimize the effectiveness and efficiencies of campaigns
</li>
<li>
Regularly reporting insights gained from social media monitoring tools, such as HootSuite or TalkWalker
</li>
<li>
Use analytics to guide social media and digital marketing strategy, understanding KPIs for different campaigns to drive better results
</li>
<li>
Budget management: monitor, track, re-forecast, and report on PPC spend 
</li>
</ul>
</li>
</ol>
<ol start="3">
<li>
Digital Marketing Strategy
<ul>
<li>
Contribute ideas to the team and maximize business impact in a fast-paced, collaborative digital environment
</li>
<li>
Execute social media and PPC strategies that will increase brand awareness at the company and product level
</li>
<li>
Collaborate with our PR & Corporate Communications team to help maximize reach, engagement, and impressions
</li>
</ul>
</li>
</ol>
Requirements:
<ul>
<li>
Bachelor’s Degree or equivalent work experience required.
</li>
<li>
3+ years of professional experience with Facebook, Instagram, X, YouTube, LinkedIn, TikTok, and Google Ads with proven results in impacting Key Performance Indicators of an organization. 
</li>
<li>
Knowledge of social media management, advertising, and productivity/analytics tools such as Hootsuite, Sprinklr, Social Studio, Google Ads, Facebook Insights, X(Twitter) Analytics, etc. 
</li>
<li>
Experience with social media design tools such as Photoshop, Canva, etc
</li>
<li>
Deep experience with data reporting & connector tools such as Excel, Supermetrics, etc.
</li>
<li>
Understanding how social media plays a role within a larger marketing team to contribute to a unified vision of campaigns 
</li>
<li>
Ability to build strong relationships with both internal and external stakeholders with excellent interpersonal skills.
</li>
<li>
Strong interest in storytelling, business strategy, and education sector issues 
</li>
</ul>
 Preferred:
<ul>
<li>
Certified in Google Ads and Meta Ads Suite
</li>
<li>
Experience as an educator or an education-focused background (non-profit, teaching, etc.)
</li>
<li>
Professional writing and/or copy-editing 
</li>
</ul>
The target hiring compensation range for this role is $35 – $40 an hour. Compensation is based on several factors including, but not limited to education, relevant work experience, relevant certifications, and location.
About Aquent Talent:
Aquent Talent connects the best talent in marketing, creative, and design with the world’s biggest brands. 
Our eligible talent get access to amazing benefits like subsidized health, vision, and dental plans, paid sick leave, and retirement plans with a match. We also offer free online training through Aquent Gymnasium. More information on our awesome benefits! 

Aquent is an equal-opportunity employer. We evaluate qualified applicants without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status, and other legally protected characteristics. We’re about creating an inclusive environment-one where different backgrounds, experiences, and perspectives are valued, and everyone can contribute, grow their careers, and thrive. 
PDN-9ce2fba2-5ec9-4b4d-9e12-1ed45c21d351

Job Title: Data EngineerClient Location: Denver, CO or Remote; VirtualStarting: 06/24/2024Salary/Pay Rate: $48.90 to $54.33 HourlyDuration: 12 months Job Description:In this role you will be contracted to build and maintain scalable data pipelines on Google Cloud Platform (GCP) to serve our cyber security data mart customers in building an asset inventory. You will work closely with cross-functional teams to ensure data integrity, reliability, and scalability. Your expertise in Google BigQuery, Google Cloud Storage, Cloud Composer, Python, and SQL will be crucial in developing effective data solution that support our security analytics and reporting efforts. What you’re good at• Design, build, and maintain scalable data pipelines using Google Cloud Platform tools such as BigQuery, Cloud Storage, and Cloud Composer.• Develop and optimize SQL queries to support data extraction, transformation, and loading (ETL) processes.• Collaborate with cross-functional teams, including business customers, Subject Matter Experts, to understand data requirements and deliver effective solutions.• Implement best practices for data quality, data governance and data security.• Monitor and troubleshoot data pipeline issues, ensuring high availability and performance.• Contribute to data architecture decisions to provide recommendations for improving the data pipeline.• Stay up to date with emerging trends and technologies in cloud-based data engineering and cyber security.• Exceptional communication skills, including the ability to gather relevant data and information, actively listen, dialogue freely, and verbalize ideas effectively.• Ability to work in an Agile work environment to deliver incremental value to customers by managing and prioritizing tasks.• Proactively lead investigation and resolution efforts when data issues are identified taking ownership to resolve them in a timely manner.• Ability to interoperate and document processes and procedures for producing metrics. Must Have• Bachelor’s or master’s degree in computer science, Information Systems, Engineering, or related field.• 3 - 5 years of hands-on experience with data management in gathering data from multiple sources and consolidating them into a single centralized location. Transforming the data with business logic in a consumable manner for visualization and data analysis.• Strong expertise in Google BigQuery, Google Cloud Storage, Cloud Composer, and related Google Cloud Platform (GCP) services.• Proficiency in Python and SQL for data processing and automation.• Experience with ETL processes and data pipeline design.• Excellent problem-solving skills and attention to detail.• Strong communication and collaboration. Nice to Have• Experience with other GCP Services like Dataflow, Pub/Sub, or Data Studio.• Knowledge of DevOps practices and tools such as Terraform.• Familiarity with data visualization tools such as Tableau, Grafana, and/or Looker.• Understanding Cyber Security data tools and analysis methodologies.• One or more of the following certifications preferred: CompTIA Sec+, CISM, CISSP, CRISC and / or CISA.• Understanding of security control frameworks such as NIST, CIS controls, COBIT, ISO etc. The target hiring compensation range for this role is the equivalent of $48.90 to $54.33 an hour. Compensation is based on several factors including, but not limited to education, relevant work experience, relevant certifications, and location.Additional benefits offered may include; medical health insurance and dental insurance, life insurance, and eligibility to participate in 401k plan with company match.

This is a remote role with the client based out of Redmond, WA.Pay Range: $43/hr to $47/hr Our client is looking for a Software Database Engineer who will be responsible for defining system information requirements and designing solutions for enterprise-wide or large-scale information systems. The role involves working with complex data formats, ETL processes, and ensuring systems meet cross-functional requirements and integration standards. Job Responsibilities:<ul><li>Design and architect software, hardware, and communications systems to support comprehensive requirements, ensuring scalability for future needs.</li><li>Ensure systems are compatible with agency IT standards and compliant with platform-specific solutions, including integration with other systems and external interfaces.</li><li>Maintain a compliant common operating environment, systematically evaluating and resolving workflow, organizational, and planning issues.</li><li>Provide daily supervision and direction to staff, ensuring successful project execution.</li></ul> Qualifications:<ul><li>Bachelor's degree in Computer Science, Computer Engineering, or a related technical field is required; an MBA or other advanced degree is preferred.</li><li>1-3 years of experience with ETL processes, particularly with large data formats and complex data systems.</li><li>Proficiency with Kusto, SQL, Azure Data Factory, and API integration.</li><li>Experience in broad technology delivery, including custom software development using various programming languages.</li><li>Proven ability to provide technical leadership, mentor team members, and present technical options and recommendations to stakeholders.</li><li>Experience in driving technical planning and solutions, including developing software designs, managing vendor evaluations, and justifying technical recommendations.</li><li>Strong analytical skills and the ability to systematically resolve technical and organizational challenges.</li></ul> The target hiring compensation range for this role is $43/hr to $47/hr. Compensation is based on several factors including, but not limited to education, relevant work experience, relevant certifications, and location. Additional benefits offered may include: <a>https://aquent.com/talent/talent-benefits</a> About Aquent Talent: Aquent Talent connects the best talent in marketing, creative, and design with the world's biggest brands. Our talent get access to amazing benefits like subsidized health, vision, and dental plans, paid sick leave, and retirement plans with a match. We also offer free online training through <a>Aquent Gymnasium</a>. More information on our awesome <a>benefits</a>! Aquent is an equal opportunity employer. We evaluate qualified applicants without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status, and other legally protected characteristics. We're about creating an inclusive environment—one where different backgrounds, experiences, and perspectives are valued, and everyone can contribute, grow their careers, and thrive. You will want to read this fine print. Part of our mission is to take care of you, so we offer the best benefits. Unlike other staffing companies, we provide talent with the same benefits that our CEO gets. This includes:<ul><li>A choice of three major medical plans (including vision coverage) plus dental insurance</li><li>Paid sick leave for all hourly talent in the U.S. and Canada</li><li>401(k) with a match and immediate vesting</li><li>Exclusive employee discounts through Promo Code: Aquent</li><li>Access to hundreds of professional development courses through Aquent Gymnasium</li><li>And much more</li></ul>

Overview Placement Type: Temporary Salary (USD): $45 - $50 per hour Start Date: 09.17.2024 We are looking for for an experienced Marketing Data Analyst to join our clients Marketing Automation team. The Marketing Automation team is a collaborative and dedicated team with a passion for ensuring that their external customers receive timely and accurate communications. They also partner with internal customers throughout the organization in sending hundreds of millions of communications a year, leveraging data to develop segmented, dynamic, and personalized communications to provide a tailored communication journey for their audiences. About the Opportunity You will be a member of a cross-functional digital campaign team, tasked with accurately provisioning for the purpose of outbound digital communications including email and SMS campaigns. Working remotely, you will also plan, analyze, develop, test, deliver and complete quality assurance of data you and other team members provision to support these external communications. In this role, you will: Business Analysis and Data Strategy (10%) <ul> <li>Develop a deep understanding of the enterprise and marketing data landscape.</li> <li>Consult periodically with internal customers on how best to use actionable data in marketing and operational email communications.</li> </ul>Data Provisioning (60%)<ul> <li>Fulfill data requests from internal customers using a sound understanding of College Board data, data policies and governance.</li> <li>Create complex data extensions and automation activities using SQL.</li> <li>Partner with Digital Production staff to customize data output as required for use in personalization, dynamic content, and reporting.</li> <li>Provide customer support on an as needed basis by investigating and addressing escalated incidents with data quality.</li> <li>Understand Salesforce Marketing Cloud (SFMC) data models, data extensions, and the core system data structure to successfully deliver segmented and tailored messaging to meet business needs.</li> <li>Facilitate and participate in detailed data analysis necessary to measure, identify and track the quality of data in an ongoing manner.</li> <li>Complete quality assurance of SQL code and data output to ensure business requirements and specs have been met.</li> </ul>Process and Project Management (20%)<ul> <li>Work closely with internal customers to ensure data requirements are clear and actionable.</li> <li>Ensure SLAs are met. Manage and escalate issues that arise through the data provisioning process.</li> <li>Leverage JIRA for collaboration and managing work.</li> </ul>Documentation (10%)<ul> <li>Contribute to team resources by documenting common queries and unique processes that can be leveraged by other data analysts on the team.</li> </ul>Qualifications:<ul> <li>A Bachelor's degree, with additional post graduate degree, MS, or MBS preferred.</li> <li>Experience with standard business and project management processes.</li> <li>3-6 years experience in managing and executing data management initiatives, including data management, warehousing, provisioning, and business intelligence.</li> <li>Advanced knowledge of SQL, with expertise in SQL standards and best practices.</li> <li>Practical knowledge of DBMS, ETL tools, reporting and analysis tools, and data mining tools.</li> <li>Experience in multiple areas of data standards, data management, data warehousing and business intelligence is essential.</li> <li>Demonstrated ability to complete projects on time and on budget.</li> <li>Strong analytical and data analysis experience with structured problem-solving ability.</li> <li>Knowledge of Salesforse Marketing Cloud</li> <li>Experience with project management tools like Jira, Asana, etc.</li> <li>Experience with AWS, Postgres Database, DynamoDB or similar cloud technology.</li> <li>Experience in business process analysis, design, and documentation.</li> </ul> The target hiring compensation range for this role is $45 to $50 an hour. Compensation is based on several factors including, but not limited to education, relevant work experience, relevant certifications, and location. About Aquent Talent: Aquent Talent connects the best talent in marketing, creative, and design with the world's biggest brands. Our eligible talent get access to amazing benefits like subsidized health, vision, and dental plans, paid sick leave, and retirement plans with a match. We also offer free online training through Aquent Gymnasium . More information on our awesome benefits ! Aquent is an equal-opportunity employer. We evaluate qualified applicants without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status, and other legally protected characteristics. We're about creating an inclusive environment-one where different backgrounds, experiences, and perspectives are valued, and everyone can contribute, grow their careers, and thrive.

W2 Only. NO C2C Job Title: Mid-level Data ScientistClient Location: Vienna, VA (Hybrid Onsite)Starting: 09/09/2024 Salary/Pay Rate: $87 to $96/hrFirm, non-negotiable: NoHours: Full-timeDuration: 3 months Job Description:This job involves using machine learning, programming, data modeling, and advanced mathematics to provide analytical insights and identify opportunities within the organization. Responsibilities include designing and evaluating predictive models, analyzing data, and coding basic algorithms, while working under close supervision. Candidates should have 2-3 years of experience in data analysis, proficiency in programming languages and tools like SQL, R, and Python, and a relevant Bachelor's degree; a Master’s degree is preferred. Provide analytical insights by extracting data through machine learning, programming, data modeling, and advanced mathematics to recognize complex patterns and identify opportunities to drive impact across the organization. Developing an understanding of business needs and objectives through the use of basic descriptive, predictive, and prescriptive models. Perform routine assignments with increasing scope and complexity. Work under close supervision with some latitude for problem solving within existing data platforms and tools. Developing professional with basic skill set and proficiency. Responsibilities:• Design, develop, and evaluate basic/routine predictive models and algorithms with some complexity• Analyze and interpret results with some complexity• Limited judgment and discretion within defined procedures and practices• Develop and code basic software programs, algorithms, and automated processes• Use modeling and trend analysis to analyze data• Collaborate with team members and participate in team projects and initiatives• Utilize effective written and verbal communication to document and present findings Qualifications:• 2-3 years of experience in exploratory data analysis• Statistics• Programming, data modeling, simulation, and mathematics• SQL, R, Python, Hadoop, SAS, SPSS, Scala, AWS• Model lifecycle execution• Technical writing• Data storytelling and technical presentation skills• Research Skills• Interpersonal Skills• Model Development• Communication• Critical Thinking• Collaborate and Build Relationships• Initiative with sound judgement• Technical (Big Data Analysis, Coding, Project Management, Technical Writing, etc.)• Problem Solving (Responds as problems and issues are identified)• Bachelor's Degree in Data Science, Statistics, Mathematics, Computers Science, Engineering, or degrees in similar quantitative fields• Desired : Master's Degree in Data Science, Statistics, Mathematics, Computer Science, or Engineering The target hiring compensation range for this role is $87 to $96 an hour. Compensation is based on several factors including, but not limited to education, relevant work experience, relevant certifications, and location. About Aquent Talent:Aquent Talent connects the best talent in marketing, creative, and design with the world's biggest brands.Our eligible talent get access to amazing benefits like subsidized health, vision, and dental plans, paid sick leave, and retirement plans with a match. We also offer free online training through <a>Aquent Gymnasium</a>. More information on our awesome <a>benefits</a>! Aquent is an equal-opportunity employer. We evaluate qualified applicants without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status, and other legally protected characteristics. We're about creating an inclusive environment—one where different backgrounds, experiences, and perspectives are valued, and everyone can contribute, grow their careers, and thrive.

Large athletic brand retailer looking for a Sr. Data AnalystThis position is on site in Portland.No C2C accepted. Analyzes complex business problems and issues using data from internal and external sources to provide insight to decision-makers. Identifies and interprets trends and patterns in datasets to locate influences. Constructs forecasts, recommendations and strategic/tactical plans based on business data and market knowledge. Creates specifications for reports and analysis based on business needs and required or available data elements. May provide consultation to users and lead cross- functional teams to address business issues. May directly produce datasets and reports for analysis using system reporting tools. Requires a Bachelors Degree and minimum of 8 or 9 years directly relevant work experience Lead to the accomplishment of key goals across consumer and commercial analytics functions. Work with key stakeholders to understand requirements, develop sustainable data solutions, and provide insights and recommendations. Document and communicate systems and analytics changes to the business, translating complex functionality into business relevant language. Validate key performance indicators and build queries to quantitatively measure business performance. Communicate with cross-functional teams to understand the business cause of data anomalies and outliers. Develop data governance standards from data ingestion to product dictionaries and documentation. Develop SQL queries and data visualizations to fulfill ad-hoc analysis requests and ongoing reporting needs leveraging standard query syntax. Organize and transform information into comprehensible structures. Use data to predict trends and perform statistical analysis. Use data mining to extract information from data sets and identify correlations and patterns. Monitor data quality and remove corrupt data. Evaluate and utilize new technologies, tools, and frameworks centered around high-volume data processing. Improve existing processes through automation and efficient workflows. Build and deliver scalable data and analytics solutions. Work independently and take initiative to identify, explore and solve problems. Design and build innovative data and analytics solutions to support key decisionsSupport standard methodologies in reporting and analysis, such as, data integrity, unit testing, data quality control, system integration testing, modeling, validation, and documentation. Independently support end-to-end analysis to advise product strategy, data architecture and reporting decisions.

This is a REMOTE with the client based out of Redmond, WAPay Range: $64/hr to $71/hr Our client is looking for a Data Scientist that will be responsible to design, build, and maintain our client's game Analytics Environment. You will focus on delivering solutions rather than technology to realize the value of our data assets. You will support initiatives to democratize data and unlock self-serve capabilities which empower new data consumers to efficiently leverage the data. Job Responsibilities:<ul><li>Collaborate with data consumers and stakeholders to understand their data needs.</li><li>Identify and analyze multi-structured data from a variety of sources to select the most effective and accurate data which fulfills the analytics requirements.</li><li>Design data models, architect dataflows, and create technical requirements to deliver solutions.</li><li>Build and maintain automated data pipelines to source and transform data into clean, enriched, and optimized polyglot data models which can evolve with changing needs.</li><li>Use modern data engineering practices and frameworks to create scalable big data solutions for analytics and machine learning, while ensuring data quality.</li><li>Write and maintain technical documentation for the data models and analytics solutions.</li><li>Assist Users with data access tools and documentation to unlock the value of the analytics data.</li><li>Provide stewardship in the creation, collection, maintenance, and documentation of metadata.</li><li>Handle confidential information responsibly and correctly apply security and privacy policies.</li></ul> Qualifications:<ul><li>3+ years working as a data engineer or equivalent on large enterprise systems.</li><li>Critical thinker and problem solver who brings a creative and open mindset to each situation.</li><li>A proven track record building and optimizing big data pipelines for analytic solutions.</li><li>Data analysis skills to identify, select and prepare quality data for analytics use cases.</li><li>Experience building enterprise scale data pipelines on Cloud Data Platforms using Spark and Databricks for ETL/ELT, data products, or Machine Learning; Azure preferred.</li><li>API and application development experience for data access and analytics solutions.</li><li>Strong Python skills for data processing combined with a pythonic mindset. Proficient SQL.</li><li>Working knowledge handling logs or event streaming data sources.</li><li>Working knowledge of DevOps and DataOps including feature planning, version control, multi-environment, CI/CD, data-modeling, automation, governance, and continuous improvement.</li><li>Video game domain knowledge is important – as an experienced Player or industry veteran</li></ul> The target hiring compensation range for this role is $64/hr to $71/hr. Compensation is based on several factors including, but not limited to education, relevant work experience, relevant certifications, and location. Additional benefits offered may include: <a>https://aquent.com/talent/talent-benefits</a> About Aquent Talent: Aquent Talent connects the best talent in marketing, creative, and design with the world's biggest brands. Our talent get access to amazing benefits like subsidized health, vision, and dental plans, paid sick leave, and retirement plans with a match. We also offer free online training through <a>Aquent Gymnasium</a>. More information on our awesome <a>benefits</a>! Aquent is an equal opportunity employer. We evaluate qualified applicants without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status, and other legally protected characteristics. We're about creating an inclusive environment—one where different backgrounds, experiences, and perspectives are valued, and everyone can contribute, grow their careers, and thrive. You will want to read this fine print. Part of our mission is to take care of you, so we offer the best benefits. Unlike other staffing companies, we provide talent with the same benefits that our CEO gets. This includes:<ul><li>A choice of three major medical plans (including vision coverage) plus dental insurance</li><li>Paid sick leave for all hourly talent in the U.S. and Canada</li><li>401(k) with a match and immediate vesting</li><li>Exclusive employee discounts through Promo Code: Aquent</li><li>Access to hundreds of professional development courses through Aquent Gymnasium</li><li>And much more</li></ul> Client Description:Our client is a large technology company based in Redmond, Washington with a mission to empower every person and every organization on the planet to achieve more. They develop computer software, consumer electronics, personal computers, and related services. This company enables digital transformation for the era of an intelligent cloud and an intelligent edge.Working here, you will be part of a company that values:<ul><li>Innovation</li><li>Diversity and inclusion</li><li>Corporate social responsibility</li><li>AI</li><li>Trustworthy computing</li></ul>Why work with AQUENT? Check out our awesome benefits: <a>https://aquent.com/talent/talent-benefits</a>Aquent is an equal opportunity employer. We evaluate qualified applicants without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status, and other legally protected characteristics.

Aquent Interview Questions

Aquent Interview Guides

Aquent Interview Questions

Aquent Salaries by Position

Aquent Opening Jobs