3 months ago
Base Salary
$75k - $175k/yr
Responsibilities
- Design and develop logical and physical data models and scalable database architectures for customer contract requirements.
- Analyze legacy database structures, identify migration risks and incompatibilities, and migrate workloads to cloud-based architectures.
- Convert legacy stored procedures, triggers, views, and functions into target-compatible SQL or PL/SQL logic.
- Identify and update hardcoded SQL queries in application source code for compatibility with the new database engine.
- Build ETL functions to clean, transform, and transport legacy data into the modern application environment.
- Configure, implement, and monitor enterprise database clusters for high availability and performance.
- Tune database objects and create table indexes to improve performance.
- Integrate database objects, stored procedures, and ETL components into CI/CD pipelines and source control.
- Develop complex data-generation scripts for automated functional and performance testing.
- Travel up to 10% annually for customer engagements.
Requirements
- Bachelor’s degree in Computer Science, Engineering, Information Systems, Mathematics, or a related technical field is strictly required.
- At least 1 year of professional data engineering experience designing, planning, and implementing tables, views, stored procedures, and functions.
- Deep proficiency with relational and NoSQL database technologies and query languages including SQL, MQL, and CQL.
- Hands-on experience with Microsoft SQL Server, MariaDB, PostgreSQL, Oracle, AWS, Snowflake, and Databricks.
- Active DoD Secret Clearance or ability to obtain one, and U.S. citizenship, are required for public-sector work.
- Willingness to travel up to 10% annually.
- Preferred certifications include AWS Certified Database Specialty, AWS Certified Solutions Architect, CompTIA Security+, or Oracle- or Microsoft-specific certifications.
- Preferred experience includes migrating complex schemas between database engines such as Oracle, PostgreSQL, MariaDB, SQL Server, and MySQL.
- Familiarity with Python, Java, C#, XML, JSON, Jenkins, Azure DevOps, and RHEL8 is preferred.
Benefits
- In-office/hybrid work model in McLean, Virginia.
- Base salary range of $75,000–$175,000 USD, plus potential government clearance differential and discretionary bonus eligibility.
- 401(k) plan with company match, retirement or pension plan, and employee stock purchase program.
- Medical, dental, vision, life, disability, wellness, flexible spending, and health savings account benefits.
- Flexible time off, paid parental leave, family-forming benefits, Employee Assistance Program support, and wellness dollars.
- Tuition reimbursement, Appian University, department training, mentorship, learning and development resources, and growth programs.
- Employee referral bonus program and employee-led affinity groups.
Tech Stack
Categories
Data Engineering
About Appian
Appian builds a low-code platform for process automation, case management, and data orchestration, used by large enterprises and government agencies to design and run mission-critical workflows. It sells subscriptions and services for cloud and on-premise deployments, spanning BPM, RPA, process mining, and AI-enabled capabilities. Founded in 1999 and headquartered in McLean, Virginia, Appian is a public company listed on NASDAQ.