Principal Cloud Data Engineer

McLean, Virginia
Jun 27, 2022
Jul 27, 2022
Full Time
Here at Appian, we're passionate about automation, speed, and efficiency; and the CIO department is a great place to apply these values! From Information Security, Business Technology, to Solution Engineering, joining Appian will provide you with the opportunity to lead technical strategy, execution and communication for all applications to support Appian employees, customers, and partners across the world. Join us, as we work collaboratively to grow Appian across the world.

The Business Technology department within Appian is seeking a Principal Cloud Data Engineer to help migrate, scale and grow the existing data warehouse on a cloud database platform. Ideal candidate would have experience designing and building processes and services that supports data ingestion and data transformation capabilities to enable enterprise-wide reporting and analytics functions. By joining our team, you will play a key role in driving innovation and help our business team uncover hidden relationships from vast troves cross-subject data sets. Appian's growth trajectory ensures that new employees immediately become core members of our team, working closely with peers and senior managers. This position requires a dedication to excellence.

This role is based at Appian's Headquarters in McLean, VA. Employees hired for this position will have the opportunity to work in a flexible, hybrid environment.

To be successful in this role, you will:
  • Act as a Subject Matter Expert (SME) on cloud database platforms and cloud integrations services to scale and grow Appian's Data Warehouse to an Enterprise Data Lake.
  • Apply deep cloud platform knowledge to design and implement data integration and master data processes for cloud database platforms ensuring scalability, flexibility, reliability, and reusability.
  • Optimize load and query performance by applying a deep understanding of cloud data warehouse engines to maximize the benefits of parallelism, concurrency, platform configuration and tuning. Design statistics, compression, indexing, and data storage to maximize performance.
  • Develop and Implement a Dev-Ops framework, incorporating automated code / database migrations (CI/CD), automated regression testing and production support monitoring capabilities.
  • Perform code reviews and recommend best practices to optimize ingestion, transformation and provisioning of certified data assets to Business Intelligence applications.
  • Develop and maintain technical, architectural and functional documentation depicting the interactions of business applications and upstream databases with Appian's Data Warehouse.
  • Work in close tandem with other team members within principles and constructs of agile methodology using project management tools such as JIRA.

Some of the tools and resources we will equip you with include:
  • Highly visible, impactful opportunities in a fast-paced team environment with very little red tape-your ideas could quickly and easily turn into impact.
  • Immersing you into our community rooted in respect starting on day one. Our community is strong and growing! Appian affinity groups are a great place to start connecting with peers from all across the globe.
  • A wide variety of growth and development opportunities such as: Appian product training and Appian certification sponsorship, our in-house Appian MBA program for new managers, Appian University which is a full library of over 3,000 LinkedIn Learning and Udemy courses, Presentation Skills training, and tuition reimbursement for those seeking to further their education.
  • Unlimited (flex) PTO, hybrid or remote working arrangement, and flexible working hours.

Basic Qualifications
  • 7+ years of experience in building and operationalizing Data Warehouses and Data Lakes using cloud database platforms such as Snowflake, Redshift, or Big Query.
  • 7+ years of building continuous integration and deployment and tools chain (e.g., GIT, Jenkins, Azure DevOps, etc.)
  • 5+ years of experience building solutions utilizing various Cloud services such as Google Cloud Platform (GCP), EC2, S3, EMR, Kinesis, RDS, Redshift/Spectrum, Lambda, Glue, Athena, API gateway, etc.
  • Experience building APIs in Python/Java/C#/Unix, Kinesis, Kafka and/or shell scripting to build and deploy data pipelines.
  • 5+ years of experience of configuration management and Infrastructure-as-Code experience (e.g. Terraform, Ansible)
  • Advanced knowledge of data modeling (transactional and analytical) and SQL skills to manipulate data and prepare the data for BI reporting and data analytics.
  • Experience supporting and troubleshooting production applications or workloads in a cloud-based environment.

Nice to Haves:
  • Experience with API management and integrations

About Appian

Before Appian was a company, it was an idea. Not about a product or a market, but about the culture needed to sustain innovation and value. Today, we help businesses build apps and workflows rapidly, with a low-code automation platform.

Appian was founded on the belief that talented and passionate people, given the power and autonomy to excel, will deliver amazing impact. We have worked thoughtfully to create an inclusive, agile and collaborative work environment where employees feel challenged, and all voices are heard. We value and encourage cross-departmental collaboration, and actively seek opportunities to better ourselves and others. Creating impact to us means that when we deliver results, we're focused on lasting positive change.

Join us.

Appian Corporation is an equal opportunity/affirmative action employer. All qualified applicants will receive consideration for employment without regard to sex, gender identity, sexual orientation, race, color, religion, national origin, disability, protected Veteran status, age, or any other characteristic protected by law. Further, Appian will not discriminate against applicants for inquiring about, discussing or disclosing their pay or, in certain circumstances, the pay of their co-worker, Pay Transparency Nondiscrimination .

If you need a reasonable accommodation for any part of the employment process, please contact us by email at and let us know the nature of your request and your contact information. Requests for accommodation will be considered on a case-by-case basis. Please note that only inquiries concerning a request for reasonable accommodation will be responded to from this email address.


Similar jobs