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

Mtsi Data Analyst Interview Guide

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


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

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

Overview

Mtsi 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.

Mtsi 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

Mtsi Data Analyst Interview Questions

<h3>Job Description</h3><div>Job Description<div>Salary: starting at $65,000 About the Company:At SimpsonScarborough, we spend our days building brands that endure, inspire, and elevate the all-important work of colleges and universities in shaping our future. Recognized as a leader in the higher ed marketing industry, our company runs a fully remote team of approximately 75 employees coast to coast. We are a growing team looking for a self-motivated and enthusiastic new member. We expect a lot from our team members and champion their successes.   About the Role:This role is a hybrid between a data analyst and a research analyst. This hybrid role is designed to leverage both primary research skills and data analytics to support business decisions and strategy. This position involves analyzing data from primary research, market and industry sources, as well as various marketing data sources. All candidates selected for interviews must have experience with primary research data. Specific Job Functions:<ul><li>Lead and execute quantitative agile testing and research projects, inclusive of message testing and creative concept testing, in collaboration with the Associate Director, Analytics Strategy. This includes ensuring that agile survey questions and testing aligns to market research practices.</li><li>Support the execution and ongoing reporting efforts of the research and analytics team dedicated towards delivering on an industry wide flagship product to measure the brand equity of an academic institution. This includes the ability to write and update SQL queries/code as needed to evolve the model.</li><li>Extract, transform, and load (ETL) data from various sources using SQL. Analyze data by writing and executing SQL queries and performing exploratory data analysis in Tableau.</li><li>Clean and prepare quantitative agile survey data for analysis. This includes identifying and removing poor quality respondents, recoding variables as needed, and otherwise ensuring that the datafile is fully annotated and easy to read.  </li><li>Create clear and detailed data visualizations, dashboards, and reports. Present data findings and research insights to stakeholders in a comprehensive and actionable manner.</li><li>Under the direction of the Associate Director of Analytics Strategy, support maintenance and development of the agency’s tech stack/data pipeline. This includes supporting onboarding new data sources, fixing errors in the data schema, and any other maintenance tasks identified by the AD.</li><li>Ensure data quality and integrity for all deliverables. This includes performing quality checks on data pipelines (including data files from vendors), SQL queries, and reporting dashboards. </li></ul> Required Skills / Qualifications:<ul><li>1-2 years of experience in a similar data analyst role.</li><li>Bachelor’s degree in Data Science, Statistics, Computer Science, Mathematics, and/or any combination of education and relevant experience.</li></ul><ul><li> Proficient in handling survey output data, including experience with Extract, Transform, Load (ETL) processes, with moderate familiarity in designing survey questions.</li><li>Experience using data visualization tools (Power BI, Tableau, etc.)</li><li>Strong proficiency in SQL for data manipulation and querying.</li><li>Experience with R and/or Python desired for data analysis and modeling but not required.</li><li>Experience with data science modeling techniques such as regression, classification, clustering, etc.</li><li>Exposure to survey questionnaire design and knowledge of survey design best practices.</li><li>Knowledge in marketing, market research, and marketing analytics is a plus.</li><li>Comfortable collaborating with remote project teams nationwide.  </li></ul> Salary, Perks & Benefits:  Salary starts at $65,000.00 and will be commensurate with experience.  Beware of fraudulent job offers. SimpsonScarborough will never ask you for personal information or for interviews through unofficial channels. Please report any suspicious activity to peopleandculture@simpsonscarborough.com SimpsonScarborough offers a full benefits package, including nationwide health coverage, dental, vision, employer paid life insurance, flexible time off (FTO), student loan reimbursement after waiting period, and voluntary benefits such as critical illness and accident insurance, 100% paid parental leave, and a 401k with employer contribution after waiting period.  Perks include flexible work model including Flexible Fridays, telework stipend, weeklong agency closures (summer and winter), and a day off for your birthday.  At SimpsonScarborough, we believe diversity, equity, inclusion, and belonging are central to our core values, cultural norms, and critical to our long-term success. We believe this work is a continual effort that requires consistency, intentionality, vulnerability and accountability for ourselves and others. Through our efforts we strive to make impact in our work, in our workplace and in our industry.  SimpsonScarborough is an equal opportunity employer. We have a strict anti-harassment policy and a no tolerance non-discrimination policy. We welcome employees of all backgrounds regardless of nationality, race, religion, gender identity, veteran status, and all characteristics protected by state and federal law.   remote work</div></div>

