The role involves designing and developing scalable BI and Data Warehouse (DWH) solutions, leveraging tools like Power BI, Tableau, and Azure Databricks. Responsibilities include overseeing ETL processes using SSIS, creating efficient data models, and writing complex SQL queries for data transformation. The candidate will design interactive dashboards and reports, working closely with stakeholders to translate requirements into actionable insights.
The role requires expertise in performance optimization, data quality, and governance. It includes mentoring junior developers and leveraging Python for data analysis (Pandas, NumPy, PySpark) and scripting ETL workflows with tools like Airflow. Experience with cloud platforms (AWS S3, Azure SDK) and managing databases such as Snowflake, Postgres, Redshift, and MongoDB is essential.
Qualifications include 6-15+ years of BI architecture and development experience, a strong background in ETL (SSIS), advanced SQL skills, and familiarity with the CRISP-DM model. The candidate should also possess skills in web scraping, REST API interaction, and data serialization (JSON, CSV, Parquet). Strong programming foundations with Python and experience in version control for code quality and collaboration are required for managing end-to-end BI projects.
