Data Analyst at InfoVision Inc.

Apply for the Data Analyst position at InfoVision Inc. in . Find the best jobs for you effortlessly with InJob.AI, your ultimate solution for job search. Discover top job opportunities and streamline your job search process.

alert circle

Job Description

<div>
 <p>
  <strong>
   Remote
  </strong>
 </p>
 <p>
  <strong>
   Job Posting Title: Data Analyst: II (Intermediate) - Snowflake SQL &amp; WMS
  </strong>
 </p>
 <p>
  <strong>
   Description: This job will run for 6 months
  </strong>
 </p>
 <p>
  &bull; This req is an immediate need, please send resumes as soon as you can.
 </p>
 <p>
  &bull; This role is also ONLY contract and will not have the opportunity for contract to hire. It will be at least 6 months in length.
 </p>
 <p>
  &bull; Management experience is not necessary.
 </p>
 <p>
  &bull; The core requirements are:
 </p>
 <p>
  &bull; Advanced to Expert SQL coding skills for report development (i.e., Snowflake SQL)
 </p>
 <p>
  &bull; Experience with order management systems (OMS) testing and supporting analytics
 </p>
 <p>
  &bull; Strong analytical skills when working with large sets of data
 </p>
 <p>
  &bull; Experience with report creation - taking business requirements and developing reports based off of business needs
 </p>
 <p>
  &bull; Self-motivated and driven
 </p>
 <p>
  &bull; Able to thrive in environments that are ever evolving and changing based on business needs (if require structured and set processes and procedures, this is not the position for you)
 </p>
 <p>
  &bull; Strong independent problem solving skills
 </p>
 <p>
  SUMMARY:
 </p>
 <p>
  This role will be housed within the Inventory Hub Management (IHM) team, with a focus on inventory data mining and reporting in relation to order management systems (OMS) and warehouse management systems (WMS). This role will be responsible for taking business requirements and developing SQL based reports for business and technical team use. These reports will assist with day-to-day inventory management as well as OMS system pre- and post-implementation testing and monitoring. The focus OMS system management by the IHM is Manhattan Active Omni (MAO). This associate will play a key role in implementing the MAO system and will oversee IHM system reporting related to omni-channel inventory visibility and order fulfillment. This position calls for someone who has direct experience in this area, as well as proven experience in SQL coding.
 </p>
 <p>
  <br/>
 </p>
 <p>
  RESPONSIBILITIES:
 </p>
 <p>
  &bull; Manage requirement capture and development of new Inventory Hub and Manhattan Active Order Management (MAO) system reporting
 </p>
 <p>
  &bull; Responsible for managing omni-channel daily, weekly, and ad hoc inventory availability and order fulfillment reporting
 </p>
 <p>
  &bull; Define and develop KPIs for omni-channel inventory sharing and order fulfillment performance tracking based on analytic findings
 </p>
 <p>
  &bull; Perform analysis and make recommendations to drive optimization of inventory visibility/sharing and omni-channel order fulfillment
 </p>
 <p>
  &bull; Potential for OMS system testing for phased MAO and MAO-impacting system implementations
 </p>
 <p>
  <br/>
 </p>
 <p>
  KEY SKILLS / ATTRIBUTES:
 </p>
 <p>
  &bull; Robust problem-solving skills, time management skills and ability to multitask efficiently
 </p>
 <p>
  &bull; Strong work ethic, ability to work independently in a fast-paced environment
 </p>
 <p>
  &bull; Ability to thrive in ever evolving and changing environments, where duties are flexed based on business/project needs
 </p>
 <p>
  &bull; Substantial capacity for following through tasks to completion in line with defined due dates
 </p>
 <p>
  &bull; Able to work effectively with all levels of the organizations
 </p>
 <p>
  &bull; Excellent verbal and written communication skills
 </p>
 <p>
  &bull; Results and actions oriented; approaches challenges and projects with perseverance
 </p>
 <p>
  <br/>
 </p>
 <p>
  EDUCATION / BACKGROUND:
 </p>
 <p>
  &bull; Bachelor&rsquo;s degree in accounting, business management, data analytics, computer science, finance or other relative studies from a four-year university
 </p>
 <p>
  &bull; Preferred a minimum of 4+ years in inventory control/management, data analytics, accounting, or audit
 </p>
 <p>
  &bull; Manhattan Active Omni system experience is a plus
 </p>
 <p>
  &bull; Oracle Retail Systems experience is a plus
 </p>
 <p>
  &bull; Snowflake query development experience is a plus
 </p>
</div>

AI Powered Job Insights

Exciting opportunity for a Data Analyst at InfoVision Inc.! They are seeking an intermediate-level professional with expertise in Snowflake SQL and experience in supporting order management systems. This is a contract role lasting six months, entirely remote, and suitable for individuals who thrive in dynamic environments.

📍 Location: Remote  
💼 Position: Data Analyst II (Intermediate) - Snowflake SQL & WMS  
⏰ Type: Contract (6 months)  
📅 Date Posted: 2024-07-26  

Role Summary:  
- They will work within the Inventory Hub Management team, focusing on inventory data mining and reporting.  
- The position involves developing SQL-based reports to support the inventory management related to order management systems.  
- Responsibilities include implementing and monitoring the Manhattan Active Omni system.  

