Who We Are
Building the AI-first frontier enterprise.
We are a global technology consultancy with a trademarked, AI-first approach—Gen-e2™. It redefines how enterprises build digital products and transform their organizations with AI. We do the right thing, and we do it right. We're proud to be a World Economic Forum New Champion, and a B Corp-certified company.
- We are small enough to care locally, big enough to deliver globally (10 countries, 450+ experts from 50+ nationalities)
- We are becoming an agentic organization, adopting the AI-native operating model we bring to our clients.
- We are robust and resilient (100% independent, 0 debt, founded 2009)
- We are AI-native professionals who invest in what we believe and work as a collective intelligence
- We are positive, courageous and deliver at the leading edge
Your Role
As a BI Analyst Semi Senior – Reporting & Report Control at PALO IT, you will be responsible for managing, monitoring, controlling, and ensuring the quality of reporting processes, guaranteeing the correct generation, validation, traceability, and delivery of approximately 182 reports with different frequencies.
- Manage and monitor the generation process of 182 reports with daily, weekly, monthly, and eventual frequencies.
- Validate the correct generation, totalization, delivery, and storage of reported figures.
- Ensure the traceability and auditability of the information delivered.
- Identify reports with zero data, abrupt drops, unusual increases, or inconsistencies.
- Analyze historical trends and variations in reported figures.
- Review execution, generation, rendering, or report delivery errors.
- Control logs, tracking records, execution statuses, and reprocessing activities.
- Design and automate controls to validate and reconcile information.
- Build monitoring dashboards to track the status of reports.
- Generate early alerts for failed, incomplete, or suspicious reports.
- Document business rules, information sources, queries, procedures, and controls.
- Support technical and functional users in interpreting figures and inconsistencies.
- Propose improvements focused on automation and reducing manual controls.
- Keep the inventory of reports, owners, frequency, and recipients up to date.
Who You Are
- 2+ years of experience in roles related to BI and reporting, information analysis and control, SQL development, ETL processes, and report administration and support.
- Experience developing and maintaining SSIS packages and administering SSRS reports.
- Experience monitoring scheduled executions, managing logs, tracking records, reprocessing activities, and validating figures and data quality controls.
- Intermediate/advanced knowledge of SQL Server and T-SQL, including queries, stored procedures, views, and functions.
- Experience with SSIS (SQL Server Integration Services) for developing, maintaining, and monitoring ETL processes.
- Experience with SSRS (SQL Server Reporting Services), including report administration, support, monitoring, subscriptions, and execution logs.
- Experience with SQL Server Agent for scheduled jobs and executions.
- Knowledge of ETL processes, data validation, figure totalization and reconciliation, and the design of audit and traceability tables.
- Advanced Excel skills.
- Strong analytical skills and attention to detail, with a critical mindset and an orientation toward information quality and control.
- Ability to identify inconsistencies, investigate root causes, document processes, and communicate clearly with technical and non-technical users.
- Autonomy, results orientation, prioritization of critical reports, and a continuous improvement and automation mindset.
Desirable
- Experience with Power BI for control and monitoring dashboards.
- Knowledge of Python / Pandas for automating validations.
- Experience with Oracle, PostgreSQL, or MySQL databases.
- Knowledge of data governance and data quality.
- Experience with information auditing processes.
More About PALO IT
Our clients include some of the world’s most successful companies. We collaborate with leading enterprises, next-generation businesses and frontier partners, shaping what comes next, helping them scale AI and solve complex business and technology challenges.
What We Offer
- Stimulating working environments
- Unique career path
- International mobility
- Internal R&D projects (including Gen-e2™)
- Knowledge sharing
- Personalized training via PALO IT Academy
- Entrepreneurship & intrapreneurship
For more on our team culture and benefits, check out our careers page https://www.palo-it.com/en/career.