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

Aurora Data Analyst Interview Guide

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


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

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

Overview

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

Aurora Data Analyst Interview Process

As part of the financial management in a large corporation, the CFO wants to review the expenses in all departments for the previous financial year (2022).

Write a SQL query to calculate the total expenditure for each department in 2022. Additionally, for comparison purposes, return the average expense across all departments in 2022.

Note: The output should include the department name, the total expense, and the average expense (rounded to 2 decimal places). The data should be sorted in descending order by total expenditure.

<h3>Example:</h3>

Input:

<code>departments</code> table

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

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

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

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

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

<tr>
<td>department_id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>amount</td>
<td>FLOAT</td>
</tr>

<tr>
<td>date</td>
<td>DATE</td>
</tr>
</tbody>
</table>
Output:

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

<tbody>
<tr>
<td>department_name</td>
<td>VARCHAR</td>
</tr>

<tr>
<td>total_expense</td>
<td>FLOAT</td>
</tr>

<tr>
<td>average_expense</td>
<td>FLOAT</td>
</tr>
</tbody>
</table>

Calculate total and average expenses for each department.

Department Expenses

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

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

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

Example:

Input:

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

Output:

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

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

Rain in N Days

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

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

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

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

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

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



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



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

Fractional Shares Metrics

Fractional Shares

Aurora Data Analyst Interview Questions

Job Title: Data Analyst Location: Montgomery, AL (onsite 5 days a week) Tax Term: W2 Job Type: Contract Duration: LongTerm Interview: Video Interview Pay Range: $40/hr. - $45/hr. on W2 Job Description: Responsibilities:<ul> <li>Collaborate with the agency's analytic staff to enhance data-driven decision-making.</li> <li>Provide on-site help desk support to address technical issues and user inquiries.</li> <li>Develop and deliver Power BI reports upon request from the agency.</li> <li>Conduct data analysis to support the agency's needs and objectives.</li> <li>Assist the Analytics Manager in the creation and refinement of Power BI reports and dashboards. </li></ul> Skills/Attributes:<ul> <li>Power BI: 3+ years of experience in report creation and data visualization.</li> <li>SQL: 3+ years of experience in database querying and management.</li> <li>Medicaid Knowledge: 3+ years of experience with Medicaid data and regulations.</li> <li>Snowflake: 1+ year of experience (preferred, but not mandatory).</li> <li>Healthcare Database Data Warehousing: Proficient in data warehousing concepts and practices within the healthcare sector.</li> <li>Medicaid experience or MMIS or Medicare experience </li></ul> What does the ideal candidate background look like (ex: healthcare specific background, etc.)? <ul> <li>Strong Medicaid Data Analyst with a solid understanding of Medicaid systems and data. </li> </ul>

