Appian Data Architect

Groundswell Corporation; McLean (VA); On-site; USD 117,000 - 209,000; Full time

Benefits offered by this job

Health benefits

401K match

PTO & holidays

Tuition reimbursement

Flexible schedule

On-site gym

Job summary

Groundswell Corporation is seeking an experienced Appian Data Architect to design scalable, secure data solutions within a federal program. You will lead data modeling, architecture, and integration efforts across Appian-based systems, collaborating with solution architects, developers, and client stakeholders.

The role requires 10+ years in data/solution architecture, strong SQL and relational DB skills, and experience with Appian or similar low-code platforms. U.S.

Qualifications

• Bachelor’s degree in Computer Science, Information Systems, Engineering, or related field, or equivalent relevant experience.
• 10+ years of experience in software development, application architecture, data architecture, database engineering, or related technical discipline.
• Significant experience designing data solutions for complex enterprise applications.
• Strong experience with relational database technologies, SQL, data modeling, database design, and performance optimization.
• Experience designing integrations between enterprise applications and external data sources using APIs, web services, and other integration technologies.
• Experience with Appian or a comparable enterprise low-code/BPM/case management platform.
• Strong understanding of application architecture and the relationship between design, data architecture, integrations, and performance.
• Experience diagnosing and resolving complex technical and performance issues across applications, databases, and integrations.
• Ability to translate business and functional requirements into scalable technical and data architecture solutions.

Responsibilities

• Design and maintain scalable data architectures supporting complex enterprise applications and business processes.
• Develop conceptual, logical, and physical data models, including data structures, relationships, schemas, and standards.
• Design data solutions for Appian-based applications, including data stores, record types, data synchronization, and integration with external sources.
• Define data storage, access, integration, and exchange across Appian and external systems of record.
• Design and optimize relational database solutions and complex SQL queries for performance.
• Collaborate with Appian architects, developers, and integration teams on technical designs.
• Evaluate data structures for scalability, performance, and data quality improvements.
• Design data integrations using APIs, web services, and other enterprise patterns.
• Establish standards for data integrity, security, access controls, and metadata governance.
• Troubleshoot complex data/app issues and provide resolution recommendations.
• Participate in architecture reviews to align with program and federal standards.
• Provide technical guidance and mentorship to development teams on data architecture.

Skills

Appian platform data architecture

Data architecture

SQL

Data modeling

APIs & integrations

Leadership

Communication

Federal government experience

Education

Bachelor's degree in CS/IS/Engineering

Equivalent relevant experience

Tools

Oracle

PostgreSQL

SQL Server

Job description

Who Are We?

Groundswell is a premier technology integrator and solution provider, resolutely committed to solving the most complex challenges facing federal agencies today. Our name, Groundswell, represents our commitment to be an unstoppable, seismic change in government. Ours is a small company culture with big company reach and results. Are you ready to be audacious, be bold and drive change at a rapid pace? Join us, where we'll make a greater impact together.

What You'll do

Groundswell is seeking an experienced Appian Data Architect to support a mission-critical federal program. This role will work as part of a cross-functional technical team to design and implement scalable, secure data solutions supporting enterprise applications built on the Appian platform. The Data Architect will provide technical leadership across data modeling, application data architecture, database design, integrations, performance, and data governance. The ideal candidate combines deep technical expertise with the ability to collaborate with solution architects, developers, and client stakeholders to translate complex business and technical requirements into effective data solutions.

Responsibilities

• Design and maintain scalable data architectures supporting complex enterprise applications and business processes.
• Develop conceptual, logical, and physical data models, including data structures, relationships, schemas, and standards.
• Design data solutions supporting applications developed on the Appian platform, including Appian data stores, record types, data synchronization, and integration with external data sources.
• Define how application data is stored, accessed, integrated, and exchanged across Appian and external systems of record.
• Design and optimize relational database solutions and complex SQL queries to support application functionality and performance.
• Partner with Appian architects, developers, and integration teams to develop technical designs and resolve complex data and application architecture challenges.
• Evaluate existing data structures and recommend improvements to scalability, performance, maintainability, and data quality.
• Design data integrations using APIs, web services, and other enterprise integration patterns.
• Establish and promote standards for data integrity, security, access controls, metadata, and data governance.
• Troubleshoot complex application, database, integration, and performance issues and provide recommendations for resolution.
• Participate in architecture and technical design reviews and ensure solutions align with program and federal technology standards.
• Provide technical guidance and mentorship to development teams and serve as a subject matter expert for data architecture and Appian-related data solutions.
• Collaborate directly with federal client stakeholders to understand requirements, evaluate technical options, and communicate architecture recommendations.

