We are seeking a talented and experienced Business Intelligence (BI) Developer to join our data team. In this role, you will be responsible for designing and delivering insightful, high-impact analytical reports and dashboards to support business decision-making across departments. As a BI Developer, you will play a pivotal role in transforming complex data into actionable insights for top management and operational teams.
Key Responsibilities
- Design, develop, and maintain interactive reports and dashboards using industry-leading BI tools, primarily Microsoft Power BI.
- Translate business requirements into technical specifications and provide efficient solutions that meet end-user needs.
- Engage with stakeholders including business users, product owners, and senior management to gather reporting requirements and translate them into insightful visualizations.
- Develop and maintain data models (normalized, denormalized, star, and snowflake schemas) that support reporting and analysis needs.
- Write complex SQL queries for data extraction, manipulation, and transformation across various relational and non-relational databases such as Microsoft SQL Server, PostgreSQL, NoSQL, and Timeseries databases.
- Optimize SQL queries for performance, including profiling, indexing strategies, and tuning for efficiency and scalability.
- Work closely with data engineers to propose enhancements or changes to data schemas in order to support evolving analytical needs.
- Establish and maintain BI development best practices, standards, and reporting terminologies to ensure consistency across all reports.
- Document technical processes, data definitions, and metadata for future reference and knowledge sharing.
- Monitor the performance and usage of BI solutions and propose enhancements to improve usability and efficiency.
- Identify opportunities to automate reporting processes and reduce manual efforts.
- Ensure that all BI deliverables align with business goals and help drive data-informed decision-making across the organization.
Qualifications & Skills
- A minimum of 5 years of hands-on experience as a BI Developer or Data Analyst in a business intelligence or analytics environment.
- Proficiency in Microsoft Power BI (or other modern BI tools such as Tableau, QlikView, Looker) with a strong portfolio of dashboards and reports.
- Deep understanding of data modeling principles including relational and dimensional modeling.
- Expertise in writing and optimizing complex SQL queries for data extraction and transformation.
- Strong experience in working with large datasets, including performance tuning and query optimization techniques.
- Knowledge of database systems including Microsoft SQL Server, PostgreSQL, NoSQL, and Timeseries databases.
- Familiarity with ETL processes and data pipeline architecture is a plus.
- Strong problem-solving skills with an ability to understand business problems and translate them into technical solutions.
- Excellent written and verbal communication skills, with the ability to clearly explain complex data topics to non-technical stakeholders.
- Ability to work both independently and collaboratively in a cross-functional team environment.
- Exposure to supply chain, order management, and logistics domains is an added advantage.
- Experience in working in Agile/Scrum development environments is preferred.
What You Can Expect
- A dynamic and collaborative work culture where your ideas and insights are valued.
- Opportunity to work on high-impact projects that directly influence strategic business decisions.
- Continuous learning and growth opportunities in the evolving world of data analytics and BI.
- Access to modern tools, infrastructure, and support to help you succeed in your role.
This role requires a strong analytical mindset, a passion for data visualization, and the ability to collaborate effectively with stakeholders from different functional areas, including supply chain, order management, and logistics.