Overview
The Analytics Engineer (AWS ETL) – VA LGY designs, builds, and maintains scalable data pipelines and warehouse solutions in AWS (Redshift, S3, Glue), developing and optimizing ETL/ELT workflows to ingest and transform mortgage data from loan origination, servicing, CRM, and regulatory systems. They model star schemas, slowly changing dimensions, and fact tables to support KPIs such as loan performance, delinquency, LTV, and prepayment risk; implement best practices for performance tuning, partitioning, and query optimization in Redshift and big-data frameworks; and integrate warehouse data with BI tools (Power BI) for dashboards and executive reporting. Partnering with business stakeholders, they translate analytics requirements into technical solutions, ensure data security, governance, and regulatory compliance, collaborate across teams on advanced analytics and machine learning initiatives, and produce high-quality client deliverables while working with a team lead to review solution options, foster teamwork, and maintain strong client relationships.
Key Functions
- Design, build, and maintain scalable data pipelines and data warehouse solutions in AWS (Redshift, S3, Glue).
- Develop and optimize ETL/ELT workflows to ingest and transform mortgage-related data from multiple sources (loan origination, servicing, CRM, and regulatory systems).
- Model data structures (star, slowly changing dimensions, fact tables) to support mortgage KPIs such as loan performance, delinquency, LTV, and prepayment risk.
- Implement best practices for performance tuning, partitioning, and query optimization in Redshift and big data frameworks.
- Partner with business stakeholders to translate mortgage analytics requirements into technical solutions and drive decisions with data-driven insights.
- Integrate warehouse data with BI and reporting tools (Power BI) for dashboards and executive reporting.
- Ensure data security, governance, and compliance with regulatory frameworks.
- Collaborate with cross-functional teams to support advanced analytics and machine learning initiatives.
- Create high-quality client deliverables with regular supervision from team lead.
- Prepare and review solution options with team lead to solve tough challenges.
- Be a good teammate to the client and the delivery team, encouraging and enabling teammates to be their best selves.
- Maintain positive relationships with the client.
Minimum Qualifications
- Bachelor's degree and 5 years of relevant experience.
- An additional 2 years of experience with an Associate's Degree.
- An additional 4 years of experience with a high school diploma.
- Proven experience in AWS cloud data services: Redshift, Glue, S3, RDS/Aurora, Step Functions.
- Strong data engineering background with SQL, Python, and/or PySpark
- Expertise in data modeling and warehouse design, particularly for mortgage and financial datasets.
- Hands-on experience with ETL/ELT design and optimization.
- Strong communication skills with the ability to engage stakeholders, present insights, and influence decisions.
- Experience integrating data into BI/reporting platforms and building analytical dashboards.
- Familiarity with data governance tools and practices, ideally Collibra
- Strong attention to detail with proven analytical and problem-solving skills.
- Can easily shift focus between high priority tasks as required.
- Demonstrates leadership in the face of ambiguity, rather than waiting for direction from above.
- Navigates through challenges to consistently get things over the finish line.
Preferred Qualifications Or Skills
- Existing Public Trust clearance at the Department of Veterans Affairs or other federal agency.
- Knowledge of mortgage industry concepts (loan origination, servicing, securitization, prepayment, delinquency) or strong initiative to self-learn.
- Familiarity with regulatory and compliance requirements for financial data or strong initiative to self-learn.
- Experience implementing AWS solutions for the federal government or Department of Veterans Affairs specifically.
- Experience using JIRA and Confluence.
Position Details
- Employment type: Full-Time, W2
- Location: 100% Remote (US-based)
- Hours: 40 hours/week with availability during core business hours of 8am-5pm ET
- Start date: ASAP
- Eligibility: Must be eligible to obtain a Public Trust clearance
- Salary: $60,000-$122,000
