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

Novus Data Analyst Interview Guide

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


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

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

Overview

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

Python

Machine Learning

Product Metrics

A/B Testing

Analytics

Statistics

Probability

Algorithms

Novus 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

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

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

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

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

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

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



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



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

Fractional Shares Metrics

Fractional Shares

What are time series models? Why do we need them when we have less complicated regression models?

What can happen if a traditional regression model is used on data that has autocorrelation?

What can happen if a traditional regression model is used on data that has autocorrelation?

Why Do We Need Time Series Models? I

Why can't standard regression models be used effectively for data points where current values are influenced by past values?

Why can't standard regression models be used effectively for data points where current values are influenced by past values?

Why Do We Need Time Series Models? II

Why Do We Need Time Series Models?

Novus Data Analyst Interview Questions

At Similarweb, we are revolutionizing the way businesses interact with the digital world by revealing to them everything that happens online. Our unique data and solutions empower over 4,300 customers globally, including industry giants like Google, eBay, and Adidas, to make game-changing decisions that drive their digital strategies. In 2021, we went public on the New York Stock Exchange, and we continue to reach new heights! Come work alongside Similarwebbers across the globe who are bright, curious, practical and good people. Were looking for a Data Analyst / Data Scientist to partner with our consulting team by delivering best-in-class data analysis for research projects for prospective and existing clients, and driving value for clients strategic business needs. This role will report to the Research Analytics Manager of Data Labs. Why is this role so important at Similarweb? Similarweb is more than just a data provider. We develop long-term and collaborative partnerships with our clients, and are constantly striving to help them make better business decisions using our data. One of the ways we do this is through our advisory services. As a Data Analyst, you will work with our team of Advisory Services Consultants and Data Engineering team, to create customized data analyses using Similarweb data. Your data analysis will support our prospective clients and existing clients strategic business needs, and help the business increase and retain customers. So, what will you be doing all day? Your role as part of the Data Labs Team means your daily responsibilities may include: Partnering with our in-house consultants and GTM teams to scope out custom data analysis projects for client Building models and utilizing sophisticated technology such as web scraping and AI to enrich datasets to target client pain points Collaborating with Data Engineering to ensure the existence of use-case specific data, and estimating the availability and effort required to produce specific custom reports Preparing and communicating customized data analysis to advisory services consultant, to ensure successful delivery to clients This is the perfect job for someone who: Demonstrates advanced proficiency in data analysis (Python, Excel, Tableau, SQL) Can use their analytical skills to drive business impact Has a general understanding of digital marketing trends Has experience in client-facing roles (preferred) Has experience working collectively with other teams and stakeholders to accomplish business goals Is able to apply relevant industry knowledge to solve specific client business needs, and demonstrate value within individual client use cases **At Similarweb, collaborating with our colleagues in-office creates a more connected, unified culture. Our best work is a product of our face-to-face collaboration, with the ability to work partially from home.** Why youll love being a Similarwebber: Youll actually love the product you work with: Our customers arent our only raving fans. When we asked our employees why they chose to come work at Similarweb, 99% of them said the product. Imagine how exciting your job is when you get to work with the most powerful digital intelligence platform in the world. Youll find a home for your big ideas: We encourage an open dialogue and empower employees to bring their ideas to the table. Youll find the resources you need to take initiative and create meaningful change within the organization. We offer competitive perks & benefits: We take your well-being seriously, and offer competitive compensation packages to all employees. We also put a strong emphasis on community, with regular team outings and happy hours. You can grow your career in any direction you choose: Interested in becoming a VP or want to transition into a different department? Whether its Career Week, personalized coaching, or our ongoing learning solutions, youll find all the tools and opportunities you need to develop your career right here. Diversity isnt just a buzzword: People want to work in a place where they can be themselves. We strive to create a workplace that is reflective of the communities we serve, where everyone is empowered to bring their full, authentic selves to work. We are committed to inclusivity across race, gender, ethnicity, culture, sexual orientation, age, religion, spirituality, identity and experience. Our culture of equality and mutual respect also helps us better understand and serve our customers in a world that is becoming more global, more diverse, and more digital every day. We will handle your application and information related to your application in accordance with the Applicant Privacy Policy available here, as applicable: https://www.similarweb.com/corp/legal/applicant-privacy-policies/ * Please note: Were unable to sponsor employment visas at this time.* #LI-DC #LI-Hybrid We will handle your application and information related to your application in accordance with the Applicant Privacy Policy available here.