Required Qualifications

• Bachelor’s degree in Computer Science, Information Systems, Engineering, or a related field, or equivalent relevant experience.
• 10+ years of experience in software development, application architecture, data architecture, database engineering, or a related technical discipline.
• Significant experience designing data solutions for complex enterprise applications.
• Strong experience with relational database technologies, SQL, data modeling, database design, and performance optimization.
• Experience designing integrations between enterprise applications and external data sources using APIs, web services, and other integration technologies.
• Experience with Appian or a comparable enterprise low-code/BPM/case management platform.
• Strong understanding of application architecture and the relationship between application design, data architecture, integrations, and system performance.
• Experience diagnosing and resolving complex technical and performance issues across applications, databases, and integrations.
• Ability to translate business and functional requirements into scalable technical and data architecture solutions.
• Strong communication skills with the ability to work effectively with technical teams, business stakeholders, and senior client leadership.
• Experience providing technical leadership, conducting design reviews, and mentoring developers or engineers.
• Experience supporting federal government programs or other large, complex enterprise environments preferred.
• U.S. Citizenship required.
• Must be able to obtain and maintain any federal government clearance and/or background investigation required for the assigned client engagement.

Preferred Qualifications

• Deep technical experience with the Appian platform, including application architecture, data architecture, record types, data stores, integrations, and platform performance.
• Experience with Oracle, PostgreSQL, SQL Server, or other enterprise relational database technologies.
• Experience with PL/SQL and complex database development.
• Experience supporting large-scale workflow, case management, or business process management solutions.
• Experience working within DHS or another federal civilian agency environment.
• Appian certifications or equivalent demonstrated Appian platform expertise.

Why You'll Never Want to Leave:

• Comprehensive medical, dental, and vision plans
• Flexible Spending Account 4%
• 401K Match (immediate vesting)
• Paid Time Off
• Tuition reimbursement, certification programs, and professional development
• Flexible work schedule
• On-site gym and childcare option

Salary Information

The salary range for this role takes into account the wide range of factors that are considered in making compensation decisions, including but not limited to skill sets, experience and training; licensure and certifications; and other business and organizational needs. The disclosed range estimate has not been adjusted for any applicable geographic differential associated with the location at which the position may be filled. At Groundswell, it is not typical for an individual to be hired at or near the top of the range for their role, and compensation decisions are dependent on the facts and circumstances of each case. A reasonable estimate of the current range is: $116,724.00 - $209,019.00 NOTE: Groundswell does not accept unsolicited resumes through or from search firms or staffing agencies. All unsolicited resumes will be considered the property of Groundswell, and Groundswell will not be obligated to pay a placement fee.

Equal Opportunity Employer

Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, pregnancy, genetic information, disability, status as a protected veteran, or any other protected category under applicable federal, state, and local laws. Read a copy of the Company's Non-Discrimination Policy Statement.

Additional Resources

EO 13496 Notification of Employee Rights under NLRA Know your rights: Workplace Discrimination is Illegal Disability Accessibility Accommodation: If you are an individual with a disability and would like to request a reasonable accommodation as part of the employment selection process, please contact us at [e-mail] or 703-639-1777. Dedicated to seismic change We creating a modern, digital government through next-generation technology and a deep understanding of the Federal space. Challenge yourself and grow We are leading the technological revolution to modernize and transform government—which is why we are recruiting the smartest, most skilled people to work at our company. Find out how our company is nurturing, challenging, and investing in our employees.