Senior Data Engineer – Analytics, Applied AI

This is a fully remote position, open to applicants in United States.

📋 Description

• Oversee data platforms comprehensively, managing everything from source ingestion to transformation, analytics, and application layers.

• Develop production-level Python code and create services, APIs, tools, and robust, maintainable software.

• Design and orchestrate AWS cloud data pipelines, incorporating scheduling, retries, data-quality gates, and effective failure management.

• Structure data for analytics and application deployment, which includes dimensional/fact modeling, grain decisions, handling of slowly-changing dimensions, and idempotent recompute patterns.

• Establish data-quality and reconciliation checks that regulate publication processes.

• Independently drive architectural and technical decisions while leading implementation with minimal oversight.

• Utilize intelligent coding assistants to expedite delivery while ensuring code quality and adherence to review standards.

• Evolve into applied AI/ML, focusing on entity resolution, LLM-assisted analytics, and anomaly/risk scoring.

⛳️ Requirements

• A minimum of SIX (6+) years in data engineering and/or software engineering, focusing on building and operating production systems.

• A University Degree coupled with at least SIX (6) years of relevant experience; FOUR (4) years of pertinent experience can be a substitute for formal education.

• Proficient software engineering capabilities: production-quality Python, clean architecture, testing, code review, and CI/CD practices.

• Advanced SQL skills, including window functions, complex joins, aggregation-grain reasoning, and query performance optimization.

• Practical experience with multiple AWS services, such as Glue, Step Functions, S3, Redshift, Aurora/RDS, Lambda, EventBridge, ECS/Fargate, and IAM.

• Expertise in data modeling: dimensional/analytical modeling, grain management, slowly-changing dimensions, and idempotent recompute patterns.

• Strong focus on data quality: validating outputs, reconciling totals, and ensuring data integrity.

• Experience with Infrastructure as Code using Terraform or CDK in actual projects.

• Proven capability to own systems and drive them to completion independently, exercising sound judgment on architecture and trade-offs.

• Demonstrated effective utilization of intelligent coding assistants in real workflows.

• Proficiency in analytics: profiling datasets, identifying anomalies, reasoning about metrics, and clarifying discrepancies.

• Must be able to obtain and sustain a Federal or DoD public trust.

• Must secure approved adjudication of public trust prior to onboarding with Guidehouse.

• Experience in applied AI/ML, agent frameworks, entity resolution/record linkage, API development, DuckDB/Parquet, data-lake table formats, and working in regulated or government data environments is advantageous.

🏝️ Benefits

• Medical, Rx, Dental & Vision Insurance.

• Personal and Family Sick Time & Company Paid Holidays.

• Parental Leave.

• 401(k) Retirement Plan.

• Group Term Life and Travel Assistance.

• Voluntary Life and AD&D Insurance.

• Health Savings Account, Health Care & Dependent Care Flexible Spending Accounts.

• Transit and Parking Commuter Benefits.

• Short-Term & Long-Term Disability.

• Tuition Reimbursement, Personal Development, Certifications & Learning Opportunities.

• Employee Referral Program.

• Corporate Sponsored Events & Community Outreach.

• Care.com annual membership.

• Employee Assistance Program.

• Supplemental Benefits via Corestream (Critical Care, Hospital Indemnity, Accident Insurance, Legal Assistance and ID theft protection, etc.).

• Position may be eligible for a discretionary variable incentive bonus.

• Flexible benefits package.