Data Visualization and Reporting Developer

Jobtailor; Deutschland; Vor Ort; EUR 60.000 - 90.000; Vollzeit

Zusammenfassung

Jobtailor is seeking a skilled BI Analyst to design, develop, and publish interactive reports and dashboards in Tableau and Power BI, ensuring accuracy, performance, and usability.

You will build semantic data models on Snowflake, write efficient SQL, validate data lineage, and collaborate with data engineers. This role emphasizes governance, self-service enablement, and strong communication.

Qualifikationen

• Design, develop, and publish interactive reports and dashboards in Tableau and Power BI meeting business requirements.
• Build semantic data models, calculated fields, measures (DAX), and Tableau LOD expressions on Snowflake data.
• Author efficient SQL queries and views in Snowflake to support reporting needs, including CTEs and window functions.

Aufgaben

• Partner with data engineers and architects to validate the data model and ensure data quality.
• Gather and document requirements from stakeholders, translating needs into specifications and analytics solutions.
• Implement data governance practices and manage permissions and datasets in BI tools.

Kenntnisse

Tableau Desktop

Power BI

SQL (Snowflake)

Data Modeling

DAX

ETL/ELT Concepts

Ausbildung

Bachelor's degree in a related field

Tools

Snowflake

dbt

Git

Jira

Confluence

Jobbeschreibung

Responsibilities

• Design, develop, and publish interactive reports and dashboards in Tableau and Power BI that meet business requirements for accuracy, performance, and usability.
• Build and optimize semantic data models, calculated fields, measures (DAX), and Tableau LOD expressions on top of client Snowflake data warehouse.
• Author efficient SQL queries and views in Snowflake to support reporting needs, including the use of CTEs, window functions, and performance tuning techniques (clustering, query profile analysis, materialized views).
• Partner with data engineers and architects to validate the data model, define metric definitions, and ensure data lineage and quality across reporting layers.
• Gather and document requirements from business stakeholders, translating ambiguous needs into clear specifications, mockups, and delivered analytics solutions.
• Implement row-level security, workspace governance, and certified dataset patterns in Power BI; manage permissions, projects, and data sources in Tableau desktop.
• Establish and follow BI development best practices, including version control, code reviews, naming conventions, documentation, and CI/CD where applicable.
• Monitor dashboard performance and usage, proactively optimizing slow queries, redesigning inefficient visuals, and retiring unused content.
• Support self-service analytics by curating trusted datasets, providing enablement, and mentoring business users on BI tools.

Requirements

• Strong hands‑on expertise with Tableau Desktop, including LOD expressions, parameter actions, dashboard actions, and performance tuning.
• Strong hands‑on expertise with Microsoft Power BI, including Power Query (M), DAX, data modeling (star schema, role‑playing dimensions), and the Power BI Service.
• Advanced SQL proficiency, with demonstrated experience writing complex analytical queries on Snowflake (preferred).
• Solid understanding of dimensional modeling, ELT/ETL concepts, and modern data warehouse architecture.
• Ability to translate business questions into data models, metrics, and visualizations that are accurate, performant, and easy to interpret.
• Strong data visualization sensibility — knows when to use which chart type, how to design for the audience, and how to avoid common visualization pitfalls.
• Proficiency with version control (Git) and familiarity with collaborative development workflows.
• Excellent written and verbal communication skills, with the ability to work effectively across technical and non‑technical audiences.
• Experience with dbt for data modeling and transformation in Snowflake (preferred).
• Familiarity with data analysis, automation, or advanced analytics integration.
• Exceptional analytical skills and attention to detail, with a commitment to delivering high‑quality reporting solutions.
• Knowledge of Snowflake‑specific features such as Streams, Tasks, Dynamic Tables, Snowpark, and role‑based access control.
• Background supporting analytics in semiconductor, manufacturing, or supply chain environments.
• Experience working in an Agile/Scrum delivery environment and using tools such as Jira and Confluence.

Core Competencies

Demonstrates expertise in designing and developing interactive reports and dashboards using Tableau and Power BI, with a strong focus on data modeling, SQL proficiency, and performance optimization. Capable of translating business requirements into effective analytics solutions while ensuring data quality and governance.