Introduction

Part one : The current market

The data industry is still growing, with companies across all sectors looking for (skilled) professionals to help them with their data. Skilled because the current market is not beginner-friendly unfortunately.

With the recents trend in Data, Big Data in 2017 and now AI, more than before, young people are looking for opportunities.

The most incredible market happened just after COVID, but now it’s on a long downtrend and there is no sign of reversal as you can see on the graph below :

The depression part is after us, let’s focus on the brighter side : software engineering is not data engineering ; USA is not the only country on earth.

Part two : The mindset of a junior vs a senior

As the title says, being a senior or confirmed developer (at least 3 years experience) is way more easier than a beginner. So as a recent graduate, or currently intern, looking for jobs, or apprenticeship you should focus on what really matters for the companies : solving business problems.

Diplomas, grade, university, certifications, those as “theoritical knowledge”, I’m taking the risk of being too extreme but the most problematic things with juniors is there lack of ability to understand the problem the companies are facing.

University people are here to teach you technology, mindset, attitude. Grade are here to validate your skills, same for diplomas and certifications, but if you know perfectly a tool, the definition, the way it works and how to use it, it doesn’t matter if you cannot use it for the purpose of the companies’ problem(s).

“I know how to code a binary tree using Python” -> Congratulations, but the company wants you to solve this bug into this system that has been maintained for 20 years in order to fill one column in a database that is the current backbone of the entire dashboard for the HR department.

Technical case =/= business use case.

It took me many years to understand this, because most of my colleagues didn’t want me to know this, so I could stay in my developer position and not climbing the ladder to a more “consulting” or “managing” role that they were enrolled for.

So as a junior, embrace the business problematic. Use your time to understand, not just how, but why this problem needs to be solved. AI can help you figure out the technical details, but AI doesn’t know the context of the business and the client that you have to satisfy.

Which direction to choose

Where do you start? So many buzzwords are right now used, data science, data engineering, analytics engineer, context engineer, machine learning, ai trainer etc… As simple as everything should be, there is 3 big “categories” inside Data, which is already a sub-family of software engineering, itself a subfamily of the big IT/digital family.

The Three Main Data Career Paths

1. Data Engineering

What they do: Build and maintain data infrastructure, pipelines, and systems. Pros: most resilient, technical, most practical

Cons: lots of “fixing stuff”, at the end of the chain so always problems solver, very flexible job

• Focus: Data infrastructure, ETL/ELT processes, data warehousing
• Skills: SQL, Python, cloud platforms, data modeling
• Typical roles: Data Engineer, ETL Developer, Data Platform Engineer

3. Data Analytics

What they do: Transform data into actionable business insights and reports.

Pros: high level, last person before submitting important dashboards, less technical

Cons: less technical so might be replaced by AI, not resilient if too high level (you need to be technical)

• Focus: Business intelligence, reporting, dashboard creation
• Skills: SQL, Excel, BI tools, data visualization
• Typical roles: Data Analyst, Business Analyst, BI Developer

2. Data Science

What they do: Analyze data to extract insights and build predictive models. Pros: data rockstar, latest technologies, high end programming Cons: lots of math, data cleaning will take all your time

• Focus: Statistical analysis, machine learning, business insights
• Skills: Python/R, statistics, machine learning, data visualization
• Typical roles: Data Scientist, ML Engineer, Analytics Engineer

Conclusion :

• A data analyst can be replaced by a data engineer, data scientist
• A data engineer can be replaced by a data scientist
• A data scientist can be doing everything except data science

Which Path Should You Choose?

Essential Skills for Data Careers

Core Technical Skills

1. SQL (Structured Query Language)

Why it’s essential: SQL is the universal language for data manipulation and analysis.

• Start with: Basic SELECT, WHERE, JOIN operations
• Advanced topics: Window functions, CTEs, performance optimization
• Practice platforms: LeetCode, HackerRank, Mode Analytics

-- Basic SQL example
SELECT 
    customer_id,
    COUNT(*) as order_count,
    SUM(amount) as total_spent
FROM orders 
WHERE order_date >= '2024-01-01'
GROUP BY customer_id
HAVING total_spent > 1000
ORDER BY total_spent DESC;

2. Python Programming

Why it’s essential: Python is the most popular language for data work.

• Core libraries: Pandas, NumPy, Matplotlib, Seaborn
• Data science libraries: Scikit-learn, TensorFlow, PyTorch
• Data engineering: Apache Airflow, PySpark, FastAPI

