Data Analyst

Data Analyst jobs at Big-Data.digital

Data Analyst

$ $17 - $20 an hour

Description:
  • Modify and upgrade Excel/VBA based reports.
  • Validate data integrity of multiple systems and reports.
  • Fully automate the data processing aspects of the business including the consolidation of the various contributing data collection spreadsheets into a centralized report.
  • Automate data flow across multiple systems.
  • Automate the integration of external data sources into a main spreadsheet from other Excel spreadsheets or data sources.
  • Design spreadsheet-based reports from the main spreadsheet accessible through macro button controls or other automated systems.
  • Weekly presentations
  • $17.00-$20.00 per hour (compensation is based on experience)
. Requirements:
  • Building complex VBA scripts to automate Excel spreadsheet processes.
  • Manipulating data with complex Excel, VBA and SQL Coding.
  • 5+ years advanced experience with MS Excel, VBA and SQL scripting.
  • Expert level Excel skills (Conditional Formatting, Data Validation Rules, Table Manipulation, Named Ranges, Creating/Modifying connections to external data sources, Workbook/Worksheet/Cell Data Protection)
  • Expert level Excel VBA skills (Ability to create complex forms/functions/subroutines, Experience using constants and visibility modifiers, Programmatic manipulation of objects/tables/data connections/formulas)
  • Advanced SQL skills (SharePoint Development Experience Data Modeling, Database Design/Development)
  • Developing/Maintaining Stored Procedures
  • Must work at least 40 hours weekly


Technical Skills

  • Excel
  • VBA
  • Power BI


Preferred Skills

  • Building complex VBA scripts to automate Excel spreadsheet processes.
  • Manipulating data with complex Excel and VBA.
  • Ability to build Power BI Dashboards.
  • 5+ years advanced experience with MS Excel, VBA and Power BI.
  • If you are selected for further consideration after an interview, you will be required to pass a series of tests related to the duties of the role to ensure your knowledge of the above listed programs.

Get the book



Published 2021-10-27

Direct Interactions, Inc. looks for a Data Analyst in Remote location.

How much Data Analyst Jobs professional earns at Direct Interactions, Inc.?

The proposed salary for Data Analyst Jobs position at Direct Interactions, Inc. is $17 - $20 an hour.

Data Analyst responsibilities at Direct Interactions, Inc.

According to the common industry standard, Data Analyst Jobs specialist is in charge for the following activities.

Required Data Analyst Jobs qualifications at Direct Interactions, Inc.

To be disscussed with candidate