<h3>Job Description</h3><div>Job Description<div>Description:At SCCS we are committed to leveraging data to drive strategic decision-making and innovation. Our team is dedicated to creating impactful solutions that improve efficiency and contribute to our overall success. We are looking for a motivated Entry Level Data Analyst to join our dynamic team. Job Summary:The Data Analyst will be a key member of the metrics and data integration team, working closely with the Data Analytics Manager, the MyEvolv (ME) Upgrade Team, and Program Directors/Managers depending on the particular project. The main role will be to work with data to provide reports on a weekly and monthly basis, along with valuable insights. This includes managing productivity data, client data such as diagnosis information, and metrics from quality software inputs, county and payor data sets, and various databases, primarily using Tableau and Excel. Key Responsibilities:· Perform ongoing data quality assessments, identify discrepancies/inconsistencies, and resolve them.· Collect, clean, and validate data from various sources.· Perform data analysis using statistical techniques and tools.· Generate routine reports weekly and create dashboards to communicate findings.· Assist in identifying trends, patterns, and anomalies in data.· Work with Data Analytics Manager to develop and maintain dashboards.· Collaborate with cross-functional teams to understand data needs and deliver actionable insights.· Support data quality initiatives and ensure the accuracy and integrity of data.· Contribute to the development and maintenance of databases and data systems.· Perform Ad-Hoc data requests.· Document data analysis and reporting architecture, designs, and user guides.· Perform other related duties as required and assigned. General Requirements:· Advanced-to-expert with Microsoft Word, Excel, and Microsoft Outlook.· Great communication skills, both verbal and written.· Ability to author and produce emails, letters, reports, and other documents professionally.· Ability to interact professionally and effectively with all levels of employees within the organization.· Excellent time management, organizational, and follow-through skills.· Ability to appear at work every day and on time. Driving to various locations on behalf of SCCS may be required.· Ability to follow directions from a supervisor.· Ability to understand and follow posted, printed, and/or electronic work rules and procedures.· Ability to accept constructive criticism in a respectful, open, and interactive manner.· Experience working with people over the phone or Zoom.· Must have the ability to perform efficiently and effectively with multiple interruptions.Requirements:Qualifications:· Bachelor’s degree in Mathematics, Economics, Computer Science, Information Management, or a closely related field.· Basic to intermediate proficiency in SQL.· Good understanding of relational databases, data cleaning, data mining concepts, and ETL.· Familiar with Business Intelligence tools and able to create and maintain online dashboards (Tableau, Power BI, or Sisense).· Proficiency in MS Excel, including V-lookups, H-lookups, and importing/exporting data from external sources, as well as pivot tables, is required. Experience with macros and VBA is a plus.· Highly analytical mindset with strong technical, strategic, and problem-solving skills.· Experienced in creating reports and analyzing data.· Strong work ethic and ability to work collaboratively within a team to execute on shared goals and deadlines.· Detail-oriented and capable of identifying and resolving data quality issues.· Able to work with minimal supervision.· At least 1 year of experience in data analytics, reporting, or related fields.· Must be authorized to work in the US. Preferred Qualifications:· Internship or project experience in data analysis or a related field.· Familiarity with data warehousing concepts and tools. Licensure, Registration, Certification:· Valid CA driver’s license and proof of automobile insurance. Management reserves the right to add, change, delete or rescind duties or responsibilities of positions within the job classification at any time. </div></div>

