Senior Data Engineer

Appian • Mclean, VA

122d

About The Position

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 headquarters 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.

Requirements

• 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

Responsibilities

• 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

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Industry: Publishing Industries
• Education Level: Bachelor's degree
• Number of Employees: 1,001-5,000 employees