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)