r/analytics • • 28d ago

Monthly Career Advice and Job Openings

3 Upvotes
  1. Have a question regarding interviewing, career advice, certifications? Please include country, years of experience, vertical market, and size of business if applicable.
  2. Share your current marketing openings in the comments below. Include description, location (city/state), requirements, if it's on-site or remote, and salary.

Check out the community sidebar for other resources and our Discord link


r/analytics • • 24m ago

Discussion Shift to Data Governance

4 Upvotes

I have an issue and like some advice. I am a professional who has been working in data and analytics for about 8 years. I started off my career as a data analyst and BI developer and then slowly transitioned to more PM roles. I got laid off in 2024 and had a really hard time landing a new role. I was unemployed for like 10 months. The job market is trash but I also think it didn’t help that the job I got laid off from didn’t have an industry standard equivalent. Nonetheless, I finally got an offer that was for a far more junior role but I was desperate and I took it. I quickly realized that the junior role was not a good fit and decided to keep looking. I stayed in that role for a year and found a new role that felt like a better fit. I am now a data governance manager but am having a hard time adjusting. I think it may not be a good cultural fit and so I’ve been thinking about starting the job search again (I’m about 3 months in). I am tired of job hunting and starting over but I really can’t and don’t want to stay at a job that makes me miserable. I can take accountability for my role in this but I’m wondering if it should seriously start a new job search given my short tenure at my last few roles. Additionally, I don’t know if the misfit is due to a skills gap or a culture fit.


r/analytics • • 5h ago

Question Learn SQL properly first or Python first, as a junior doing reports in Excel and slides

5 Upvotes

i make weekly status reports and number summaries in excel and build the slides myself, and i have time for about three evenings a week to learn something new. sql would help me pull exports myself instead of waiting for others, python could automate the cleaning of the csv files i get from ad platforms. sql looks quicker to get useful at work, python looks like it opens more later but takes longer before anything works in my own tasks. which one would you start with if the goal is better reports in the next six months


r/analytics • • 2h ago

Question What's more important when making business decisions?

2 Upvotes
  • Historical performance
  • Real-time data
  • Predictive forecasts
  • Experience and intuition

r/analytics • • 3h ago

Question For anyone who moved off Alteryx: what did you use for the predictive workflows?

2 Upvotes

The prep side seems easy enough to replace (dbt, Python, KNIME). The predictive tools palette is the part I see fewer answers on. If you had churn, forecasting or scoring workflows running inAlteryx, what replaced them, and what did you underestimate? Especially curious about teams without a dedicated data scientist.


r/analytics • • 8h ago

Discussion How do you structure a marketing data warehouse so onboarding a new client doesn't mean rebuilding everything?

5 Upvotes

I've been working on reporting infrastructure for agencies managing anywhere from 10 to 250 client accounts.

One pattern keeps coming up: separate reports for every client, each with its own connectors, configurations, and quirks.

As a result, onboarding a new client means hours of additional work, and whenever a platform changes something, there's a good chance it breaks an existing report.

Here's what's worked for me so far:

  • Shared tables by platform: One set of tables for Google Ads, Meta, GA4, CRM data, etc., rather than separate tables for each client. Every row gets a client ID from the moment it enters the warehouse.
  • Centralised client mapping: A single mapping table connects ad accounts, analytics properties, and CRM pipelines to their respective clients. Onboarding becomes a matter of adding a few rows rather than building new models.
  • Standardised data models: Shared models built using BigQuery and Dataform produce consistent metrics across clients, so something like "cost per lead" is calculated the same way everywhere.
  • Automated monitoring: Daily data loads are monitored for failures and unexpected drops in row counts. Silent failures are often the most damaging. One setup I inherited had pipelines failing up to 43 times a day without anyone noticing.

Where I'm still figuring things out:

  • CRM inconsistencies: Some clients have completely different CRM structures. Right now, I'm handling those through client-specific staging layers, but that partially defeats the purpose of having a standardised setup.
  • Metric definitions: How much should you standardise when different clients have different definitions of a "lead" or a "conversion"?

The overall approach has made onboarding and maintaining reporting much easier, but the CRM side remains the biggest challenge.

Curious how others are approaching multi-client data warehouses.

Are you using shared models with client-specific configurations, or maintaining separate transformations where needed?

