Steneral Consulting

Sr. Technical Analyst I ETL Analyst I Data Quality Analyst

Steneral Consulting United States
Steneral Consulting

Sr. Technical Analyst I ETL Analyst I Data Quality Analyst

Steneral Consulting United States
1 month ago 115 applicants

See who Steneral Consulting has hired for this role

It's for a true technical analyst or BSA who can identify error codes in the ERP/ Data and be able to correct them. See the sample sent

Position: Technical Analyst (2 openings)

Location: prefer local (Chicago, IL), but can be remote for a rockstar

Duration: 12+ month contract

"not very BI, Business Analyst or Technical Analyst Titles...Python and SQL data analysis, ERP, ETL experience "

Call Notes

  • resumes due 6/12, interviews will start 6/17
  • Strong at understanding data and querying data
  • Understand and dig into problem solving from a technical standpoint
  • A BA would understand the business data, but they won’t be able to do the technical mapping
  • Agility is the ERP, there are a lot of integrations that are happening
  • SQL, ETL/ELT processes, Python and how maneuvering data through systems works
  • They will interact with BAs and with the business stakeholders
  • The goal is that they identify potential problems sooner rather than later
  • Technical acumen needs to be very strong
  • There is a data component, and the technical point is understanding where the issue is (is it in the APIs and where does it tie back to the systems for example).
  • BSA – understand the systems and be able to trace it back from system to system.

As a Technical Business Analyst, you will…

  • Gain a deep understanding of various data sources by collecting descriptive statistics, data types, and understanding the context of values in disparate data sets
  • Perform data quality assessment and understand risks of assumptions made about the data
  • Validate alignment of data within scope of business rules and requirements
  • Collaborate with cross-functional teams, including data engineers, data analysts, and business stakeholders, to understand data requirements and challenges and ensure data quality standards are met
  • Validate data mappings with an understanding of downstream business needs to ensure that requirements can be met given available data
  • Utilize various tools such as SQL, Python, or BI applications to profile current and anticipated data in systems of record
  • Collaborate with developers, providing clarifications and addressing inquiries to help ensure software deliveries meet required business functionality

Qualifications

  • 4-year degree
  • 5+ years of proven experience working with data sets, gathering requirements, writing test documentation and procedures, and tracking errors:
    • Proficiency in data analysis tool and languages (e.g. SQL, Python) and writing/developing SQL queries
    • Knowledge of data/information workflows, data ingestion and ETL/ELT processes
    • Architectural Patterns: Data Warehousing, Medallion Architecture, Microservices Architecture, Event-based Architecture
    • Outstanding skills with MS Excel, and other standard office applications
    • Strong data modeling and lineage background
  • Excellent written and verbal communication skills and strong cognitive ability especially with respect to understanding, documenting, and describing complex technical subjects
  • Strong interpersonal skills and broad business and technical knowledge
Bonus Skills

  • Cloud experience with data engineering resources (Databricks, SQL Server)
  • Python (data frames, statistical analysis)

  • Seniority level

    Associate

  • Employment type

    Contract

  • Job function

    Information Technology

  • Industries

    IT Services and IT Consulting

Referrals increase your chances of interviewing at Steneral Consulting by 2x

See who you know

Get notified about new Data Quality Analyst jobs in United States.

Sign in to create job alert

Similar jobs

People also viewed

Looking for a job?

Visit the Career Advice Hub to see tips on interviewing and resume writing.

View Career Advice Hub