Description: Our client has an immediate need for a Business/Data Analyst, who will be responsible for working with complex information systems and developing or modifying existing systems through analysis of business and user needs. Requirements: Associate's degree in Computer Science, Computer Engineering or other related field 2 - 4 years of experience Experience with Excel and SQL Experience with Jira Experience withPEP plus (Fiserv) Strong facilitation and presentation skills Ability to resolve minor conflicts/issues using different tactics prior to escalation Knowledge of cost/benefit analysis, risk assessment, and quantification methodologies Demonstrated ability in the following methods: interviewing, data modeling, business process modeling, business object modeling and user interface design Knowledge of computer software Ability to work independently Organized with strong time management ACH or Online Banking Platform experience is a plus Responsibilities: Coordinates detailed business requirements while identifying and tracking business systems issues Research and document sponsor/stakeholder needs in accordance with Project Life Cycle methodology utilizing reporting tools, requirements gathering methodologies, process models, data models, and prototypes Estimate activities required to perform requirements gathering and acceptance testing improving accuracy over time Recommend business solutions that satisfy sponsor/stakeholder needs continually exploring and assessing options for value-add for clients May complete end-user documentation and prepare training material. Execute and document test plans to ensure quality Perform unit testing and integration testing Troubleshoot problems with systems Maintain systems to optimize performance Document systems Why Work for ConsultUSA: ConsultUSA offers competitive salaries, major medical (PPO or HDHP w/ HSA), dental, and vision insurance plans, and 401k plan with immediate eligibility for both salary and hourly employees ConsultUSA hosts several outings and events, holiday and summer parties, and volunteer opportunities throughout the year for employees We will work with you to obtain training for in-demand technologies and prepare you for industry-recognized certification exams ConsultUSA offers Business Analysis and Project Management training through our Project Management Institute (PMI) award-winning sister company, PMCentersUSA How to Apply: To submit your application, please click the Apply Now button located at the top and bottom of the page. ConsultUSA is committed to providing equal employment opportunities (EEO) to all qualified employees and applicants for employment without regard to race, color, religion, gender identity or expression, sexual orientation, national origin, age, disability, genetic information, marital status, pregnancy, ancestry, or status as a covered veteran as well as any other prohibited criteria under any applicable federal, state, and local laws applicable to ConsultUSA. For a complete listing of all ConsultUSA jobs please visit www.consultusa.com

<h3>Job Description</h3><div>Job Description<div>Supply Chain Data AnalystRef No: 1391Location: Racine, WIOur team is partnering with a dynamic $1B pharmaceutical company that is driven to help make people look and feel better. After going through a reorganization moving from a regional to a global focus, and building a Supply Chain Center of Excellence, they now are looking to add a Supply Chain Data Analyst to lead data-driven decision making to ultimately increase overall supply chain efficiency around the world.Position Description:<ul><li>Reporting to the Director of Global S&OP, this role will leverage analytical tools such as PowerBI, SQL, Excel, etc. to drive supply chain analysis in support of the demand- and supply planning teams to ensure optimal balance of inventory and service levels.</li><li>The ability to work closely with Executives, including the VP of Operations and the COO.</li><li>Work cross-functionally to build KPI’s and ensure timely information and data accuracy to drive business decisions.</li><li>Partner with IT to develop roadmaps for planning tools that drive service improvements and cost-saving opportunities.</li></ul>Background Required: <ul><li>Highly energetic individual with at least 2-5 years of solid analytical depth driving analysis in support of integrated business planning and other aspects of supply chain.</li><li>Strong working knowledge of Tier-1 planning applications, Business Intelligence tools (i.e. Power BI, Qlik Sense, MicroStrategy, Tableau, etc.) and Excel.</li><li>Proven track record of success in similar role.</li><li>Bachelor's degree required.</li></ul>Miscellaneous:<ul><li>Compensation commensurate with experience.</li><li>Full benefit package including medical, dental and 401(k).</li><li>Great work/life balance - 4 weeks’ vacation, 15 paid holidays and a company shutdown the week of Christmas.</li><li>Hybrid schedule – 3 days onsite, 2 remote.</li><li>Sorry, but no Visa sponsorship available.</li></ul></div></div>