<h3>Job Description</h3><div>Job Description<div>Company Description About Us: VIVIO Health is a leading provider of innovative healthcare solutions, dedicated to enhancing the well-being of our members. Our mission is to revolutionize the healthcare experience by offering personalized, accessible, and high-quality care. Mission and Impact: <ul><li>VIVIO’s mission is to make data the foundation for clinical decision-making. </li><li>Our evidence-based, data-driven approach has significantly improved healthcare outcomes and reduced costs for self-insured employers and health plans since 2016. </li></ul>Why VIVIO? <ul><li>Innovation: We’re not afraid to challenge the status quo. Join us in shaping the future of healthcare. </li><li>Impact: Your work will directly impact patient care and the bottom line. </li><li>Collaboration: Work alongside brilliant minds who share your passion for making a difference. </li><li>Culture: VIVIO encourages autonomy and reliability; micromanagement is not our style. </li><li>Growth: VIVIO is growing rapidly—so are your opportunities. </li></ul>Position: Data Analyst Intern :This role is a Hybrid position for candidates within a commutable distance of our Hayward, CA location. Job Description About you:Are you passionate about data analytics and healthcare? Do you enjoy working with customers and solving their problems? If so, you might be the perfect fit for VIVIO!  As an Intern Data Analyst, you will work within our Tech Team, reporting to the Sr. Director of Engineering, to analyze customer and operational data to identify trends, patterns, and insights to enhance sales, and customer satisfaction, drive business growth and increase operational efficiency.  This role involves working with various data sources, creating reports and dashboards and building automation for the same while collaborating with cross-functional teams. We are looking for a talented, new Computer Science or Data Science graduate or a college student with strong communication, analytical and problem-solving skills and with a passion to learn and grow. Qualifications Who should apply We're looking for candidates with the following requirements: <ul><li>Completed or currently enrolled in a computer science/computer engineering/data science degree, with at least three academic years completed at the time you start your internship. </li><li>Strong knowledge SQL preferably with MySQL </li><li>Strong hands-on experience with Python  </li><li>Understanding of database schemas and design </li><li>Experience with data processing and building automation with Python/Pandas is preferred </li><li>Exposure to Artificial Intelligence and Machine Learning is a plus </li><li>Experience building dashboards using BI tools such as Jasper, Quicksight, PowerBI or Tableau is a plus </li><li>Strong aptitude for complex products and solutions </li><li>Extreme attention to detail </li><li>A willingness to work independently and be flexible to shifting needs and priorities.  </li><li>Candidate is required to work in a hybrid environment at our corporate office in Hayward, CA </li><li>No visa sponsorship available for this role</li><li>This long-term internship (at least six months) may also be extended. </li></ul>Pay Range: $25-35/hour  Additional Information VIVIO Health is an Equal Opportunity Employer and does not unlawfully discriminate based on any status or condition protected by applicable federal, state, or local municipal law. All your information will be kept confidential according to EEO guidelines. </div></div>

