Job Specifications
Job Requirements
Senior Data Engineer (Senior Consultant, Data & Analytics)
Fearless is seeking a senior-level individual contributor role focused on developing and maintaining the data infrastructure used to monitor and protect the Paid Family and Medical Leave (PFML) fund. You will work with the Data Architect to build pipelines that consolidate data from Salesforce, a Ruby on Rails application, and external sources into an AWS environment for the purpose of fraud detection and program analysis.
At Fearless, the Senior Consultant is an expert in data analysis, engineering, and science. This role will possess the necessary skills at an advanced level of proficiency to drive organizational transformation by architecting scalable data platforms, building advanced machine learning solutions, and mentoring customers and teams to become data-driven organizations. The role involves working with executives, project teams, and internal leaders across departments to identify opportunities where data can accelerate missions, create efficiencies, and deliver technical excellence.
Your Responsibilities In This Role
Data Integration: Build and manage ETL/ELT pipelines using AWS Glue (Python/Spark) and SQL to ingest data from Salesforce APIs and Ruby on Rails (PostgreSQL) databases.
Fraud Detection Engineering: Develop data models and logic to identify high-risk patterns, including identity theft, duplicate claims across accounts, and suspicious changes to banking information.
Forensic Data Analysis: Use SQL and Python to conduct deep-dive analyses on claim behavior, identifying anomalies such as IP address clusters, disposable email domains, and inconsistent wage reporting.
Automated Monitoring: Create and maintain automated alerts in AWS Redshift or Athena to flag potential improper payments before they are processed.
Data Auditing: Implement strict versioning and logging within the data lake to ensure all data used for integrity investigations is traceable and immutable.
Regulatory Compliance: Manage data masking and encryption for sensitive PII/PHI to meet HIPAA and state privacy requirements.
Fearless Impact
The Impact You Will Create in this Role:
Fosters collaboration with cross functional teams
Coach, mentor, and develop peers in data literacy, strengthening organizational decision making
Earn the trust of your customer and teammates by delivering world class services.
Drive accountability and delivery by ensuring project objectives are not only met on time but aligned with client priorities and Fearless standards of excellence. Anticipate risks and implement proactive solutions to keep initiatives on track.
Take ownership of risk management by monitoring deliverables across the team, identifying issues early, and coaching teammates on mitigation strategies while keeping leadership informed.
Shape client engagement and intelligence-gathering efforts by actively cultivating relationships with stakeholders, synthesizing insights across the client organization and partner ecosystem, and providing Fearless leaders with actionable recommendations that inform strategy and strengthen delivery outcomes.
Fearless Customer Impact
Deliver expected outcomes relative to data that enable smarter, faster, and more informed customer decisions
Offer and implement innovative solutions that introduce advanced analytics, machine learning, and emerging technologies for greater data accuracy and insight
Lead and align stakeholders with product and project goals that build trust and confidence in data as a strategic asset that drives customer value and Fearless success
Serve as a trusted advisor in your area of expertise
Work Experience
PROJECT SKILL AND EXPERIENCE REQUIREMENTS
Technical Requirements
AWS Stack: Extensive experience with S3, Redshift, Glue, and Lambda.
Database Systems: Strong understanding of relational database design (Postgres) and the ability to navigate Salesforce data structures.
Programming: Proficiency in Python for data manipulation and SQL for complex analytical queries (window functions, CTEs).
Tools: Experience with dbt for data transformation and Airflow or AWS Step Functions for orchestration.
Analytical Approach: Ability to use statistical methods to identify outliers and suspicious trends in large datasets.
Technical Autonomy: Ability to take architectural requirements and produce production-ready code without significant oversight.
Problem Solving: Experience troubleshooting data discrepancies between the primary application (Rails) and the reporting environment.
Data Integrity: A focus on building "defensive" pipelines that include automated data quality checks and validation logic
Advanced SQL/Python: Deep knowledge of window functions, performance tuning, and building custom libraries. Data Modeling: Expert in Dimensional Modeling (Star/Snowflake schema) and Data Vault 2.0 (ideal for audit-heavy environments).
Cloud Infrastructure: Proven track record with large-scale deployments on AW
About the Company
At Fearless, we have a unique opportunity to change the world. Because we serve the government sector, we’re able to build powerful and scalable technologies that make a real difference in people’s lives.
We don’t take this responsibility lightly. In fact, we work hard to help our clients think about how to provide services and experiences in the digital age. Using best-in-class technology and agile and DevOps approaches, we’re modernizing and transforming the experiences of millions of people.
We're constantly pushing ...
Know more