Senior Data Engineer

Here at Appian, our core values of Respect, Work to Impact, Ambition, and Constructive Dissent & Resolution define who we are. In short, this means we constantly seek to understand the best for our customers, we go beyond completion in our work, we strive for excellence with intensity, and we embrace candid communication. These values guide our actions and shape our culture every day.  When you join Appian, you'll be part of a passionate team that's dedicated to accomplishing hard things.

Here at Appian, our core values of Respect, Work to Impact, Ambition, and Constructive Dissent & Resolution define who we are. In short, this means we constantly seek to understand the best for our customers, we go beyond completion in our work, we strive for excellence with intensity, and we embrace candid communication. These values guide our actions and shape our culture every day.  When you join Appian, you'll be part of a passionate team that's dedicated to accomplishing hard things.

As a Senior Data Engineer, you will join a high-performing team of data engineers responsible for building foundational datasets and pipelines, as well as the infrastructure that supports them, across all Appian business functions including sales, finance, marketing, people and product.  You will partner closely with business stakeholders to understand their data and analytics needs and with business intelligence developers to deliver metrics and KPIs to accelerate the decision-making process of key product and business functions.  This position sits within our Business Technology team where you will collaborate with cross-functional teams to understand source architecture, data models and processes.

This role is based at our ​h​eadquarters in ​McLean, Virginia. Appian was built on a culture of in-person collaboration, which we believe is a key driver of our mission to be the best. Employees hired for this position are expected to be in the office 5 days a week to foster that culture and ensure we continue to thrive through shared ideas and teamwork. We believe being in the office provides more opportunities to come together and celebrate working with the exceptional people across Appian.

What you’ll do:

• Facilitate discovery and requirement gathering sessions and build productive partnerships with various business stakeholders to understand their data needs for reporting and analytics

• Translate business logic into actionable artifacts like source to target mapping, data integration patterns, etc.

• Develop data pipelines using tools such as Informatica Cloud, Python and SQL to ingest, transform and manipulate data for analysis and reporting purposes

• Maintain existing pipelines and implement enhancements 

• Provide data modeling and data architecture recommendations to ensure core data assets are managed and governed as per enterprise standards

• Analyze various disparate (internal/external) data sources and document findings

• Clearly articulate data acquisition, integration strategies along with inherent risks with each strategy

• Drive standards in data reliability, data integrity, and data governance, enabling accurate, consistent, and trustworthy data 

• Be a technical advisor and subject matter expert on the effective use of data modeling practices, data analytics, and optimal data architecture

• Manage multiple projects simultaneously, ensuring timely delivery and adherence to high-quality standards

• Collaborate with team of data engineers and BI developers to deliver data services covering various business domains

 

Preferred experience:

• 7+ years of experience in a data/software engineering role, with a focus on building and maintaining data pipelines and automating data availability and accuracy

• Experience building high quality ETL/ELT pipelines using cloud-based tools such as Informatica Cloud (preferred), Fivetran, SSIS, etc.

• Experience with cloud-based data technologies such as BigQuery, Redshift, Snowflake, Databricks or similar

• Expert knowledge of SQL, Python and integration with APIs

• Domain knowledge covering areas including finance, sales, marketing, etc.

• Experience developing data products to drive data science and machine learning initiatives

• Knowledge of data visualization tools such as Tableau, MS Power BI or Looker

• Strong communications skills with the ability to collaborate effectively with peers and business stakeholders to understand requirements and build shared datasets

Educatio