Data Analyst - Remote (Local to AZ only with in-person interview)

Title:Data Analyst - Remote (Local to AZ only with in-person interview)Location:RemoteLength:Long termRestriction:w2 or c2c Description:

** Webcam interview.** Initial PO for 12 months; usually projects with this customer goes for 3+ years ***w2 or 1099 or c2c; ``*Remote***

Job Description

Under limited supervision, performs complex tasks to support the division by performing data analysis, data mining, design, development, testing activities, and execution of AdHoc, Standard, and Customized reports to achieve strategic objectives and goals.

Has working experience in writing and working with SQL (Standard Query Language), Visual Basic, MS Access, Sales Force Marketing Cloud, dimensional and relational database design, and other business intelligence software tools to develop queries and create Journeys to gather appropriate data from multiple systems and create reports in multiple technology applications (Excel, Tableau, Sales Force Marketing Cloud, etc.), write SSIS packages, complete paperwork/documentation to test and move reports into Production and send out electronic messages (email and SMS) via Sales Force Marketing Cloud.

Knowledge and use of UI Path for creating BOTS (Robotic Process Automation - RPA) would be a plus.

Serves on projects and/or pilots to develop and/or provide input for requirements, provide technical guidance for design or enhancements to systems/reports, and develop Work Plans, schedule, monitor, etc. to ensure successful and timely completion.

Responsibilities
  • Designing reports requiring analysis, writing of SQL, data mining, and presentation to technical and non-technical audiences in a variety of technical platforms (Tableau, Excel, Power BI, Sales Force Marketing Cloud, UI Path, etc.)
  • Create Journeys in Sales Force Marketing Cloud for sending out ongoing electronic messages (email and SMS.)
  • Prioritize business and operational needs
  • Extract, import, clean, transform, and validate data
  • Writing queries using SQL and MS Access
  • Experience with DB2
  • Identify, analyze, and interpret trends or patterns in complex data sets
  • Create standard and ad-hoc reports including detail, summary, history, snapshots, drill down, and other reports
  • Develop report specifications, test plans, prepare test data, execute tests, supporting documentation, and coordinate production implementation
  • Establish data connections with various data sources
  • Setup report schedule, subscription, access process and procedures, and delivery method
  • Present data in lists, tables, charts, graphs, snapshots, crosstab, and other formats
  • Tailor the analysis and reporting methods by the type of data as well as to the intended audience
  • Review key indicators to locate and correct problems
  • Follow up and track remediation of issues
  • Write and present Desk-Aids and Workflows for both technical and non-technical audiences.
  • Creating RPA BOTs to automate repetitive, rule-based tasks such as data entry and system processing.
Knowledge, Skills & Abilities

Knowledge:

  • Knowledge of Service Level Agreement (SLA); laws, rules, security policies, privacy, data confidentiality management.
  • Knowledge of Engineering workflow, IT lifecycle and system design, performance tuning, and Business Intelligence tools and features.
  • Knowledge of Statistical and business analysis and research and analysis methodologies.
  • Knowledge of multiple business intelligence software applications (SQL, SSIS, MS Visual Studio, Tableau, Visual Basic, MS Access, Sales Force Marketing Cloud, UI Path, etc.) and multidimensional and relational database design.
  • Knowledge of project management concepts, principles, and practices.

Skills:

  • Skilled in the use of Business Intelligence (SQL, SSIS, Tableau, Visual Basic, MS Access, BI Software, and RPA.)
  • Skilled in dimensional and relational database design.
  • Skilled in analysis, design review, troubleshooting, implementation, and integration for applications.
  • Skilled in keyboarding and use of Microsoft Office programs such as Excel, Word, Access, and PowerPoint and Google for gmail, calendar, chat, sheets, docs, forms, slides, etc.
  • Problem and negotiation skills to research and resolve issues.
  • Good time management and organizations skills with attention to detail.
  • Skilled in effective listening, oral and written communications skills to communicate technical and non-technical concepts to a variety of audiences.

Abilities:

  • Ability to write business and functional requirements and diagram business processes, translate into technical solutions and reports, query and view objects, and present them in a meaningful format.
  • Ability to work at least 40 hours per week and maintain satisfactory attendance and punctuality standards.
  • Ability to work independently and collaboratively and under stress/pressure.
  • Ability to analyze data, develop and execute queries and reports, and proficiently manipulate data.
  • Ability to adapt to changing needs and priorities quickly while contributing feedback based on rules and regulations.
  • Ability to multi-task and make good decisions balancing competing deadlines and priorities.

Back to blog

Common Interview Questions And Answers

1. HOW DO YOU PLAN YOUR DAY?

This is what this question poses: When do you focus and start working seriously? What are the hours you work optimally? Are you a night owl? A morning bird? Remote teams can be made up of people working on different shifts and around the world, so you won't necessarily be stuck in the 9-5 schedule if it's not for you...

2. HOW DO YOU USE THE DIFFERENT COMMUNICATION TOOLS IN DIFFERENT SITUATIONS?

When you're working on a remote team, there's no way to chat in the hallway between meetings or catch up on the latest project during an office carpool. Therefore, virtual communication will be absolutely essential to get your work done...

3. WHAT IS "WORKING REMOTE" REALLY FOR YOU?

Many people want to work remotely because of the flexibility it allows. You can work anywhere and at any time of the day...

4. WHAT DO YOU NEED IN YOUR PHYSICAL WORKSPACE TO SUCCEED IN YOUR WORK?

With this question, companies are looking to see what equipment they may need to provide you with and to verify how aware you are of what remote working could mean for you physically and logistically...

5. HOW DO YOU PROCESS INFORMATION?

Several years ago, I was working in a team to plan a big event. My supervisor made us all work as a team before the big day. One of our activities has been to find out how each of us processes information...

6. HOW DO YOU MANAGE THE CALENDAR AND THE PROGRAM? WHICH APPLICATIONS / SYSTEM DO YOU USE?

Or you may receive even more specific questions, such as: What's on your calendar? Do you plan blocks of time to do certain types of work? Do you have an open calendar that everyone can see?...

7. HOW DO YOU ORGANIZE FILES, LINKS, AND TABS ON YOUR COMPUTER?

Just like your schedule, how you track files and other information is very important. After all, everything is digital!...

8. HOW TO PRIORITIZE WORK?

The day I watched Marie Forleo's film separating the important from the urgent, my life changed. Not all remote jobs start fast, but most of them are...

9. HOW DO YOU PREPARE FOR A MEETING AND PREPARE A MEETING? WHAT DO YOU SEE HAPPENING DURING THE MEETING?

Just as communication is essential when working remotely, so is organization. Because you won't have those opportunities in the elevator or a casual conversation in the lunchroom, you should take advantage of the little time you have in a video or phone conference...

10. HOW DO YOU USE TECHNOLOGY ON A DAILY BASIS, IN YOUR WORK AND FOR YOUR PLEASURE?

This is a great question because it shows your comfort level with technology, which is very important for a remote worker because you will be working with technology over time...