Note: The job is a remote job and is open to candidates in USA. SunnyData helps customers power their businesses through scalable data architectures, robust data engineering pipelines, data consumption layers, and accurate ML and AI applications. The Data Analytics Engineer will support reporting and data engineering needs by building and maintaining BI dashboards, translating business requests into visualizations, and modeling and transforming large datasets. The role also involves optimizing SQL and data models, validating data accuracy, documenting metrics, and collaborating with cross-functional teams and clients.
Responsibilities
- Develop, modify, and maintain dashboards and reports in BI tools such as PowerBI, Tableau and Databricks AI/BI
- Translate business requests (submitted via ticketing system) into accurate and actionable data visualizations
- Ensure consistency in definitions, metrics, and data logic across reports
- Optimize queries and dashboards for performance and clarity
- Document logic and assumptions behind key metrics and dashboards
- Advanced SQL knowledge and proven proficiency in writing and optimizing SQL queries
- Create and maintain database views, derived tables, and other analytical objects to support reporting needs
- Proven work in dashboard engineering projects, with a focus on storytelling and usability
- Perform data modeling and transformation tasks to ensure reliable downstream reporting
- Troubleshoot data discrepancies and validate data accuracy across systems
- Collaborate on improvements to data structure and warehouse organization when needed
Skills
- • Advanced SQL knowledge and proven proficiency in writing and optimizing SQL queries
- • Proven work in dashboard engineering projects, with a focus on storytelling and usability
- • Strong SQL proficiency (advanced querying, joins, CTEs, aggregations, window functions)
- • Hands-on experience with cloud based data warehouse
- • Experience building dashboards and reports in BI tools such as Looker, Tableau, Power BI
- • Ability to interpret business requirements and translate them into technical solutions
- • Strong attention to detail and data validation practices
- • Profile oriented toward leading business interactions, defining standards, documenting KPIs and reports, optimizing large data models, and supporting more junior team members
- • Bachelor's Degree in Computer Science or Engineering related field
Benefits
- Health insurance for employees and eligible family members, including spouses, domestic partners, and children, from the first day of employment.
- A minimum of 15 days of paid time off annually.
- Nine paid company holidays.
- An opportunity to grow technical and people skills and lead teams on complex customer projects.
- Opportunities for professional development and career advancement.
- Employees are eligible for performance-based cash incentive awards.
- Innovative environment with cutting-edge technologies and industry leaders in data engineering and AI.
- Collaborative culture with a supportive team that values collaboration and knowledge sharing.
Company Overview