Data Warehouse Analyst

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.

#J-18808-Ljbffr