<h3>Job Description</h3><div>Job Description<div> Reporting to the Senior Vice President of Access to Care, the Clinical Data Analyst position will be responsible for managing and analyzing clinical data to support our organization’s decision-making processes, improve patient outcomes, and enhance operational efficiency. The Clinical Data Analyst will work closely with healthcare providers, clinical teams, IT professionals, and executive stakeholders to ensure data integrity and optimize the use of analytics, KPI reporting and Electronic Health Record (EHR) system data extraction. This position is ONSITE in Ewing, NJ, no relocation.    Responsibilities <ul><li>Collect, clean, and analyze clinical data from various sources, including EHR systems, and other business intelligence platforms used by the organization.</li><li>Develop and maintain databases and data collection systems to ensure data accuracy and integrity.</li><li>Perform data validation and quality checks to identify and resolve data discrepancies.</li><li>Design and implement EHR templates to capture relevant clinical data efficiently.</li><li>Collaborate with healthcare providers to ensure templates meet clinical and operational needs.</li><li>Optimize existing templates based on feedback and evolving requirements.</li><li>Generate and distribute regular reports and dashboards to track key performance indicators (KPIs) and other metrics.</li><li>Provide actionable insights and recommendations based on data analysis to support clinical and operational decision-making.</li><li>Develop and maintain performance measurement tools and systems.</li><li>Work with E.H.R. stakeholders, IT, and clinical staff to troubleshoot data issues and implement solutions.</li><li>Train and support healthcare providers in the use of EHR templates and data reporting tools.</li><li>Participate in cross functional teams and projects to support data driven initiatives.</li><li>Ensure compliance with healthcare regulations and data privacy standards, including HIPAA.</li><li>Implement and adhere to data security protocols to protect sensitive patient information.</li><li>Other responsibilities as assigned or as needed to support department or organizational goals.</li></ul>Qualifications & Skills <ul><li>Ability to analyze large datasets to identify trends, patterns, and insights; </li><li>Ability to interpret complex data and present it in a clear and understandable manner.</li><li>Knowledge of healthcare regulations and standards, including HIPAA and other data privacy laws; understanding of clinical workflows and healthcare operations. </li><li>Computer skills including Microsoft Office (Outlook, Word, Excel) and proficiency in data analysis software such as SQL, Python, R, and data visualization tools like Tableau or Power BI.</li><li>Ability to generate and interpret reports and dashboards for tracking KPIs and other metrics.</li><li>Excellent written and verbal communication skills to convey data insights to nontechnical stakeholders; ability to collaborate effectively with healthcare providers, IT staff, and other team members.</li><li>Ability to work effectively in a team environment, participate in cross functional teams and contribute to data driven initiatives.</li></ul>Required Licenses or Experience <ul><li>Bachelor’s degree in Health Informatics, Data Science, Computer Science, or related field;  master’s degree preferred. </li><li>3+ years experience in clinical data analysis, preferably in a healthcare setting, including application of statistical methods to analyze clinical data.</li><li>Experience with data analysis software such as SQL, Python, R, and data visualization tools like Tableau or Power BI.</li><li>Experience in designing and implementing EHR templates to capture relevant clinical data.</li></ul>#INDPR1EEO STATEMENTWe are an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to age, race, color, religion, sex, national origin, ancestry, marital status, affectional or sexual orientation, gender identity or expression, disability, veteran status, or any other characteristic protected by law.Powered by JazzHRLKywRODacW</div></div>

