Data Warehouse Analyst

Billennium; Kraków; On-site; PLN 120,000 - 180,000; Full time

Benefits offered by this job

Comprehensive benefits

Career growth

Global collaboration

Innovative environment

Engaging community

Team-building events

Welcome pack

Job summary

Billennium is a global technology company with over 20 years of experience, committed to innovation and empowering businesses. As an employer, we offer a supportive, growth-focused environment where collaboration and creativity thrive.

We are looking for an experienced Data Warehouse Analyst to bridge business and technology by analyzing requirements, designing data models, and preparing functional specifications for development teams.

Qualifications

• 3+ years of experience as a Data Warehouse Analyst or similar analytical role.
• Strong experience with relational databases and advanced SQL, preferably Oracle.
• Experience analyzing data from multiple source systems and creating ER diagrams.
• Knowledge of data warehouse concepts and data integration processes.
• Experience in Agile environments and working with cross-functional teams.
• Excellent communication and proactive stakeholder management skills.

Responsibilities

• Participate in development and maintenance of the enterprise Data Warehouse.
• Analyze business requirements and identify data sources across systems.
• Translate business needs into technical specifications for development teams.
• Prepare analytical and functional documentation including ER diagrams and data flow diagrams.
• Collaborate with architects, developers, and DBAs throughout the lifecycle.
• Support design and evolution of Data Warehouse architecture.
• Contribute to solution validation and testing activities.

Skills

Data modeling

ER diagrams

SQL

Oracle

Agile

Stakeholder management

Analytical thinking

Communication

Data integration

Tools

Jira

Confluence

Oracle SQL Developer

Job description

Billennium is a global technology company with over 20 years of experience, committed to innovation and empowering businesses. As an employer, we offer a supportive, growth-focused environment where collaboration and creativity thrive.

Join us to shape the future of technology together!

Role Summary:

We are looking for an experienced Data Warehouse Analyst.

In this role, you will bridge business and technology by analyzing business requirements, designing data models, defining transformation rules, and preparing functional specifications for development teams. You will collaborate closely with architects, developers, database administrators, and business stakeholders to deliver high-quality data solutions that support strategic business initiatives.

Core Responsibilities:

• Participate in the development and maintenance of the enterprise Data Warehouse.
• Analyze business requirements and identify appropriate data sources across multiple systems.
• Work closely with business stakeholders to understand data needs and translate them into technical specifications.
• Prepare analytical and functional documentation, including:
• ER diagrams,
• data flow diagrams,
• business transformation rules,
• Collaborate with architects, developers, and database administrators throughout the solution lifecycle.
• Support the design and evolution of Data Warehouse architecture.
• Participate in solution validation and testing activities.
• Ensure consistency, quality, and completeness of delivered analytical specifications.
• Contribute to Agile ceremonies and cross-functional team collaboration.

Role Requirements:

• 3+ years of experience as a Data Warehouse Analyst, System Analyst, BI Analyst, or a similar analytical role.
• Strong experience working with relational databases and advanced SQL, preferably Oracle.
• Experience analyzing and processing large volumes of data from multiple source systems.
• Strong understanding of Data Warehouse concepts and data integration processes.
• Experience in data modeling and creating Entity Relationship Diagrams (ERD).
• Ability to analyze and design business processes and translate business needs into technical specifications.
• Experience working in Agile environments.
• Ability to work independently while managing multiple stakeholders.
• Strong analytical thinking and problem-solving skills.
• Proactive approach and excellent communication skills.
• Experience within the banking or financial services industry is highly desirable.

Nice to Have:

• Experience with Informatica PowerCenter.
• Experience with Oracle Data Integrator (ODI).
• Experience with Microsoft SSIS.
• Knowledge of Business Intelligence tools.
• Experience working with Lakehouse architectures.
• Familiarity with data governance and data quality practices.

Technologies:

• Oracle
• SQL
• Oracle Data Integrator (ODI)
• Microsoft SSIS
• Business Intelligence tools
• Lakehouse

Tools:

• Jira
• Confluence
• Oracle SQL Developer

Perks and benefits (our offer):

• Comprehensive benefits - enjoy Udemy for Business, private medical care, Multisport card, veterinary package, language lessons, and shopping vouchers.
• Career growth - access opportunities for professional development and learning, including perks related to our official partnerships with global IT giants: Microsoft, AWS, Snowflake, Salesforce & more.
• Global collaboration - work with a diverse, international team.
• Innovative environment - be part of a forward-thinking and growth-oriented workplace.
• Engaging community - Work with passionate professionals and participate in team-building events, hackathons, and CSR initiatives to make an impact beyond work.
• Team-building events including our company tradition (annual company event in Mazury).
• A pleasant surprise to start your journey with us in the form of a welcome pack.