<h3>Job Description</h3><div>Job Description<div>Welcome! At Digital Infuzion, we believe that everyone deserves to live a better, healthier life. That's why we're dedicated to providing life science researchers with faster insights and health providers with on-demand data and tailored software solutions. Our passion for developing innovative healthcare solutions goes beyond ordinary health IT services to include comprehensive translational research support. If you're looking for a creative, open, and growth-oriented environment where you can do what you love while helping people live healthier lives, then keep scrolling - we may have just the opportunity for you.  Career Opportunity  Are you seeking an opportunity to use your analytical skills to drive healthcare advancements? We're seeking a detail-oriented Data Analyst to join our team. As a Data Analyst,  in collaboration with stakeholders, including program directors, data scientists, and a data analytics lead, you will analyze and map data from multiple sources to generate metrics reports, visualizations, and dashboards that support evidence-based decision-making. If you're passionate about using data to drive innovation and have a keen eye for detail, this role perfectly fits you. Join us and make a difference in the healthcare industry!  Position Overview  We seek a passionate and detail-oriented Data Analyst to join our growing team. As a critical member of our team, you'll have the opportunity to influence the development of our clinical support services and assist with shaping the ongoing strategy and mission of our client's program. If you're excited about being part of a dynamic and innovative environment where you can make a meaningful impact, this is your perfect role. Join us and help drive advancements in healthcare!  Responsibilities   Data Entry:<ul><li>Retrieve and organize data from databases for data entry, reporting or analysis.</li><li>Review and verify data for accuracy and completeness before entering into systems.</li><li>Input various types of data into the designated database systems </li><li>Ensure data quality and integrity by identifying errors and inconsistencies and making necessary corrections</li><li>Regularly update and maintain databases, ensuring that records are current and accurate.</li><li>Ensure that sensitive data is handled securely and in compliance with data privacy policies and regulations.</li></ul>Data Analysis: <ul><li>Perform appropriate data preprocessing steps to prepare data for ingestion into pipelines</li><li>Conduct in-depth analysis of clinical trial and clinical trial operations data</li><li>Monitor key study metrics using tracking tools, providing timely and quality updates </li></ul><ul><li>Identify trends, patterns, and anomalies in clinical trial data that may require further investigation or action. </li><li>Create clear and informative data visualizations, graphs, and dashboards to present key findings to DSMB members and stakeholders. </li></ul>Quality Control: <ul><li>Ensure the accuracy and integrity of data included in the analysis</li><li>Identify and report clinical study data-related issues affecting data quality and impeding data import. </li><li>Support internal audits by providing requested data and participating in quality checks.</li></ul>Reporting: <ul><li>Generate regular and ad-hoc reports </li><li>Present reports to clients, program/project staff, and external stakeholders via multiple modalities, i.e., emails, teleconference meetings, etc. </li></ul>Communication: <ul><li>Collaborate with stakeholders to communicate data findings, answer questions, and provide insights during meetings. </li><li>Collaborate with stakeholders to improve reports and refine analyses</li><li>Anticipate and respond to client needs and provide accurate and timely status updates. </li></ul>Documentation: <ul><li>Maintain detailed documentation of data analysis processes, methodologies, and results. </li><li>Independently validate work products and deliverables before QA and reconcile inconsistencies. </li></ul>Continuous Improvement: <ul><li>Stay current with the industry's best clinical trial data analysis practices and contribute to process improvements. </li></ul>Compliance: <ul><li>Ensure compliance with regulatory requirements, data privacy standards, and company policies. </li></ul> Requirements<ul><li>Bachelor's degree in a relevant field or equivalent education and experience. </li><li>Minimum of 3 years of data analysis experience, with a preference for clinical research, clinical trial, or healthcare backgrounds. </li><li>Comfortable using Python and Jupyter notebooks</li><li>Providing visualizations using software platforms, PowerBI</li><li>Meticulous attention to detail and accuracy, including precise proofreading abilities. </li><li>Strong interpersonal skills, enabling rapid relationship-building with internal and external stakeholders. </li><li>Exceptional written and oral communication skills, emphasizing problem-solving and process enhancement. </li><li>Proficiency in facilitation, complemented by outstanding presentation capabilities. </li><li>Adaptable to shifting priorities, demonstrating autonomy with minimal supervision. </li></ul> Digital Infuzion, LLC is an Equal Opportunity Employer. EOE/AA/M/F/D/V   Digital Infuzion, LLC’s policy is to provide equal employment opportunities without regard to race, color, religion, sex, gender identity, sexual orientation, national origin, age, disability, marital status, veteran status, genetic information, or any other protected characteristic under applicable law.   Powered by JazzHRbxUFAKQlJm</div></div>

