Strong Middle/Senior Data Analyst (Contractor)

About the Position

Binariks is looking for a highly motivated, detail-oriented, and skilled Strong Middle/Senior Data Analyst (Contractor) to serve as a key player in transforming, validating, and modeling complex product datasets for large-scale enterprise clients. This role is designed for a true Excel Guru who also possesses strong Python scripting skills to automate pipelines and process massive datasets.

You will be responsible for designing complex data transformation "recipes," analyzing chaotic e-commerce/PIM data feeds from major companies, and bridging the gap between advanced spreadsheet modeling and backend automation.

About the project: an AI-powered platform that automates data wrangling tasks, helping teams transform messy and inconsistent data into clean, reliable feeds for Product Information Management (PIM) and e-commerce systems. The platform reduces manual work, minimizes human error, and accelerates data-driven operations.

It is a part-time position.

Responsibilities

• Data Wrangling & Recipe Design: Author and optimize highly complex data cleaning, standardization, and enrichment workflows ("recipes") using our proprietary AI platform and advanced Excel interfaces.
• Enterprise Data Analysis: Ingest, analyze, and map large-scale, inconsistent, and unstructured datasets (100k+ rows) from large corporate clients, preparing catalog files for PIM/e-commerce integrations.
• Python Automation & ETL: Develop and maintain scripts to automate manual spreadsheet processes, clean data programmatically, and parse nested JSON/XML structures.
• Client & Cross-Functional Collaboration: Partner with Technical Leads, Product Managers, and enterprise stakeholders to translate complex business rules and catalog requirements into robust data-wrangling logic.
• Data Integrity & QA: Perform data profiling, identify systematic quality issues, and write validation cases to ensure exact data type alignment and functional correctness.

Requirements

• 3+ years of professional experience in Data Analytics, Data Engineering, or BI
• 3+ years of daily, expert-level use of Microsoft Excel/Google Sheets in data-intensive environments
• Deep proficiency in writing complex formulas (INDEX/MATCH, XLOOKUP, array formulas, advanced logical nesting, LAMBDA functions)
• Expertise in Power Query (M-code) and Power Pivot for data modeling, alongside handling massive sheets with complex dependencies
• At least 2 years of practical experience using Python for data manipulation, particularly with the pandas and NumPy libraries
• Proven track record of managing and structuring big datasets from major companies (PIM systems, ERP catalog migrations, or e-commerce databases)
• Experience with schema mapping, handling duplicates, resolving null values, and parsing nested metadata
• Familiarity with writing unit tests (using pytest) and analyzing code performance
• Solid experience with relational databases (SQL) and querying data
• Strong understanding of Git workflows
• Strong systematic problem-solving aptitude-you are self-motivated and can independently tackle abstract data structures
• Excellent communication skills to discuss data logic with non-technical stakeholders and developers
• English Level: Upper-Intermediate (B2) or higher (the role involves direct alignment on business rules)

Nice to Have

• Hands-on experience with PyArrow or Apache Arrow data types

We Offer

• Opportunity to work on cutting-edge AI-powered data transformation projects
• Flexible part-time position
• Collaborative and innovative work environment

About the Company

Binariks is a leading software development company that specializes in delivering high-quality software solutions to clients across various industries. Our team is passionate about leveraging technology to solve complex business challenges and drive growth.