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

City Year Data Analyst Interview Guide

Getting ready for an Data Analyst interview at City Year? The City Year Data Analyst interview span across 10 to 12 different question topics. In preparing for the interview:
<ul>
<li>Know what skills are necessary for City Year Data Analyst roles.</li>
<li>Gain insights into the Data Analyst interview process at City Year.</li>
<li>Practice real City Year 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 City Year Data Analyst interview.


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

- Know what skills are necessary for City Year Data Analyst roles.
- Gain insights into the Data Analyst interview process at City Year.
- Practice real City Year 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 City Year Data Analyst interview.
        

Overview

City Year Data Analyst Salary

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.

City Year Data Analyst Interview Process

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

The probability that it will rain tomorrow is dependent on whether or not it is raining today and whether or not it rained yesterday.

If it rained yesterday and today, there is a 20% chance it will rain tomorrow. If it rained one of the days, there is a 60% chance it will rain tomorrow. If it rained neither today nor yesterday, there is a 20% chance it will rain tomorrow.

Given that it is raining today and that it rained yesterday, write a function <code>rain_days</code> to calculate the probability that it will rain on the nth day after today.

Example:

Input:

<pre tabindex="0" class="chroma"><code>n=5
</code></pre>

Output:

<pre tabindex="0" class="chroma"><code>def rain_days(n) -&gt; 0.39968
</code></pre>

Given that it is raining today and that it rained yesterday, write a function to calculate the probability that it will rain on the nth day after today.

Rain in N Days

Let’s say that you’re a data scientist at Robinhood. 

How do we measure the launch of Robinhood’s fractional shares program?

Let’s say you are a data scientist at Robinhood.

Robinhood is introducing a program to allow users to buy fractional shares of publically listed companies.

Focusing in on the activity of new users, which of the following metrics would be the LEAST important to keep track of in determining if the program added value to Robinhood’s platform for new users?

Let's say you are a data scientist at Robinhood. 



Robinhood is introducing a program to allow users to buy fractional shares of publically listed companies.



Focusing in on the activity of new users, which of the following metrics would be the LEAST important to keep track of in determining if the program added value to Robinhood's platform for new users?

Fractional Shares Metrics

Fractional Shares

City Year Data Analyst Interview Questions

