Analytics Engineer (mfd) AI & Business Intelligence

Finmatics GmbH; Wien; Hybrid; EUR 60 000 - 80 000; Vollzeit

Zusammenfassung

A technology company in Vienna is seeking an Analytics Engineer to optimize data processes and create impactful dashboards using Google BigQuery and Looker Studio. The role involves SQL knowledge and working collaboratively with various teams to ensure data accuracy and efficiency. Ideal candidates should be fluent in German or English and have a strong affinity for technology, especially AI tools like ChatGPT Gemini. A pleasant work atmosphere and flexible working hours are offered, with a minimum salary of €55,000.

Leistungen

Pleasant working atmosphere

Remote work option

Flexible working hours

Job ticket for Wiener Linien

Subsidized lunch menu

Company events

Free fruit and snacks

Qualifikationen

• Fluent in German or English.
• Proven experience in BI dashboards.
• Experience with Google BigQuery is highly preferred.
• Understanding of data warehouse concepts.
• No need for traditional software engineering experience.

Aufgaben

• Design and maintain data warehouse architecture in Google BigQuery.
• Utilize AI to generate complex SQL transformations.
• Ensure data quality and troubleshoot issues.
• Take ownership of dashboards in Looker Studio.
• Maintain Data Dictionary and architectural guides.

Kenntnisse

SQL

Data Visualization

Business Intelligence

Data Modeling

ETL/ELT processes

BigQuery optimization

Looker Studio

Jobbeschreibung

Finmatics Your AI Accountant

With Fin the AI accountant Finmatics simplifies, accelerates, and optimizes accounting processes. Instead of performing routine tasks manually, our software handles them reliably for accounting professionals in Germany and Austria.

Our mission is to design, build, and deliver the trusted AI accountant for every accounting team in Germany and Austria to work smarter, faster, and with confidence.

As our Analytics Engineer you are the central hub for our data. You are responsible for transforming raw data from our production systems into meaningful, reliable data models and dashboards. You will own the crucial Transformation layer of our new Google BigQuery data warehouse, translating business requirements from Product, Customer Success, and Management into performant SQL logic and insightful Looker Studio visualizations.

Your Key Responsibilities

• Data Warehouse Logic: Design and maintain our One Big Table architecture in Google BigQuery. You will own the logic for deduplication, window functions, and ensuring our Single Source of Truth remains accurate.
• AI‑Native Workflow: You don’t just use AI; you treat LLMs (ChatGPT Gemini) as your junior developer. You act as the architect, prompting the AI to generate complex SQL transformations while you validate the logic, debug the output, and ensure business accuracy.
• BigQuery Optimization: You are responsible for query performance and cost control. You understand partitioning, clustering, and incremental build strategies (e.g. rolling windows) to keep our cloud costs efficient.
• BI & Dashboarding: Take end‑to‑end ownership of our dashboards in Looker Studio from requirements gathering with management and customer success to technical implementation and maintenance.
• Data Quality & Debugging: Ensure data quality across our denormalized data models. Proactively investigate anomalies, debug complex joins and window functions, and maintain consistency for KPIs.
• Documentation: Maintain our Data Dictionary and architectural guides (like our Usage Warnings and raw table definitions) to ensure future scalability.

Required Qualifications

• SQL Skills: You have some SQL knowledge and ideally experience with Google BigQuery.
• BigQuery Expertise: Experience with BigQuery specific features (partitioning, scheduled queries) and cost optimization is highly preferred.
• BI Experience: Proven experience in building and maintaining BI dashboards (Looker Studio is a big plus).
• Data Modeling Expertise: A solid understanding of data warehouse concepts, data modeling, ETL/ELT processes, and query cost optimization.
• Tech Affinity: You are a true Citizen Data Analyst. You leverage tools like ChatGPT Gemini to move 10x faster than a traditional coder.
• Analytical Strength: You can understand complex business questions and translate them into technical requirements and data logic.
• Languages: Fluent in German or English.
• Important: You do not need traditional software engineering experience (Java/Python). Your focus is on the logic, the transformation, and the truth within the data. AI is your best friend.

What We Offer

Be part of shaping the future of financial workflows using the latest technical possibilities.

• Pleasant working atmosphere in the middle of Vienna
• Possibility to work remote
• Open and honest corporate culture
• Independent work and short decision‑making paths
• Motivated dynamic team and flat hierarchies
• Additional benefits include a subsidized lunch menu in our office (Schrankerl), a selection of free fruit and snacks, as well as company and team events
• Flexible working hours
• Job ticket for Wiener Linien
• The minimum salary for this position is 55,000€ – overpayment possible depending on qualifications

Key Skills

Business Intelligence, Cognos, SQL, Power BI, QlikView, Data Visualization, SSRS, Tableau, SSIS, Data Modeling, Data Warehouse, Data Analysis Skills

Join us and help shape the future of Analytics Engineering!