Non-competitive: bachelor's degree and either: satisfactory completion of a two-year traineeship or two years of experience* in data visualization, and statistical models and data mining tools. Substitution: A master's degree in data or computer science, informatics, economics, statistics, mathematics, or a related field, may substitute for one year of the specialized experience. A Ph.D. in the above fields may substitute for two years of the specialized experience. Preferred Qualifications: •Proficiency in Excel, Tableau, and SAS strongly preferred, ArcGIS, and R , knowledge also helpful. •Experience working with large datasets; including importing, merging data, and validation. •Comfortable with presenting and explaining data analyses methods and results to both technical and public audiences. •Able to respond to requests quickly and manage multiple priorities. * The salary range listed in this posting reflects the full range for this graded position, factoring in annual performance advances based on satisfactory annual performance reviews. Candidates with no previous State service will begin at the hiring rate (starting rate of the salary range) listed above, plus any applicable Location Pay/Geographic Pay/Shift Pay differentials. Promotion salaries are calculated by the NYS Office of the State Comptroller in accordance with NYS Civil Service Law, OSC Payroll rules and regulations and negotiated union contracts. Duties Description Under the direction of Head of the Prevention Data Management Unit and Analysis, the Data Analyst 1 duties include but are not limited to: •Extracting and performing analysis of prevention data to identify data quality issues. •Providing summaries or reports related to program and provider data. •Responding to provider requests for technical assistance as received by email and phone. •Supporting implementation of enhancements and system updates in the prevention data system and related data collection systems. •Working with external vendor and other internal customers to improve/maintain functionality of internal systems. •Reviewing and resolving any issues related to new provider and new program requests. •Contacting providers regarding data entry and reporting compliance issues, and assisting with resolution of data entry issues. •Reviewing and suggesting improvements to current or planned processes. •Utilizing SQL Server Reporting Services (SSRS) Reports, Excel, and Oracle analytical tools as needed. •Working with cross-functional teams to interpret data and support decision-making processes. •Applying knowledge of statistical methods and data mining techniques to uncover patterns, trends, and insights. •Other relevant duties as assigned. Additional Comments Excellent Health Insurance Benefits Including Vision and Dental, NYS Employees Retirement System (Pension), Optional Deferred Compensation, Continuing Education Benefits, Generous Paid Leave Benefits, Compensation for 12 State holidays per year. Telecommute may be discussed at interview. Some positions may require additional credentials or a background check to verify your identity. Name Office of Human Resources Management Telephone (518) 457-2963 Fax (518) 457-4880 Email Address Recruitment@oasas.ny.gov Address Street NYS Office of Addiction Services and Supports 1450 Western Avenue, 3th Floor City Albany State NY Zip Code 12203 Notes on Applying Please submit a resume and cover letter clearly indicating your qualifications. Please be sure to include Reference Code BK/DA1/50112/PRIME. Failure to include this code could result in your application not being processed.

Job Title: Data Analyst Duration: 12 MonthsLocation: San Jose, CA 95110 Pay Rate: $66.2 per hour on W2 Intelliswift Software Inc. conceptualizes, builds, and supports the world's most amazing technology products and solutions. Our team of rich experts from diverse backgrounds contributes to making Intelliswift one of the most reliable partners in IT and Talent solutions. We specialize in delivering world-class Digital Product Engineering, Data Management and Analytics, and Staffing Solutions services to Fortune companies, SMBs, ISVs, and fast-growing start-ups. Job Description:<ul><li>Drive analytics for Document Cloud to unlock growth and monetization opportunities and hypothesis tests (A/B testing's) through analyzing results and communicating insights and recommendations.</li><li>Partner with cross-functional/cross-regional team including growth managers, product manager, GTM, finance, and engineering's to understand monetization opportunities, product/customer behavior and features, and use insights generated to make recommendations to improve customer experience and drive monetization.</li><li>Be a specialist of stitching and calibrating sparse and noisy data across various data sources.</li><li>Support regular ad-hoc data and analysis needs to better understand customer behavior, end-to-end customer journey, and monetization path.</li><li>Define metrics/reporting frameworks and design and implement reporting dashboards and track Key Performance Indicators and provide useful insights.</li></ul> Requirement:<ul><li>Expertise in statistical analysis, hypothesis testing, and A/B test analytics.</li><li>Expertise in working with large data sets using SQL.</li><li>Strong analytical and quantitative problem-solving ability.</li><li>Ability to synthesize large scale data sets to generate a clear story and impactful insights to senior/cross-functional stakeholders.</li><li>Excellent oral and written communication skills.</li><li>Ability to work with stakeholders across different time zone.</li><li>Hands-On coding experience with at least one programming language (Python/R).</li><li>Hands-on experience working with Cloud Platform e.g. Databricks. Ability to build and run data pipelines in Cloud.</li><li>Experience in developing sophisticated reports/dashboards using Tableau & Power BI.</li><li>Good attention to detail and ability to stitch and QA multiple data sources.</li><li>Adobe Analytics or Customer Journey Analytics experience is a plus.</li></ul> Equal Employment Opportunity StatementIntelliswift celebrates a diverse and inclusive workforce. We offer equal employment opportunities to all applicants and employees. All qualified applicants will be considered regardless of race, color, sex, gender identity, gender expressions, religion, age, national origin or ancestry, citizenship, physical or mental disability, medical condition, family care status, marital status, domestic partner status, sexual orientation, genetic information, military or veteran status, or any other protected basis under the law. Americans with Disabilities Act (ADA)If you require a reasonable accommodation in completing this application, interviewing, completing any pre-employment testing, or otherwise participating in the employee selection process, please contact Intelliswift Human Resources Department Other Employment StatementsIntelliswift participates in the E-Verify program. Learn MoreFor information on Intelliswift Software, Inc., visit our website at <a>www.intelliswift.com</a>.