<h3>Job Description</h3><div>Job Description<div>About ForaHi, we’re Fora. We’re reimagining the travel advisor industry with fresh eyes, and building a travel agency that is modern, inclusive, tech-enabled and well, cool. Fora is a next-generation travel platform that, through training and tools, enables anyone to become a travel agent. Fora's mission is to empower 100,000 entrepreneurs to transform their passion for travel into revenue, and we’re doing it by curating the most incredible experiences for travelers.  Fora was founded in 2021 by travel entrepreneurs Henley Vazquez, Jake Peters and Evan Frank – who shared one big idea. Since then, we’ve grown to a team of 50+ full-time employees, with an office headquarters in Tribeca, New York City. We are fortunate to be backed by an incredible group of investors and are looking for more talented and mission-driven individuals to join our team.About the RoleWe’re looking for a curious and collaborative Data Analyst to join Fora. You will be joining as the second Analyst on a centralized Data team that collaborates across all departments at Fora, including Product & Engineering, Growth & Marketing, Sales, Advisor Experience, Finance, and Operations.In this role you will report to our Senior Manager, Data & Analytics, who is based in NYC and works a hybrid remote / in-office schedule. As a Data Analyst you will:<ul><li>Partner with cross-functional teams to understand their processes, determine requirements & definitions, and prioritize analytics projects.</li><li>Build and maintain our data analytics infrastructure, unlocking new capabilities and making it easier and more intuitive for users to explore data, create reports, or run sophisticated analysis.</li><li>Initiate analyses and deliver business insights that lead directly to process and product improvements.</li><li>Set measurable and strategic goals, and build new measurement and optimization capabilities.</li><li>Help foster Fora’s data and experimentation culture by mentoring, training, and improving data literacy across the organization.</li></ul>About YouYou're excited to join a high-growth, high-caliber team and draw energy from a role where your work has a meaningful impact on both company goals and our data-driven culture.To be successful, we believe you need 2+ years of professional experience in an analytical role, with the following demonstrated skills and qualities:<ul><li>Proficient in SQL.</li><li>Experience with exploratory and ad hoc analysis.</li><li>Experience in data visualization and dashboard creation.</li><li>A track record of using data to make recommendations and drive insights for the business.</li><li>Strong communication skills and ability to collaborate effectively with others.</li><li>Empathetic and curious: we are a centralized team in service to people, and the ability to relate to their needs is instrumental to success in this role.</li></ul><div>The strongest candidates may also have some of the following: </div><ul><li>Hands-on experience with a modern data analytics stack (e.g. BigQuery, dbt, Looker, or comparable tools).</li><li>Familiarity with dimensional data modeling techniques.</li><li>Work experience in a SaaS, marketplace, or high growth startup environment.</li></ul>Compensation $85,000 – $105,000 per year, plus equityThis role is based in New York City with a hybrid WFH & office schedule (Tuesday, Wednesday, Thursday are our Tribeca in-office days, with flexibility for Monday/Friday at your preference). Fora is backed by Forerunner, Insight Partners, and Heartcore. --WORK AUTHORIZATIONYou must have authorization to work in the United States. Fora is unable to assist applicants with obtaining work authorization.EQUAL OPPORTUNITYFora is committed to an equitable hiring process and an inclusive work environment. BIPOC and traditionally underrepresented candidates are strongly encouraged to apply. We will not discriminate and will take action to ensure against discrimination in employment, recruitment, advertisements for employment, compensation, termination, upgrading, promotions, and other conditions of employment against any employee or job applicant on the bases of race, color, gender, national origin, age, religion, creed, disability, veteran's status, sexual orientation, gender identity, gender expression or any other characteristic protected by law.Powered by JazzHR4m7NghfH7W</div></div>

