The Role:

We're hiring a hands-on Senior Data Engineer to be part of Data Solutions organization. The data solutions team builds out Data Pipelines, Data Marts, tools and infrastructure needed to source, validate, clean and process the data to build compelling reports for business leaders. Our team is looking for a Senior Data Engineer to help scale our data efforts. If you have passion for data and want to help build Intapp’s next gen data platform that provides actionable insights to drive client and business outcomes, we’d love to hear from you.

You will contribute to the full BI development life cycle, including data ingestion, design, modeling, data migrations, unit testing, performance tuning, deployment activities in an agile environment.

What you’ll do:

• Design, develop and document end-to-end pipelines with strong focus on architecture including Data Acquisition, Data Integration, ODS, MDM, Data Warehouse, Data Provisioning, ETL, and BI
• Partner with business subject matter experts, system analysts, data/application architects and development teams to ensure data design is aligned with business strategy and direction
• Contribute to build standards around data governance, data security, privacy, data quality and speed of analysis
• Identify and document best practices, standards and architecture guidelines for the data warehouse and data ecosystem are shared across teams.
• Dive deep, as required, to assist Data/BI analysts and engineers through technical hurdles impacting delivery.
• Build data quality and audit framework, data transformations to serve data products that empower data-driven decision making.
• Understand the analytical objectives to make data engineering and data architecture recommendations and drive informed actions.

In order to be successful in this role you need:

• B.S. degree in computer science, mathematics, statistics or a similar quantitative field
• 7+ years of proven hands on experience in data engineering, data pipelines, data warehouses (relational, dimensional, columnar, big data), data architecture and metadata management
• Strong experience with commercial ETL platforms with in-depth knowledge and understanding of ETL methodology & design supporting data transformations transformation layer
• Knowledge in In-Memory New SQL, NoSQL
• Experience in Redshift or Snowflake, Spark, Serverless technologies like Athena, Spectrum.
• Experience with distributed data systems such as Hadoop and related technologies (Spark, Presto, Pig, Hive, etc.)
• Experience working with databases, APIs for front-end applications
• Experience in data modeling and reporting tools
• Proficiency in a major programming language (e.g. Java) and/or a scripting language (Perl/Python)
• Desire to grow, learn, deliver and a create a strong sense of teamwork

It would be amazing if you also have:

• Strong knowledge and experience with Agile/Scrum methodology and iterative practices in a service delivery lifecycle.
• Experience with machine learning, advanced analytics.

LI-JS2