3. Data Visualization

Why it’s essential: Communicating insights effectively is crucial.

• Tools: Tableau, Power BI, Plotly, D3.js
• Principles: Color theory, chart selection, storytelling
• Best practices: Keep it simple, focus on insights, consider accessibility

Analytical Skills

Critical Thinking

• Problem decomposition: Breaking complex problems into manageable parts
• Hypothesis testing: Formulating and testing data-driven hypotheses
• Root cause analysis: Identifying underlying issues in data problems

Business Acumen

• Domain knowledge: Understanding your industry’s specific needs
• Stakeholder communication: Translating technical findings for business audiences
• ROI thinking: Connecting data insights to business value

Data Fundamentals

Data Types and Structures

• Structured data: Databases, CSV files, JSON
• Unstructured data: Text, images, videos
• Semi-structured data: XML, log files

Data Quality Concepts

• Accuracy: Data reflects reality
• Completeness: No missing values
• Consistency: Data follows expected patterns
• Timeliness: Data is current and relevant

Building Your Portfolio

Portfolio Components

1. GitHub Repository

• Well-documented projects with README files
• Clean, production-ready code
• Diverse project types showing different skills
• Active contributions to open-source projects

2. Personal Projects

• End-to-end solutions from data collection to insights
• Real-world datasets (Kaggle, government data, APIs)
• Business impact demonstrated through metrics
• Technical complexity appropriate for your level

3. Blog or Technical Writing

• Share your learning journey
• Write tutorials and guides
• Analyze interesting datasets
• Contribute to data communities

Job Search Strategy

Where to Look

Job Boards

• General: LinkedIn, Indeed, Glassdoor
• Tech-focused: Stack Overflow Jobs, AngelList
• Data-specific: DataJobs, Analytics Vidhya Jobs

Company Career Pages

• Tech companies: Google, Amazon, Microsoft, Meta
• Consulting firms: McKinsey, BCG, Deloitte
• Startups: Look for companies with data teams

Networking

• LinkedIn connections with data professionals
• Alumni networks from your university
• Professional associations and meetups

Interview Preparation

Technical Interviews

• Practice coding problems on LeetCode and HackerRank
• Review SQL queries and data manipulation
• Prepare for system design questions (for senior roles)
• Practice explaining technical concepts clearly

Behavioral Interviews

• STAR method for answering questions
• Prepare stories about your projects and challenges
• Research the company and their data initiatives
• Prepare questions to ask the interviewer

Common Mistakes to Avoid

Learning Mistakes

• Trying to learn everything at once: Focus on fundamentals first
• Only watching tutorials: Practice with real projects
• Ignoring business context: Understand why you’re doing what you’re doing
• Not building a portfolio: Projects are your best resume

Job Search Mistakes

• Applying to too many jobs: Quality over quantity
• Generic applications: Tailor each application
• Not networking: Relationships matter in data
• Ignoring company culture: Fit is as important as skills

Career Mistakes

• Staying in your comfort zone: Keep learning and growing
• Not staying current: Data technology evolves quickly
• Ignoring soft skills: Communication is crucial
• Not building a personal brand: Stand out in the crowd

Conclusion

Starting a career in data is both challenging and rewarding. The field offers excellent opportunities for growth, competitive salaries, and the chance to work on meaningful problems that impact businesses and society.

Remember that everyone’s journey is different. Focus on building a strong foundation, creating a compelling portfolio, and continuously learning. The data industry values practical skills and real-world experience, so prioritize hands-on projects over theoretical knowledge.

Next Steps

1. Choose your path: Data Engineering, Data Science, or Analytics
2. Build your foundation: Master SQL, Python, and basic statistics
3. Create projects: Build a portfolio that showcases your skills
4. Network actively: Connect with professionals in the field
5. Apply strategically: Target roles that match your skills and interests
6. Keep learning: The data field evolves rapidly

Pro Tips

• Start small: Don’t try to learn everything at once
• Be patient: Building expertise takes time
• Practice regularly: Consistency is key to skill development
• Share your work: Teaching others reinforces your learning
• Stay curious: The best data professionals are always learning

The data industry is waiting for passionate, skilled professionals like you. With dedication, practice, and the right approach, you can build a successful and fulfilling career in data.

Thanks for reading this article. Still lost ? Or questioning yourself ? Fill up the form and I’ll personaly answer you.