<h3>Job Description</h3><div>Job Description<div>Company Description TIDAL was founded for artists by artists as the next innovative streaming platform to bring value back to the music industry. We empower artists with the products, resources, services, and content required to take control of their careers and connect more deeply with fans. Available in over 60+ countries, TIDAL continues to help artists break down economic barriers to continue creating what’s next in culture. TIDAL is part of Block, Inc. (NYSE: SQ), a global technology company with a focus on financial services.Job Description You will join the small but tight-knit TIDAL Data Science & Analytics team, and will report into the Head of Data Science & Analytics. As a member of the team, you will help shape the future of our streaming and artist products. You will use your expertise in product analytics quantitative analysis to empower data-driven decision-making in the full lifecycle of thisproduct development. You will collaborate closely with a wide array of cross-functional partners across Product, Engineering, Design and Data Engineering to drive impact for our users and our business.This role is remote-friendly and open to candidates based anywhere in the United States Eastern Time Zone. You Will<ul><li>Work with cross-functional partners to translate business and product questions into analysis questions </li><li>Provide actionable data-driven recommendations to inform strategic decisions </li><li>Partner with engineering to ensure accurate and reliable logging for new product and features</li><li>Develop deep domain expertise and own measurement strategy for product and develop KPIs to track product success </li><li>Effectively communicate analysis and recommendations in verbal, visual and written form</li><li>Build effective and reliable self-serve dashboards</li></ul>Qualifications You Have<ul><li>4+ years of analytics experience</li><li>A BS/BA in Math, Statistics, Economics or a related technical field </li><li>Ability to translate ambiguous, unstructured problems into applicable data-driven analyzes </li><li>Fluency with data, analytics and visualization technologies (We use SQL, Tableau, Looker)</li><li>Experience with applying quantitative analysis and logical reasoning to influence business outcomes</li><li>Exceptional written and verbal communication skills with the ability to explain technical data to a variety of stakeholders across the company</li><li>Experience building relationships to influence with product partners with data</li><li>Creativity in developing new processes, analyses, and recommendations</li><li>Familiarity with data warehouse design and best practices</li></ul> Additional Information Block takes a market-based approach to pay, and pay may vary depending on your location. U.S. locations are categorized into one of four zones based on a cost of labor index for that geographic area. The successful candidate’s starting pay will be determined based on job-related skills, experience, qualifications, work location, and market conditions. These ranges may be modified in the future. Zone A: USD $111,700 - USD $167,500 Zone B: USD $103,800 - USD $155,800 Zone C: USD $98,200 - USD $147,400 Zone D: USD $89,400 - USD $134,000US and Canada EEOC StatementWe’re working to build a more inclusive economy where our customers have equal access to opportunity, and we strive to live by these same values in building our workplace. Block is a proud equal opportunity employer. We work hard to evaluate all employees and job applicants consistently, without regard to race, color, religion, gender, national origin, age, disability, pregnancy, gender expression or identity, sexual orientation, citizenship, or any other legally protected class. We believe in being fair, and are committed to an inclusive interview experience, including providing reasonable accommodations to disabled applicants throughout the recruitment process. We encourage applicants to share any needed accommodations with their recruiter, who will treat these requests as confidentially as possible. Want to learn more about what we’re doing to build a workplace that is fair and square? Check out our I+D page.Additionally, we consider qualified applicants with criminal histories for employment on our team, and always assess candidates on an individualized basis.Block, Inc. (NYSE: SQ) is a global technology company with a focus on financial services. Made up of Square, Cash App, Spiral, TIDAL, and TBD, we build tools to help more people access the economy. Square helps sellers run and grow their businesses with its integrated ecosystem of commerce solutions, business software, and banking services. With Cash App, anyone can easily send, spend, or invest their money in stocks or Bitcoin. Spiral (formerly Square Crypto) builds and funds free, open-source Bitcoin projects. Artists use TIDAL to help them succeed as entrepreneurs and connect more deeply with fans. TBD is building an open developer platform to make it easier to access Bitcoin and other blockchain technologies without having to go through an institution.While there is no specific deadline to apply for this role, on average, U.S. open roles are posted for 70 days before being filled by a successful candidate.<div></div>To find a location’s zone designation, please refer to this resource. If a location of interest is not listed, please speak with a recruiter for additional information. Full-time employee benefits include the following:<ul><li>Healthcare coverage (Medical, Vision and Dental insurance)</li><li>Health Savings Account and Flexible Spending Account</li><li>Retirement Plans including company match </li><li>Employee Stock Purchase Program</li><li>Wellness programs, including access to mental health, 1:1 financial planners, and a monthly wellness allowance </li><li>Paid parental and caregiving leave</li><li>Paid time off (including 12 paid holidays)</li><li>Paid sick leave (1 hour per 26 hours worked (max 80 hours per calendar year to the extent legally permissible) for non-exempt employees and covered by our Flexible Time Off policy for exempt employees) </li><li>Learning and Development resources</li><li>Paid Life insurance, AD&D, and disability benefits </li></ul>These benefits are further detailed in Block's policies. This role is also eligible to participate in Block's equity plan subject to the terms of the applicable plans and policies, and may be eligible for a sign-on bonus. Sales roles may be eligible to participate in a commission plan subject to the terms of the applicable plans and policies. Pay and benefits are subject to change at any time, consistent with the terms of any applicable compensation or benefit plans.United States and Canada EEOC StatementWe’re working to build a more inclusive economy where our customers have equal access to opportunity, and we strive to live by these same values in building our workplace. Block is a proud equal opportunity employer. We work hard to evaluate all employees and job applicants consistently, without regard to race, color, religion, gender, national origin, age, disability, pregnancy, gender expression or identity, sexual orientation, citizenship, or any other legally protected class. We believe in being fair, and are committed to an inclusive interview experience, including providing reasonable accommodations to disabled applicants throughout the recruitment process. We encourage applicants to share any needed accommodations with their recruiter, who will treat these requests as confidentially as possible. Want to learn more about what we’re doing to build a workplace that is fair and square? Check out our I+D page.Additionally, we consider qualified applicants with criminal histories for employment on our team, and always assess candidates on an individualized basis. While there is no specific deadline to apply for this role, on average, U.S. open roles are posted for 70 days before being filled by a successful candidate.Block, Inc. (NYSE: SQ) is a global technology company with a focus on financial services. Made up of Square, Cash App, Spiral, TIDAL, and TBD, we build tools to help more people access the economy. Square helps sellers run and grow their businesses with its integrated ecosystem of commerce solutions, business software, and banking services. With Cash App, anyone can easily send, spend, or invest their money in stocks or Bitcoin. Spiral (formerly Square Crypto) builds and funds free, open-source Bitcoin projects. Artists use TIDAL to help them succeed as entrepreneurs and connect more deeply with fans. TBD is building an open developer platform to make it easier to access Bitcoin and other blockchain technologies without having to go through an institution.</div></div>

