Senior Technical BA & BI Developer

About the role

An organization with an urgent need for BI developers is looking for a Senior Technical Business Analyst and BI Developer. The role covers designing and maintaining data warehouse ETL processes, building dashboards and reports, and using predictive modelling to improve business outcomes.

Key responsibilities

• Design, develop and test data warehouse ETL processes.
• Develop and enhance ETL (SSIS), OLAP (SSAS) and OLTP models, and maintain and tune ETL jobs.
• Manage and optimize data warehouse activities and support data warehouse process development.
• Create dashboards and interactive reports in Power BI, and oversee their editing and support.
• Plan analytical models such as forecasting, classification and clustering, and use predictive modelling to improve user experience, revenue, and ad targeting.
• Integrate data from external sources and generate periodic or ad hoc reports for stakeholders.
• Collaborate with cross-functional teams.

Required profile

• Bachelor's degree in Computer Engineering; Master's or Ph.D. is a plus.
• At least 5 years of experience in a similar role, with a strong background in data management, analysis and reporting.
• Excellent verbal and written communication skills in English.
• No military obligation for male candidates.

Required skills

• Strong understanding of SQL and expert-level MS SQL query.
• Microsoft SSIS, SSAS, SSRS and Power BI.
• Python or R.
• ETL and data modelling, data warehousing concepts (SCD, partitioning).
• Probability, statistics, machine learning and advanced analytics (regression, classification, clustering, causal inference).
• DAX is a distinct advantage; ERP and CRM experience is a plus.