Sign upLog in
JobsJobs in New YorkJobs in New York, NYInformation Technology and Internet JobsSoftware Jobs

Data Analytics & Engineering Consultant

eTeam Inc.

New York City, NY

Apply
JOB DETAILS
SALARY
$60–$70 Per Hour
SKILLS
Administrative Skills, Analysis Skills, Automation, CAD/CAM (Computer-Aided Design/Computer-Aided Manufacturing), Consulting, Customer Support/Service, Customer/Client Research, Data Analysis, Data Lake, Data Management, Data Processing, Data Sets, Database Extract Transform and Load (ETL), Engineering Consulting, Internal Audit, Microsoft Excel, Pivot Tables, Python Programming/Scripting Language, Quest Software TOAD, Reporting Dashboards, SQL (Structured Query Language), Schedule Development, Tableau, Testing, Training/Teaching, Vlookups
LOCATION
New York City, NY
POSTED
30+ days ago
Job Title - Data Analytics & Engineering Consultant
Location - New York City, NY (Hybrid )
Duration 6 to 12 Months Contract Roles

Role Overview
  • The CAD Data Analytics Program relies on skilled contingent resources to extend the team's capacity to deliver high-quality, data-driven insights that support client's Internal Audit function. This consultant role requires expertise in data engineering, ETL/ELT development, SQL, and Tableau dashboard development, and will operate as both a Subject Matter Expert and execution-focused resource working under the direction of the CAD Data team.

Job Function and Key Responsibilities
  • Work primarily under the direction of the CAD Data team, with interaction with Internal Audit teams focused and purposeful, occurring when clarification is needed on requirements submitted through the CAD data intake form, or when presenting Tableau dashboard designs for user review and agreement prior to finalization.
  • Design and build data pipelines and ETL/ELT processes to source, extract, and prepare data from Redshift, the company's data lake, in fulfillment of data intake requests received from Internal Audit, ranging from targeted population file pulls to more complex analytical datasets.
  • Build, test, modify, and finalize Tableau dashboards in accordance with specifications provided by the CAD Data team, ensuring accuracy, completeness, and design quality prior to production release.
  • Refresh and maintain dashboards according to their established schedules, utilizing Tableau Prep, Python, and StoneBranch for automation, with familiarity in Databricks as the team transitions its automation workflows.
  • Configure subscription and alert notifications for Tableau dashboards when requested, and serve as the central recipient of all system-generated alerts to monitor and verify that CAD's alert inventory is functioning as intended.
  • Support ongoing program administration, including maintaining CAD's dashboard inventory on a daily basis and updating CAD's Tableau Landing Page weekly to reflect current dashboard links and purposes.

MUST HAVE Qualifications
  • Experience in data engineering practices including the design and development of data pipelines and ETL/ELT processes
  • Proficiency in SQL for querying (building from scratch) using TOAD and extracting data from structured tables in Redshift.
  • Proficiency in Tableau for dashboard development, modification, and maintenance.
  • Experience with Tableau Prep for automated data preparation and refresh workflows
  • Proficiency in Python for automation and data processing
  • Experience with StoneBranch for workflow automation and scheduling
  • Proficiency in Databricks, including its GenAI capabilities, for data access, processing, and automation.
  • Proficiency in Microsoft Excel: building macros (preferred), joining files, vetting files, teaching formulas to auditors, pivot tables, vlookups.

About the Company

e

eTeam Inc.

Looking for a great job? Join eTeam. We’re looking for talented staffing professionals to join our staff. We also provide contract assignments and full-time jobs at Fortune 2000 Companies. We’ve been named one of the best companies to work for by Staffing Industry Analysts and New Jersey Business.
COMPANY SIZE
100 to 499 employees
INDUSTRY
Other/Not Classified
FOUNDED
1998
WEBSITE
www.eteaminc.com

Similar Job Searches

.net Developer Jobs in New York, NYAndroid Developer Jobs in New York, NYApplication Architect Jobs in New York, NYApplication Developer Jobs in New York, NYBuild Engineer Jobs in New York, NYBusiness Intelligence Developer Jobs in New York, NYBusiness Objects Developer Jobs in New York, NYContract Developer Jobs in New York, NYCrm Developer Jobs in New York, NYDatabase Developer Jobs in New York, NY