AWS/ETL Engineer (Salesforce)

CADRE is seeking an AWS / ETL Engineer to support an initiative that will evaluate and build out an end-to-end communication workflow delivering high-volume outbound email communications. The role spans two related work streams: a solution assessment/architecture analysis phase to validate that the proposed integration pattern can reliably scale, and a development phase to build, test, and deploy the resulting Salesforce and AWS components into production. This is a hands-on, individual-contributor role requiring strong AWS integration skills, working knowledge of Salesforce-based integration patterns, and the ability to produce clear architectural and technical documentation for both technical and business stakeholders. Key Responsibilities • Evaluate S-Docs' ability to generate accurate, consistent HTML/PDF templates, and identify the data dependencies, automation triggers, and governance controls needed to ensure template quality at scale. • Analyze Salesforce's integration pathways to identify the most scalable pattern for transmitting large-volume email payloads to AWS, considering throughput, API limits, latency, and fault-tolerance requirements. • Examine AWS Lambda's processing capacity, queueing strategies, and monitoring capabilities to confirm the integration layer can support transformation, routing, and secure delivery to VA Notify under peak loads. • Review VA Notify's API capabilities and status-reporting mechanisms. • Validate the overall solution against operational expectations around scalability, security controls, auditability, observability, and alignment with enterprise compliance requirements. • Document findings, architectural decisions, and identified risks/issues to ensure traceability and support future governance reviews. • Summarize the analysis in formal solution documentation — data flows, sequence diagrams, considerations, and decision logs — to ensure alignment among technical teams, business stakeholders, and support groups. • Build and refine data models, integration components, error-handling logic, and orchestration needed to support end-to-end processing across Salesforce, AWS, and VA Notify. • Develop capabilities including S-Docs template automation, email request creation, outbound integration callouts, inbound status update processing, and supporting dashboards and reports. • Implement AWS components such as API Gateway endpoints, Lambda functions, SQS queueing, dead-letter queues (DLQs), logging/monitoring pipelines, and services for writing delivery • Execute unit testing, integration testing, full end-to-end testing, and high-volume load validation • Deploy changes through CI/CD pipelines across development, QA, UAT, and production environments, ensuring monitoring, alerting, and operational readiness • Finalize technical documentation, operational runbooks, and support procedures, and conduct handover and training for system administrators and support teams. Required Qualifications • Bachelor's degree in Computer Science, Information Technology, Data Engineering, or a related field, or equivalent professional experience. • Experience in data engineering, systems integration, ETL development, and/or cloud infrastructure. • Hands-on expertise with AWS services including Lambda, API Gateway, SQS (including DLQ patterns), S3, IAM, and CloudWatch • Experience with Salesforce integration patterns, including outbound/inbound callouts, Apex, Flow automation, and document-generation tools such as S-Docs (or comparable tools, e.g., Conga, Nintex Drawloop). • Working knowledge of, or ability to quickly ramp up on, VA Notify (or comparable notification/delivery-status APIs) for status, bounce, and failure reporting. • Proficiency in SQL and at least one scripting/programming language commonly used for integration and data processing (e.g., Python, Apex). • Demonstrated experience with the full test lifecycle — unit, integration, end-to-end, and high-volume load/performance testing — and with CI/CD deployment across multiple environments (dev, QA, UAT, production). • Experience working on federal government contracts, with familiarity with VA or other federal agency IT environments, security requirements, and compliance frameworks (FISMA, FedRAMP, NIST 800-53). • Strong ability to produce clear architectural documentation (data flow diagrams, sequence diagrams, decision logs) and to communicate findings to both technical and business stakeholders. • Ability to obtain and maintain a Public Trust clearance; U.S. Citizenship required per VA contract requirements. Preferred Qualifications (Nice to Have) • Salesforce certification (e.g., Platform Developer I/II, Salesforce Administrator, or Integration Architect) and/or AWS Certified Solutions Architect (Associate). • Direct hands-on experience with S-Docs template design/automation and with VA Notify or another government notification-delivery API. • Experience with VA-specific systems or programs (e.g., VistA, MASS, VBMS, or other VA data platforms) is a strong plus. • Familiarity with infrastructure-as-code tools such as Terraform or AWS CloudFormation, and CI/CD tooling (e.g., Jenkins, GitLab CI, AWS CodePipeline). • Experience with observability/monitoring tooling for distributed, queue-based systems (e.g., CloudWatch dashboards/alarms, X-Ray, Splunk). • Prior experience supporting a VA ATO process, governance review, or working directly with VA OIT. How We’ll Support You: Keeping people satisfied is no small undertaking. At CADRE, our commitment to supporting employees extends further than conventional benefits. While we offer competitive industry-standard packages, our focus goes beyond transactional care. This is why we developed the CADRE Cares Program which encompasses a range of benefits and initiatives aimed at enhancing the overall well-being and job satisfaction of employees. We want to support our employees at the times they need it the most. We envision unwavering commitment to our employees that sets a new standard for compassionate and impactful business practices. CADRE Convoy Program: · A dedicated support system designed to cater to your individual needs and enhance your overall well-being, no matter where you are. CADRE Connect Program: · A series of intentional touchpoints, events, and initiatives that promote open communication and encourage continuous growth and development among team members. CADRE Compensation Program: · 401k Safe Harbor Plans with matching & immediate vesting · Medical, Dental, & Vision Plans · Paid Time Off: Holidays, Vacation, Wellness, & Personal Leave Plans · Continuing Education & Training Budget · Office & Technology Budget · Cell Phone Budget · Wellness & Healthy Living Budget · Awards & Bonuses · Profit Sharing Plans Who We Are: We’re more than a government contracting company. We’re a cadre, a specialized team finely honed in providing innovative solutions that meet the complex and evolving needs of government agencies. We strategically mobilize, manage, and maintain specialized cadres using our RO(M³) model. CADRE GOVERNMENT SOLUTIONS is an Equal Opportunity and Affirmative Action Employer. We welcome and encourage diversity in our workforce. It is the policy of CADRE GOVERNMENT SOLUTIONS to provide equal employment opportunity to all employees and qualified applicants without regard to race, color, religion, national origin, sex, age, disability, pregnancy, sexual orientation, gender identity, genetic information, protected veteran status, or any other protected characteristic under federal, state, or local law.