Back to jobs

ETL Analyst

Philadelphia, PA, United States

Actively hiring, first seen by us 3 days ago
Pay
Pay not listedSimilar roles state $95K–$145K
Work setting
Hybrid — work setting source
The Analyst will work with business owners, data architects, database developers and analysts to create data solutions that enable holistic visualizations, forecasts, and ad-hoc analysis to provide deeper insight into various products and their delivery platforms. This role is a hybrid role that will also leverage this person’s ability with data manipulation to perform data stigmatization and characterization. Core Responsibilities/Tasks:
Read the full posting
Employment
Contract — employment source
Employment type in the employer’s posting: Contract
From the employer’s posting

What you’ll work on

Full posting
  • Capture business requirements and turn them into technical ETL and data harvest designs

  • Use scripts (Perl, Linux, Ruby, Bash, SQL) to extract and compute data from large databases

  • Enrich data and build summaries and visualizations using exploratory data analysis

  • Turn proof-of-concept ETL scripts into enterprise-grade ETL systems

  • Automate scheduled processes and validate that data loads are correct and accurate

From the employer’s posting
translate business requirements into technical requirements for data harvesting designs and ETL processes
Use scripting (perl/linux/ruby/bash/SQL or other) language to perform computations and data harvest/extracts from large databases and other sources
Enrich data and develop into data summaries and visualizations using understanding of basic statistics and exploratory data analysis concepts
Be able to translate Proof-of-Concept and Prototype ETL scripts into enterprise grade ETL systems
When required, develop automation using scripting and other languages to run processes on a schedule
Education & alternatives
Qualifications § Bachelor’s Degree in technology, engineering, mathematics, computer science, data science; graduate or post-graduate degree a plus § 3 to 5 years of experience working with Linux/Shell scripting

Tools in this posting

  • Bash
  • Perl
  • Python
  • Ruby
  • Shell
  • SQL
  • VBA
  • Excel
  • MySQL
  • Oracle
  • Tableau
  • Vertica
  • PostgreSQL
Source — Tool mentions in context
§ Work with lead analysts data architects to translate business requirements into technical requirements for data harvesting designs and ETL processes. § Use scripting (perl/linux/ruby/bash/SQL or other) language to perform computations and data harvest/extracts from large databases and other sources § Enrich data and develop into data summaries and visualizations using understanding of basic statistics and exploratory data analysis concepts
§ 3 to 5 years of experience working with Linux/Shell scripting § 3 to 5 years of experience working with scripting languages such as Ruby, Python, Perl or similar in an enterprise environment. § 3 to 5 years of experience working with SQL and with relational database systems such as MySQL, Vertica, Postgres, or Oracle in an enterprise environment.
§ Bachelor’s Degree in technology, engineering, mathematics, computer science, data science; graduate or post-graduate degree a plus § 3 to 5 years of experience working with Linux/Shell scripting § 3 to 5 years of experience working with scripting languages such as Ruby, Python, Perl or similar in an enterprise environment.
§ 3 to 5 years of experience working with scripting languages such as Ruby, Python, Perl or similar in an enterprise environment. § 3 to 5 years of experience working with SQL and with relational database systems such as MySQL, Vertica, Postgres, or Oracle in an enterprise environment. § 3 to 5 years of experience working with data harvest and ETL systems in an enterprise environment.
§ 3 to 5 years of experience working with data harvest and ETL systems in an enterprise environment. § 3 to 5 years of data manipulation using Excel or similar data exploration tools (VBA, Macros) § 1 to 2 years of experience working with visualizing data in Excel/Tableau or other BI platform
§ 3 to 5 years of data manipulation using Excel or similar data exploration tools (VBA, Macros) § 1 to 2 years of experience working with visualizing data in Excel/Tableau or other BI platform § Exposure to spreadsheet modeling; or programmatic scenario analysis
Check the employer’s page ↗

Posting record

Report an error

Actively hiringFirst seen by us 3 days ago, still listed, and not a repost of an earlier posting.

Status in our records
Live
First seen by us
Nov 19, 20263 days ago
Recorded sightings
4
Last seen by us
Nov 22, 2026
Employer says posted
May 19, 2016

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

How this job compares

Pay

$95K–$145K is typical

The middle half of what similar US postings state. This one doesn’t list pay.

From 2,327 postings in the last year. Stated ranges, not salaries paid.

Time since we first saw it

Day 3

Early. Similar jobs usually come down between day 5 and day 43.

From 16,008 similar postings that came down. Coming down is not always a hire.

Artech Information System is hiring

45 open jobs

Open jobs by the week we first saw them, last 12 weeks.

Hiring record

Your next step

Check the employer’s posting for the current role and application details.

Applying through SmartRecruiters

  • Uploading your resume fills in the application form for you, so check what it filled before you send.