<h3>Job Description</h3><div>Job Description<div>Salary: 65,587.80 Annually PlanRVA is hiring a data analyst with a strong interest in urban and regional planning. This role focuses on using data to support transportation, environmental, community development, and hazard mitigation projects. As a key member of our multidisciplinary team, the Data Analyst will work closely with planners and specialists across these areas. The role involves sourcing data from public repositories, government agencies, and regional partners, including private and non-profit sectors. The Data Analyst will transform raw data into actionable insights using tools like Excel, ArcGIS,  and Python or R,. The analyst will support various analyses, such as population forecasting, scenario modeling, land use & land cover analysis, and more. Additionally, the analyst will develop and maintain indicators that track trends in demographics, affordable housing, the economy, education, health, and other factors measuring upward mobility in the Richmond region. The role also includes communicating the findings through data visualizations, web applications, reports, and other dissemination formats. Core competencies: <ul><li> Demonstrated commitment to building a career in urban data science, with a particular focus on analyzing and communicating insights across key areas such as demographics, socio-economics, transportation, environment, land use and community development. </li><li> Proficient in both verbal and written communication, with the ability to effectively collaborate with diverse teams and translate complex data into clear, actionable insights through reports, interactive maps, and data visualizations. Skilled in managing multiple long- and short-term projects, conducting literature reviews - traditional and web-based. Knowledge of research methods - both quantitative and qualitative, ability to design survey and conduct statistical analysis, and data synthesis.</li><li> Proficient in using Geographic Information System (GIS) software such as ArcGIS and ArcGIS Online. Experienced with tools like Story Maps, Experience Builder, and Dashboard Builder for developing interactive maps and web applications. Foundational knowledge of raster data, including raster data mosaic, raster calculator/map algebra, and various analytical tools within ArcGIS Pro.</li><li> Strong quantitative analysis skills with experience in using Excel for data management and analysis. Experience in using geodatabase management tools within ArcGIS Pro. Familiarity with data visualization using Excel, ArcGIS Online, or through platforms such as Tableau or Power BI.</li><li> Deep understanding of the fundamentals of transportation and environmental planning. Capable of utilizing geoprocessing tools to develop spatial analysis models and assess the impacts of transportation and environmental projects on surrounding communities. Proficient in analyzing geographic data and effectively communicating results through data reports and interactive mapping tools.</li></ul> An ideal candidate will have some of the following additional skills:<ul><li> Demonstrated experience in scripting languages such as Python and/or R, including libraries for data analysis and visualization. Skilled in developing data pipelines, cleaning and managing data using Pandas or Tidyverse, data analysis using Pandas, Geopandas, Statsmodels, or similar libraries, and creating visualizations with tools like Matplotlib, Bokeh, Plotly, Seaborn, or similar plotting libraries. Experience in developing dashboard applications using open-source libraries like HoloViz, Flask, Plotly Express, Streamlit, or similar.</li><li> Familiarity with travel demand modeling, including experience with CUBE modeling software. Knowledge of population forecasting methods, such as the cohort component method, and skills in future year travel forecasting, future network planning, and deficiency analysis.</li><li> Experience with environmental data sources and analytical methods, including identifying green infrastructure, assessing watershed and flood risk, analyzing tree canopy and urban heat islands, and evaluating the impact of development on air quality and other environmental factors.</li><li> Understanding of regional planning foundations, land use practices, and transportation modes in accordance with Virginia Code.</li><li> Familiarity with comprehensive planning process in general and some knowledge of regional issues and programming for the Richmond region/metropolitan area.</li><li> Knowledge of research practices for compiling and analyzing data needed for planning models, including developing base year socioeconomic data.</li></ul> Supervisory Responsibility This position is generally not responsible for supervision of other personnel but may have responsibility for project management and team coordination.       Position Type/ Expected Hours of Work This is a full-time position.  Standard days and hours of work are Monday through Friday, 8:00 am to 4:30 pm; flexible schedules are permitted with prior approval.  Occasional evening and weekend work may be required for specific project deadlines or meetings as job duties demand.    Required Education and Experience Masters' degree in planning, public administration, data, computer science, engineering or related field. Bachelor's degree with 5 years of progressive relevant experience in listed fields also accepted. Ideal candidates will have at least one year working experience as Data Analyst or in related field. Work Environment This job operates in a professional office setting.  This role routinely uses standard office equipment such as computers, phones, photocopiers, and filing cabinets.    Physical Demands <ul><li> While performing duties of this job, the employee is regularly required to talk or hear.</li><li> The employee is frequently required to stand, walk, use hands to touch, handle or feel and to reach with hands and arms. </li><li> The position requires the ability to occasionally lift office products, small equipment and supplies up to 30 pounds.</li><li> Must possess the visual acuity to prepare data and statistics, to perform accounting, to operate a computer, and to read extensively. </li></ul> Additional Eligibility Qualifications None required for this position.    BenefitsMore information about benefits offered can be found on our websitehttps://planrva.org/home/about-the-commission/employment-opportunities/ Work Authorization/ Security Clearance The position does not require a criminal background check.    Deadline: Applications will be considered until the close of business Friday, September 27, but we will begin screening applicants immediately.   Important: When applying please submit a cover letter and resume.---  This position description is not designed to cover or contain comprehensive listing of activities, duties or responsibilities that are required of the employee for this position.  Duties, responsibilities and activities may change at any time with or without notice.    PlanRVA strives to cultivate and maintain an inclusive culture among its staff members.  We are committed to the principle of equal employment opportunity for all employees and to providing employees with a work environment free of discrimination and harassment. All employment decisions are based on agency need, job requirements and individual qualifications, without regard to race, sex, color, national origin, religion, sexual orientation, gender identity, age, veteran status, political affiliation, genetics, disability or any other status protected by the laws or regulations applicable in the Commonwealth of Virginia.    </div></div>