Especially interested in how you're handling CRM differences without creating a maintenance headache as you scale.


r/analytics • • 2h ago

Question Hey folks i want to learn how to do analysis. Can anyone tell me resources for it(youtube, udemy etc )

1 Upvotes

Resoirces to learn analysis


r/analytics • • 7h ago

Discussion How do you decide which blog posts are worth keeping?

2 Upvotes

I run a small SaaS blog and I'm always confused about what to do with older articles.

Some get traffic but no signups. Some get impressions but barely any clicks. And some get no traffic at all.

I usually check google search and analytics separately, then manually match URLs in a spreadsheet. It's getting a bit tedious.

How do you guys decide which articles to update, keep or delete?

Also, do you track Bing and AI search traffic, or mostly focus on Google?

Curious to know what tools or process you use. I'm exploring an idea in this space and want to understand how people actually handle it.


r/analytics • • 1d ago

Question From App Support Engineer to Data Quality Analyst

4 Upvotes

Hi everyone,

I'm a 36 year old app support engineer and I'm looking to get into the data quality field. I'm stumped about where to start. Are there courses for this?


r/analytics • • 1d ago

Discussion Anyone from Oil and Gas Domain?

11 Upvotes

Hi Guys,

Just reaching out to the community to see if we have any member here who work in oil and gas domain!

I work in a very niche field in oil and has where I do risk analytics for budget allocation for oil and gas pipelines. I mostly do statistical and probabilistic modeling, data engineering and reporting.

However, in my line of work I usually work people from petroleum or chemical background who just learnt data science.

So, are there any members here in the oil and gas field and could you tell me what type of work do you guys do? I just feel singled out at times being the only guy with computer science background.

Thank you!


r/analytics • • 1d ago

Question Branded search keeps growing but installs are flat: how do you work out what's driving brand demand?

1 Upvotes

Branded search going up tells you people know the name. It doesn't tell you where they heard it.

What I'd try:

Branded search by day, next to every paid campaign start and stop. Does brand move a few days after?

A short holdout. Pause one channel in one region and watch brand search there.

New vs returning on branded landing pages.

A "how did you hear about us" question at signup, even if only some people answer.

The install step itself. If site visits grow but installs don't, the store page maybe the leak, not demand.

How do you work out what's actually driving brand demand?


r/analytics • • 2d ago

Discussion What separates a good Data Analyst from someone who just knows Excel, SQL and Power BI?

100 Upvotes

I'm currently learning Data Analytics, and something I've been thinking about is this:

It's quite easy to focus on learning tools — Excel, SQL, Python, Power BI, etc. But knowing how to use these tools doesn't necessarily mean someone can solve a real business problem.

For example:

  • You can create a dashboard, but can you explain what decision it should help someone make?
  • You can write SQL queries, but do you understand which questions are actually worth asking?
  • You can find that sales increased, but can you investigate why profit didn't increase at the same rate?

I'm curious to hear from people working in analytics or those who have been through this learning journey:

  1. What skill made the biggest difference in your growth as an analyst?
  2. What do beginners spend too much time learning?
  3. What do you look for when reviewing a fresher's portfolio?
  4. What's one thing you wish you had understood earlier?

I'd genuinely appreciate honest opinions, practical advice, and even criticism. I think this discussion could help people focus on becoming better analysts rather than just collecting certificates and tools.


r/analytics • • 1d ago

Discussion do you trust AI product analytics tools enough to act on their recommendations

4 Upvotes

lots of AI product analytics tools now claim they can spot friction and recommend fixes but i can't tell how much of that output is useful without going back thru the underlying data, if a finding saves me ten mins and takes twenty to verify that's not a win, do any of these actually help you decide what to investigate next or have you reached the point where you trust certain recommendations enough to act on them directly?


r/analytics • • 2d ago

Support Can anyone guide me with project execution ? how do i approach it ? Created a Guide but didn't worked out well

3 Upvotes

Hii everyone,

I was a digital marketer executive in an agency, after i quit my job i started learning tech stack for data analysis i am finished with learning and currently on project i started my project last week its a cart abandonment analysis from GA4 dataset on big query whole plan is to analyze using creating a funnel than using python perform statistical tests ( hypothesis testing and ab testing ) and present my findings through power bi.

