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

SMC 3 Data Analyst Interview Guide

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


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

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

Overview

SMC 3 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.

A/B Testing

Algorithms

Analytics

Machine Learning

Probability

Product Metrics

Python

Statistics

SMC 3 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

You’re given two dataframes. One contains information about addresses and the other contains relationships between various cities and states:

Example:

<code>df_addresses</code>

<table>
<thead>
<tr>
<th>address</th>
</tr>
</thead>

<tbody>
<tr>
<td>4860 Sunset Boulevard, San Francisco, 94105</td>
</tr>

<tr>
<td>3055 Paradise Lane, Salt Lake City, 84103</td>
</tr>

<tr>
<td>682 Main Street, Detroit, 48204</td>
</tr>

<tr>
<td>9001 Cascade Road, Kansas City, 64102</td>
</tr>

<tr>
<td>5853 Leon Street, Tampa, 33605</td>
</tr>
</tbody>
</table>
<code>df_cities</code>

<table>
<thead>
<tr>
<th>city</th>
<th>state</th>
</tr>
</thead>

<tbody>
<tr>
<td>Salt Lake City</td>
<td>Utah</td>
</tr>

<tr>
<td>Kansas City</td>
<td>Missouri</td>
</tr>

<tr>
<td>Detroit</td>
<td>Michigan</td>
</tr>

<tr>
<td>Tampa</td>
<td>Florida</td>
</tr>

<tr>
<td>San Francisco</td>
<td>California</td>
</tr>
</tbody>
</table>
Write a function <code>complete_address</code> to create a single dataframe with complete addresses in the format of street, city, state, zip code.

Input:

<pre tabindex="0" class="chroma"><code>import pandas as pd

