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:
- Everyone at Avenga is subject to professional growth via our mentorship program;
- Our specialists get regular performance reviews and technical assessments to identify development plans;
- The company provides extended training and certification opportunities;
- Opportunity to take up to 21 days of unpaid time off per year for any reason;
- Designated HR partner to support you with any HR-related matters on your way with Avenga.
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.