Role Description The Senior Data Engineer will play a pivotal role in building, modernizing, and scaling our enterprise data platform. While our legacy footprint includes SQL Server on GCP, our future is centered on a modern stack powered by Snowflake and Python. - Pipeline Engineering: Design, develop, and maintain resilient, scalable, and efficient end-to-end data pipelines. - Stakeholder Collaboration: Partner directly with product owners, data analysts, and Analytics stakeholders to gather requirements, communicate technical roadmaps, and deliver data solutions aligned with business goals. - Architecture & Design: Play a key role in data modeling and architecture discussions to support high-volume, low-latency, and high-availability systems. - Technical Leadership: Act as a subject matter expert for the data layer; mentor junior engineers, advocate for code quality, and delegate project tasks effectively. - DevOps Culture: Champion a modern DevOps mindset by implementing CI/CD practices, automated testing, and robust monitoring/observability for data workflows. - SDLC Execution: Deliver clean, well-tested, and secure code within an Agile/Scrum framework (Jira), participating fully from discovery through to deployment. - Continuous Innovation: Evaluate emerging data technologies and framework optimizations to continuously improve platform performance and cost-efficiency. - Responsible for end-to-end project ownership. - Follow established processes and be a champion for best practices and continuous improvement. - Deliver timely, well-written, well-designed, testable, efficient code. - Ensure designs and code are in compliance with specifications. - Perform other duties as assigned. Qualifications - 5+ years of professional experience designing and implementing commercial data warehouses and data marts. - 4+ years of hands-on production experience with Snowflake (including performance tuning, Snowpipe, or secure data sharing). - 3+ years of strong development experience in Python for data manipulation and pipeline orchestration. - 3+ years of strong experience with DBT or similar transformation tool. - Expert-level proficiency in advanced SQL (including complex joins, window functions, and query optimization). - Experience integrating with external data sources via APIs and handling semi-structured data (JSON, Parquet). - Solid understanding of relational databases (MSSQL/MySQL). - Proven track record of shipping high-quality software backed by a strong belief in automated testing (unit, integration, and data quality testing). - Experience working within an Agile SDLC environment. - Must comply with HIPAA rules and regulations. - Must be willing and able to communicate with the team via webcam, webconf, and phone. - Must have access to private, quiet work space with high-speed internet to effectively work remotely. Requirements - Minimum of 5 MBPS for Download Speed and 3 MBPS for Upload Speed for remote work. - Employees who regularly work from home offices are eligible for expense reimbursement to offset internet costs. Benefits - Salary range: $105,000.00 to $120,000.00 in base pay, exclusive of any bonuses or benefits. - Eligible for an annual bonus targeted at 15%. - Includes medical, dental, vision, life, and pet insurance, 401K, paid time off, and other wellness programs.

• Architect behind the high-performance data infrastructure • Responsible for implementing identified components • Ensure that implemented components are appropriately documented, unit-tested, and ready for integration into the final product • Architect the solution, test the code, and deploy and build a CI/CD pipeline for it • Provide work estimates for assigned development work • Guide features, functional objectives, or technologies being built for interested parties

• Lead the modernization of a mission-critical legacy system managing billions of dollars in international security cooperation. • Work as an "Agent-native" engineer using AI-led development tools daily to replace a decades-old Oracle-based platform. • Own the modernization ground, ensuring complex production data is migrated with financial-grade proof while building across the full stack (UI, API, and Infrastructure).

• Decompose complex data and business problems into specifications precise enough for AI agents to implement directly and concretely. • Design and maintain a repeatable migration pipeline that consolidates legacy mirrored Oracle schemas into a modern, single-schema PostgreSQL environment. • Implement rigorous automated reconciliation machinery (checksums, financial control totals, and row counts) to provide government acceptance evidence. • Conduct "legacy archaeology" by interrogating hundreds of thousands of lines of PL/SQL packages and triggers to extract and document load-bearing business rules. • Develop transactional schemas using Prisma and design Change Data Capture (CDC) workflows into dedicated analytics stores. • Build complete vertical slices of capability, including React-based admin UIs for data quality reports and Node.js API endpoints. • Set the technical bar for data integrity, utilizing golden-master behavioral checks to prove migrated cases still price and process identically to legacy systems. • Maintain a rigorous human-review process for all agent-generated code to ensure compliance with federal financial standards.