Business Intelligence Analyst

Job Description

*Description of the job position
At Behsazan Mellat, we are looking for cooperation with experienced and creative people in the field of business intelligence. If you are interested in the development of interactive dashboards using data analysis and display tools and their implementation and deployment, and you are looking for your professional growth in a dynamic and specialized environment, there is no place for you in our team.

*Job Responsibilities:

• Participation in the design of data warehouse structure and Cube and packages
• Designing tables and determining indexes according to the identified requirements (KPI).
• Designing the ETL process and writing optimal queries
• Designing appropriate analytical dashboards for monitoring indicators-criteria (KPIs)
• Testing the quality and accuracy of data and reports in order to ensure the accuracy of performance and the fulfillment of expected results
• System analysis by interacting with other analysts, programmers, managers, banking group and business owner
• Analyzing, writing and extracting reports and documentation in all stages (from the initial design to after the installation of the system)
• Analyzing errors and limitations of jobs and reports in order to optimize according to new hardware or improve their efficiency.
• Preparation of beta and operational versions (transfer of tables, reports, jobs, codes and other required items to the operational environment) in order to provide conditions for beta testing and error-free installation

*Specialized skills:

• SQL language and full knowledge of database entities
• Concepts of BI and data warehouse
• Concepts of ETL
• Concepts of Reporting & Cubes
• Relative mastery of the key factors of query optimization, table design and indexing
• Familiarity with banking business
• Familiarity with pipeline creation tools such as Airflow, SSIS, IBM Data Stage
• Familiarity with Python, Fast API

*General competencies:

• Responsiveness
• Continuous learning
• time management
• Critical thinking and problem solving
• Creativity

*Qualifying conditions:

• Those born in 1368 onwards
• At least 2 years of related work experience
• Degree and specialization: Bachelor of software, applied mathematics, statistics, computer science
• Termination of service or permanent exemption is mandatory for men.
• Working hours: Saturday to Wednesday, 8:00 a.m. to 17:00 p.m

*Benefits of cooperation with Behsazan Mellat:
Loans, incentives, project bonuses, supplementary insurance (for you and your family), travel facilities, health services (doctor, psychologist, nutrition) and special packages throughout the year.