What You'll Do:  
- Capture requirements and develop new reports for inventory and order management systems.  
- Handle daily, weekly, and ad hoc inventory reporting.  
- Define and implement key performance indicators for tracking inventory and order fulfillment.  
- Analyze data and provide recommendations for improvements in inventory visibility and order fulfillment.  
- Participate in OMS system testing related to phased implementations.  

What's Needed:  
- Advanced SQL coding skills, especially in Snowflake SQL.  
- Experience with order management systems and supporting analytics.  
- Strong analytical abilities with large datasets.  
- A bachelor's degree in relevant fields such as data analytics, finance, or computer science.  
- A minimum of 4+ years in data analytics or inventory management.  
- Experience with Manhattan Active Omni and Oracle Retail Systems is a plus.

Top Interview Questions

  • Q: Can you describe your experience with SQL, specifically using Snowflake for report development?

    A: I have over four years of experience working with SQL, including extensive use of Snowflake for report development. I enjoy utilizing advanced SQL functions like window functions and common table expressions to streamline data queries. For instance, I once created a comprehensive inventory report that aggregated data from different sources, which allowed my team to make data-driven decisions about stock levels and order fulfillment.

  • Q: How do you approach gathering business requirements for report development?

    A: I use a structured approach to gather business requirements by conducting thorough stakeholder interviews. I ask targeted questions to identify their key metrics and reporting needs. I also facilitate workshops or brainstorming sessions to ensure that all perspectives are considered. This collaborative approach ensures that the reports I develop meet the exact needs of the business and drive actionable insights.

  • Q: Describe a situation where you needed to analyze a large set of inventory data. What tools and methods did you use?

    A: In my last role, I was tasked with analyzing a large dataset to identify trends in inventory turnover rates. I used SQL to extract and manipulate data from our Snowflake database and then employed visualization tools like Tableau to present insights. I conducted trend analysis over several months and was able to recommend strategies that improved turnover by 15%, which positively impacted our overall efficiency.

  • Q: What steps would you take if the data in your reports seemed inconsistent or erroneous?

    A: First, I would conduct a detailed examination of the data sources to pinpoint where discrepancies might have occurred. This involves checking the ETL processes and validating each data transformation step. Then, I would collaborate with the data engineering team to resolve any identified issues. Lastly, I would implement data validation checks to minimize errors in future reports, ensuring consistent and reliable data for decision-making.

  • Q: How do you stay motivated and productive in a rapidly changing work environment?

    A: I thrive in rapidly changing environments by maintaining a flexible mindset and prioritizing tasks effectively. I utilize project management tools like Trello or Asana to visualize my tasks, which helps me stay organized. Additionally, I seek feedback regularly and embrace changes as opportunities for improvement, which keeps my motivation high and allows me to adapt quickly to evolving business needs.

People Faces

200+ professionals have found their dream job with InJob.ai this week.

salary

Salary Benefits

Salary details not provided

application process

Want to apply directly?

Apply for the Data Analyst position at InfoVision Inc. in using https://www.linkedin.com/jobs/view/3983307698

Get StartedGet Started

Similar Jobs found by InJob.AI


Data Analyst

Arrow Search Partners, New York, NY

Junior Data Analyst

Tech Consulting, Florida, United States

Data Analyst

Algo Capital Group, Chicago, IL

Data Analyst

Pyramid Consulting, Inc, Chicago, IL

Data Analyst

HealthStream, Nashville, TN

Entry-Level Data Analyst

Vaco, Shelton, CT

Data Analyst

Pyramid Consulting, Inc, Lake Mary, FL

Data Analyst

GitHub,

Scroll To Top
Get Started

Frequently asked Questions

Still have a question? Check out our FAQ section below.

FAQ Section

InJob searches for the best jobs, based on your profile and automatically generates customized cover letters for you. It saves a lot of hours in your job hunting time.

InJob creates your profile by having a conversation with you to learn about your skills and requirements. It also scans your resume to gather information about your experiences, skills, and achievements. This information is used to craft your profile in the backend which is further used to match jobs and gives you a personalized cover letter for each job opportunity.

InJob searches for job opportunities across a wide range of sources, including LinkedIn, Indeed, and hundreds of other job boards to find hidden gems. Its search is not limited, ensuring it covers as many potential job listings as possible. It also searches the career pages of individual companies that suit your target industry and location and you get applied there.

InJob is constantly active, scanning for fresh job opportunities every single minute. This ensures that you are the first person to apply to new job listings that align with your profile.

InJob plays matchmaker by comparing your profile and resume with job listings. Each job receives a score from 1-10, indicating how well you match with it.

In the upcoming update, Yes, this will be included and this will be the main differentiator. InJob will apply for jobs on your behalf. It will target top matches and craft custom cover letters for each job, ensuring your application stands out. InJob will also handle the application process, including visiting company websites and filling out forms.

In the upcoming update, Yes, InJob will provide an interactive dashboard that serves as mission control for your job search. It will display all the jobs InJob has applied for you and their current status. You will also be able to track which companies have shown interest in your profile and view the feedback they provided.

In an upcoming feature, Yes, InJob will collect all feedback, including positive and constructive feedback, and presents it to you. This will allow you to know exactly where you stand in the job market and provides insights on how to improve your skills.