Application Instructions Click Apply to submit your online application. Please attach a resume and thoughtful cover letter on the "My Experience" page in the "Resume/CV" field. Active City Year Staff members must login to Workday to apply internally. Number of Positions: 1 Work Location: 100% On-Site Position Overview City Year Tulsa is seeking a Data Analyst with experience and/or interest in social impact innovation to join our team, reporting to the Senior Director of Data Strategy and Analytics. The Data Analyst will be collaborative and a critical thinker who enjoys solving complex problems. The Data Analyst collaborates across multiple teams to manage the organization's data stack and tools, analyze complex data sets, identify trends and evidence for informed decision-making, visualize and share insights with site leadership and peers. The Data Analyst will contribute to a data culture that supports powerful service delivery, empowers program teams, and drives positive student, school, and community outcomes. The ideal candidate is looking to grow their skillsets in data engineering, machine learning and predictive analytics, strategy, and demonstrates a desire to grow their leadership abilities. The ideal candidate will excel in a dynamic and collaborative environment. About Us City Year is an education-focused, nonprofit organization founded in 1988 that partners with public schools and teachers to help keep students in school and on track to succeed. In 29 communities across the United States and through two international affiliates, this innovative public-private partnership is challenging the educational status quo with tenacity, passion and empathy. We help create environments where young people feel like they belong, so they can fulfill their potential. City Year is recognized by Charity Navigator, America's premier charity evaluator, as a four-star rated organization for each of the last eight years, placing it among the top 1% of all organizations rated. City Year is also a five-time winner of Fast Company Social Capitalist Award and has been recognized in leading business and management books including Built to Last and Forces for Good: The Six Practices of High-Impact Nonprofits. Job Description Responsibilities <ul> <li>Develop and maintain data warehouse and other key data sources, build scripts and models that build a flexible, scalable, and robust data evaluation process </li></ul><ul><li>Create and maintain appropriate data structures that support efficient and sustainable reporting and insight generation; ensure rigor, accuracy, and consistency of data processing, documentation, reporting </li></ul><ul><li>Work closely with internal data team members and partners to understand and maintain focus on the organization's analytical needs, including identifying relevant questions, metrics, and insights </li></ul><ul><li>Proactively explore and analyze data using a variety of tools and methods to answer key questions related to program performance and opportunities </li></ul><ul><li>Prepare differentiated analyses and visualizations to engage multiple audiences, communicate compelling results and outcomes that are accessible and understandable </li></ul><ul><li>Support program data operations by developing self-serve data tools and dashboards </li></ul><ul><li>Other tasks as required, including participation in full-site events and service projects. </li></ul>Knowledge, Experience, Skill Requirements <ul> <li>Strong working knowledge of effective and efficient data structures, data pipelines, and cloud-based data warehouses such as Google BigQuery </li></ul><ul><li>Prior experience with data management, data analysis, and modeling </li></ul><ul><li>Practical experience in statistical analysis using tools such as R, SPSS, SAS </li></ul><ul><li>Proficiency in statistical programming languages SQL, R, Python </li></ul><ul><li>Working knowledge of visualization tools such as PowerBI or Tableau </li></ul><ul><li>Ability to identify opportunities for data collection and analysis in alignment with organization's priorities </li></ul><ul><li>Ability to understand and communicate complex (sometimes technical) concepts with simplicity; ability to navigate through layers of ambiguity, think abstractly, and solve complex problems </li></ul><ul><li>Demonstrated ability to work well in a collaborative teams and dynamic environment; ability to take initiative, define and manage multiple projects/workstreams in collaboration with stakeholders </li></ul><ul><li>Ability to self-direct, take initiative, work and learn independently, while also enthusiastically partnering with cross-disciplinary teams </li></ul><ul><li>Minimum 2-4 years of related experience or an equivalent combination of training and experience </li></ul><ul><li>Bachelor's degree in quantitative sciences such as economics, statistics, computer science, public health or related fields such as urban studies, sociology, public policy preferred </li></ul> Benefits Full time employees will be eligible for all benefits including vacation and sick days and organization holidays. You may participate in all benefit programs that City Year establishes and makes available to eligible employees, under (and subject to all provisions of) the plan documents that govern those programs. Currently, City Year offers medical, dental and vision, life, accidental death and dismemberment and disability coverage, Flexible Spending Accounts (FSA), other benefits including 401(k) plan(s) pursuant to the terms and conditions of company policy and the 401(k) plan document. For more information, click here. Employment at City Year is at-will. City Year does not sponsor work authorization visas.

