Skip to content

DataNotesCareers

Which Data Career Is Right for You?

Baraa Khatib Salkini3 min read

Subscribe to DataNotes

Join 213,000+ curious readers.

Subscribe takes you to Substack to confirm, and you can unsubscribe anytime (privacy policy).

Subscribe to DataNotes

Subscribe takes you to Substack to confirm, and you can unsubscribe anytime (privacy policy).

In this issue3 min left

Hey friends!👋

Let’s get real—jumping into random tools and skills because they’re “trending” is like trying to run before you can walk. I see so many aspiring data pros diving into Tableau, then Python, then TensorFlow without stopping to ask: “What kind of job do I want?”

If you’re all over the place, it’s tough to build the focused skills that’ll actually land you a role. So let’s break it down and talk about some of the most common data roles, what they’re all about, and the skills you need to crush them.

1. Data Analyst

This is your classic entry point into the data world. Data analysts gather, clean, and make sense of data so businesses can make smarter decisions. Think Excel and dashboards, not machine learning models.

  • What you do: Create reports, analyze trends, and answer business questions.
  • Key tools: Excel, SQL, Tableau/Power BI, Python (basic stats & cleaning).

If you love telling stories with data, this is a great place to start.

2. Data Scientist

Photo of a man with thick glasses who writes formulas and diagrams on a glass wall.

Data scientists are like data analysts, but they level up with machine learning and advanced stats to solve complex problems.

  • What you do: Build models to predict customer behavior or improve decision-making.
  • Key tools: Python/R, SQL, machine learning libraries (like Scikit-learn or TensorFlow).

This is where you get to play with algorithms and lots of data, but you’ll need solid coding and math skills.

3. Data Engineer

Love the idea of building things behind the scenes? Data engineers create the pipelines and systems that make data usable. Without them, analysts and scientists wouldn’t have clean, accessible data to work with.

  • What you do: Build and maintain databases, ETL pipelines, data warehouses, data lakes, data lakehouses.
  • Key tools: SQL, Python, Spark, cloud platforms (AWS, Azure).

If you like solving big, messy technical problems, this could be your jam.

4. Business Intelligence (BI) Developer

BI Developers are like the architects of insights. They build the tools and systems that Data Analysts (and others) use to find answers. Think dashboards, data models, and infrastructure that make data accessible and actionable at scale.

  • What you do: Design dashboards, set up data models, and optimize systems for reporting. You create the platform that makes decision-making possible.
  • Key Tools: Power BI, Tableau, SQL, and data modeling techniques (Star Schema, Snowflake Schema).

If you’re more into building systems and creating long-term solutions rather than just analyzing data, this is your lane.

6. Data Architect

Picture of a large curved monitor that shows drawings of buildings and charts like a blueprint.

Data architects design the big picture—how all the data in an organization is stored, accessed, and managed. They focus on scalability, security, and efficiency.

  • What you do: Plan and build data frameworks, databases, and systems.
  • Key tools: SQL, cloud platforms, database design, data modeling.

This is a high-level, strategic role for seasoned data pros.

Quick Tip

Not sure where to start? Think about what excites you most:

  • Love solving puzzles? Look into Data Engineering.
  • Love numbers and patterns? Check out Data Science.
  • Love creating dashboards and data models? Try BI Development.
  • Love telling stories with visuals? ? Focus on Data Analytic.
  • Love designing the big picture? Become a Data Architect.

Pick one path, focus, and go deep. You don’t need to learn everything—just the right things for your goals.

Weekly Wisdom

"The best way to predict the future is to build it—starting with your skills."

I hope you found this helpful, and if you have any questions or want to share your own tips, I’m all ears! Happy querying!

Baraa