P

Junior Business Intelligence (BI) Analyst – Logistics Data Solutions

pixel systems Germany
Remote
Apply
AI Summary

Join Pixel Systems as a Junior BI Analyst to transform fragmented logistics data into actionable insights for a German client’s warehouse and shipment operations. Your role will focus on writing SQL queries, cleaning legacy data, and building dashboards to ensure real-time visibility for warehouse managers. This fully remote, hands-on position requires foundational SQL skills, attention to detail, and a preference for practical problem-solving over abstract theory.

Key Highlights
Fully remote role focused on logistics data organization and dashboard development for a German client
Hands-on work with SQL, data cleaning, and API integrations to improve operational visibility
Small, flat team with direct mentorship from senior developers in a remote-first environment
Key Responsibilities
Write SQL queries to extract and transform logistics data from fragmented sources into usable insights
Clean and validate legacy data records to ensure accuracy for warehouse and shipment operations
Assist in connecting APIs to streamline data flow between systems and dashboards
Verify that generated reports align with the client’s real-time business operations
Collaborate with senior developers to build and maintain internal dashboards for logistics managers
Technical Skills Required
SQL Databases (Postgres) APIs
Benefits & Perks
Competitive salary for entry-level experience
Fully remote work with flexible hours
Stable, permanent full-time position
Nice to Have
Experience with GitHub for version control
Familiarity with Node.js or React for dashboard development
Projects involving large-scale data cleaning or organization

Job Description


We are adding a Junior BI Analyst to our team to help with a major project for a logistics provider based in Germany. This client manages a large network of shipments and warehouses, and they currently rely on fragmented data sources that make it difficult to see the full picture of their operations. In this role, you will help us organize that data and build the internal dashboards their managers use to keep deliveries on schedule.

About Pixel Systems
Pixel Systems is a small software agency that builds the tools teams actually use to do their work. We stay away from flashy consumer apps or marketing sites. Instead, we focus on practical software like admin panels, CRM integrations, and the database migrations that most people try to avoid. Our clients come to us when they need to replace a messy spreadsheet with a real database or get their different software tools to communicate with each other.
We believe that working code is better than a perfect plan that never ships. Our approach is straightforward: we provide fixed quotes, perform weekly demos, and hand over everything (code, documentation, and walkthrough videos) when we finish. We are a fully remote team of developers and designers who prefer solving real operational headaches over chasing the latest industry trends. When something breaks, we are the ones who answer the phone and fix it.

The Role
As a Junior BI Analyst, your primary task is to help us turn raw data into useful information. You will spend time moving data between systems and ensuring that the information we pull from our client's logistics databases is accurate. This is not about creating complex models or chasing high-level abstractions: it is about making sure a warehouse manager knows exactly how many pallets are on a floor at any given time.
You will write SQL queries to extract data, help clean up legacy records that contain errors, and assist in connecting different APIs so that information flows smoothly. Because this role is fully remote, you will communicate with the rest of the team through written updates and video calls. You will be responsible for verifying that our reports match the reality of the client's business operations.

What you bring
  • A basic understanding of how databases are structured and how to retrieve information from them.
  • The ability to write simple SQL queries and a willingness to learn more complex ones.
  • Strong organizational skills and an eye for detail (you notice when a row of data looks out of place).
  • Comfort working with spreadsheets and the ability to explain your findings clearly to others.
  • A preference for practical work that solves immediate problems for users.
  • The ability to manage your own time while working from home.
  • Curiosity about how logistics and supply chains operate behind the scenes.


Helpful background
While this is an entry-level position, there are a few tools and technologies we use every day. If you have any experience with the following, it will help you get up to speed faster:
  • Postgres or other relational databases.
  • Working with APIs to pull data from third-party services.
  • Basic familiarity with GitHub for version control.
  • Exposure to Node or React, as these are what we use to build our dashboards.
  • Any previous projects where you had to clean or organize a large set of data.


Working at Pixel Systems
Working here is different from working at a large corporation. We do not have layers of middle management or long, unnecessary meetings. We are a small, flat team where everyone is expected to contribute to the final product. You will work directly with senior developers who can provide guidance as you learn the ropes of data analysis in a professional environment.
We value stability and clear communication. Since we are a remote company, we rely on documentation and straightforward talk to keep projects moving. This is a full-time, permanent position that offers a competitive salary for the market and your level of experience. We want the people who work here to have a good balance between their professional and personal lives, so we focus on hitting our deadlines during work hours and logging off when the day is done.
Our goal is to build software that lasts and solves real problems for companies like our German logistics partner. We are looking for someone who takes pride in doing the quiet, essential work that keeps a business running smoothly. If you enjoy digging into data and making sense of complicated systems, you will fit in well here.

Similar Jobs

Explore other opportunities that match your interests

Senior Data Engineer (Payments & Blockchain Data Platform)

Data Science
1w ago

Premium Job

Sign up is free! Login or Sign up to view full details.

•••••• •••••• ••••••
Job Type ••••••
Experience Level ••••••

find data science jobs

Germany

Data Science Intern

Data Science
3w ago
Visa Sponsorship Relocation Remote
Job Type Full-time
Experience Level Internship

ai superior

Germany
Visa Sponsorship Relocation Remote
Job Type Full-time
Experience Level Not Applicable

cendas

Germany

Subscribe our newsletter

New Things Will Always Update Regularly