Junior BI Analyst

About Pixel Systems

Pixel Systems is a compact, fully remote software agency specializing in creating practical tools that enhance business operations. Unlike flashy consumer apps or marketing websites focused on appearance, our projects are centered on CRM integrations, administrative dashboards, and database migrations that solve real operational challenges. Transparency guides our work approach with fixed project quotes, weekly demonstrations, and comprehensive handovers including source code and documentation. We rely on stable, maintainable technologies such as Postgres, Node.js, and React. Our team comprises senior developers and designers committed to practical problem solving rather than following fleeting industry trends. Remote work is integral to our culture, supported by clear communication and well-documented processes.

Position Overview

We are seeking a Junior BI Analyst to assist a major London consultancy client by transforming their disorganized data into clear, actionable reports. Your primary tasks will involve migrating information from disparate spreadsheets into structured, reliable systems that provide valuable insights for management. This is a permanent, full-time role ideal for those early in their data analytics career eager to learn how professional data systems are developed and maintained.

Key Responsibilities

• Convert fragmented raw data into understandable and functional reports aligned with client needs.
• Collaborate with developers remotely to effectively locate and retrieve data from various databases.
• Clean and organize inconsistent or poorly formatted data records to ensure accuracy.
• Create dashboards and visualizations that present complex numbers in a simple manner accessible to non-technical users.
• Produce walkthrough videos and straightforward documentation to guide the client in using created tools.
• Maintain rigorous attention to detail to ensure reporting matches source data precisely.

Candidate Profile and Required Skills

We are looking for an organized individual who enjoys bringing clarity to complex information. Although extensive professional experience is not mandatory, the following foundational skills and attitudes are essential:

• Fundamental understanding of SQL and principles of database data organization.
• Ability to simplify complicated numerical data through clear and readable charts.
• Good written communication skills to prepare documentation and client updates.
• Comfortable working independently within a fully remote setting.
• Patient and methodical approach to cleaning and handling inconsistent data.
• A willingness to acquire new skills and adapt to specific project requirements.
• Strong attention to detail to verify that reports are consistent with original data sources.

Preferred Additional Experience

• Exposure to Postgres or other relational database systems.
• Experience using BI tools such as Tableau, Power BI, or Looker.
• Basic understanding of APIs for moving data between different software applications.
• Educational background in business, statistics, or related disciplines to support analytical thinking.
• Familiarity with version control systems like GitHub.
• Knowledge of basic Microsoft Excel functions for initial data handling prior to database migration.

Working Environment at Pixel Systems

Our small team focuses on meaningful work without distractions from corporate politics. You will have direct mentorship from seasoned developers and be free from complex management layers. We value clarity, honesty, and delivering correct results efficiently. While we are fully remote, flexible work hours are supported as long as deliverables progress and you participate in scheduled team meetings.

We emphasize high-quality documentation to complement reliable software development. Your efforts will have visible impact as clients utilize the dashboards you create for daily operations and project planning. This role offers a stable and productive setting conducive to career growth in data analytics.

Our straightforward style avoids lengthy meetings and unfocused brainstorming. Problems are quickly identified, decisions made, and solutions built. If you appreciate a practical, results-driven atmosphere where your contributions help others perform better, you will fit well with our collaborative remote culture.