About the job
Business Intelligence (BI) Analytics Engineer
At SunnyData, we are dedicated to guiding our clients through their data journeys, helping them harness the power of data to drive their businesses forward. We believe that a strong foundation is crucial for achieving exceptional data-driven results, including scalable architectures, robust data engineering pipelines, user-friendly data consumption layers, and precise ML and AI applications. We are in search of a Business Intelligence (BI) Analytics Engineer who will play a pivotal role in supporting our ongoing reporting and data engineering requirements. This position will primarily focus on creating and managing business reports across various BI tools, as well as executing data modeling and transformation with extensive datasets.
A proactive approach, excellent communication abilities, and a collaborative spirit are essential for success in this role.
The Impact You Will Have
1. Business Intelligence & Reporting
Develop, modify, and maintain dashboards and reports utilizing BI tools like PowerBI, Tableau, and Databricks AI/BI.
Translate business requests (submitted via a ticketing system) into actionable data visualizations.
Ensure uniformity in definitions, metrics, and data logic across all reports.
Optimize queries and dashboards for enhanced performance and clarity.
Document the logic and assumptions that underpin key metrics and dashboards.
2. Data Engineering & Data Modeling
Possess advanced SQL knowledge and demonstrated proficiency in writing and optimizing SQL queries.
Create and maintain database views, derived tables, and other analytical objects to meet reporting requirements.
Demonstrate experience in dashboard engineering projects, emphasizing storytelling and usability.
Conduct data modeling and transformation tasks to ensure reliable downstream reporting.
Identify and resolve data discrepancies while validating data accuracy across systems.
Collaborate on enhancements to data structure and warehouse organization as necessary.
3. Deliverables & Success Criteria
Deliver accurate, well-documented dashboards within agreed service level agreements (SLAs).
Provide clean, reusable SQL objects that support long-term reporting needs.
Enhance clarity and consistency in metric definitions.
Minimize back-and-forth communication on reporting requests due to thorough documentation and clarity.