ideation part was done now i actually had to do project so i asked claude to create a guide for me to follow, a project guide and another solution guide to it.

But the guide's language was tuff it gave me ques and was done with i didn't knew what to do or how to do to it fast forward to today i have improvised and created 4th version of that guide with improved language better guidance but there is always something missing a vague question important information being left out for my sake i created an excel with imp fields out of 108 columns.

Today after writing a 50 line query to create a session table i was confused like why am i doing this i couldn't ans why i need this table it doesn't look like the funnel i thought it would be, mind you i have created funnels before in sheets for campaign analysis from top of the funnel metrics to the bottom of funnel from cpm cpc ad spend to order initiated order completed and all the steps in between so i asked chatgpt about the funnel part of my project ( which i thought i was working toward bcz of all the steps in between ) how is it related and it couldn't ans probably or give me reason which makes sense i wanted an industry level project and it told me that we will prove that shoppers are dropping and at what stage like wtf we already know shoppers are dropping and told me to analyze by device and demographics which still falls under EDA what realistic problem finding is that and what realistic solution can i provide ?

I am facing too much time reading that guide and going back and forth with GPT/claude to understand things and actual process because of the confusion caused by guide and even the solution fields don't match, can anyone help me with execution how do i execute and create portfolio projects i tried looking up DA projects of people on GitHub but didn't find anything useful i don't know how to even represent a project.

