About the job
Business Intelligence (BI) Analytics Engineer
At SunnyData, we are dedicated to empowering our clients in their data journey, enabling them to drive their business forward. We understand that a robust data foundation is essential for achieving exceptional data-driven outcomes, which include highly scalable architectures, trustworthy data engineering pipelines, user-friendly data consumption layers, and precise machine learning and artificial intelligence applications. We are on the lookout for a Business Intelligence (BI) Analytics Engineer who will be instrumental in fulfilling ongoing reporting and data engineering requirements. This role emphasizes the development and maintenance of business reports across various BI platforms, along with modeling and transforming extensive datasets.
We value a proactive approach, excellent communication skills, and the ability to work collaboratively with cross-functional teams.
The Impact You Will Make
1. Business Intelligence & Reporting
Create, update, and sustain dashboards and reports using BI tools such as PowerBI, Tableau, and Databricks AI/BI.
Interpret business requests submitted via a ticketing system into precise and actionable data visualizations.
Maintain consistency in definitions, metrics, and data logic throughout reports.
Enhance performance and clarity of queries and dashboards.
Document the logic and assumptions behind critical metrics and dashboards.
2. Data Engineering & Data Modeling
Possess advanced SQL expertise and demonstrated ability to write and optimize SQL queries effectively.
Develop and maintain database views, derived tables, and other analytical components to support reporting needs.
Experience in dashboard engineering projects, emphasizing storytelling and user experience.
Conduct data modeling and transformation tasks to guarantee reliable reporting downstream.
Identify and resolve data discrepancies while ensuring data accuracy across systems.
Collaborate on enhancements to data structure and warehouse organization as needed.
3. Deliverables & Success Criteria
Deliver accurate, well-documented dashboards within agreed-upon service level agreements (SLAs).
Provide clean, reusable SQL objects that cater to long-term reporting requirements.
Enhance clarity and consistency in metric definitions.
Minimize back-and-forth communications on reporting requests through thorough documentation.