This role is 100% on-site in our Carmel, IN office. The Data Analyst’s role is to design data modeling/analysis services used to mine enterprise systems and applications for knowledge and information that enhance business processes. This individual is responsible for assisting in building, deploying, and maintaining data support tools, metadata inventories, and definitions for database file/table creation. The Data Analyst will also assist in the development and operation of the BI/data warehousing practice, including optimizing processes and technologies, and ensuring a high availability BI/data warehouse platform. This individual will participate in defining data standards and warehouse architecture models. KEY RESPONSIBILITIES Strategy & Planning<ul><li>Devise, develop, and deploy required data visualizations and underlying data queries in response to business user needs.</li><li>Maintain appropriate documentation to support usage of visualizations and queries</li><li>In conjunction with data owners and department managers, develop data models and protocols for mining production databases.</li><li>Assist in the development of data management policies and procedures.</li><li>Identify research questions, problem solve using data analysis, and communicate the results to various stakeholders</li><li>Ensure best practices are established for effective problem resolution for a high availability, 24/7, global environment. </li><li>Analyze existing operations and make recommendations for the improvement and growth of the BI/EDW architecture.</li></ul> Operational Management<ul><li>Work with application development staff to coordinate the creation and management of data visualizations and queries.</li><li>Collaborate with unit managers, end users, development staff, and other stakeholders to integrate data management applications with existing systems. </li><li>Provide and apply quality assurance best practices for data analysis services across the organization.</li><li>Develop, implement, and maintain change control and testing processes for modifications to data models.</li><li>Create data definitions for new database file/table development and/or changes to existing ones.</li><li>Develop routines for end users to facilitate best-practice use of data management tools.</li><li>Monitor data management system details within the database, including stored procedures and execution time, and implement efficiency improvements.</li><li>Diagnose and resolve data warehouse access and performance issues.</li></ul> PHYSICAL DEMANDS<ul><li>Must be able to sit or stand for extended periods of time and interact with computers, telephone and other electronic media.</li><li>Overtime hours may be required to meet project deadlines.</li></ul> QUALIFICATIONS<ul><li>Bachelor’s Degree in Information Technology, Computer Science, or a related field required.</li><li>Previous work experience delivering data and business intelligence solutions and integrations with a bias to best leverage existing applications and tools.</li><li>Ability to work independently, as well as part of a team, on multiple projects.</li></ul> PERSONAL ATTRIBUTES<ul><li>Excellent written and oral communication, and decision-making skills.</li><li>Excellent interpersonal skills and desire to work with business users to understand problem areas and formulate a solution.</li><li>Ability to conduct and direct research into IT issues and products as required.</li><li>Self-motivated, self-directed, personally accountable, and operate with a sense of integrity.</li><li>Demonstrate critical thinking and problem-solving skills with ability to effectively prioritize and execute tasks in a high-pressure environment.</li></ul> KNOWLEDGE & EXPERIENCE<ul><li>Strong technical knowledge of data management systems, data warehousing methodology, data quality, data modelling, data governance, analytics, and predictive modeling.</li><li>Extensive knowledge of SQL, data manipulation languages, and Microsoft’s BI suite.</li><li>Experience working in a DevOps environment utilizing techniques such as code versioning (e.g. git), code review and agile software development</li><li>Proven experience in BI/data warehousing planning and development.</li><li>Strong understanding of relational database structures, theories, principles, and practices.</li><li>Hands-on experience with data mining, large-scale data modeling, and business requirements gathering/analysis.</li><li>Experience with data processing flowcharting techniques.</li><li>Proven project management experience.</li></ul>

Position: Data ConsultantsPay Rate: $47.83Duration: 1 YEARLocation: Charlotte, NC Must Haves: <ul><li>Advanced, expert Excel skills is mandatory (5+ years)</li><li>Moderate-to-advanced SQL skills is also mandatory (5+ years)</li><li>Data mining experience (7+ years)</li><li>Analytics experience – dissect, distill, and simplify data (7+ years)</li></ul> Day to Day:The role provides critical end to end production support of metric reporting routines. The reports/dashboards are shared with senior executives within and outside of the organization to drive proper risk culture and business strategy. Given the level of the audience, report dashboards and executive summaries must be pristine and error free. Data analytics responsibilities may include, and are not limited to, trending analysis, and success analytics to identify areas of discrepancy and possible at-risk controls. The work includes data mining, data aggregation, business metrics, SPI inventory output analysis, risk program metrics analysis, and performance/milestone analytics. Success measures for this role include:<ul><li>Consistent, timely delivery of reporting requirements using existing macros and code</li><li>Proactive identification of code or macro breaks</li><li>Successful application of macro/code fixes and creation</li><li>Demonstrated ability capture, manipulate and clean data from multiple sources and systems of record</li><li>Applied critical eye to catch errors or discrepancies</li><li>Reliable application of advanced Excel and SQL skills to produce reporting in an efficient, timesaving manner</li><li>Ability to remain nimble and positive when priorities change and Adhoc needs arise</li><li>Shows a sense of urgency and attention to detail as standard work practice</li><li>Strong collaboration</li><li>Significant attention to detail</li><li>Effective prioritization of workbench deliverables</li><li>Timely follow-up on reporting requests and questions</li><li>Experience working in a highly regulated industry or financial institution</li><li>Has previously interacted with senior level managers</li><li>Created dashboard reports or analytics</li></ul>