Are you driven to keep people safe? That's what we do every day at Missouri Employers Mutual. We've created a casual, values-driven work culture that's making a positive impact on the way people live and work. This is a place where you can grow with confidence - because that's what safety and success really mean to us. SUMMARY: The Data Analyst I is responsible for working with an assigned business unit within MEM to help build and support data driven decision making. The analyst will be accountable for continuously building strong business acumen while developing the ability to tell a cohesive story. In this role, the data analyst will prep, collect, organize, and distill insights from various data sources. This role will also be accountable for leveraging various tools and technologies that provide strong data visualization. ESSENTIAL DUTIES AND RESPONSIBILITIES: The requirements listed below are representative of the knowledge, skill and/or ability required. To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. Other duties may be assigned. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. Business Acumen With guidance from the Director,Data & Analytics, or senior members of the team, collaborate with assigned functional areas to build an understanding of business needs. Data Analysis This role will assist in prepping, collecting, and organizing large amounts of data. With supervision from senior members of the team, this role will begin to identify patterns and trends emerging from complex data sets. Assist business leaders in monitoring Key Performance Indicators (KPIs) to determine business initiatives' success. Data Visualization & Storytelling With close guidance from senior members of the team, the Data Analyst I will deliver high-quality PowerBI reports. This role will begin to develop presentations (written and non-verbal) that provide timely & actionable insights in non-technical terms. QUALIFICATIONS: Education: Bachelor's degree in a technical field, such as data analytics/science, mathematics, computer science, etc. Designations/Certifications: None required Our home office is located in vibrant Columbia, Missouri - #6 in Livability's 2019 Best Places to Live. Other details <ul> <li> Pay Type Salary</li> </ul> Apply Now

Mtsi Data Analyst Interview Guide

Overview

Mtsi Data Analyst Salary

Mtsi Data Analyst Interview Process

Mtsi Data Analyst Interview Questions

Mtsi Data Analyst Jobs