Job Description
We are seeking a BI Developer with strong experience in the Microsoft BI stack, Python, and Apache Airflow to build scalable data pipelines and analytical solutions across multiple business domains. The role supports a variety of reporting and analytics use cases, including finance, while also working with operational and enterprise data.
Key Responsibilities
• Design, develop, and maintain end-to-end data pipelines using Python, Apache Airflow, and Microsoft data platform
• Build and optimize ETL/ELT workflows using SSIS, and Python
• Develop and maintain Power BI dashboards and self-service analytics solutions
• Design and manage data warehouse and data mart solutions (star/snowflake schemas)
• Develop and optimize SSAS Tabular models and semantic layers
• Write and optimize complex T-SQL queries, views, and stored procedures
• Orchestrate, schedule, and monitor workflows using Apache Airflow (DAGs, operators, monitoring, alerting)
• Integrate data from Data Sources, business applications, APIs, and flat files
• Implement data quality, validation, reconciliation, and monitoring frameworks
• Apply data security, row-level security (RLS), and governance, lineage and metadata tools best practices
• Collaborate with stakeholders across Finance, Operations, Product, and Analytics teams
• Document data models, pipelines, and BI solutions
Required Skills & Qualifications
• Strong proficiency in Python for data transformation and automation
• Hands-on experience with Apache Airflow for workflow orchestration
• Advanced experience with SQL Server/ SSIS/ SSAS / T-SQL and query optimization
• Strong understanding of ETL/ELT patterns, incremental loads, and scalable data pipelines
• Experience working with data lakes and data warehouses
• Strong experience with Power BI (DAX, Power Query, data modeling)
• Experience with SSAS Tabular and SSRS
• Ability to translate business requirements into effective analytical solutions Domain Knowledge
• Experience supporting finance-related reporting and analytics
• Exposure to operational, sales, or other enterprise data domains
• Understanding of data quality, controls, and auditability, especially for critical business data
Preferred / Nice-to-Have Skills
• Experience with KAFKA and CLICKHOUSE
• CI/CD for data pipelines
Education & Experience
• Bachelor’s degree in Computer Science, Information Systems, Data, or related field
• 3+ years of experience in BI and/or data engineering roles