Mid-Senior Business Intelligence Analyst - Hybrid Opportunity
About the Role
We are looking for a Business Intelligence Analyst to work in a hybrid model in Lisbon, Portugal. This exciting opportunity will allow you to leverage your skills in data analysis and contribute to impactful projects. As a Business Intelligence Analyst, you will play a crucial role in developing, maintaining, and optimizing data process pipelines, ensuring data integrity and quality across various systems.
What You'll Do
- Develop, maintain, and optimize data process pipelines using SQL Server and SQL Integration Services (SSIS).
- Implement and manage data integration and synchronization processes between heterogeneous systems, ensuring consistency and error control.
- Evolve relational databases in SQL Server and PostgreSQL, providing support for production environments, tuning, and troubleshooting.
- Create and optimize complex queries in T-SQL and SQL (PostgreSQL), ensuring performance and readability.
- Participate in the design and modeling of data in relational databases.
- Implement data anonymization and pseudonymization mechanisms to protect sensitive information and comply with GDPR.
- Define and apply data quality mechanisms, validations, and reconciliations to ensure integrity and traceability.
- Document technical solutions, data flows, and models for efficient maintenance and knowledge sharing.
- Collaborate with functional and technical teams for requirements gathering and continuous delivery of improvements.
- Work experience in CI/CD with GitLab.
Requirements
- At least 5 years of experience in similar roles.
- Experience with SSIS for data integration.
- Strong knowledge of creating and optimizing complex queries in T-SQL and SQL.
- Experience with CI/CD processes.
- Bachelor's degree in Information Technology or a related field.
- Medium level of English (B1 at least) and fluent Portuguese.
Nice to Have
- Experience with data modeling and database design.
- Familiarity with data visualization tools.
- Knowledge of cloud data solutions.
What We Offer
- A project that matches your skills and ambitions.
- A competitive salary with awesome benefits.
- An empowering and respectful work culture enriched with social and learning events.
- A People Experience Partner assigned to support your growth and work-life balance.
- A relocation package and visa sponsorship for international hires.
Does this sound exciting? Apply now for the Business Intelligence Analyst remote position!
This Business Intelligence Analyst role offers a hybrid work environment in Lisbon with competitive salary and strong career growth support. KWAN emphasizes employee empowerment and offers relocation assistance.
About KWAN
Explore KWAN careers in 2026 and discover exciting job opportunities tailored for you. Browse a variety of remote, hybrid, and office roles with our advanced filters. Utilize application tracking to stay organized and gain valuable company insights to help you succeed. Start your journey towards a fulfilling career at KWAN today and find the perfect position that fits your skills and aspirations.
Who Will Succeed Here
Proficiency in SQL Server and T-SQL for developing complex queries and optimizing database performance, coupled with hands-on experience in SSIS for ETL processes.
Strong analytical mindset with the ability to derive insights from data, demonstrating a passion for data integrity and quality, essential for maintaining robust data pipelines in a hybrid work environment.
Experience with CI/CD practices in data integration projects, showcasing an understanding of how to streamline deployment processes and improve collaboration in a hybrid setup.
Learning Resources
Career Path
Market Overview
Skills & Requirements
Domain Trends
Industry News
Loading latest industry news...
Finding relevant articles from the last 6 months