Mid Data Analyst in Banking
Share
Job Location:
Monthly Salary:
Posted on:
2 days ago
Vacancies:
1 Vacancy
Job Summary
Position Description:
We are looking for a Mid-Level Data Analyst to support the development of a banking Data Warehouse environment and deliver high-quality reporting and data visualizations in Power BI.
This role combines advanced data analysis SQL-based transformation logic design close cooperation with IT teams on ETL processes and independent development of business-facing dashboards and reports. You will work in a collaborative Agile environment supporting data-driven decision-making across the organization.
Your future duties and responsibilities:
Gathering and refining business requirements related to data and reporting needs
Analyzing data availability within the Data Warehouse and performing gap analysis
Identifying missing data sources in cooperation with Data Stewards and system owners
Defining business logic KPIs and data definitions with stakeholders
Developing advanced SQL queries for data extraction transformation and aggregation
Preparing detailed analytical documentation and transformation logic for ETL implementation
Validating ETL implementation against defined business rules and SQL logic
Performing data validation reconciliation and quality checks
Designing and developing Power BI reports and dashboards for business users
Building and maintaining data models in Power BI (relationships calculated columns measures)
Creating KPIs and calculations using DAX
Ensuring clarity usability and performance optimization of reports
Translating analytical findings into clear visual insights and actionable recommendations
Monitoring and improving data quality and consistency
Supporting integration with Master Data / MDM
Ensuring alignment with Data Governance standards and best practices
Working in an Agile environment (Scrum / Kanban)
Collaborating closely with business stakeholders IT Data Engineers and governance teams
Supporting junior team members when needed
Required qualifications to be successful in this role:
Strong knowledge of SQL (complex joins aggregations subqueries window functions)
Practical experience with Power BI including report and dashboard development data modeling and DAX measures
Experience working in Data Warehouse environments and understanding of ETL concepts
Ability to perform gap analysis and translate business needs into technical data solutions
Experience working with stakeholders and independently driving analytical tasks
Good understanding of banking products and processes
Strong analytical thinking and problem-solving skills
Very good communication skills and ability to clearly explain data insights
Nice to have:
Knowledge of Data Governance / MDM concepts
Experience with regulatory reporting risk or finance data
Basic knowledge of Python (pandas) for advanced analysis
Experience mentoring junior analysts
#LI-MC2
Skills:
- Data Analysis
- Polish
- Banking
- English
What you can expect from us:
Together as owners lets turn meaningful insights into action.
Life at CGI is rooted in ownership teamwork respect and belonging. Here youll reach your full potential because
You are invited to be an owner from day 1 as we work together to bring our Dream to life. Thats why we call ourselves CGI Partners rather than employees. We benefit from our collective success and actively shape our companys strategy and direction.
Your work creates value. Youll develop innovative solutions and build relationships with teammates and clients while accessing global capabilities to scale your ideas embrace new opportunities and benefit from expansive industry and technology expertise.
Youll shape your career by joining a company built to grow and last. Youll be supported by leaders who care about your health and well-being and provide you with opportunities to deepen your skills and broaden your horizons.
Come join our teamone of the largest IT and business consulting services firms in the world.
Required Experience:
IC
Key Skills
- Data Analytics
- Microsoft Access
- SQL
- Power BI
- R
- Data Visualization
- Tableau
- Data Management
- Data Mining
- SAS
- Data Analysis Skills
- Analytics
About Company
The COMPANY is one of the few end-to-end consulting firms with the scale, reach, capabilities and commitment to meet clients’ enterprise digital transformation needs. Our 77,500 consultants and professionals work side-by-side with clients in 10 industries across more than 400 location ... View more
