Analytics (BI) Engineer

Openkrill; United States; Remote; USD 90,000 - 130,000; Full time

Job summary

SunnyData is seeking an Analytics (BI) Engineer to build and maintain business reports, perform data modeling, and support scalable data pipelines. You will translate business requests into visualizations, ensure metric definitions are consistent, and collaborate with cross-functional teams to improve reporting accuracy and performance.

The role emphasizes hands-on SQL, dashboard engineering, and working with cloud data warehouses, Looker/Tableau/Power BI experiences, and a mindset for data

Qualifications

• 4+ years of analytics/BI and data engineering experience.
• Strong SQL proficiency with advanced querying, joins, CTEs, aggregations, and window functions.
• Hands-on experience with cloud-based data warehouses.
• Experience building dashboards and reports in BI tools (Looker, Tableau, Power BI).
• Ability to interpret business requirements and translate them into technical solutions.
• Strong attention to detail and data validation practices.

Responsibilities

• Develop, modify, and maintain dashboards and reports in BI tools such as PowerBI, Tableau and Databricks AI/BI.
• Translate business requests 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.
• Create and maintain database views and derived tables to support reporting needs.
• Perform data modeling and transformation tasks to ensure reliable downstream reporting.
• Troubleshoot data discrepancies and validate data accuracy across systems.

Skills

Advanced SQL

Data modeling

Data storytelling

Cross-functional collaboration

Requirement translation

Education

Bachelor's degree in CS/Engineering

Tools

Looker

Tableau

Power BI

Job description

ANALYTICS (BI) ENGINEER

At SunnyData our mission is to help our customers in their data journey to power their business. We believe a solid foundation is the key to achieving outstanding data driven results: highly scalable architectures, robust data engineering pipelines, simple data consumption layers and accurate ML and AI applications. We are seeking a Data Analytics Engineer to support ongoing reporting and data engineering needs. This role will focus on building and maintaining business reports in different suites of BI tools, as well as performing modeling and transformation with large datasets.

A proactive mindset, strong communication skills and ability to collaborate closely with cross-functional teams are key.

The Impact You Will Have

1. BUSINESS INTELLIGENCE & REPORTING

• 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.

2. DATA ENGINEERING & DATA MODELING

• 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.

3. DELIVERABLES & SUCCESS CRITERIA

• Accurate, well-documented dashboards delivered within agreed SLAs.
• Clean, reusable SQL objects supporting long‑term reporting needs.
• Improved clarity and consistency in metric definitions.
• Reduced back‑and‑forth on reporting requests due to thoughtful implementation.

What We Look For

• 4+ years of related experience in analytics/BI and data engineering.
• 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.

Education:

• Bachelor’s Degree in Computer Science or Engineering related field.

Our Commitment to Diversity and Inclusion:

SunnyData is dedicated to building a workforce that reflects the world around us. We are an equal opportunity employer committed to unbiased hiring practices. All qualified applicants will receive consideration for employment without regard to race, religion, gender identity, disability, veteran status, or any other protected characteristic.

Why Join SunnyData?

• Innovative Environment: Work with cutting‑edge technologies and industry leaders in data engineering and AI.
• Customer Impact: Make a real difference in how businesses leverage data for strategic decision‑making.
• Career Growth: Opportunities for professional development and career advancement.
• Collaborative Culture: Join a supportive team that values collaboration and knowledge sharing.