Title: Sr. Behavioral Health Data Analyst #Open (if applicable): 1 Location: Remote - MUST BE IN SENTARA APPROVED STATE!!! This is a contract to hire role! Start: 4/15/24 Duration: 6 month Contract to hire Work Auth: No OPT CPT H1B Sentara Approved States-: Alabama, Delaware, Florida, Georgia, Idaho, Indiana, Kansas, Louisiana, Maine, Maryland, Minnesota, Nebraska, Nevada, New Hampshire, North Carolina, North Dakota, Ohio, Oklahoma, Pennsylvania, South Carolina, South Dakota, Tennessee, Texas, Utah, Virginia, Washington (state), West Virginia, Wisconsin, Wyoming Why Open: working on partnership with new Enterprise behavioral health VP - joined Sentara a few months ago. Pulling in hospital acute, payer side, etc. (moving away from little silos of teams throughout analytics) pulling it together - behavior health hasn't had a devoted focus/space within analytics at Sentara Health yet. VP has goals she's trying to push out - need someone to come in push out road map with her - REALLY need Behavioral Health experience. Want EPIC, hospital acute side, payer side, provider side… Important Skills (Definitely Data Analyst) Technical - EPIC (requirement) (flow sheets - Epic: behavioral health patient data PLUS*) STRONG SQL Experience: Writing Queries - critical Agile Scrum methodology Worked on Power BI with tableau Any experience assisting stakeholder with roadmap; consultative experience Must Haves Bachelors must have - business analytics; hospital admin (possibly); background of having worked through analytics; health administration. Day To Day VP would be prioritizing this person's work; but reporting into Melanie. There will be a number of objectives that candidate will work through. Bunch of strategy sessions within this team. One may be goal to provide a way to improve access to care. Team expectations of this candidates : May need data to implement new programs across the system for behavioral health - may need data tools that would show what telesite services are doing (have telesites svcs throughout org. - help identify what do they look like? Help identify how to set goals to those and track what's happening- set actionable insights…) Work on project that provides patient consumer feedback and build tools that can connect us to that data and compare to their goals. There are so many metrics that the business is requesting and this team is trying to narrow what they can build for them - one stop shot but makes sense Want UM Dashboard; looking at claims approvals denials; finance data side. This person would be prioritizing the objectives with (VP) and then coming up with the most important builds first for these types of requests. This candidate will start with a clean slate - they have one tool looking at payer and provider side and wants to build on that and this person will work with vp to pull in data for these objectives. Additionally - more high level overview of what to expect day to day provided by Dir: This person is doing agile methodology day to day Meet with stakeholders; create deliverables; iterate delivery; get a roadmap; execute roadmap; return Requirements gathering and delivery; what are goals; do that build.
#J-18808-Ljbffr

Title: Sr. Behavioral Health Data Analyst #Open (if applicable): 1 Location: Remote – MUST BE IN SENTARA APPROVED STATE!!! This is a contract to hire role! Start: 4/15/24 Duration: 6 month Contract to hire Work Auth: No OPT CPT H1B Sentara Approved States-: Alabama, Delaware, Florida, Georgia, Idaho, Indiana, Kansas, Louisiana, Maine, Maryland, Minnesota, Nebraska, Nevada, New Hampshire, North Carolina, North Dakota, Ohio, Oklahoma, Pennsylvania, South Carolina, South Dakota, Tennessee, Texas, Utah, Virginia, Washington (state), West Virginia, Wisconsin, Wyoming Why Open: working on partnership with new Enterprise behavioral health VP – joined Sentara a few months ago. Pulling in hospital acute, payer side, etc. (moving away from little silos of teams throughout analytics) pulling it together – behavior health hasn't had a devoted focus/space within analytics at Sentara Health yet. VP has goals she's trying to push out – need someone to come in push out road map with her – REALLY need Behavioral Health experience. Want EPIC, hospital acute side, payer side, provider side… Important Skills (Definitely Data analyst) Technical – EPIC (requirement) (flow sheets – Epic: behavioral health patient data PLUS*) STRONG SQL Experience: Writing Queries – critical Agile Scrum methodology Worked on Power BI with tableau Any experience assisting stakeholder with roadmap; consultative experience Must Haves: Bachelors must have – business analytics; hospital admin (possibly); background of having worked through analytics; health administration. Day to Day: VP would be prioritizing this person's work; but reporting into Melanie. There will be a number of objectives that candidate will work through. Bunch of strategy sessions within this team. One may be goal to provide a way to improve access to care. Team expectations of this candidates : May need data to implement new programs across the system for behavioral health – may need data tools that would show what telesite services are doing (have telesites svcs throughout org. – help identify what do they look like? Help identify how to set goals to those and track what's happening- set actionable insights…) Work on project that provides patient consumer feedback and build tools that can connect us to that data and compare to their goals. There are so many metrics that the business is requesting and this team is trying to narrow what they can build for them – one stop shot but makes sense Want UM Dashboard; looking at claims approvals denials; finance data side. This person would be prioritizing the objectives with (VP) and then coming up with the most important builds first for these types of requests. This candidate will start with a clean slate – they have one tool looking at payer and provider side and wants to build on that and this person will work with vp to pull in data for these objectives. Additionally – more high level overview of what to expect day to day provided by Dir: This person is doing agile methodology day to day Meet with stakeholders; create deliverables; iterate delivery; get a roadmap; execute roadmap; return Requirements gathering and delivery; what are goals; do that build .