addresses = {&#34;address&#34;: [&#34;4860 Sunset Boulevard, San Francisco, 94105&#34;, &#34;3055 Paradise Lane, Salt Lake City, 84103&#34;, &#34;682 Main Street, Detroit, 48204&#34;, &#34;9001 Cascade Road, Kansas City, 64102&#34;, &#34;5853 Leon Street, Tampa, 33605&#34;]}

cities = {&#34;city&#34;: [&#34;Salt Lake City&#34;, &#34;Kansas City&#34;, &#34;Detroit&#34;, &#34;Tampa&#34;, &#34;San Francisco&#34;], &#34;state&#34;: [&#34;Utah&#34;, &#34;Missouri&#34;, &#34;Michigan&#34;, &#34;Florida&#34;, &#34;California&#34;]}

df_addresses = pd.DataFrame(addresses)
df_cities = pd.DataFrame(cities)
</code></pre>

Output:

<pre tabindex="0" class="chroma"><code>def complete_address(df_addresses,df_cities) -&gt;
</code></pre>

<table>
<thead>
<tr>
<th>address</th>
</tr>
</thead>

<tbody>
<tr>
<td>4860 Sunset Boulevard, San Francisco, California, 94105</td>
</tr>

<tr>
<td>3055 Paradise Lane, Salt Lake City, Utah, 84103</td>
</tr>

<tr>
<td>682 Main Street, Detroit, Michigan, 48204</td>
</tr>

<tr>
<td>9001 Cascade Road, Kansas City, Missouri, 64102</td>
</tr>

<tr>
<td>5853 Leon Street, Tampa, Florida, 33605</td>
</tr>
</tbody>
</table>

Write a function to create a single dataframe with complete addresses in the format of street, city, state, zip code.

Complete Addresses

SMC 3 Data Analyst Interview Questions

Posting Details I. JOB OVERVIEW Job Description Summary: The Office of the Vice President for Research (OVPR) supports all sponsored research project activity and large portions of internal funding for research projects across the George Washington University's schools and units. The Senior Data Analyst, Research reports to the Director of Operations and Projects within OVPR and is responsible for performing general analytics and statistical modeling on existing data sets in the area of university research activity. Activities include: defining data requirements, data collection, processing, cleaning, analysis, modeling and visualization. Examines and identifies data patterns and trends to help answer business questions and improve decision making. Provides inputs for complex Data Science and Big Data Mining projects. Identifies areas to increase efficiency and automation of data analysis processes. This position works to manage the integrity of research data and acts as OVPR's data steward in defining data elements and data governance. Works closely with the university's business intelligence and information technology teams to define visualization and data requirements based on user needs and understanding of applicable business systems and industry requirements. Designs and builds reusable queries, identifies data patterns and trends, reviews and analyzes results, and devises or modifies procedures to solve complex problems. Responds to ad hoc data requests and to surveys conducted by external agencies. Performs data imports, extraction, database maintenance and reporting, and also guides and advises decision making by OVPR leadership. Specific responsibilities include: Data Analysis and Reporting: Acts as a key member of the OVPR central operations team to create, integrate and manage multiple data sets across all divisions within OVPR. Understands research data needs from multiple stakeholders and advises OVPR and IT on how to best move forward. This will include routine data imports, extractions and integration of data from both university Data Warehouse and multiple other sources, timely analysis and interpretation of complex data in order to make findings relevant and actionable for both internal and external stakeholders use. Provides actionable insights into the data trends; devises or modifies procedures to solve complex problems; and supports managerial workload decision making. Guides and advises others regarding research data. Data Visualization: Primarily using Tableau, Excel, and PowerBI, develops and enhances graphical representations of research trends and internal metrics that display research data in a meaningful and easy to comprehend manner. Works closely with GW's Information Technology and Business Intelligence Services to provide requirements and prioritization for enhancements to research dashboards, including the PI Dashboard. Tests and provides input when enhancements are completed. Data Governance: Works as an integral part of the university's information technology team on data governance processes to verify data quality and ensure accurate analysis and reporting, and assist in all phases of agile scrum-based project development; roles-based access, and assessment and implementation of ERP systems. Continuously assesses OVPR data needs and management reporting for areas of improvement. Information Requests: Uses various data analytics tools to perform data extractions and report building to respond to information requests. Documents and understands user requirements, considers capacity and limitations of current systems, and responds in a consistent way that meets customer needs while maintaining data integrity. Develops queries and reports and makes recommendations for how to best display data for reporting and analysis purposes. Provides data support and analysis required for recurring inputs to external groups. Maintains historical comparisons of research activities. Investigates research trends for schools, departments and Principal Investigators (PIs). Makes recommendations for how to streamline reporting processes. Creates process documentation related to requests and responsibilities and provides training to others as applicable. Systems Administration: Serves as subject matter expert for systems used by OVPR for managing research processes as it relates to data collection, data integration and data integrity. Understanding system interfaces and building necessary reports for data analysis. Gathers requirements to assist with system builds that allow for data collection and process workflow for various OVPR offices. Performs other related duties as assigned. The omission of specific duties does not preclude the supervisor from assigning duties that are logically related to the position. Minimum Qualifications: Qualified candidates will hold a Bachelor's degree in an appropriate area of specialization plus 5 years of relevant professional experience, or, a Master's degree or higher in a relevant area of study plus 3 years of relevant professional experience. Degree must be conferred by the start date of the position. Degree requirements may be substituted with an equivalent combination of education, training and experience. Additional Required Licenses/Certifications/Posting Specific Minimum Qualifications: Preferred Qualifications: Ability to understand data analysis logic and data system structure in order to correctly interpret complex data. Skills include ability to respond to fast-paced projects thoroughly and accurately, ability to translate business requests into technical analysis, and attention to detail. Advanced knowledge in Microsoft Access, SQL, Excel, Tableau, Power BI. Knowledge of Visual Basic, Drupal, SharePoint, and/or Nintex preferred. Hiring Range $68,359.64 - $109,234.47 GW Staff Approach to Pay How is pay for new employees determined at GW? Healthcare Benefits GW offers a comprehensive benefit package that includes medical, dental, vision, life & disability insurance, time off & leave, retirement savings, tuition, well-being and various voluntary benefits. For program details and eligibility, please visit https://hr.gwu.edu/benefits-programs. II. JOB DETAILS Campus Location: Foggy Bottom, Washington, D.C. College/School/Department: Office Vice President of Research (OVPR) Family Information Technology Sub-Family Functional Data Analysis Stream Individual Contributor Level Level 3 Full-Time/Part-Time: Full-Time Hours Per Week: 40 Work Schedule: M-F 8:30 am - 5:00 pm Will this job require the employee to work on site? Yes Employee Onsite Status Hybrid Telework: Yes Required Background Check: Criminal History Screening, Education/Degree/Certifications Verification, Social Security Number Trace, and Sex Offender Registry Search Special Instructions to Applicants: Employer will not sponsor for employment Visa status Internal Applicants Only? No Posting Number: S013484 Job Open Date: 12/17/2024 Job Close Date: If temporary, grant funded or limited term appointment, position funded until: Background Screening Successful Completion of a Background Screening will be required as a condition of hire. EEO Statement: The university is an Equal Employment Opportunity/Affirmative Action employer that does not unlawfully discriminate in any of its programs or activities on the basis of race, color, religion, sex, national origin, age, disability, veteran status, sexual orientation, gender identity or expression, or on any other basis prohibited by applicable law.

Your Role
The Health Data Transformation & Evaluation team drives implementation of the Digital Health Record (DHR). As the business driver, the team leads the integration of various data sources into a longitudinal patient record. The Data Analyst-Health, Principal, will report to Sr. Manager, Health Data Strategy. In this role you will oversee, as a Business Product Owner, the design, development, testing, and deployment of the Digital Health Record, ensuring that it meets Blue Shield's data-driven objectives. In addition, this role will lead efforts to validate accuracy and integrity of data received from DHR sources and its adoption within the operational workflows by end-users.
Your Work
In this role, you will:
Liaise with cross functional teams of data architects, modelers and data quality analysts, who are responsible for building the Digital Health Record within the enterprise data warehouse
Define and implement the data integration strategy, architecture, standards, and best practices for the Digital Health Record, ensuring alignment with the organization's vision, mission, and goals
Establish and monitor the data quality and governance processes and perform user acceptance testing for the Digital Health Record, ensuring that the data is accurate, complete, consistent, and trustworthy
Collaborate with stakeholders and business users across the enterprise to understand their data needs and expectations, and to deliver solutions that enable data-driven decision making and insights
Lead design, analysis, and interpretation of various data sources to meet health data strategy goals including but not limited to creation of Digital Health Record
Serve as a partner to the Director, Health Data Strategy and Evaluation team to ensure all Digital Health Record and Program evaluation data needs are met
Your Knowledge and Experience
Requires an MPH, MBA, MS, MA in science, social science, public health, MIS, computer science, data science, health services research or business, or BA/BS with demonstrated equivalent work experience
Requires 10 years of prior relevant experience, with at least 5 years of in Health Care (managed care, academic, or government payer)
Proficiency and experience in health informatics is preferred
Familiarity with health information exchanges, interoperability, longitudinal patient records and meaningful use is preferred
Experience validating the quality and integrity of incoming data is preferred
Prior experience in data analysis and reporting, such as SQL, BI tools, and data visualization is preferred
Experience in Agile and DevOps methodologies, such as Scrum, Kanban, CI/CD, and Git is preferred
Excellent communication, presentation, and interpersonal skills, with the ability to communicate complex technical concepts to both technical and non-technical audiences
Strong problem-solving, analytical, and critical thinking skills, with the ability to deliver solutions that meet business objectives and requirements
Pay Range:
The pay range for this role is: $136,400.00 to $204,600.00 for California.
#J-18808-Ljbffr

Job Title: Data Analyst (Casual Gaming)Location: BengaluruCompany: Circle of Games Prior experience in the gaming industry is a must. About Us:Circle of Games is a leading Web3-based casual gaming company committed to delivering immersive gaming experiences. We blend the thrill of casual games with blockchain technology to create a cutting-edge gaming ecosystem. Join our dynamic team and contribute to shaping the future of Web3 gaming! Job Description:We are seeking a Data Analyst with a minimum of 2 years of experience in real-money gaming or casual gaming companies. As a Data Analyst at Circle of Games, you will play a key role in analyzing, interpreting, and optimizing our gaming data. Your insights will drive our game design, player engagement, monetization strategies, and overall growth within the Web3 gaming landscape. Key Responsibilities:<ul><li>Analyze gameplay data, user behavior, and in-game economy trends to provide actionable insights.</li><li>Develop and maintain dashboards, reports, and metrics to track game performance, player engagement, and retention.</li><li>Collaborate with product managers, game designers, and developers to optimize game design and user experience based on data-driven insights.</li><li>Support marketing and community engagement teams by analyzing user acquisition, retention, and monetization strategies.</li><li>Conduct deep dives into data to identify patterns, player preferences, and areas for improvement in monetization and user retention.</li><li>Create predictive models and forecasts to improve decision-making across the organization.</li><li>Work closely with blockchain developers to analyze Web3-related gaming data, such as tokenomics, user wallet activity, and blockchain transactions.</li><li>Monitor KPIs, player trends, and provide recommendations for improving player satisfaction and revenue.</li></ul> Requirements:<ul><li>2+ years of experience as a Data Analyst, preferably in the real-money gaming or casual gaming industry.</li><li>Strong proficiency in SQL, data visualization tools (e.g., Tableau, Power BI), and Excel.</li><li>Experience with Python or R for data analysis and modeling.</li><li>Hands-on experience in working with large datasets, A/B testing, and data mining techniques.</li><li>Familiarity with gaming KPIs such as player lifetime value (LTV), churn rates, ARPDAU, and engagement metrics.</li><li>Strong analytical and problem-solving skills, with the ability to interpret complex data and present insights clearly to stakeholders.</li><li>Familiarity with blockchain and Web3 technologies is a strong plus.</li><li>Ability to work in a fast-paced environment and handle multiple projects simultaneously.</li><li>Familiar with Moengage/Clever Tap or any event based user funnel data tracking platforms</li></ul> Preferred Qualifications:<ul><li>Experience in analyzing tokenized economies or in-game currencies in Web3 or blockchain-based games.</li><li>Knowledge of real-time data processing tools and techniques.</li><li>Previous experience in working with cross-functional teams in a gaming environment.</li></ul> Why Join Us:<ul><li>Be a part of the Web3 gaming revolution and work on cutting-edge blockchain projects.</li><li>Collaborative and creative work environment.</li><li>Opportunities for growth and learning within a rapidly expanding industry.</li><li>Competitive salary and benefits package.</li></ul>

NO EXTERNAL RECRUITERS PLEASE No Sponsorship/Transfer Available Job Description : Are you passionate about turning data into actionable insights? Join MeriCal, a leader in dietary supplement manufacturing, as a Sales Data Analyst . About MeriCal : MeriCal stands as a leading private label and contract manufacturer of dietary supplements within the United States. With a cumulative experience of over 90 years, our dedicated industry experts drive innovation in delivering product solutions tailored for today's markets. MeriCal LLC is committed to providing top-tier dietary supplements that prioritize consumer health and wellness. Explore more about us at www.merical.com. What it's Like to Work Here : As a Sales Data Analyst , you'll be the focal point for reporting and analyzing POS and shipment data. Your responsibilities will include creating, distributing, and presenting reports that guide decision-making across Retail and Contract Sales. You'll work with external datasets like IRI/Circana and retailer-specific databases to deliver timely and accurate insights. About You : You're a skilled data analyst with a strong ability to turn large datasets into meaningful insights. You thrive in cross-functional environments and have the communication skills to present complex data to various stakeholders. You're organized, detail-oriented, and excel in a fast-paced setting. Essential Job Functions: Data Reporting & Analysis: Create, distribute, and present daily, weekly, and monthly reports to management, including the C-suite and Board of Directors. Lead discussions on data analysis and business performance. Category Research: Manage category research, including IRI/Circana analysis, industry trends, and disseminating relevant articles and data across the organization. New Business Evaluation: Support evaluating potential new business opportunities by providing cost estimates and volume assessments. Cross-Functional Collaboration: Work closely with Sales, Operations, and other departments to ensure data alignment and support company goals. Project Management: Ensure projects are delivered on time with attention to detail and accuracy. Qualifications: 3 years of experience with Neilsen/IRI or similar syndicated data platforms. 3 years of experience in sales forecasting and data analysis. Advanced proficiency in Excel, PowerPoint, and Word. Proven ability to work cross-functionally and drive business results. Strong organizational skills with the ability to manage multiple projects simultaneously. Experience in a manufacturing environment, ideally OTC/Nutritional, is a plus. Education Requirements: Bachelor's degree in business, economics, accounting, statistics, or a related field is required. The Perks : At MeriCal, we value our team members and offer exceptional benefits: No cost (yes, you read that right) vision insurance, employer-paid life insurance, 12 paid company holidays, generous paid time off benefits and sick time, employee assistance program and a comprehensive wellness program Affordable medical and dental insurance plans that fit the needs for you and your dependents Outstanding supplemental benefits, including Accident, Critical Illness, Hospitalization indemnity plans, and pet insurance Matching 401k plan and more Join us in our pursuit of wellness through innovation Click on the 'apply' button below to be part of our dynamic team. Best of luck The salary range stated here is the low and high end of the pay range for this position. They do not necessarily reflect actual compensation that may be earned and are not a promise of any specific pay for any specific employee. Actual starting rate of pay may vary based on factors that include, but are not limited to, position offered, location, work education, training, and experience. MeriCal uses E-Verify to confirm authorization to work in the United States. For more information on E-Verify please visit the following website: https://www.e-verify.gov/employees MeriCal is an equal opportunity employer and is committed to providing a workplace that is inclusive and free of discrimination and harassment. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability status, protected veteran status, or any other characteristic protected by law. We encourage individuals of all backgrounds to apply. We believe in creating a diverse and inclusive workplace where all employees feel valued and respected, and where differences are embraced as strengths. We are dedicated to fostering an environment that promotes equality and celebrates diversity.

Genesis10 is currently seeking a Data Analyst with our reinsurance agency client in their Warren, NJ location. This is a 6 month + right to hire and hybrid remote position. This position required 3 days onsite.

Summary:
Seeking a Data Analyst.

Responsibilities:    The Data Analyst will be responsible for gathering, documenting, and managing requirements for data projects.
This role involves working closely with stakeholders to understand their needs and translating them into technical specifications for teams working with SQL databases, Power BI, QlikView, and data lake.

Requirements:    Engage with stakeholders to document detailed requirements for data projects which includes ETL processes, Power BI Reports, Qlik View reports and dashboards.
Proficient in documenting data mappings for seamless integration between various applications and services.
Proficient in documenting data ingestion, and processing requirements for data warehouse / data lake.
Proven experience in business analysis, particularly in data projects.
Strong proficiency in SQL and experience with database management systems (e.g., SQL Server, PostgreSQL).
Knowledge of data visualization tools, including Power BI and QlikView.
Experience with data lake technologies and big data platforms (e.g., Hadoop, Azure Data Lake).
Excellent analytical, problem-solving, and documentation skills.
Ability to communicate complex technical concepts to non-technical stakeholders.
Only candidates available and ready to work directly as Genesis10 employees will be considered for this position.

If you have the described qualifications and are interested in this exciting opportunity, please apply!

Ranked a Top Staffing Firm in the U.S. by Staffing Industry Analysts for six consecutive years, Genesis10 puts thousands of consultants and employees to work across the United States every year in contract, contract-for-hire, and permanent placement roles. With more than 300 active clients, Genesis10 provides access to many of the Fortune 100 firms and a variety of mid-market organizations across the full spectrum of industry verticals.

For contract roles, Genesis10 offers the benefits listed below. If this is a perm-placement opportunity, our recruiter can talk you through the unique benefits offered for that particular client. Benefits of Working with Genesis10:   Access to hundreds of clients, most who have been working with Genesis10 for 5-20+ years.
The opportunity to have a career-home in Genesis10; many of our consultants have been working exclusively with Genesis10 for years.
Access to an experienced, caring recruiting team (more than 7 years of experience, on average.)
Behavioral Health Platform
Medical, Dental, Vision
Health Savings Account
Voluntary Hospital Indemnity (Critical Illness & Accident)
Voluntary Term Life Insurance
401K
Sick Pay (for applicable states/municipalities)
Commuter Benefits (Dallas, NYC, SF)
Remote opportunities available

For multiple years running, Genesis10 has been recognized as a Top Staffing Firm in the U.S., as a Best Company for Work-Life Balance, as a Best Company for Career Growth, for Diversity, and for Leadership, amongst others. To learn more and to view all our available career opportunities, please visit us at our website.

Genesis10 is an Equal Opportunity Employer. Candidates will receive consideration without regard to their race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.

Arcadis is the world's leading company delivering sustainable design, engineering, and consultancy solutions for natural and built assets.

We are more than 36,000 people, in over 70 countries, dedicated to improving quality of life. Everyone has an important role to play. With the power of many curious minds, together we can solve the world's most complex challenges and deliver more impact together.

Role description:

Arcadis is seeking a  Data Analyst  to join our team in New Work. In this role, you will be responsible to assist and provide support to ensure business needs are being met. While having the willingness to explore new ideas and creative solutions.

Role accountabilities:

Managing and merging multiple Excel data files without error or data corruption
Perform detailed data analysis using SQL
Writing complicated queries, stored procedures, functions using SSMS
Analyze & manipulate data in Excel, and provide feedback to stakeholders
Assist with various aspects of the data management process - which may include data input
Ability to create and maintain dashboards using PowerBI, and setup Data Gateway for dashboards
Ability to automate weekly/monthly/quarterly reports using Python/R or Microsoft Power Platform
Collecting, tracking and trending projection/ forecast data
Working closely with the Project Controls Scheduling team
Presenting data result outputs to stakeholders and management teams as needed
Required Qualifications:     Bachelor's Degree in Computer Science/Information Technology
Minimum of 2 years of relevant work experience
Key Skills and Abilities :    Advanced technical skills - MS SQL, Power BI/Tableau and/or Advanced Excel
Proficient with Microsoft Office (Word, Excel, and PowerPoint), including document editing and tracking changes
Exceptional interpersonal skills and effectiveness in communicating across all levels of the organization
Preferred Qualifications:     Previous experience in infrastructure industry is preferred.

Why Arcadis?

We can only achieve our goals when everyone is empowered to be their best. We believe everyone's contribution matters. It's why we are pioneering a skills-based approach, where you can harness your unique experience and expertise to carve your career path and maximize the impact we can make together.

You'll do meaningful work, and no matter what role, you'll be helping to deliver sustainable solutions for a more prosperous planet. Make your mark, on your career, your colleagues, your clients, your life and the world around you.

Together, we can create a lasting legacy.

Our Commitment to Equality, Diversity, Inclusion & Belonging

We want you to be able to bring your best self to work every day which is why we take equality and inclusion seriously and hold ourselves to account for our actions. Our ambition is to be an employer of choice and provide a great place to work for all our people. We are an equal opportunity and affirmative action employer. Women, minorities, people with disabilities and veterans are strongly encouraged to apply. We are dedicated to a policy of non-discrimination in employment on any basis including race, creed, color, religion, national origin, sex, age, disability, marital status, sexual orientation, gender identity, citizenship status, disability, veteran status, or any other basis prohibited by law.

Arcadis offers benefits for full time and part time positions. These benefits include medical, dental, and vision, EAP, 401K, STD, LTD, AD&D, life insurance, paid parental leave, reward & recognition program and optional benefits including wellbeing benefits, adoption assistance and tuition reimbursement. We offer nine paid holidays and 15 days PTO that accrue per year. The salary range for this position is 70,000 - $85,000. Actual salaries will vary and are based on several factors, such as experience, education, budget, internal equity, project and location.

Join Arcadis. Create a Legacy.

#LI-BB1 #LI-Hybrid #Mobility-ANA-Jobs

Job Title: Senior Data Analyst
Company: Grand Circle LLC
Location: Boston, MA
Job Type: Full-time (Hybrid - 3 days in office)
We are seeking a highly skilled and motivated Sr. Data Analyst to contribute to the development of cutting-edge solutions. If you are passionate about pushing the boundaries of technology and solving complex problems, we want to hear from you!
Job Description:
As a Sr. Data Analyst on our Digital Analytics Department at Grand Circle LLC you will play a crucial role in Delivering Consistent insights on key strategies to maximize profitability. You will work closely with our Director of Digital Analytics Marketing partnering with our Brand and Execution teams to provide actionable & measurable data insights across our marketing channels.
Responsibilities:
Conduct in-depth analysis of large and complex datasets to extract valuable customer insights segment performance, behavior, and preferences in the omnichannel landscape.
Develop and implement consistent insight and report out techniques to solve business problems.
Use data visualization and written summary to communicate findings effectively.
Collaborate with cross-functional teams to understand business problems for both Analysis and reporting to support Company initiatives
Present findings and insights to non-technical stakeholders in a clear and understandable manner.
Communication Skills: Proven ability to translate data-driven insights into compelling narratives and communicate them clearly and effectively in both written and verbal communication.
Decision-Making Support: Ability to use data analysis to support strategic decision-making, with a track record of influencing business outcomes through data-driven findings and recommendations.
Executive Reporting: Regularly present findings at in-person meetings with senior and executive leadership, providing clear, concise, and actionable recommendations based on data analysis.
Cross-Functional Collaboration: Experience creating and delivering Written Executive Summaries with supporting reports to marketing, brand, and execution teams to ensure that data insights directly contribute to achieving business goals.
Qualifications:
Bachelor's degree in Computer Science, Statistics, Mathematics or a related field.
Proven experience as a Data Analyst in the Digital marketing space focusing on Web/Social/SEO/SEM Analytics
Specialized in using advanced analytics tools and languages (e.g., SQL, Python, R).
Specialized with data visualization tools such as Tableau, Power BI, or similar platforms.
Excellent communication skills, complex problem-solving skills and the ability to work in a fast-paced, collaborative environment.

#J-18808-Ljbffr

Job Description

Clinical Data Analyst

Vancouver, Washington

$80000K-$85000K Range

Why Choose GMR?  Global Medical Response (GMR) and its family of solutions are dedicated to delivering compassionate, quality medical care, primarily in the areas of emergency and patient relocation services. Here you'll embark in meaningful work that will make an impact on you and the customers we service. View our employees's stories on how we provide care to the world at www.AtaMomentsNotice.com.

With more than 38,000 employees, Global Medical Response teams deliver compassionate, quality medical care, primarily in the areas of emergency and patient relocation services around the world. We provide end-to-end medical transportation as well as fire services, integrated healthcare solutions and disaster response.

POSITION SUMMARY

The Clinical Data Analyst is responsible for designing, developing, and maintaining reporting solutions. This role is instrumental in data collection, dashboard development, reporting and identifying areas for performance improvement. This role will maintain a portfolio of quality and utilization reports to drive improved performance with value-based contracts. Responsibilities include sharing actionable performance dashboards with value-based care leadership, operational leadership and quality improvement teams. Other duties include assisting with analysis of clinical quality metrics, operational trends, compliance reporting, and utilization in support of value-based care strategies.

DUTIES & RESPONSIBILITIES
Analyze current data to perform gap analysis on report available and utility of current reports.
Query, review and gather data from multiple internal/external sources to create dashboards, drill down capable reports and key performance indicators.
Provide analytical expertise in data quality, improvement opportunities and understanding of variation in the clinical and quality metrics.
Utilize Tableau, Power BI, ESO, and other data visualization software to create actionable dashboards and reports.
Provide consultative support for value-based care leaders on improvement opportunities for clinical and quality metrics.
Facilitate the efficient use of dashboards, reports and presentations for clinic-based improvement projects.
Analyze and vet report as well as help colleagues interpret the information to answer clinical and quality performance questions.
Works in conjunction with the Director of Operations, Clark County Medical Program Director, Clinical QA/QI Coordinator.
Reviews project requests describing clinical database user needs.
Attends specification meetings with Clinical and Educational Services (CES) team members to determine scope and limitations of projects.
Works closely with front-end users to ensure program usability, recognize data collection issues, and recommend solutions.
Troubleshoots and improves existing reports and reporting logic to meet clinical data user needs.
Develops data models describing data elements and how they are used.
Designs, executes, and interprets the results of custom T- SQL queries linking multiple databases.
Contributes to planning of system operations. Design data collection instruments for focused investigations and audits.
Responds to Value leadership requests for analysis and reporting related to clinical and quality performance.
MINIMUM QUALIFICATIONS     High School Diploma or GED.
Advanced Excel knowledge & Experience.
Experience using SQL and analyzing queries.
Experience analyzing, interpreting, summarizing, displaying and presenting data.
Using desktop software and data visualization tools.
Experience extracting data from EMR, preferably ESO and Epic.
Excellent computer skills including Microsoft applications.
Excellent written and verbal communication skills.
WORKING CONDITIONS AND MENTAL/PHYSICAL REQUIREMENTS      Work is generally performed in a typical interior/office environment or remote as determined by the Director of Operation's discretion.
Frequently required to sit for long periods.
Work requires stooping, walking, grasping, and repetitive motions; vocal communication is required for expressing or exchanging ideas by means of the spoken word; visual acuity is necessary for preparing and analyzing written or computer data, determining the accuracy and thoroughness of work, and observing general surrounds and activities.
Pass drug screen, and background check.
Continually required to perceive normal speaking levels with or without correction and can receive detailed information through oral communication.
Frequently required to stand, walk, and use hands and arms.
Must be able to read/comprehend, write, perform calculations, reason, and analyze.
Special Requirements - Reasonable accommodations may be made to enable individuals with disabilities to perform essential tasks.
Critical thinking skills with the ability to use logic and reasoning to identify the strengths and weaknesses of alternative solutions, conclusions, or approaches to problems.
To learn more about GMR and how our values are at the core of our services and vital to how we approach care, visit www.GlobalMedicalResponse.com.

#LI-SS1

EEO Statement

Global Medical Response and its family of companies are an Equal Opportunity Employer, which includes supporting veterans and providing reasonable accommodations for individuals with a disability.

More Information about this Job   Salary Range $120,000K-$125,000K
Check out our careers site Benefits | GMR Careers to learn more about our comprehensive benefit options, which include medical, vision, dental, 401k, disability, FSA, HSA, EAP, vacation and paid time off.
The application window for this position is anticipated to close on 12.19.2024

<h3>Job Description</h3><div>Job Description<div>Description:At Rhodes, our core purpose is to enhance the lives of our customers and team through building communities. We specialize in developing master planned communities and construction of high quality, energy efficient homes. Rhodes has been recognized among the fastest growing private companies in the US by Inc. 5000 and is on a mission to expand its footprint into more communities across South Texas. Since 2019, Esperanza Homes, a Rhodes Company, has ranked nationally on the Builder Magazine’s Top 100 Builders list, and is on an aggressive growth trajectory to serve more communities across South Texas. Rhodes was founded in the early 1990’s as a land acquisition and holding company. In 2006, the company shifted gears and ventured into residential/commercial land development and home building with the formation of Esperanza Homes. Rhodes Enterprises has grown to one of the largest developers of residential, commercial, and master-planned communities in the areas we serve. We are passionate about our customers, building exceptional homes, our team, and the communities where we live and work. Rhodes is a certified Great Place to Work, when you choose to work with us, you are part of a passionate and high-performing Team! You will work alongside team members who set and reach ambitious goals every day and are excited to continue to grow and build communities. Benefits of being a part of our Team include:<ul><li>Competitive Compensation including Bonus & Profit-Sharing Programs </li><li>Health Care - Medical/Dental/Vision/Prescription Drug Coverage </li><li>Employer Paid Health Reimbursement Account for Medically Enrolled Staff </li><li>401(k) with Company Matching Contributions </li><li>Disability Programs </li><li>Employee & Dependent Life Insurance </li><li>Vacation & Company Holidays </li><li>Employee Home Purchase Rebate Program </li><li>Employee Assistance Program (EAP) </li></ul> Role Mission: As a Junior Data Analyst at Rhodes, you will play a crucial role in supporting data-driven initiatives by assisting in data collection, analysis, reporting, and managing reporting tickets. You will work closely with experienced data analysts to extract valuable insights from large datasets and contribute to developing data-driven strategies. This role offers opportunities for growth, skill development, and exposure to various aspects of data analytics. Reporting directly to the Director of Data and IT, you are part of the Administrative Services department and have an exciting opportunity to support Rhodes organizational purpose to enhance the lives of our customers and team through building communities. Measured Performance Goals:<ul><li>87.5% Projects on time</li><li>90% Reports on time</li><li>90% Data tickets completed on time</li></ul> Accountabilities: Reports:<ul><li>Conduct analyses to drive valuable business insights, using analytics tools, Python, and SQL to access and manipulate multivariate data</li><li>Complete reports for the reporting calendar on time</li><li>Provide ad-hoc analysis support to identify trends that drive business performance</li><li>Communicate updates on report requests</li><li>Maintain an inventory/documentation of all reports created</li></ul>Dashboards:<ul><li>Maintain existing dashboards, ensuring they reflect the most current data and insights.</li><li>Handle enhancement requests, changes, and issues related to dashboards in collaboration with stakeholders.</li><li>Actively participate in team meetings and contribute to data-related discussions.</li><li>Maintain an inventory/documentation of all dashboards created</li></ul>Managing Reporting Tickets:<ul><li>Handle enhancement requests, changes, and issues related to dashboards in collaboration with stakeholders.</li><li>Provide reports to requestors within the agreed-upon time frames, taking into account the urgency of the request. If unforeseen delays occur, proactive communication with stakeholders is necessary.</li></ul>Collaboration:<ul><li>Collaborate with cross-functional teams to understand data requirements and provide analytical support.</li><li>Actively participate in team meetings and contribute to data-related discussions.</li></ul>Lives Rhodes Core Values:<ul><li>Act with Integrity, No Exceptions - believes there is no such thing as compromise when it comes to acting with integrity in everything you do. </li><li>Honor our Team - honors team members as individuals and professionals, no exceptions. </li><li>Never Be Satisfied -continuously looks for ways to improve every aspect of our business</li><li>Best in Class Customer Experience -provide a best-in-class customer experience – every time, with every customer</li><li>Community Leadership – takes pride in actively engaging in the communities we serve, making them better for our future.</li></ul>Embodies Characteristics of the Rhodes Team:<ul><li>Believes and is committed to our purpose to enhance the lives of our customers and our team through building communities</li><li>Is driven by outcomes and results, and wants to be held accountable for them</li><li>Has a propensity for action, willing to make mistakes by doing in order to learn and improve quickly</li><li>Thrives in an entrepreneurial, high-growth environment; is comfortable with ambiguity and change</li><li>Seeks and responds well to feedback, which is shared often and freely across all levels of the organization</li><li>Works through silos and forges strong cross-departmental relationships in order to achieve outcomes</li></ul> Supervisory Responsibilities:-None Qualifications, Knowledge and Skills:<ul><li>Bachelor’s degree or pursuing a bachelor’s degree</li><li>Exposure to Business Intelligence tools</li><li>Experience with Python programming language</li><li>Enthusiasm for data analysis and a strong desire to learn and grow in the field.</li><li>Advanced Excel and reporting skills</li><li>Strong in communication skills both oral and written as well as strong in organization skills</li><li>Deadline driven and organized</li><li>Customer service oriented </li><li>Understand the need to be flexible and prioritize tasks in order to meet deadlines</li></ul> FLSA Status: ExemptEssential Functions: (Mental/Physical/Environmental Requirements):The physical demands described here are representative of those that must be met by a team member with or without reasonable accommodations, to successfully perform the essential functions of this job. <ul><li>Report to office daily and adhere to schedule</li><li>Ability to oversee direct reports daily and provide guidance as needed</li><li>Ability to access, input, and retrieve information from a computer and/or electronic device</li><li>Ability to have face to face conversations with customers, co-workers and manager</li><li>Ability to sit or stand for long periods of time and move around work environment as needed</li></ul> Requirements: </div></div>

The Workforce Planning team within JPMorganChase exists to help ensure success of major transformation efforts through data by identifying challenges with existing programs of work and proactively working with key partners to shape the future state of the organization.As a Data Analyst Vice President on the Workforce Planning team, you will leverage your extensive experience in data wrangling and creative problem-solving to collaboratively build and maintain models that accurately forecast the hiring activities necessary to meet our organization's workforce needs. In this role, you will tackle complex business challenges and transform them into data-driven solutions. Whether you're dissecting intricate data sets, developing sophisticated dashboards, or conceptualizing solutions to underlying business issues, your expertise will be both valued and impactful.**Job Responsibilities**+ Develop advanced dashboards, reports, and workflows to address critical questions about technology talent and workforce strategy+ Demonstrate resourcefulness and creativity in sourcing and analyzing data+ Serve as the authority on internal people-related data, providing data-driven solutions to stakeholders' challenges+ Effectively communicate actionable insights and analytical methodologies to non-technical partners+ Automate processes and enhance efficiencies in traditional data workflows+ Collaborate with multiple teams, adeptly navigating unstructured and ambiguous environments+ Independently drive end-to-end projects while managing stakeholder expectations+ Mentor peers and partners in enhancing their data fluency and analytical capabilities**Required Qualifications, Capabilities, and Skills**+ 7+ years of professional experience as an analyst in a business intelligence role+ Proven track record of success across the analytics project lifecycle, including solution design, data extraction and transformation, descriptive analysis, and data visualization+ Advanced proficiency in data analysis and visualization tools (Excel, Tableau, Alteryx, and Python)+ Strong, precise verbal and written communication skills with both technical and non-technical colleagues, including senior stakeholders**Preferred Qualifications, Capabilities, and Skills**+ Bachelor's or Master's degree in a quantitative field+ Extensive experience with people analytics projects+ Proficiency in statistics and data science techniquesJPMorganChase, one of the oldest financial institutions, offers innovative financial solutions to millions of consumers, small businesses and many of the world's most prominent corporate, institutional and government clients under the J.P. Morgan and Chase brands. Our history spans over 200 years and today we are a leader in investment banking, consumer and small business banking, commercial banking, financial transaction processing and asset management.We offer a competitive total rewards package including base salary determined based on the role, experience, skill set, and location. For those in eligible roles, we offer discretionary incentive compensation which may be awarded in recognition of firm performance and individual achievements and contributions. We also offer a range of benefits and programs to meet employee needs, based on eligibility. These benefits include comprehensive health care coverage, on-site health and wellness centers, a retirement savings plan, backup childcare, tuition reimbursement, mental health support, financial coaching and more. Additional details about total compensation and benefits will be provided during the hiring process.We recognize that our people are our strength and the diverse talents they bring to our global workforce are directly linked to our success. We are an equal opportunity employer and place a high value on diversity and inclusion at our company. We do not discriminate on the basis of any protected attribute, including race, religion, color, national origin, gender, sexual orientation, gender identity, gender expression, age, marital or veteran status, pregnancy or disability, or any other basis protected under applicable law. We also make reasonable accommodations for applicants' and employees' religious practices and beliefs, as well as mental health or physical disability needs. Visit our FAQs for more information about requesting an accommodation.JPMorgan Chase & Co. is an Equal Opportunity Employer, including Disability/Veterans

SMC 3 Data Analyst Interview Guide

Overview

SMC 3 Data Analyst Salary

SMC 3 Data Analyst Interview Process

SMC 3 Data Analyst Interview Questions

SMC 3 Data Analyst Jobs