Job Description

Professional Summary:
The Data Analyst will be responsible for consolidating, validating, and transforming data to support operational reporting and business decision‑making. This role requires strong analytical skills, advanced Excel proficiency, and the ability to work with large datasets from multiple sources. The ideal candidate is detail‑oriented, technically adept, and comfortable producing accurate reports in a fast‑paced environment.
Key Responsibilities
Consolidate data from multiple sources using functions such as VLOOKUP, INDEX‑MATCH, and XLOOKUP.
Perform data cleaning, validation, and error identification to ensure accuracy and consistency.
Build and maintain weekly and monthly reports, including KPI tracking dashboards and PivotTables.
Transform raw data into structured, actionable formats for internal stakeholders.
Support ad‑hoc analysis and troubleshoot discrepancies across datasets.
Required Skills & Tools
Advanced Excel skills: VLOOKUP, HLOOKUP, INDEX‑MATCH, XLOOKUP, PivotTables, SUMIF/COUNTIF, and data formatting.
Strong competency in data manipulation, including working with large multi‑tab or multi‑workbook datasets.
Technical aptitude with relational databases, SQL queries (e.g., joins), and basic familiarity with Python, Power Query, Tableau, and Jira.
Job Requirements
Demonstrated experience using VLOOKUPs, PivotTables, SUMIF/COUNTIF, and other advanced Excel functions.
Ability to perform data mining, data cleansing, and validation using Excel‑based lookup tools.
Must‑have skills: Advanced Excel, specifically VLOOKUP and PivotTables.

Job Tags

Similar Jobs

Legend Senior Living

Certified Nursing Assistant (CNA) Job at Legend Senior Living

...associates) 7 years in a row! Benefits-- Certified Nursing Assistant (CNA)~ Medical, Dental, Vision offerings (for benefit eligible... ...in the amount of $15,000~ Voluntary benefits including: Hospital Indemnity, Accident Insurance, Critical Illness, legal/Identify...

Comic Book Resources (CBR)

Self-Publishing Writer: News (Movies & TV) Job at Comic Book Resources (CBR)

...SEO and engagement goals Coordinate with editors and fellow writers to maintain consistent daily coverage Contribute to news ideation... ..., sports, technology, automotive, gaming, lifestyle and travel. Valnet is committed to producing premium content, and we therefore...

Techo-Bloc

General Laborer (Pallet Repair) Job at Techo-Bloc

...5/hr Location: Waterloo, IN Schedule: MondayFriday, 7:00am3:30pm Work Environment: Outdoor yard Type of Work: Pallet repair & yard operations At Techo-Bloc , our yard laborers play an important role in keeping operations running smoothly. This entry...

Futurex

Technical Writer Job at Futurex

...Futurex is seeking a Technical Writer for full-time employment at Futurexs campus in Bulverde, TX. As a Technical Writer at Futurex, you will be responsible for ensuring that the documentation for all of our products is clear, correct, comprehensive, and easy to use...

usaa

Actuary Lead Job at usaa

...making. Advanced knowledge of data analysis tools, data visualization, developing analysis queries and procedures in Python, R, SQL, SAS, BI tools or other analysis software, and relevant industry data & methods and ability to connect external insights to business problems...

Data Analyst Job at BLEHEALTH, Pomona, CA

QlRPVFlRZlJIY2lQWkYwUVpOR095ZlN0NlE9PQ==