KWAN27.01.26
AI SCORE 8.5

Mid-Senior Business Intelligence Analyst - Hybrid Opportunity

$60K–$80K/year

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!

Language Requirements
EnglishB1
PortugueseC1
BasicIntermediateAdvancedNative
Why This Job8.5 of 10

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.

Salary Range
Required
0/1
Optional
0/1
Bonus
0/1

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.

Industry
Tech
Location
On-site

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

SQL Server Tutorialguide

Career Path

Mid-Senior Business Intelligence Analyst(Now)Senior Business Intelligence Analyst / Data Architect(2-4 years)Lead Data Analyst / BI Manager(4-6 years)

Market Overview

Market Size 2024
$45B
Annual Growth
10.5%
AI Adoption
38%
Investment
+25%
Labour Demand
+15%
Avg Salary
$95K

Skills & Requirements

Required
SQL ServerSSIST-SQL
Growing in Demand
Azure Data FactoryPower BIData Warehousing
Declining
Oracle PL/SQLMicrosoft Access

Domain Trends

Increased Cloud Adoption
By 2025, over 70% of SQL Server workloads are expected to migrate to cloud platforms, driven by the need for scalability and cost-effectiveness.
Rise of Self-Service BI Tools
Self-service BI tools usage has increased by 50% in organizations, allowing non-technical users to generate insights without deep SQL knowledge.
Integration of AI in Data Analytics
AI-driven analytics solutions are projected to increase by 30% annually, enhancing data processing and predictive analytics capabilities.

Industry News

Loading latest industry news...

Finding relevant articles from the last 6 months

All job postings are automatically gathered by algorithms. We do not review or verify listings, be careful when applying and do not sign-in with iCloud or Google services.