BI Developer (Business Intelligence)

About the Role:

We are looking for a Business Intelligence (BI) Developer to design, develop, maintain, and monitor data warehouse and analytics architecture and have deep insight into the BI project life cycle. As a BI developer, you will be creating data architecture within the Microsoft BI Platform to respond to business requirements. This role involves delivering robust data integration projects and, therefore, requires using the best practices and experience at implementation.

Responsibilities:

• Design, optimize, and monitor data infrastructure (data warehouse, OLAP, etc.)
• Design and implement ETL pipelines from multiple data sources; as well as ensure data quality
• Collaborate with business and technology stakeholders to ensure data infrastructure architecture aligns with organization objectives
• Monitoring query and ETL pipeline performance and ensuring to meet acceptable performance criteria
• Create visualizations and reports for requested projects
• Develop and update technical documentations

Requirements:

• Highly experienced in Microsoft BI Stack (SQL Server, SSIS, SSAS(Tabular), and SSRS)
• Highly experienced in developing T-SQL
• High proficiency in dimensional modeling techniques
• Strong analytical, consultative, and communication skills; and the ability to make good judgments and work with both technical experts and business stakeholders
• Practical experience with Power BI or other reporting tools
• Fairly skilled in Data Quality principles and concepts
• Familiar with SQL Server administration tasks
• Fairly skilled in query and database performance tuning
• Familiarity with “big data” technologies (Kafka, Hive, Spark, etc.) is a plus
• Familiarity with Python data packages (PyData tools such as Pandas, Numpy, Matplotlib, etc.) is a plus
• Practical experience with C# is a plus