Overview: Join Virginia Housing and help make a difference as a Senior Business Data Analyst.This important role will function as an expert advocacy and translation layer between various core business divisions with their requirements and technical implementations of various data solutions, providing strategic, analytical, and technical support for data and analytics activities. This role conducts data analysis, usage requirements and focuses on data reporting and integration-intensive initiatives that drives valuable business outcomes. The analyst leverages data and technology tools to gain key insight into business opportunities, identifies technical solution possibilities, and effectively presents these insights to business stakeholders. They are responsible to identify business challenges, opportunities related to data and analytics, initiate data project requests and engage with business partners to influence project decisions; assess the risks of various solutions and help prioritize competing business demands.They are responsible for working with business partners to elicit high-level requirements and capture business needs; understand the customer journey and define user requirements. Help with prioritizing needs within and across projects based on business impact. This role is expected to use modern data and analytics tools to gather data, analyze problems, aid with designs, monitor progress and facilitate delivery of data solutions. Virginia Housing is one of the nations premier housing finance agencies. Our mission is to help Virginians attain quality, affordable housing, which we accomplish through our public-private partnerships. We are focused on employee engagement and committed to a healthy and diverse workforce. We offer on-site conveniences such as a fitness center and free parking. Educational opportunities to help your advancement are available through classroom and online programs.To be successful in this role you must possess: <ul style="margin-top: 0in; margin-bottom: 0in;" type="disc"><li style="margin-bottom: 0in; line-height: normal; margin-top: 0in; margin-right: 0in; font-size: 11pt; font-family: Calibri, sans-serif;">Bachelor's degree in computer science, business administration with data engineering focus, or equivalent experience; Masters degree preferred. </li><li style="margin-bottom: 0in; line-height: normal; margin-top: 0in; margin-right: 0in; font-size: 11pt; font-family: Calibri, sans-serif;">Several years of experience in data & analytics and delivering business value through focused data initiatives </li><li style="margin-bottom: 0in; line-height: normal; margin-top: 0in; margin-right: 0in; font-size: 11pt; font-family: Calibri, sans-serif;">Several years of experience in contributing to a data quality, master data, data cataloging and advanced analytics disciplines, with three to five year experience preferred. </li><li style="margin-bottom: 0in; line-height: normal; margin-top: 0in; margin-right: 0in; font-size: 11pt; font-family: Calibri, sans-serif;">A few years of experience in technology architecture, operations, and design related disciplines.</li><li style="margin-bottom: 0in; line-height: normal; margin-top: 0in; margin-right: 0in; font-size: 11pt; font-family: Calibri, sans-serif;">Expert knowledge of data analysis and usage requirements assessment and recording</li><li style="margin-bottom: 0in; line-height: normal; margin-top: 0in; margin-right: 0in; font-size: 11pt; font-family: Calibri, sans-serif;">Strong understanding of data and integration architectures </li><li style="margin-bottom: 0in; line-height: normal; margin-top: 0in; margin-right: 0in; font-size: 11pt; font-family: Calibri, sans-serif;">Influencing skills and demonstrated ability to engage both data developers and business partners to achieve target outcomes </li><li style="margin-bottom: 0in; line-height: normal; margin-top: 0in; margin-right: 0in; font-size: 11pt; font-family: Calibri, sans-serif;">Ability to guide solution design and architecture to meet business needs </li><li style="margin-bottom: 0in; line-height: normal; margin-top: 0in; margin-right: 0in; font-size: 11pt; font-family: Calibri, sans-serif;">Proficiency in modern data and analytics tools on-premise and in the cloud</li><li style="margin-bottom: 0in; line-height: normal; margin-top: 0in; margin-right: 0in; font-size: 11pt; font-family: Calibri, sans-serif;">Good understanding of Data Management Body of Knowledge principles from DAMA or similar industry D&A leaders</li><li style="margin-bottom: 0in; line-height: normal; margin-top: 0in; margin-right: 0in; font-size: 11pt; font-family: Calibri, sans-serif;">Excellent verbal and written communication skills Self-starter with ability to multi-task, adapt quickly, learn independently, and complete projects with short iterative timelines.</li><li style="margin-bottom: 0in; line-height: normal; margin-top: 0in; margin-right: 0in; font-size: 11pt; font-family: Calibri, sans-serif;">Knowledge of modern cloud data analytics technologies preferably Microsoft based.</li><li style="margin-bottom: 0in; line-height: normal; margin-top: 0in; margin-right: 0in; font-size: 11pt; font-family: Calibri, sans-serif;">Ability to deliver presentations to senior-level business leaders and technical audiences.</li></ul> The ideal candidate would also have experience in:<ul style="margin-top: 0in; margin-bottom: 0in;" type="disc"><li style="margin-bottom: 0in; line-height: normal; margin-top: 0in; margin-right: 0in; font-size: 11pt; font-family: Calibri, sans-serif;">A Data Management, Data Analytics, Data Engineering, Business Intelligence or similar certification from a reputable institution is preferred</li><li style="margin-bottom: 0in; line-height: normal; margin-top: 0in; margin-right: 0in; font-size: 11pt; font-family: Calibri, sans-serif;">Knowledge of financial/mortgage business data analysis and processes is preferred.</li></ul> Applications and resumes are accepted online only at <a style="color: #0563c1; text-decoration: underline;" href="http://www.virginiahousing.com/careers">http://www.virginiahousing.com/careers</a>.This position will remain open until filled.Hiring Range: 92-886-120,751 A background check will be performed as a condition of employment. Internal applicants MR-8 Please review relevant HR policy under 'Employment Practices' on the Zone before applying. Apply through the Zone or at <a style="color: #0563c1; text-decoration: underline;" href="http://employees-virginiahousing.icims.com/">http://employees-virginiahousing.icims.com/</a>.-EOE-V3 Certified Military friendly employer