Data Analyst Location: Hybrid in Dallas, TX (3 days a week on-site) Job Type: 6-month contract with possibility of hire What will I be doing?As a Resource Data Analyst, you will play a key role in supporting technology development teams by managing and analyzing resource data. You will be responsible for maintaining accurate data records, performing detailed analyses, and ensuring resource data supports decision-making processes effectively. Your role will involve:<ul><li>Reconciling, entering, and updating resource data weekly and monthly.</li><li>Validating data accuracy through regular audits and checks.</li><li>Uploading and verifying business case data.</li><li>Conducting analyses to provide insights into resource allocation and utilization.</li><li>Supporting resource planning and capital allocation processes.</li><li>Testing and validating updates to resource management tools.</li><li>Collaborating with HR, Finance, and Business Management teams to align resource data with organizational goals.</li></ul> What are we looking for?<ul><li>Experience:</li><li>Strong background in data entry and analysis in complex environments.</li><li>At least two years of professional experience and one year in an analyst role (preferably in accounting, finance, or complex data).</li><li>Skills:</li><li>Proficiency in Microsoft Office, especially Excel, with the ability to create data models.</li><li>Excellent problem-solving and collaboration skills.</li><li>Effective time management and ability to prioritize tasks under pressure.</li><li>Attention to detail and a continuous improvement mindset.</li><li>Strong written and verbal communication skills.</li></ul> Other Requirements:<ul><li>Bachelor’s degree (BA/BS).</li><li>Ability to handle sensitive information with discretion.</li><li>Hybrid work arrangement requiring 3 days in the office per week.</li></ul> Contract Benefits:<ul><li>Comprehensive benefits package, including 401k, health, dental, and vision insurance provided while on contract.</li></ul>

About the Program:People Tech Technology is pleased to offer a comprehensive Data Training Program designed for individuals looking to start a career in data science and analytics. This program aims to equip participants with the essential skills and knowledge required to become proficient data professionals.Key Responsibilities:<ul><li>Training Participation: Attend and actively engage in all training sessions, workshops, and assignments.</li><li>Learning and Development: Utilize training materials, complete exercises, and participate in discussions to deepen understanding of data science and analytics concepts.</li><li>Project Work: Apply learned skills by working on real-world projects and assignments with guidance from experienced mentors.</li><li>Data Analysis: Conduct data cleaning, analysis, and visualization using various tools and techniques.</li><li>Collaboration: Work collaboratively with peers and mentors to foster a productive learning environment.</li><li>Feedback and Improvement: Provide and receive constructive feedback to and from peers and mentors to continually improve skills and program experience.</li></ul>What You Will Learn:<ul><li>Data Fundamentals: Understanding data types, data collection, and data cleaning techniques.</li><li>Statistics and Probability: Basic concepts of statistics and probability used in data analysis.</li><li>Programming for Data Science: Using programming languages such as Python or R for data manipulation and analysis.</li><li>Data Visualization: Creating visualizations using tools like Matplotlib, Seaborn, or Tableau.</li><li>Machine Learning: Introduction to machine learning concepts, algorithms, and model evaluation.</li><li>Big Data Technologies: Understanding big data frameworks like Hadoop and Spark.</li><li>SQL and Databases: Writing SQL queries and understanding database management.</li><li>Data Storytelling: Communicating insights effectively through data storytelling and presentation.</li></ul>Qualifications:<ul><li>Education: Masters in Computer Science, Statistics, Mathematics, Engineering, or a related field (or currently pursuing one).</li><li>Basic Programming Knowledge: Familiarity with basic programming concepts, preferably in any programming language.</li><li>Passion for Data: Demonstrated interest in data science and analytics.</li><li>Analytical Skills: Strong analytical and problem-solving skills.</li><li>Communication Skills: Strong verbal and written communication skills.</li></ul>Preferred Skills (Not Mandatory):<ul><li>Prior Experience with Data: Any prior experience with data analysis or related fields is a plus.</li><li>Knowledge of Statistics: Basic understanding of statistical concepts and methods.</li></ul>Benefits:<ul><li>Hands-on Training: Gain practical experience through real-world projects.</li><li>Mentorship: Receive guidance and support from experienced data professionals.</li><li>Career Opportunities: Potential for full-time employment opportunities upon successful completion of the program.</li><li>Networking: Connect with industry professionals and like-minded peers.</li></ul>

