Database Engineer II — Public Sector Data Architect (Hybrid)

Appian Corporation; North Dakota; Hybrid; USD 75,000 - 175,000; Full time

Benefits offered by this job

401(k) match

Parental leave

Medical insurance

Dental & Vision

Life insurance

Disability insurance

Wellness programs

HSA contributions

Employee referral bonus

Learning & development

Job summary

Appian is seeking a Database Engineer for the Public Sector Customer Success team. You will design and maintain a scalable data architecture to support DoW initiatives, handling large datasets and migrating legacy data to modern systems.

Responsibilities include analyzing legacy structures, migrating queries and procedures, building ETL processes, and integrating DB objects into CI/CD pipelines. A DoD Secret clearance (or ability to obtain) and US citizenship are required, with up to 10% travel.

Qualifications

• Bachelor’s Degree: B.S. or B.A. in Computer Science, Engineering, Information Systems, Mathematics, or a related technical field. (Note: Degree is strictly required).
• Experience: 1+ years of professional experience in data engineering, including hands‑on experience designing, planning, and implementing tables, views, stored procedures, and functions.
• Core Technical Skills: Deep proficiency in both relational (RDBMS) and NoSQL database technologies, along with mastery of query languages including SQL, MQL, and CQL.
• Database Platforms: Professional experience designing, planning, and implementing new stored procedures, views, tables, and functions specified by business requirements.
• Core Technical Skills: Strong proficiency in both SQL and NoSQL database languages including SQL, MQL, CQL, etc. Hands‑on experience technologies such as Microsoft SQL Server, MariaDB, Postgres, Oracle and AWS Cloud, Snowflake, Data Bricks.
• Security & Clearance: Active DoD Secret Clearance (or ability to obtain). Must be a U.S. Citizen (required for Public Sector efforts).
• Travel: Willingness to travel up to 10% annually for customer engagement.

Responsibilities

• Design and develop database architectures and data models to support the customer’s contract requirements by working closely with the Appian team to build logical and physical data models.
• Analyze legacy database structures to identify incompatibilities, data type mismatches, and migration risks before moving workloads to the cloud.
• Convert legacy stored procedures, triggers, views, and functions into target-compatible languages (such as PL/SQL or SQL), rewriting logic.
• Identify and update hardcoded SQL queries within application source code to ensure compatibility with the new database engine.
• Establish ETL functions to clean, transform, and transport legacy data into the new application environment.
• Configure, implement, and monitor enterprise database clusters
• Tune database objects for performance, and create indices on tables as needed.
• Integrate existing and new database objects into CI/CD pipelines to improve code reliability and consistency.
• Set up source control for database architecture code, stored procedures, and ETL objects.
• Develop complex data generation scripts used for automated functional and performance testing efforts.

Skills

RDBMS & NoSQL

SQL

MQL

CQL

Data modeling

Cloud databases

DoD clearance

US citizenship

Python

Java

C#

Travel readiness

Education

Bachelor’s Degree

Tools

MS SQL Server

MariaDB

PostgreSQL

Oracle

AWS Cloud

Snowflake

Databricks

Job description

Appian is seeking a Database Engineer for the Public Sector Customer Success team. You will design and maintain a scalable data architecture to support DoW initiatives, handling large datasets and migrating legacy data to modern systems.

Responsibilities include analyzing legacy structures, migrating queries and procedures, building ETL processes, and integrating DB objects into CI/CD pipelines. A DoD Secret clearance (or ability to obtain) and US citizenship are required, with up to 10% travel.