CINQCARE Senior Healthcare Economics Data Analyst Position Description Overview The Senior Healthcare Economics Data Analyst reports to the Senior Vice President of Healthcare Economics and Analytics, CINQCARE, Inc., with accountability for data analytics support for the company's ACOs (with particular attention on CMS's ACO REACH model) and value-based care initiatives. This position is primarily responsible for providing analytical via the development of reporting solutions and decision analysis from a variety of data sources. The analyst will perform research and analysis of multiple data sources, including clinical and claims data, to meet business performance reporting needs. The analyst will be required to effectively communicate key findings to the executive team and support to the President ACOs and Value-Based Care Innovations, CINQCARE, Inc., and assist in presenting the results to wider audiences as applicable. The analyst must possess solid research skills, excel at written and verbal communication, and have the proven ability to manage multiple assignments of varying depth and duration. The Sr HCE Data Analyst should embody CINQCARE's core values, including Trusted, Empathetic, Committed, Humble, Creative and Community-Minded. At CINQCARE, we don't have patients or customers - we have Family Members. Job Responsibilities The Sr HCE Data Analyst will have the following responsibilities: <ul> <li>Interface, coordinate with, support and be accountable to the President, ACOs and Value-Based Care Innovations, CINQCARE, Inc. </li><li>Use quantitative and data science skills, collect, manage, analyze, and assess data of multiple types and sources related to CINQCARE ACOs and value-based care initiatives. </li><li>Manage file transfer from the CMS 4i system, file processing, and file ingestion into SQL Server environment. </li><li>Provide subject matter expertise support to data architect and developers regarding data integration, data warehousing, modeling, database, and technical aspects of reporting via business intelligence tools. </li><li>Provide oversight of data quality and provides feedback to various areas to improve service delivery and enhance operational design efforts. </li><li>Document reporting parameters and maintains version controls. </li><li>Create queries of moderate complexity using T-SQL and other query languages, ensuring data accuracy and that results meet intended requirements. </li><li>Compile, manipulate, and analyze CMS CCLF and related claims files to identify trends and variances for patients receiving medical care. </li><li>Support the transformation of raw data into valuable and meaningful insights in the form of appealing dashboards and reports via both Power BI and advanced Excel applications (e.g., levering external PowerShell scripts). </li><li>Prepare ad hoc reports from clinical and/or financial data, using Microsoft Office applications including Word, Access and Excel, Tableau, and other similar business intelligence tools to meet business and clinical performance reporting needs. </li><li>Provides analytics that support new approaches to system-wide models for delivering health care and improving the health of populations including Accountable Care Organizations models and shared savings programs. </li><li>Stay current with updates on technology tools and available data sets relevant to programs of interest to CINQCARE and the use of various analytic techniques. </li><li>Perform other job-related duties. </li></ul>General Duties The Sr HCE Data Analyst will have the following duties: <ul> <li>Leadership: The Sr HCE Data Analyst will lead in defining and executing strategies and solutions to create business value for CINQCARE, including collaborating with their team to design, develop, and execute those strategies and solutions to deliver desired outcomes. </li> <li>Strategy: The Sr HCE Data Analyst will establish the business strategy and roadmap: (1) improve outcomes for CINQCARE Family Members; (2) enhance the efficacy of other CINQCARE business divisions; and (3) develop and deliver external market opportunities for CINQCARE products and services. In establishing the business strategy, the Sr HCE Data Analyst will define and innovate sustainable revenue models to drive profitability of the Company. </li> <li>Collaboration: The Sr HCE Data Analyst will ensure that CINQCARE's capabilities form a cohesive offering, including by working closely with other business divisions to learn their needs, internalize their knowledge, and define solutions to achieve the business objectives of CINQCARE. </li> <li>Knowledge: The Sr HCE Data Analyst will provide subject matter expertise in Medicaid, Medicare, and dual eligible solutions, including determining and recommending approaches for mitigating risk solution deployment and performance evaluation. </li><li>Culture: The Sr HCE Data Analyst is accountable for being hands-on in the field and for creating a productive, collaborative, safe and inclusive work environment for the team and as part of the larger Company. The Sr HCE Data Analyst demonstrates a willingness to listen effectively and communicate with respect, thoughtfulness, and transparency. </li></ul>Qualifications The Sr HCE Data Analyst should have the following qualifications: <ul> <li>Education/Experience: <ul> <li>Bachelor's degree in Computer Science, Business, Economics, or Healthcare Administration or related field; Master's degree preferred. </li><li>At least 3 years' experience with relational databases, report building and or data analysis is required. </li><li>Experience with clinical applications such as electronic medical records preferred. </li><li>At least 3 years of experience working with healthcare analytics projects using medical claims data is preferred. </li><li>Experience working with Medicare data is strongly preferred. </li><li>Experience with CMS CCLF sources, HCC risk coding, and shared risk/savings contracts strongly preferred. </li><li>Experience with CMS 4i system is strongly preferred. </li><li>Understanding of, and familiarity with, accountable care organizations preferred. </li></ul> </li><li>Computer Knowledge: <ul> <li>An advanced level of proficiency working with Microsoft Office Tools (Excel, Word, PowerPoint etc.) is required. </li><li>Experience using SQL, SQL Server, and T-SQL is required. </li><li>Previous experience automating processes and securely transmitting data via SFTP using command scripts is strongly preferred. </li><li>Advanced Excel skills levering external PowerShell scripts is strongly preferred. </li><li>Experience with PowerBI is preferred. </li></ul> </li></ul><ul><li>Entrepreneurial: CINQCARE seeks to fix gaps that have persisted for generations in the delivery of care to Black and Brown populations. This position is accountable for ensuring CINQCARE is positioned to innovatively deliver on its promise. </li><li>Communication: Excellent verbal, written, presentation, and group facilitation skills; ability to clearly articulate and present concepts and models in an accessible manner to CINQCARE's team, partners, and other stakeholders. Must have strong critical analytic, thinking and communication skills necessary to evaluate andrespond to team progress, anticipate needs and other related team dynamics. </li><li>Professional Demeanor: Ability required to collaborate in a matrixed environment with a strong focus on the attainment of organizational goals and objectives through a commitment to teamwork. Expert problem-solving skills, attention to detail, working against deadlines and communicating status of project, and natural curiosity and drive towards understanding the health trends of a population. Excellent oral and written communication skills including the ability to present complex information effectively with a wide range audience. Ability to prioritize multiple projects and assignments; work independently as well as in a team environment; and deal effectively with complex assignments and essential projects. </li><li>Culture: Good judgement, impeccable ethics, and a strong team player; desire to succeed and grow in a fast-paced, demanding, and entrepreneurial Company. </li></ul> Location: D.C Compensation: $85,000-$95,000

