2 months ago
Base Salary
$100k - $200k/yr
Responsibilities
- Design database architectures, logical data models, and physical data models for customer contract requirements.
- Analyze legacy database structures, data-type mismatches, incompatibilities, and migration risks before cloud migration.
- Convert legacy stored procedures, triggers, views, and functions into target-compatible SQL or PL/SQL.
- Identify and update hardcoded SQL queries in application source code for compatibility with the target database engine.
- Establish ETL functions to clean, transform, and transport legacy data.
- Configure, implement, and monitor enterprise database clusters.
- Tune database objects and create table indexes to improve performance.
- Integrate database objects into CI/CD pipelines and establish source control for database architecture code, stored procedures, and ETL objects.
- Develop complex data-generation scripts for automated functional and performance testing.
Requirements
- Bachelor’s degree in Computer Science, Engineering, Information Systems, Mathematics, or a related technical field; the posting states that the degree is strictly required.
- At least 3 years of professional data engineering experience designing, planning, and implementing tables, views, stored procedures, and functions.
- Deep proficiency with relational and NoSQL databases and query languages including SQL, MQL, and CQL.
- Hands-on experience with Microsoft SQL Server, MariaDB, Postgres, Oracle, AWS Cloud, Snowflake, and Databricks.
- Active DoD Secret Clearance or ability to obtain one.
- U.S. citizenship is required for public-sector efforts.
- Willingness to travel up to 10% annually for customer engagement.
- Preferred experience includes migrating complex schemas across database engines such as Oracle, PostgreSQL, MariaDB, SQL Server, and MySQL.
- Preferred certifications include AWS Certified Database Specialty, AWS Certified Solutions Architect, CompTIA Security+, and Oracle- or Microsoft-specific certifications.
- Preferred familiarity includes Python, Java, C#, XML, JSON, Jenkins, Azure DevOps, and RHEL8.
Benefits
- In-office/hybrid work model in McLean, Virginia.
- Base salary range of $100,000–$200,000 USD, plus potential government clearance differential and discretionary bonus eligibility.
- 401(k) plan with company match, retirement or pension benefits, and an Employee Stock Purchase Program.
- Flexible time off, paid parental leave, family-forming benefits, and tuition reimbursement.
- Medical, dental, vision, life, disability, wellness, flexible spending account, health savings account, and Employee Assistance Program benefits.
- Learning and development resources, Appian University training, mentorship, leadership programs, skills-based training, and a First-Friend onboarding program.
- Employee referral bonus program, employee affinity groups, and possible equity awards.
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.