Senior NetSuite Data Engineer

Full time @Greenhouse jobs posted 11 months ago

Job Description

Soligent is the largest pure play solar distributor in the Americas. At Soligent, we envision a world where solar isn’t just the cleanest choice for power: it’s the obvious choice. Our mission is to empower homeowners and installers with a tool-set that transforms the way the world produces energy. We do this by hiring talented people, empowering our team, and being mission driven. Soligent has been featured by the White House, Forbes, Wall Street Journal, The World Economic Forum, and the Atlantic among other publications. In this role, you will see and participate in the interworking of a high growth entrepreneurial large company in a sector that changes the world.

Why Soligent?

  • We are the largest business of its kind in the world. With 5,000 customers in 45 countries, Soligent is an established industry leader in solar with the fast-paced and entrepreneurial spirit of a startup.
  • You will be part of a vital team at the forefront of transforming how people use energy. Drive positive change in the world while working with the best and brightest. Our executives have built and led successful billion-dollar companies.
  • We invest in you. You will learn the ins and outs of solar, be exposed to roles across the company, and receive quality training.

Why You?

  • Are you mission driven? At Soligent, solar is more than a job; it’s our future.
  • Do you see solutions where others see problems? You’re not satisfied with the status quo; you constantly think about how to improve processes.
  • Do you enjoy getting your hands dirty? You understand the big picture but also have an innate ability to drill down and execute with high attention to detail.
  • Can you execute individually but enjoy working with a team? We support a strong culture of teamwork where it’s about the collective gain. Feedback is a big part of that.
  • Does your word mean everything, you take responsibility for outcomes, and are incredibly persistent? We have a culture of integrity and accountability.
  • Do you connect the dots easily? You can see how your role fits in with the organization.
  • Are you fun to be around and able to wear many hats? Soligent is a fast-paced entrepreneurial culture. We believe saving the world should be fun.

As Soligent, the leading pure-play solar distributor in the US, continues to grow rapidly, we’re seeking a highly skilled Senior NetSuite Data Engineer to build the foundational datasets and pipelines for robust financial, supply chain and operations reporting.

You’ll be at the forefront of integrating our product, financial, and business systems to create rock solid processes that will propel us forward. If you’re passionate about analytics use cases, data models, and solving complex data problems, then we want you on our team.

The perfect candidate will bring expertise in SuiteQL, SuiteAnalytics, and the forward-thinking NetSuite2 schema to refine our NetSuite data infrastructure. Significant to this role is experience in crafting robust datasets for Microsoft’s Power BI, driving business intelligence. Additionally, the ideal candidate will have hands-on experience with Fivetran and DBT for creating scalable and trustworthy data pipelines. Understanding the software development lifecycle and having a knack for building and leading data teams will be an added advantage. This role requires proficiency with AWS Redshift, and familiarity with Microsoft’s Azure Synapse Analytics is considered advantageous. Mastery of SQL, with an intimate understanding of aggregation functions, window functions, UDFs, self-joins, partitioning, and clustering approaches for optimal query performance, is a key requirement for this role.

Responsibilities:

  • Innovate, construct, and implement custom objects, and new functionalities in line with dynamic business needs using SuiteQL and SuiteAnalytics within the NetSuite2 schema.
  • Design and create data structures, schemas, and data models to facilitate efficient data exchange among various business systems.
  • Develop and maintain datasets for usage with Microsoft’s Power BI, delivering strategic insights for business decision-making.
  • Collaborate proactively with the Business Intelligence team to translate business requirements into technical specifications.
  • Establish and adhere to quality assurance practices and procedures, performing detailed testing of data pipelines.
  • Construct scalable and dependable data pipelines using Fivetran to bolster robust reporting across finance, sales, supply chain, and operations.
  • Regularly analyze our NetSuite environment for potential enhancements and efficiency upgrades.
  • Spearhead troubleshooting initiatives and determine root causes of issues to ensure their resolution.

Qualifications:

  • BS or MS in Computer Science, Information Systems, or a similar field.
  • A minimum of 5 years of experience as a NetSuite Data Engineer or in a similar role.
  • SQL expert with a deep understanding of aggregation functions, window functions, UDFs, self-joins, partitioning, and clustering for high-performing queries.
  • Advanced knowledge of NetSuite’s SuiteScript, SuiteQL, and SuiteAnalytics.
  • Comprehensive understanding and experience with the new NetSuite2 schema.
  • Documented experience with Microsoft’s Power BI and business intelligence data modeling.
  • Hands-on experience with Fivetran for building data pipelines.
  • Proficiency with DBT is highly desirable.
  • Must have experience with AWS Redshift.
  • Familiarity with Microsoft’s Azure Synapse Analytics is considered a plus.
  • In-depth understanding of the software development lifecycle.
  • Experience building and leading data teams is a significant advantage.
  • Profound knowledge of ETL processes, data management, and data warehouse principles.
  • Proven capability to troubleshoot and resolve complex technical issues.Excellent interpersonal skills with the ability to collaborate effectively in cross-functional teams.
  • Certified NetSuite Developer or equivalent professional experience is a plus.
  • Perform other duties as assigned

Benefits

Medical, Dental, Vision, 401K, HSA, FSA, Flexible PTO

California Privacy Protection Notice

Related Jobs