Data & AI jobs

ETL Analyst

Artech Information System LLC (agency)Philadelphia, PAContractHybrid3+ years experience

Pay not listed

2 things to check before you apply.

On Artech Information System LLC’s own careers site (SmartRecruiters), checked open today.

  • To check: Posted by the employer 10 years agoLong-open jobs are sometimes already filled. Ask when they plan to hire.
  • To check: No pay range listedAsk for the pay range before you interview.
  • Checked: On the company's own careers siteSmartRecruiters board
  • Checked: Checked open todaySmartRecruiters board
  • Checked: No reposts foundSmartRecruiters board
  • Trust score 60 / 100 · Check details
See all 6 checksShow fewer
How we check

What you’ll do

  • Capture business and technical requirements for Cloud TV platforms and IP Migration analysis.
  • Translate requirements into data-harvesting designs and ETL processes with analysts and data architects.
  • Extract, enrich, validate, and analyze data from large databases and other sources.
  • Create data summaries, visualizations, reports, and potentially models or scenario analyses.

Summarised from the posting by AI and can be wrong. The full description is the source.

Requirements

Experience

  • 3 to 5 years of experience working with Linux/Shell scripting
  • 3 to 5 years of experience with Ruby, Python, Perl, or similar scripting languages in an enterprise environment
  • 3 to 5 years of experience with SQL and relational database systems in an enterprise environment
  • 3 to 5 years of experience with data harvesting and ETL systems in an enterprise environment
  • 3 to 5 years of data manipulation using Excel or similar data exploration tools, including VBA or macros
  • 1 to 2 years of experience visualizing data in Excel, Tableau, or another BI platform
  • Exposure to spreadsheet modeling or programmatic scenario analysis
  • Background in statistical analysis and/or engineering (preferred)
  • Software Development Lifecycle or Agile/Scrum experience (preferred)

Education

  • Bachelor’s degree in technology, engineering, mathematics, computer science, or data science
  • Graduate or post-graduate degree (preferred)

Skills

  • Familiarity with Splunk and extracting data from Splunk
  • Familiarity with REST, JSON, and XML
  • Proficiency with version control systems such as Git
  • Ability to translate data formats from various data sources using scripting languages

Other requirements

  • Ability to work closely with business owners, analysts, and data architects at various levels

Your match

Sign in and add your resume to see which of this job's requirements it shows.

Sign in to check your match

Saved to your account, encrypted. The AI that reads it doesn't keep it or train on it.

Full job description

From Artech Information System LLC’s careers site

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.

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.

Show full descriptionShow less

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

Something wrong with this job? Report it · This flag looks wrong

Similar jobs

Data Analyst

Vestwell · New York, NY +3 places

$70k–$80k/yrFull-timeHybrid

StrongChecked open todayPosted 19 days ago

Senior Data Analyst

City of Philadelphia · Philadelphia, PA

$110k/yrFull-timeOn-site

StrongChecked open todayPosted 1 month ago

Data Analyst

Cantor Fitzgerald/BGC · NY, United States

$120k–$150k/yr

StrongChecked open todayPosted 18 days ago

Data Analyst

CyberMedia Technologies · Ashburn, VA

$120k–$135k/yr

StrongChecked open todayPosted 1 month ago

See more like this