<h3>Job Description</h3><div>Job Description<div>POSITION NO: 201381 POSITION: Data Analyst NATURE OF POSITION: Full-Time (Exempt Administrative, 260 days), 1.0 FTE (This is a grant-funded position) ORGANIZATIONAL RELATIONSHIP:The position of Data Analyst reports to the Director of Institutional Effectiveness and Planning. There are no supervisory duties. PURPOSE/SUMMARY OF JOB:This position is funded through a U.S. Department of Education Hispanic-Serving Institutions Program (STEM) Title III grant (Award # P031C210103) and Title V MI CASA grant (Award #P0315230272). The Data Analyst is responsible for coordinating, managing, and reporting on internal and external data collection and analysis related to grant reporting, institutional research, event participation, and other data of various forms to contribute to the objectives and goals of each grant. Specific activities include assisting with the grant planning and developing processes, preparing reports for grant reporting and internal communication, collaboration with faculty and staff, event participation for planning and review, and data retrieval, analysis, presentation, and communication from a variety of internal and external sources. The Data Analyst will uphold the College's Guiding Principles, and work to actively promote inclusivity, celebrate diversity, and ensure equal opportunities. The position will include work from the MCC Fort Morgan campus, and also have an occasional need to travel. Some remote work may be appropriate based on the business needs and/or work cycle of the position. ESSENTIAL JOB FUNCTIONS:<ol><li>Collaborates closely with other grant and college staff to contribute to efforts on the collection, compilation, and analysis of data, recommend changes, and promote data-informed choices using Banner, Cognos, Navigate, Recruit, Evaluation Kit, and other institutional data systems. (30%)</li><li>Coordinates the development and keeps regular maintenance of grant specific data and methods of data collection and corresponding documentation including but not limited to performance measures for each grant objective, cohort data, and event numbers. (30%)</li><li>Prepare and disseminate appropriate internal communications and conduct trend reporting and analysis as needed to maximize the use of data. (15%)</li><li>Coordinates with grant staff to analyze and review grant initiatives, performances of events, and other projects. (10%)</li><li>Assists in data-oriented sections of the grant Annual Performance Report. (5%)</li><li>Develops and maintains a master calendar and/or schedule for grant/institutional data collection and dissemination processes. Facilitates a process to increase direct access to data by college employees. (5%) </li><li>Other duties as assigned. (3%)</li><li>Based on the functions, this position has been identified as a Campus Security Authority. As a Campus Security Authority, the incumbent in this position is required to report allegations of Clery Act crimes that they become aware of to the Vice President of Student Services at Morgan Community College. Various trainings pertaining to these responsibilities may be required. (1%)</li><li>All MCC employees are responsible for ensuring their work and educational environments are free from illegal discrimination, sexual harassment, and related retaliation. When alleged or suspected discrimination, sexual harassment, or retaliation is experienced or observed by, or made known to, an MCC employee, the employee is responsible for reporting that information to one of the following individuals: the Title IX Coordinator or the Deputy Title IX Coordinator. Attends training pertinent to these responsibilities as required. (1%)</li></ol> REQUIRED QUALIFICATIONS:<ul><li>Bachelor's degree in data analysis, statistical interpretation, research, or related field from a regionally accredited institution. A combination of education and professional level experience performing similar duties to those described for this position may substitute.</li></ul><ul><li>Experience with database management and reporting; ability to examine data to determine outcomes and trends. </li><li>Ability to think critically and diplomatically ascertain information needs</li><li>Strong, self-driven learning ability</li><li>Excellent oral and written communication skills. </li><li>Strong attention to detail. </li><li>Strong interpersonal skills. </li><li>Strong organizational and time management skills. </li><li>Excellent analytical and problem-solving skills. </li><li>Ability to handle multiple tasks and prioritize duties. </li><li>Proficiency in Excel and strong MS Office skills. </li><li>Ability to meet deadlines and to work independently.</li></ul> PREFERRED QUALIFICATIONS:<ul><li>Master's degree in a field related to data analysis, statistical interpretation, research, or related field. </li><li>Experience in higher education. </li><li>Experience with one or more of the institutional data systems including but not limited to Banner, Cognos, Navigate, Recruit, Evaluation Kit, etc. </li></ul> RESPONSIBILITY AND DECISION MAKING:This position performs data extraction, analysis, and institutional support using a variety of programs to track measures and communicate with the grant directors and other needed parties. The day-to-day operations include problem solving, analyzing, and coordinating data that are used in the operation and reporting of the grant. This position will consistently exercise discretion and equity and apply analytical skills to the performance of advanced work/daily duties. This position works with staff and faculty from across the institution. There are no supervisory responsibilities. Job Posted by ApplicantPro </div></div>

Title: Clinical Safety Analytics Associate (Data Analyst)Location: Princeton New Jersey 08540 (Hybrid)Duration: 6+ Months Must Have List:<ul><li>4+ years of Data Analyst experience</li><li>Intermediate to Advanced skills with Tableau or Qlik</li><li>Extensive experience with SQL and Python or R or SAS</li><li>Strong communication skills</li><li>Biopharma experience preferred</li><li>Bachelor's or Master's (preferred) degree in a relevant field, such as Biostatistics, Analytics, Engineering or related discipline.</li></ul> Summary:<ul><li>Clinical Safety Analytics Associate will play a critical role within the PV CoE. This position focuses on assisting with analyzing data and deriving insights from clinical and safety data sources to generate evidence and support decision making across the organization.</li><li>The Associate will leverage a variety of analytics and visualization techniques to contribute to research, clinical development, drug safety and post-marketing activities.</li></ul> Roles & Responsibilities<ul><li>Collaborates and works closely with cross-functional teams, including data analysts/engineers and business stakeholders, to understand their needs and gather requirements</li><li>Cleans, transforms and pre-processes data to ensure data quality, consistency and compatibility for analysis</li><li>Develops and implements data analysis plans to answer clinical and safety questions</li><li>Applies analytical and/or statistical techniques to analyze data and generate insights on safety questions</li><li>Visualizes data and results to share insights with technical and non-technical cross-functional stakeholders</li><li>Interprets and communicates findings through reports, presentations and visualizations</li><li>Stays up to date and compliant with the regulatory landscape related to drug safety and data analyses</li><li>Works closely with PV CoE and other stakeholders, sharing knowledge and best practices within the broader safety and analytics teams</li></ul> Skills & Competencies<ul><li>Strong understanding of data sources, such as clinical trial data, electronic health records, and other healthcare databases</li><li>Proficiency in data pre-processing, cleaning and transformation techniques to ensure data quality and compatibility for analysis</li><li>Knowledge of relevant analytical and statistical methodologies, such as regression analysis, survival analysis etc.</li><li>Excellent problem-solving skills and the ability to derive meaningful insights from complex real-world data sets</li><li>Excellent communication and presentation skills to effectively convey complex concepts and findings</li><li>Ability to work collaboratively in cross-functional teams and manage multiple projects simultaneously</li><li>Strong attention to detail and accuracy in data analysis and interpretation</li></ul> Experience<ul><li>Bachelor's or Master's (preferred) degree in a relevant field, such as Biostatistics, Analytics, Engineering or related discipline.</li><li>Minimum of 3-5 years of experience in data analysis, statistical modeling, and data visualization, preferably within the biopharma or healthcare industry.</li><li>Experience applying statistical and analytical techniques, to analyze real world data</li><li>Experience with Python or R or SAS and SQL required</li><li>Working knowledge of visualization tools, such as Tableau or Power BI</li><li>Experience or familiarity with the biopharma industry</li></ul>

• Data entry and data analysis experience in a complex environment• Team player with a continuous improvement mindset, keen attention to detail, and excellent time management skills• Self-starter with intellectual curiosity and drive who can proactively identify and prevent potential problems in an ambiguous environment• Strong problem-solving, collaborative and communication skills with the ability to work well under pressure and effectively balance multiple concurrent demands and appropriately prioritize responsibilities• Proficiency in the Microsoft Office suite with the ability to create data models using Microsoft Excel• Discretion and confidentiality regarding sensitive information • Reconciling, entering and updating resource data which received on a weekly and monthly basis• Performing weekly and monthly data validation to ensure data correctness• Uploading and validating business case data• Performing analysis of resource data• Supporting business case level resource management• Supporting capital allocation process• Testing Hilton resource tool changes• Partnering with Business Management, HR, and Finance to support resource-based decisions

This is a contract role for 12 Months in our San Jose Office. Job Overview:We’re looking for a marketing data analyst to join the Demand Generation Activation team in our San Jose office on a 12-month contract. Our team is made up of three functions, data & analytics, marketing automation, and paid media. You’ll be joining our data & analytics function.You will work closely with the other data analysts in our team as well as colleagues in the digital team, developer marketing team and the broader demand generation campaign team. This is an excellent opportunity for a collaborative and eager-to-learn individual looking to grow their marketing and digital data knowledge and abilities by joining a dedicated team with deep expertise.Responsibilities:<ul><li>Adobe Analytics Reporting: Build and maintain reports in Adobe Analytics Workspace to support the marketing department and other digital platform owners.</li><li>Data Integration and Queries: Write SQL queries in Google Cloud Platform’s BigQuery to combine Adobe Analytics web data with other data sources including CRM, email, digital ad channels and social media channels to support cross-channel reporting.</li><li>Audience Segmentation: Use Adobe Analytics or BigQuery to define and set up target audiences based on behavioral traits, user profiles, and account profiles.</li><li>Dashboard Development: Create dashboards using Power BI, integrating data from our data mart (in Google Cloud Platform’s BigQuery) and other relevant sources.</li><li>Communicate insights and findings from your analysis to colleagues, both technical (your data team colleagues) and non-technical marketing colleagues.</li></ul>Required Skills and Experience :<ul><li>Marketing Data Expertise: Familiarity with marketing data (both transactional and digital), including campaign tracking, web activity, CRM data, UTM parameters, and lead generation.</li><li>SQL Proficiency: Writing of SQL queries, creating relationships, and joining data from multiple sources.</li><li>Adobe Analytics Proficiency: Experience with Adobe Analytics Workspace, creating segments, calculated metrics, and understanding core dimensions and measures.</li><li>Dashboard Tools: Experience with Power BI or similar BI tools (e.g., Looker, Tableau) for visualizing and reporting data.</li></ul>“Nice To Have” Skills and Experience :<ul><li>Experience with JavaScript, Python, or R programming.</li><li>Familiarity with API endpoints and webhooks for data activation purposes.</li><li>Familiarity with data modeling in dbt, common table expressions, joins, and groupings.</li><li>Experience creating data pipelines, or familiarity with ETL / ELT processes.</li></ul>

This Vendor Master Data Analyst is responsible for governance, process improvements, and problem resolution for vendor master data for all ERP systems, complying with vendor setup policy.<ul><li>Ensure requests from the business are process timely and follow-up internal guidelines.</li><li>Ensure compliance and changes to master data are made following business policies and procedures.</li><li>Develop and publish SLA for vendor master data requests.</li><li>Monitor and follow-up as required to meet Service Level Agreements.</li></ul>Qualifications:<ul><li>Bachelor’s Degree highly desired.</li><li>2-3 years of related experience with vendor master data/data analytics required.</li><li>Attention to detail and ability to perform tasks with accuracy.</li><li>Understanding of data management principles and best practice.</li><li>Proficient in Microsoft Office with intermediate Excel, preferred.</li><li>Strong communication skills and ability to work in a team environment.</li><li>Possesses a willingness to learn.</li></ul>

City Year Data Analyst Interview Guide

Overview

City Year Data Analyst Salary

City Year Data Analyst Interview Process

City Year Data Analyst Interview Questions

City Year Data Analyst Jobs