About Alchemy Worx: Alchemy Worx is an audience management agency specializing in email and SMS marketing. The agency offers businesses advanced marketing services, utilizing time-tested methods, and procedures to secure a higher customer retention rate. In the reporting and analytics process, the team dissects and analyzes the email list, mailing style, and frequency to determine the campaign quality, health, and effectiveness of email and SMS. After reviewing all KPIs, the analytics team builds predictive models for benchmarking purposes and creates a strategy to hit those benchmarks. We are looking for a tech-savvy person who is ambitious and an aggressive self-starter. The ideal candidate will be based in NYC (hybrid role, with the expectation of 3 days a week in-office) and should be able to manage data analytics, run reports, and excel in a client-facing role. What You'll Do: <ul> <li> Data Analysis: Dive into large sets of data to extract actionable insights to help drive strategic decisions</li> <li> Strategy Development: Contribute to strategic planning based on data-driven insights.</li> <li> Client Interaction: Engage with clients to communicate data-driven insights and recommendations</li> <li> Collaboration: Work closely with cross-functional teams of data analysts, designers, account strategists, and others across the company who are passionate about the company's success</li> <li> Data Pipeline: Manage an efficient, comprehensive, and accurate reporting & analytics reporting process done by on-shore and offshore teams</li> <li> Email Expertise: Develop a thorough understanding of email user data flow, recommend best practices, and develop self-serve reports to monitor customer email data hygiene</li> </ul> Who You Are: <ul> <li>You have a deep passion, curiosity, and understanding of advanced data analysis and a strong business sense</li> <li>You are a self-starter, problem solver, resourceful, and work with limited supervision</li> <li>You are flexible and able to manage multiple tasks and deadlines</li> <li>You can work within a globally dispersed team</li> <li>You are a strong verbal and written communicator and an excellent collaborator who values building strong relationships with colleagues, clients, and other stakeholders</li> <li>You can understand complex topics/processes/problems and explain them to your colleagues in layman's terms</li> <li>You are customer, results, and solutions-oriented</li> </ul> Requirements <ul> <li>E-commerce experience required</li> <li>2+ years of experience in a role that required advanced analytics, extensive reporting, and abstracting insights/recommendations from large datasets</li> <li>1+ years of experience in business or marketing analytics, ideally email or digital marketing</li> <li>Excellent knowledge of Excel</li> <li>University degree in science, computer science, statistics, economics, mathematics, or similar quantitative discipline</li> </ul> Preferred Skills / Experience: <ul> <li>Project Management Experience</li> <li>Management and communication with globally dispersed teams</li> <li>Coding and Database Skills</li> <li>Knowledge of Tableau or Data Studio</li> <li>Knowledge of Email Service Provider Platforms and email campaign building</li> <li>Knowledge of SQL, Python, or R</li> <li>Ability to build predictive models and cluster analysis models in Python OR R</li> </ul> Benefits <ul> <li>Salary range: $70,000 - $90,000</li> <li>Unlimited PTO policy</li> <li>Fully covered medical, dental and vision insurance</li> <li>401k with company match</li> <li>Hybrid team, with both main office and remote team members</li> </ul>

