Напиши текст вакансии для должности "PowerBi/Business Intelligence Analyst". Название компании: "A&D Mortgage". Расположение: Санкт-Петербург. График работы: Полный день. Опыт работы: От 1 года до 3 лет. Ключевые навыки: 'Python', 'MS SQL Server', 'Английский язык', 'Olap (online analytical processing)', 'SQL', 'Data Analysis', 'Business Intelligence Systems'

Let’s get acquainted: AD Mortgage is:  One of the TOP Direct Mortgage Lender with almost 20 years history, which offers a full spectrum of innovative lending products to meet a home buyer’s needs in the USA Headquarter in Hollywood, FL. We represent our A+++ service in 11 states but are striving to obtain licenses in every State of US and to become a Nationwide Mortgage Lender Our employees are our most valuable resource and their knowledge and expertise play an important role in achieving our Client’s goals. We are 150+ employees, and it’s just a beginning.  We are waiting for responsible, motivated, diligent employees who are ready for efficient work with details and constant development in cooperation and completing projects with members from abroad. We offer:  Incredible international experience in mortgage loaning without relocating from Russia Amazing atmosphere in a team of like-minded people, who strive to grow-up in a professional way Perfect opportunity to improve your English with native speakers Everything you need for comfortable work: competitive salary (totally white), official employment according to Russian labor legislation, fixed working schedule (5/2), comfortable office with good transport accessibility, corporate training system (paid internship), the possibility of continuous development and local training.  Job description:  Translate reporting business needs to technical specifications and execute solution Work with business users and IT Team at all level for performance improvement and suggestions Design, build and deploy BI solutions (e.g. reporting tools) Evaluate and improve existing BI systems Create tools to store data (e.g. OLAP cubes) Develop and execute database queries and conduct analyses Create visualizations and reports for requested projects Develop and update technical documentation Develop automated reports and dashboards using Power BI and other reporting tools Connecting to data sources, importing data and transforming data for BI. Proficient in making DAX queries in Power BI desktop.    Requirements:  BSc/BA in Computer Science, Engineering or relevant field Proven experience as a BI Developer or Data Scientist Financial Industry experience is preferred Understanding of database management systems, OLAP and ETL framework Familiarity with BI technologies (e.g. Microsoft Power BI,) Excellent in analytical thinking for translating data into informative visuals and reports. Knowledge of SQL queries, SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS) Experience using Python and various community libraries for Data Science Able to integrate Power BI reports into other applications using embedded analytics like Power BI service (SaaS), or by API automation Proven experience in Excel Create, customize charts and custom calculations as per requirements Proven abilities to take initiative and be innovative Analytical mind with a problem-solving aptitude English at upper or intermediate level