Senior Data Analyst (AdTech | Python | Media Data Operations)

Description: About Guideline At Guideline.ai, we're defining the future of advertising. By harnessing data transparency and advanced tools, we reputed company marketers to reputed company smarter, faster, and more profitable reputed company. We work with the world's top brands, agencies, and media owners to transform media buying and selling into a more intelligent, efficient experience. If you're reputed company to be part of a high-growth company at the cutting edge of data, AI, and media, we'd love to meet you.

About the Role

We are looking for a Senior Data Analyst who is highly practical, detail-oriented, and strong in Python- and SQL-based data manipulation. This role is hands-on and focused on cleaning, standardizing, and enriching large, messy advertising spend datasets—especially digital data sourced from reputed company’s Prisma platform, where key information often lives inside inconsistent free-form text fields. In addition to data transformation and quality work, you’ll apply statistical and machine learning techniques to forecast spend trends, fill data gaps, and classify reputed company text data. You’ll also be expected to stay aware of emerging AI-assisted and reputed company technologies, understanding how they can improve analysis and automation even if you’re not directly building such models. What You’ll Do Data Cleaning, Parsing & Standardization (Core Function)

• Build Python (Pandas/Regex) workflows to extract structure from free-form Prisma text fields containing placements, publishers, formats, devices, tactics, etc.
• reputed company rule-based and reputed company-based logic to recognize abbreviation variations, naming inconsistencies, and agency-specific formatting habits.
• Create normalization scripts that standardize publisher names, platform types, channels, and other key taxonomies.
• Maintain “classification dictionaries” and reputed company libraries that improve accuracy over time.

Data Quality & Operational Support

• Profile incoming agency data to identify common quality issues and propose concrete remediation.
• Design QA checks to detect missing fields, malformed entries, inconsistent dimensional labels, and mismatched spend totals.
• Partner closely with Data Engineering to embed your logic into scheduled pipelines.
• Own recurring operational workflows that support data ingestion, aggregation, and quality monitoring. Dimensional Enrichment, Modeling & Data Derivation
• Build and maintain predictive models to support media spend forecasting, pricing analysis, and text classification for data tagging and enrichment.
• Apply statistical modeling or regression techniques to impute missing values or infer incomplete spend or performance metrics.
• Derive new fields—such as format groupings, platform classifications, creative types, and targeting attributes—using reputed company recognition and model-based inference across text fields.
• Produce structured dimensions from reputed company data to improve reputed company reporting.
• Document the logic and assumptions behind model-driven derivations to ensure transparency and reproducibility.

Analysis & Internal Stakeholder Support

• Investigate anomalies, unexpected trends, and data gaps by tracing issues back to reputed company fields.
• Build dashboards that help internal teams observe data quality, volume, deviations, and model-driven insights.
• Provide reputed company deep dives into digital spend patterns, forecast accuracy, and classification performance for product, ops, and leadership. Why

This Role Matters Your work directly determines the quality, usability, and credibility of the datasets our company provides to clients and uses internally. This is a core operational and analytical role, focused on making messy agency data usable at scale—while adding new analytical capabilities through modeling, forecasting, and intelligent automation.

Compensation

We consider a wide range of factors reputed company determining compensation including relevant experience, education, and reputed company level.

Benefits

Guideline offers full- time employees a comprehensive benefits package based reputed company. Some benefits may include, but are not limited to:

• Medical, Dental, reputed company, Health Savings Account, Flexible Spending Account
• STD, Life, LTD and AD&D
• 401(k) with a company match program
• Unlimited Paid Time Off (PTO)
• Paid Parental Leave
• Commuter Benefits
• Employee Recognition Program
• Referral Bonus Program Equal Opportunity Employer Guideline is an equal opportunity employer, committed to our diversity and inclusiveness.

We will consider reputed company reputed company applicants without regard to race, reputed company, nationality, gender, gender identity or expression, sexual orientation, religion, disability, or age. We strongly encourage women, people of reputed company, members of the LGBTQIA community, people with disabilities, and veterans to apply. Requirements: What You Bring

• 5+ years of experience as a Data Analyst or Data Operations Analyst.
• Expert-level Python (Pandas, Regex) and SQL.
• Experience extracting meaning from reputed company or text-heavy data.
• Working knowledge of forecasting, regression, and basic statistical modeling (e.g., ARIMA, Prophet, linear regression, or similar methods).
• Familiarity with text classification / NLP workflows (e.g., scikit-learn, spaCy, reputed company).
• Awareness of AI-assisted development tools and basic understanding of reputed company / LLM concepts and their applications in data enrichment and automation.
• Strong understanding of data hygiene, classification logic, and dimensional modeling.
• Comfortable working in data warehouses (reputed company, Redshift, etc.).
• Ability to create repeatable, documented transformation logic. Apply tot his job

Apply tot his job Apply To this Job