Job Description Skills and Abilities: <ul><li>Data analysis and reporting</li><li>Ability to read and interpret policy and law, including: Virginia Procurement law and policy (VPPA and APSPM), etc.</li><li>Leadership, including working leader</li><li>Oral and written Communication skills</li><li>Strong understanding and implementing of change management</li><li>Communicate clear daily progress updates</li></ul> Job Duties: Description Deliverable Change Orders: - Design and build required monthly reports - Change Orders Rpt Produce monthly reports on defined schedules and submit communication - Confirming Orders Rpt and associated communications - Change Orders Rpt and associated communications Confirming Orders and Change Orders - Analyze data and provide assessments and recommendations to team members - Assessments - Recommendations Additional Reporting needed in support of procurement initiatives - Design and build - Produce reports as needed - Analyze data and provide assessments and recommendations to team members - New Reports - Assessments - Recommendations In support of OCM for the Initiative: Complete deep dive review of data and meet one on one with customers (e.g. Colleges) OCM Support: - College data Assessments - College data Recommendations Identify impacts or changes needed to policies and procedures (e.g. Business Rules, Job Aids, Procedures) - Policy, Procedure impact analysis and recommendations Draft procedures and gain approvals - Procedures that capture the effort required in the: o design, development of reports o data analysis and o subsequent recommendations Create end-user training content in support of the OCM for the changes needed to improve compliance. - End user training content In support of the L2 initiative, conduct necessary research, including: state laws, policies, comparisons to other Higher Eds in VA, other VA agencies, and other states as needed. - Comparative assessments Requirements Required / Desired Skills Skill Required / Desired Amount of Experience Design and build required monthly reports Required 5 Years Produce monthly reports on defined schedules and submit communication Required 5 Years Analyze data and provide assessments and recommendations to team members Required 5 Years Identify impacts or changes needed to policies and procedures (e.g. Business Rules, Job Aids, Procedures) Required 5 Years Create end-user training content in support of the OCM for the changes needed to improve compliance Required 5 Years Strong understanding and implementing of change management Required 5 Years Data analysis and reporting Required 5 Years Ability to read and interpret policy and law, including: Virginia Procurement law and policy (VPPA and APSPM) Desired 5 Years

Novus Data Analyst Interview Guide

Overview

Novus Data Analyst Salary

Novus Data Analyst Interview Process

Novus Data Analyst Interview Questions

Novus Data Analyst Jobs