Already applied? Track this application

Job description

View original posting ↗

Job Description

The Engineering Analysis ETL Business Analyst function implements understands and can operate across the entire analytical workflow from business requirements to solution delivery. 

The Analyst will work with business owners, data architects, database developers and analysts to create data solutions that enable holistic visualizations, forecasts, and ad-hoc analysis to provide deeper insight into various products and their delivery platforms. 

This role is a hybrid role that will also leverage this person’s ability with data manipulation to perform data stigmatization and characterization.

Core Responsibilities/Tasks:

§ Participates in analysis efforts for Cloud TV platforms and IP Migration and will be responsible for business/technical requirements definition/capture, data design and harvest/etl and data enrichment/exploration/visualization/reporting; and possibly modeling and scenario analysis.

§ Participate in business owner consultation to understand and capture business requirements 

§ Work with lead analysts data architects to translate business requirements into technical requirements for data harvesting designs and ETL processes.

§ Use scripting (perl/linux/ruby/bash/SQL or other) language to perform computations and data harvest/extracts from large databases and other sources

§ Enrich data and develop into data summaries and visualizations using understanding of basic statistics and exploratory data analysis concepts

§ Review and refine analysis/visualizations in collaborative effort with lead analysts and business owners

§ When required, develop automation using scripting and other languages to run processes on a schedule.

§ Utilize team best practices to validate that data is loaded correctly and accurately.

§ Be able to translate Proof-of-Concept and Prototype ETL scripts into enterprise grade ETL systems. 

§ Be proficient with various coding standards and best practices related to version control, error logging, and code documentation.

§ Minimum travel.


Qualifications

§ Bachelor’s Degree in technology, engineering, mathematics, computer science, data science; graduate or post-graduate degree a plus

§ 3 to 5 years of experience working with Linux/Shell scripting

§ 3 to 5 years of experience working with scripting languages such as Ruby, Python, Perl or similar in an enterprise environment.

§ 3 to 5 years of experience working with SQL and with relational database systems such as MySQL, Vertica, Postgres, or Oracle in an enterprise environment.

§ 3 to 5 years of experience working with data harvest and ETL systems in an enterprise environment.

§ 3 to 5 years of data manipulation using Excel or similar data exploration tools (VBA, Macros)

§ 1 to 2 years of experience working with visualizing data in Excel/Tableau or other BI platform

§ Exposure to spreadsheet modeling; or programmatic scenario analysis

§ Familiarity with Splunk and extracting data from Splunk

§ Familiarity with REST protocol, JSON and XML data formats

§ Proficient with version control systems such as Git

§ Ability to translate data formats from various data sources using scripting languages

§ Background in statistical analysis and/or engineering is a huge plus

§ Software Development Lifecycle or Agile/Scrum experience preferred

§ Must be a team-player and be able to work closely with business owners, analysts and data architects at various levels

Mode of interview : Telephonic followed by In-person 

Additional Information

For more information, Please contact

Siva Kumar

973-507-7543

Company Description

Artech is the 10th Largest IT Staffing Company in the US, according to Staffing Industry Analysts' 2012 annual report. Artech provides technical expertise to fill gaps in clients' immediate skill-sets availability, deliver emerging technology skill-sets, refresh existing skill base, allow for flexibility in project planning and execution phases, and provide budgeting/financial flexibility by offering contingent labor as a variable cost.

Demand for Analyst roles

New Analyst postings at the employers we follow are up 26% over the last 6 weeks compared with the 6 before.

Weekly new Analyst postings at the same employers, from the week of August 17 to the week of November 9. The fewest in a week was 993, the most 1,510, and the latest week had 1,367.
August 17Last week

Each bar is one week of new postings. The darkest bars are the last 6 weeks.

Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.

About the role

We file this job under Analyst, by the work the posting describes.

Analysts answer business questions with data. They pull numbers with SQL, build reports and dashboards, and explain what changed and why to the people making decisions.

Most postings ask for SQL, spreadsheets, a dashboard tool such as Tableau or Power BI, and clear writing.

Unlike a data scientist, an analyst mostly explains what happened rather than building models that predict what will.

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay

No pay amount identified in the saved description.

Location & working pattern

Philadelphia, PA, United States

The Analyst will work with business owners, data architects, database developers and analysts to create data solutions that enable holistic visualizations, forecasts, and ad-hoc analysis to provide deeper insight into various products and their delivery platforms. This role is a hybrid role that will also leverage this person’s ability with data manipulation to perform data stigmatization and characterization. Core Responsibilities/Tasks:
Work authorization

No clear work-authorization passage found. Eligibility is unconfirmed.

AI answers unavailable

We couldn’t identify enough role detail in this saved description to support an AI answer. Read the full posting