TixelJobs
F
Fictivvia Greenhouse

Senior Data Engineer

Pune, India OfficePosted 6mo ago
Data EngineerSeniorFull-time

About the Role

Fictiv Exists to Enable Hardware Innovators to Build Better Products, Faster

Fictiv exists to help product innovators create.

Fictiv is a global manufacturing and supply chain company that enables organizations to scale globally across Fictiv’s four global manufacturing centers in India, Mexico, China, and the U.S.. Companies use Fictiv to access high-quality production, optimize supply chain logistics, and mitigate supply chain risk—ensuring they can move from prototype to full-scale manufacturing with speed and confidence. To date, Fictiv has delivered more than 35 million commercial and prototype parts for industries such as aerospace, robotics, automotive, climate tech, and more, helping them innovate faster, free up precious resources, and drive profitable growth.


 

What’s in it for you?

Opportunity To Unlock Your Creativity
Think of all the times you were held back from trying new ideas because you were boxed in by bureaucratic legacy processes or old school tactics. Having a growth mindset is deeply ingrained into our company culture since day 1 so Fictiv is an environment where you have the creative liberty and support of the team to try big bold ideas to achieve our sales and customer goals.

Opportunity To Grow Your Career
At Fictiv, you'll be surrounded by supportive teammates who will push you to be your best through their curiosity and passion.

Impact In This Role

The Data Intelligence team creates reports and dashboards to provide meaningful insights from the data warehouse. This team works closely with cross-functional stakeholders and leverages multiple Business Intelligence (BI) technologies to enable data-driven decision-making across the organization.
As a Senior Data Engineer on the Data Intelligence team, you will play a key role in designing, managing, and evolving Fictiv’s reporting data warehouse and semantic layer. You will partner closely with the Data Intelligence Manager, Data Engineers, Data Analysts, and Product Managers to ensure replicated data from production systems is transformed into scalable, trusted semantic data models that power consistent, accurate self-service reporting. Acting as a bridge between business and technology, you will translate analytical requirements into well-structured data models and transformations that enable reliable dashboards and insights across multiple domains.
In addition, you will collaborate with Infrastructure, Software, and Systems Engineering teams to strengthen database design and query efficiency across the broader data ecosystem. You will provide hands-on guidance on optimal table structures, indexing and clustering approaches, and SQL query patterns that improve performance and scalability. By proactively identifying bottlenecks and recommending architectural and modeling improvements, you will help ensure that both analytical and operational workloads are efficient, maintainable, and aligned with best practices.
This is a hands-on role responsible for leading the design, transformation, implementation, and operation of data solutions across disparate source systems—driving best practices in data modeling, semantic layer design, performance optimization, documentation, and governance. You will plan, design, and operate data pipelines and models using Agile methodologies to deliver high-quality, maintainable, and secure data assets

You will report to the Data Analytics Manager.

What You’ll Be Doing

  • Design efficient, scalable, and maintainable semantic data models that align with business logic and enable intuitive self-service analytics and reporting across multiple domains.
  • Build, maintain, and optimize data transformations and pipelines that transform replicated production data into trusted, analytics-ready models.
  • Collaborate with stakeholders across data, engineering, product, and business teams to resolve data-related issues, clarify requirements, and align on solution design.
  • Provide technical leadership and guidance to Software Engineers and Data Engineers on query performance, optimization techniques, and efficient data access patterns.
  • Drive ongoing improvement of database and table structures, partnering with engineers to validate and refine table design, joins, partitioning/clustering, and other performance-related considerations.
  • Review and advise on SQL query design for both application and analytics use cases, helping teams design queries that are performant, maintainable, and cost-effective.
  • Analyze performance metrics and execution plans to identify bottlenecks in data models, queries, and transformations, and recommend practical tuning and refactoring opportunities.
  • Follow and contribute to SQL coding standards, data modeling best practices, change control procedures, and data warehouse governance processes.
  • Develop and maintain data flow diagrams, data dictionaries, and schema documentation with a focus on clarity, consistency, and enterprise data management.
  • Understand and document end-to-end data flows and dependencies from production systems through the ELT pipeline into Snowflake and downstream BI tools, supporting delivery, release, and change management.
  • Execute and lead data design sessions and technical reviews to gather requirements, validate modeling approaches, and communicate design decisions and trade-offs to stakeholders.
  • Research emerging technologies, patterns, and tools related to Snowflake, dbt, SQL optimization, and semantic modeling, and recommend enhancements to Fictiv’s data platform and practices.
  • Help set broad direction and vision for the reporting data platform architecture, influencing data engineering, analytics, and application data design strategy.
  • Partner with internal and external teams for knowledge transfer and smooth handoff in advance of new feature launches or reporting changes.
  • Work effectively with remote and cross-functional teams across time zones, fostering strong communication and collaboration.
  • Proven experience working with large and complex datasets and comfort writing advanced SQL queries or leveraging BI tools for analysis and transformation.
  • Deep understanding of data and analytics architecture, including data
Share