Why Avenga?
Data Analyst
Avenga is seeking a skilled Data Analyst to join our team. Our client is the largest private telecommunications company in Switzerland, offering industry-leading mobile, Internet, TV, and fixed network services for both private and business customers. The client specializes in data consulting services, including Reporting, Data Design, ETL processes, and more.
As part of our team, you will play a critical role in helping to design, build, and maintain robust data solutions that drive business insights and operational efficiency.
What you bring along:
- 4+ years of experience in the Data field;
- Extensive expertise in SQL with familiarity with aggregation and window (i.e. analytical) functions;
- Experience in BI Design and Reporting;
- Deep knowledge of DWH development and deployment processes;
- Understanding of business processes in the Telecom sector, including areas like Customer Service, Sales, B2B, and Finance;
- Experience working in a structured DWH environment;
- Skilled in maintaining documentation and creating technical specifications as required;
- Strong problem-solving abilities and keen attention to detail;
- English proficiency at an Upper-Intermediate level or higher.
Nice to have:
- Understanding of Customer Relations Management concepts, including Subscriptions, FCR, NPS, Churn, and Retention;
- Experience with ETL tools, particularly Informatica Power Center, and familiarity with database systems such as Teradata;
- Hands-on experience with modern BI reporting tools, with a preference for QlikView and Qlik Sense
This is your mission:
- Collaborate with business stakeholders to gather and translate requirements into Data Warehouse (DWH) objects that integrate seamlessly into reporting solutions;
- Develop conceptual, logical, and physical data models to organize, represent, and store data effectively;
- Analyze business needs, design, and implement data-driven solutions;
- Create and manage data objects, including tables, views, and ETL mappings;
- Design and implement data models, adhering to development guidelines and best practices;
- Conduct SQL view definition, script reviews, and debugging to resolve issues and incidents;
- Perform data design testing to validate and ensure data quality, accuracy, and consistency in both DWH and source systems, supporting User Acceptance Testing (UAT).
Your benefits:
- We offer an attractive social and benefits package;
- Everyone at Avenga is subject to professional growth via our mentorship program;
- The company provides extended training and certification opportunities;
- We stay up to date with the industry by embarking on tech talks, webinars, conferences, and hackathons;
- Avenga cares for its employees well-being by providing well-rounded health insurance coverage and fitness compensation programs;
- Our employees’ families are no less important, as we offer maternity aid and financial support for a number of family reasons, including marriage and childbirth;
- The company fosters a sense of professional belonging and an environment of togetherness: we achieve things together and celebrate our milestones.
Svitlana Liaskovska
Lead Recruiter
More than just a place to work
Avenga is a perfect environment for anyone eager to build a successful meaningful career, as we work with both global and local projects.
Continuous care for people
Our employees are the company’s biggest asset. The reason we excel at projects is because we take proper care of our professionals who stand behind the solutions we deliver.
Global unity
We are an international team of like-minded digital transformation proponents from Ukraine, Germany, Poland, the US and Malaysia.
Sustainable growth
We care for the planet and we care for people. This is why we aspire for sustainable excellence when it comes to setting up processes at Avenga and how we choose the projects we work on.
Mature experts you will cherish working with
Avenga is a self-development organism where seniors grow by mentoring juniors and vice versa.
Constant professional development
We believe there is always room for improvement. We will foster your growth by guiding and supporting you along your chosen path.