Position Title: Data AnalystLocation: South Portland, MEReports To: Chief Operating Officer Position Summary: The Data Analyst will utilize a generalist data analytics skillset to significantly impact S&W’s internal business reporting, generate quantitative research content, and improve CRM processes & data accuracy. This is an important role in the execution of several S&W strategic initiatives (inbound lead generation, creating & improving proprietary data sets, and modernizing business intelligence & reporting practices). Key Responsibilities:<ul><li>(30%) In conjunction with the COO, analyze, summarize, & interpret large data sets for internal and external use using Excel, PowerBI, & PowerPoint</li><li>(25%) Capture, clean, organize, & integrate open-source data into proprietary data sets for S&W research & marketing projects</li><li>(25%) CRM – Report on end user adherence to CRM data entry standards & enhance historical data to reach this standard</li><li>(10%) Performing one-off analyses at the request of the COO or S&W leadership</li><li>(10%) Maintain an accurate & timely record of business metrics</li></ul> Qualifications:<ul><li>Bachelor’s degree in a relevant field (e.g., Data Science, Business Analytics, etc.) or 2+ years of relevant job experience</li><li>Proficiency in at least one modern programming language (e.g., Python, R, etc.)</li><li>Advanced Excel skills, including vlookup, pivot tables, and compound formulas (if, sumif, countif)</li><li>Familiarity with Business Intelligence tools (e.g., Tableau, Power BI)</li><li>Familiarity with PowerPoint for data presentation and reporting</li></ul> Preferred Skills:<ul><li>Experience writing Python script for web scraping</li><li>Basic knowledge of statistics and data visualization techniques</li><li>Ability to work independently and juggle multiple initiatives simultaneously</li></ul> Personal Attributes:<ul><li>A team player who communicates proactively and delivers on deadlines</li><li>Strong analytical and problem-solving skills</li><li>Integrity, strong work ethic, & a growth mindset</li></ul>

