AWS Data Engineer & Analytics Specialist

Serco; Virginia (MN); Hybrid; USD 90,000 - 130,000; Full time

Benefits offered by this job

Medical, dental, and vision insurance

401(k) plan with employer matching

Tuition reimbursement

Life insurance

Disability coverage

Flexible work arrangements

Parental leave

Employee Assistance Plan

Job summary

Serco is seeking a Software Engineer to design, develop, and implement data-centric software solutions in a hybrid role based in Herndon, VA. The role focuses on building secure, scalable AWS-based data infrastructure and analytics, including data warehouse modernization and BI reporting.

The candidate will work with AWS services, Redshift, and MS SQL, contributing to architecture reviews and PoCs. A 3+ year track record and US citizenship are preferred for this position.

Qualifications

• U.S. Citizenship.
• Bachelor's degree in a related field.
• At least 3 years of experience in data engineering or BI roles.
• Hands-on experience with data warehouse design and implementation, Normalized vs. Denormalized Data Structures, Fact and Dimension tables.
• Data engineering including data management, cataloging, data integration and ETL processes, SQL for data querying and manipulation, integrating data from various sources, and ensuring data quality & data integrity throughout the data pipeline.
• Experience with AWS technologies: S3, Postgres/Redshift, QuickSight/QuickSight.
• MS SQL expertise including CDC, Temporal Tables, Indexing, Optimization, and Query Performance tuning; Power BI.
• Desirable knowledge of FFM health care and medical insurance data.
• Ability to travel up to 10%.
• Position contingent upon EUA ICT registration and verification.

Responsibilities

• Design and implement scalable, secure, and resilient solutions on AWS with guidance from technical solution architects.
• Participate in and contribute to technical architecture and design for complex applications.
• Ensure design and implementation of application, integration, and processes are in accordance with guidance from technical solution architect and AWS best practices.
• Understand "As Is" Data Warehouse structures and ETL processes in order to transition these to leverage cloud-native tools and technologies.
• Design and implement optimized enterprise data warehouse processes in accordance with established architecture standards using Amazon Redshift.
• Implement data analytics solutions and processes for metrics reporting dashboards to support business decisions with minimal supervision.
• Contribute to design and implementation of solutions using AI/ML services and technologies in AWS with guidance from technical architect.
• Participate in and contribute to Proof of Concept (PoC) efforts to support evaluation of emerging technologies under technical architect supervision.
• Participate in architecture, design, and code reviews to ensure quality, security, and maintainability.

Skills

Data warehousing

ETL processes

Data integration

Data governance

Education

Bachelor's degree

Tools

AWS

Amazon Redshift

PostgreSQL

MS SQL

Power BI

QuickSight

S3

CDC

Temporal Tables

Job description

Serco is seeking a Software Engineer to design, develop, and implement data-centric software solutions in a hybrid role based in Herndon, VA. The role focuses on building secure, scalable AWS-based data infrastructure and analytics, including data warehouse modernization and BI reporting.

The candidate will work with AWS services, Redshift, and MS SQL, contributing to architecture reviews and PoCs. A 3+ year track record and US citizenship are preferred for this position.