Lead Data Engineer (Remote Positions Available)

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

Fictiv, coined the “AWS of manufacturing,” is a leading technology company transforming the $350 billion manufacturing industry. Our cutting-edge cloud platform uses AI and machine learning algorithms to help companies build hardware at the speed of software. Come join our growing team!

What’s in it for you?

The Data Engineering & Analytics team develops a centralized data warehouse and produces reports and dashboards for Fictiv, that are to provide strategic insights that impact multiple functional areas including: Operations, Finance, Sales, Marketing, Engineering, Product, Architecture, and Customer Support. This team works very closely with cross-functional stakeholders, and leverages multiple different Business Intelligence (BI) technologies to achieve these goals.

This team sets the stage for ensuring Fictiv’s business is delivering on KPIs and goals. This team provides all the inputs for Fictiv’s strategic decision making.

Impact In This Role

As a Lead Data Engineer for the data team, you will support the Data Engineering & Analytics Director, Data Engineers, Data Analysts and Product Managers in the everyday management of our data warehouse.  You will serve as a facilitator between the business and technology in understanding the technical requirements and ensure that solutions address the business problems.  This is a ‘hands on’ role and is responsible for leading the transformation and execution of data solutions from disparate source systems.  In addition, the role will plan, design, implement, and operate data solutions, using an Agile methodology.     

Our company understands the importance of utilizing data to make informed decisions. We are looking for someone that gets excited about data and continues to drive a data driven culture.

You will report to the Director, Data & Analytics - Lead Data & Document Control Teams.

What You’ll Be Doing

• Lead the technical planning and delivery of multiple projects.
• Responsible for understanding end-to-end data flows and identifying data dependencies in support of delivery, release, and change management.
• Partner with internal and external teams for knowledge transfer in advance of new feature launches.
• Mentor team members in their use of data ingestion, data mapping, ETL, data modeling and business intelligence tools.
• Design, implement, and maintain database solutions, manage data access, and resolve database performance, capacity, and security issues.
• Develops Data Flow Diagrams, Data Dictionaries, and database schemas with a focus on enterprise data management.
• Participates in on-call support rotation for monitoring, alerting and on-call duties for all data warehouse operations.
• Participates in brainstorming and discussion sessions to help development teams better understand and utilize data technologies.
• Executes design sessions to gather requirement, review, approve, and communicate design artifacts with stakeholders.
• Working with stakeholders including data, design, product, and executive teams and assisting them with data-related technical issues.
• Help set broad direction and vision, influence engineering and business strategy, and establish practices to efficiently and effectively address customer needs.
• Follow and contribute to SQL coding standards, change control practices, and data warehouse practices.
• Research, Diagnose, and Monitor performance bottlenecks.
• Assemble and modify large complex datasets to meet business requirements.
• Identifying, designing, and implementing internal process improvements for greater scalability, optimizing data delivery and automating manual processes.
• Building BI reports to utilize datasets to provide actionable insights into key business performance metrics including operational efficiency .
• Create data tools for analytics and data team that assist in building and optimizing our product into an innovative industry leader.

Desired Traits

• B.S. in Data Science, Data Analysis, or a related field.
• 5-8 years experience as a Data Engineer using BI tools providing complex analysis.
• Experience with Snowflake, Redshift, Heap, Fivetran and SigmaComputing (or similar BI tools such as Tableau, Looker or Quicksight).
• Proven experience working with complex datasets and writing SQL queries with multiple levels of CTEs directly.
• Extensive knowledge of BI concepts (regressions, sliding window functions, financial metrics, marketing funnel metrics, logistics and fulfillment metrics).
• Build processes supporting data transformation, data structures, metadata, dependency and workload management.
• Experience with leading and coordinating cross-functional initiatives, conducting interviews and performing analyses to create business cases for projects.
• Have proven experience working with large and complex datasets and are comfortable writing queries directly or utilizing BI tools. Experience with Snowflake, Sigma, and Heap is a bonus.
• Working knowledge of data and analytics architecture, data warehousing concepts, and data integration best practices.
• Experience mentoring and leading data engineers to develop successful solutions.
• Ability to analyze external tools and compare to our current data stack and suggest a detailed solution plan.
• Extensive knowledge of BI concepts and database query languages (i.e. SQL or Python),  dimensional modeling, data warehouse design, dashboarding).
• Ability to build and optimize datasets and data pipelines.
• Ability to perform root cause analysis on internal processes and data to identify opportunities for improvement and answer questions.
• Excellent analytic skills associated with working with structured and unstructured datasets.
• Ability to build processes that support data transformation, workload management, data structures, dependency and metadata.
• You are a clear communicator.  You can provide business context for engineers as well as highlight technical challenges for non-engineers.
• Ability to present to groups of mixed technical ability.
• Comfortable not knowing answers, but resourceful and able to resolve issues. Willing to learn and understand new ways of doing things.
• Experience performing live training sessions for internal and external stakeholders during system and process implementation.
• Must have strong communication skills and possess the ability to interact effectively with co-workers.
• Must have strong leadership skills.
• Available to work with remote teams. 

Perks and Benefits

• Competitive medical, dental, and vision insurance
• 401K plan
• Monthly Virtual Work stipend for things like food, internet, travel, pet care, health and wellness
• Annual Education stipend
• Parental leave programs 
• Paid volunteer days
• Onboarding setup, including: standing desk, laptop, monitor, and chair, and a stipend for additional items such as headphones, blue light glasses, or any other ergonomic supplies you may want or need
• And much, much more!

Fictiv is continuing to expand our remote US workforce. Recent hires include professionals located in:

Arizona (AZ), California (CA), District of Columbia, (DC), Delaware (DE), Florida (FL), Georgia (GA), Hawaii (HI), Iowa (IA), Illinois (IL), Indiana (IN), Kansas (KS), Massachusetts (MA), Maryland (MD), Michigan (MI), Minnesota (MN), Missouri (MO), North Carolina (NC), New Hampshire (NH), New Jersey (NJ), Nevada (NV), Ohio (OH), Oregon (OR), South Carolina (SC), Texas (TX), Tennessee (TN), Utah (UT), Virginia (VA), Washington (WA), West Virginia (WV), Wyoming (WY)

Interested in learning more?  We look forward to hearing from you soon.

About Fictiv

Our Digital Manufacturing Ecosystem is transforming how the next rockets, self-driving cars, and life-saving robots are designed, developed and delivered to customers around the world. 

This transformation is made possible through our technology-backed platform, our global network of manufacturing partners, and our people with deep expertise in hardware and software development.

We’re actively seeking potential teammates who can bring diverse perspectives and experience to our culture and company. We believe inclusion is the best way to create a strong, empathetic team. Our belief is that the best team is born from an environment that emphasizes respect, honesty, collaboration, and growth.

We encourage applications from members of underrepresented groups, including but not limited to women, members of the LGBTQ community, people of color, people with disabilities, and veterans.