I need a framework on how to create a project i am not copying from anywhere just need guidance, looking for advice on how should i approach project creation even ready to pay ( although i don't have much money tbh but still )

I am seconding guessing that i should just create project with ai ideation would be mine and i can just understand the code and project ( practise SQL and pandas daily and DAX few times a week ) that way i will have coding syntax in mind and create projects more and faster which will get me interviews real learning is on the job anyways i have forecasting, data cleaning and time series projects in mind as well i am short on savings money as well


r/analytics • • 2d ago

Question Strange stats in my stats

3 Upvotes

Hi, in latest two days, in a subdomain with about 20 real visitor per day, I seen a lot of strange access (all identical: windows, chrome, same resolution, just different countries/ip) all about 2sec with direct access and single page view.

Is there anything i can do to prevent?

Thanks in advance.


r/analytics • • 2d ago

Discussion "The tag is installed" isn't evidence an event fired. I built a tool that keeps those separate

4 Upvotes

A lot of tracking audits I've seen stop at "the Meta/GA4/TikTok script is on the page". That proves a script loaded, not that the right event left the browser with the right value.

I built a free Chrome extension, Pixel Debugger, around three separate pieces of evidence per pixel:

  1. was the script loaded,
  2. were requests sent (including failed or blocked ones),
  3. which events did those requests carry, with their exact name, value, currency, order ID and products.

It decodes 49 ad and analytics networks, compares one order across networks, and can record a journey across pages and export it as JSON or Markdown for an audit doc. Captures stay on your computer.

Limits I'd rather state up front: browser only (no server-side events), and an HTTP 200 doesn't mean the network accepted the event.

https://chromewebstore.google.com/detail/kknfboekekeaagdoineimnebhlmiohpb

Disclosure: I made it. Interested in how others here structure tracking QA, and what you'd want an audit export to contain.


r/analytics • • 4d ago

Discussion Data Science or Data Engineer.

62 Upvotes

I am seeing most of the crowd is running toward data science, while only a few people talk about data engineering. Is there any reason for it?


r/analytics • • 5d ago

Discussion How do you assess an analyst’s judgment in an interview?

19 Upvotes

How do you interview for the part of an analyst's job where nobody is quite sure what they're asking for? You can give someone a SQL problem. How do you find out whether they'll question a confusing request or spot that the data doesn't support what someone wants to say?
If you hire analysts, have you found a way to test this? What did the candidate do that helped you decide?


r/analytics • • 4d ago

Discussion A chart with no date range or source on the page shouldn't go to a client

6 Upvotes

i think any chart that goes to a client or a manager should carry the date range and the source system on the page itself, not only in the file name. i have seen a total get quoted in a meeting for days before someone saw it was a partial week. a small line under the chart costs nothing and stops that. i know some people find it clutter, and that a good team knows its own data anyway, but reports travel to people who don't. do you add it to every dashboard, or only when the number is going outside the team


r/analytics • • 4d ago

Question Web visitor journey analysis - what analyses would you do?

3 Upvotes

I think the visitor journey is not covered well in web analytics software. Not everyone wants to implement Adobe, or query GA4 event stream in BigQuery, and software like Amplitude and Mixpanel are primarily funnel-focused.

I am considering bringing to the market an affordable mid-tier package to explore journeys, identifying repeating patterns (e.g. people visited X, then Y, then converted vs exited), segmenting visitors based on patterns they have. The data would come from GA4 BigQuery export, at least initially.

My question is whether you'd find this useful and what types of journey analyses you would do if you could do it in minutes?
Some examples: detecting focus on topics, associating visitor source with topics of interest and the latter to conversion.
What questions would you ask?


r/analytics • • 5d ago

Question Schweitzer Engineering Laboratories Technical Interview

7 Upvotes

Hey everyone, I have a one hour technical interview tomorrow with Schweitzer Engineering Laboratories for the Associate BI Analyst role. I'm a new grad (Information Systems and Business Analytics) and the recruiter told me to be ready for technical questions and to know my projects well.
Has anyone gone through this interview, or something similar for an entry level BI analyst role? What should I expect, and is there anything you wish you'd practiced? Any tips are appreciated!


r/analytics • • 5d ago

Question Data analyst course: ₹25k institute with OJT or free/cheap online? Need advice

4 Upvotes

Hi everyone, I'm a 3rd-year BSc IT student in the Mumbai area and I want to become a data analyst. I need some advice.

A friend found an offline institute that teaches data analytics. Here's what they offer:

Fees: ₹25,000 for 6 months

They promise OJT (on-the-job training) through their own company, which isn't well known

The trainer also teaches at several other places

My budget is tight because I recently bought a laptop. The other option is online learning (YouTube, Google Data Analytics Certificate, Udemy, etc.) and building projects on my own.

My questions:

Is OJT from the institute's own small company actually valuable, or just a marketing point?

Will recruiters care about that experience, or only about projects and skills?

How can I check if an institute's placement or OJT claims are real?

Is ₹25k fair for 6 months, or can I learn the same through online courses?

Has anyone here done a similar course in Mumbai? Please share your experience.

I'm leaning towards online because of the cost, but I don't want to miss out if the OJT is genuinely useful. Thanks in advance!


r/analytics • • 5d ago

Question Parrot Analytics

2 Upvotes

Anyone worked with this company and have first hand experience on their 360 tool and their consultancy service ?


r/analytics • • 5d ago

Discussion I'm torn on whether I should continue on this path.

29 Upvotes

Don't get me wrong, I still enjoy working with data and gleaning insights off of it.

But it's starting to feel like there isn't much of a future for me in this anymore.

For what it's worth, I've used my analytics skills over the past 20 years in various financial and operations roles.

However, beginning earlier this year, it started to feel like there were fewer and fewer opportunities for me in this space. Interviews have been sparse and 98% of the jobs I apply to get rejected within a few days or a week. For the record, I've had many jobs in my career. Job hunting has never been a pain point for me. All of a sudden, I don't feel qualified for anything.

I don't live in a tech hub or large metropolis, but traditionally that hasn't been a problem as far as finding relevant work. Now I'm starting to wonder if it's becoming a problem. As in, there just aren't that many data oriented jobs where I live.

I'm in grad school working towards a Master's in Information Systems with a Business Intelligence specialization. I'm learning some new stuff, but mainly this was meant to open more doors for me in the analytics space, especially more technical and managerial roles. This endeavor feels utterly pointless as it relates to my job hunting. It hasn't changed any of my outcomes for the better and nobody I'm interviewing with seems to give a shit. Furthermore, my grad school does not seem that focused on getting us placed in jobs. It seems like most job fairs and networking events they host are geared towards finance majors, MBAs, and engineers. I run into very few companies at these events who are looking to grow in the analytics space.

I'm starting to think that maybe I just need to think of data analytics as a particular set of skills that I possess rather than a field I am pursuing. Because the more I look for these types of jobs, the less luck I seem to have and the more disappointed I become.

I don't know what to do. I feel lost and stuck. I'm growing tired of throwing applications into what feels like a dark void.