Visioneering Story- A powerful team with a strong work ethic. JobGet Staffing is looking for provides the aerospace industry with high-quality conceptual design, engineering, and innovative tooling. As a full-service provider, established in 1953, we provide industry-leading organizations with totally integrated program management, design, engineering, NC machining and manufacturing. Our quality management system has been tried and tested to meet the stringent requirements of AS9100 certification. More information? Check out our quick video: Company Video - Visioneering (vistool.com) Equal Opportunity Employer Visioneering is an equal employment opportunity employer, offering equal employment opportunities to all individuals regardless of race, color, religion, sex, age, national origin, disability status, sexual orientation, protected veteran status, marital status and any other characteristic protected by law. Benefits Direct hire position, Referral Bonus Program, Job Development Training, Holiday Schedule, 401k, Flexible Spending Account, Paid Time Off, Health/Dental/Vision Insurance, Pet Insurance, Life/Disability Insurance, ADP Discounts, and MORE. Position Title: BI/Data Analyst Requisition Number: V711 Team: IT Reports to: Director of IT Character of Position As a BI/Data Analyst, you will be a key team member in helping Visioneering gain insight into core business applications by creating custom reports using various reporting and BI tools. This position will have also have a significant voice in the selection and implementation of new technologies to improve financial and operational reporting capabilities, perform integrations with on-premises and cloud based business systems, and be part of a larger team focused on upgrading and maintaining the current ERP environment. *Please note this is an onsite position. Responsibilities <ul> <li>Create and modify SQL queries, views, and stored procedures in a Microsoft SQL Server environment </li><li>Generate new reports and dashboards using tools like SSRS, PowerBI, Crystal Reports, and Excel based on business requirements </li><li>Develop custom objects, reports, and workflows in cloud applications such as Salesforce and Monday.com </li><li>General support of Infor Visual ERP environment </li><li>Interact with various stakeholders to find ways to optimize existing business systems through automation or systems integration </li><li>Work with team members to implement new tools and technologies to streamline enterprise reporting capabilities </li><li>Follow OSHA safety guidelines, and ITAR compliance </li><li>Other duties as assigned </li></ul> Skills <ul> <li>Strong knowledge of SQL, ability to create complex queries to return relevant data </li><li>Exceptional verbal and written communication skills </li><li>Strong attention to detail </li><li>Strong multitasking capabilities </li><li>Strong analytical and problem-solving skills </li><li>High proficiency in Microsoft Office applications, specifically Excel and Access </li><li>Ability to work with minimal supervision </li><li>Good interpersonal skills to work with different management levels </li></ul> Experience <ul> <li>2+ years of writing complex SQL statements </li><li>Maintaining business systems such as ERP and CRM </li><li>Financial and operational reporting </li><li>Infor Visual ERP, Power BI, Salesforce, Monday.com, and ETL tools highly desired </li></ul> Education <ul> <li>High School Diploma </li><li>Higher education degree in a relevant field highly preferred </li></ul> Due to the nature of work performed within our facilities, U.S. citizenship or Valid Permanent Resident status is required. Job Posted by ApplicantPro

Aurora Data Analyst Interview Guide

Overview

Aurora Data Analyst Salary

Aurora Data Analyst Interview Process

Aurora Data Analyst Interview Questions

Aurora Data Analyst Jobs