Senior Data Engineer

Lexipol; United States; Remote; USD 160,000 - 165,000; Full time

Job summary

Join a forward-thinking organization as a Senior Data Engineer, where you'll build and optimize an AWS-based data infrastructure that empowers public safety professionals. This role offers a unique opportunity to work with cutting-edge technology, contributing to strategic data goals while ensuring data integrity and performance. Collaborate with a talented team, mentor junior engineers, and make a tangible difference in communities by enhancing the efficiency of first responders. Enjoy a flexible, remote work environment that values creativity and problem-solving, while directly influencing critical outcomes within the organization.

Benefits

401(k) with Company Match

Flexible Paid Time Off

Remote Work Environment

Opportunity for Mentorship

Access to Senior Leadership

Cutting-edge Technology Training

Qualifications

• 3+ years of experience in data engineering with AWS focus.
• Expertise in Redshift, ETL processes, and data security.
• Advanced Python skills for data transformations.

Responsibilities

• Design and maintain AWS-based data infrastructure.
• Build and optimize data pipelines using AWS services.
• Collaborate with teams to ensure data integration.

Skills

Data Engineering

AWS Cloud Solutions

Redshift Optimization

Python

ETL/ELT Processes

Data Security Best Practices

Problem-Solving Skills

Communication Skills

Education

Bachelor's Degree in Computer Science or related field

Tools

AWS Glue

Kinesis Firehose

Apache Airflow

Terraform

Job description

1 week ago Be among the first 25 applicants

This is a remote role.

Remote position. Candidates must already live in the United States.

Applicants must be a United States Citizen or Green Card holder.

No visa sponsorship. We are unable to sponsor or take over sponsorship of an employment Visa (H1-B, Student visa, or OPT visa) at this time.

At Lexipol, our mission is to create safer communities and empower the individuals on the front lines with market-leading content and technology. Our top-notch team works closely with law enforcement, fire, EMS, corrections, and local government professionals to tailor our solutions to better address today’s challenges and keep first responders coming home safely at the end of each shift.

Working at Lexipol means making a difference – day in and day out.

The Work

Our team is at the forefront of data-backed decision-making to align with organizational objectives. As part of our team, the Senior Data Engineer will play a critical role in building, maintaining, and scaling our AWS-based data infrastructure, which includes a data lake and warehouse that support both internal operational reporting and external customer-facing in-product reporting.

This role will contribute to Lexipol's 2025 strategic data goals, including:

• Building and scaling our data infrastructure, including both the data lake and Redshift warehouse.
• Delivering reporting requirements for in-product reporting.
• Maintaining data lake architecture diagrams and ensuring data flow documentation is up to date.
• Documenting job schedules and automating data pipeline monitoring.
• Migrating all ETL processes, jobs, and data sources from Azure to Redshift.
• Establishing backup and recovery schedules for all critical data.
• Cost-optimizing the data lake for efficient storage and processing.
  
  

Role Responsibilities

• Design, develop, and maintain an AWS-based Redshift data warehouse and data lake to support enterprise-wide data needs.
• Build and optimize data pipelines using AWS services such as Glue, Kinesis Firehose, Lambda, Step Functions.
• Oversee data lake cost management, ensuring efficient resource utilization and cost reduction.
• Design and document data lake architecture, including data flow diagrams, processing logic, and schema design.
• Develop and maintain playbooks and configuration guides for data lake operations, troubleshooting, and best practices.
• Design and maintain Redshift schemas, tables, and views, optimizing for performance and scalability.
• Implement data ingestion and ETL/ELT processes, ensuring efficient transformation and integration of data sources.
• Contribute to the migration from Azure to Redshift, ensuring seamless transition of ETL jobs, data sources, and workflows.
• Document and maintain job schedules, data flow diagrams, and system architecture.
• Define and enforce backup and disaster recovery policies for data infrastructure.
• Collaborate with Engineering, DevOps, and Data Services teams to ensure smooth data integration and ongoing system optimization.
• Set up roles, permissions, and security policies to ensure secure access and governance across the data lake.
• Proactively troubleshoot and optimize data pipeline performance, identifying areas for automation and improvement.
• Provide technical mentorship and guidance to junior data engineers on AWS best practices and Redshift optimization.
  
  

Requirements: To be considered for this role, you will have this experience:

• Minimum of 3 years, prefer 5+ years of current experience in data engineering, with a focus on AWS cloud-based data solutions.
• Proven current expertise with Redshift: optimizing performance, advanced query writing & optimization, monitoring & alerts, workload management.
• AWS data lake services, including Glue, Apache Airflow, Step-Functions, S3, Kinesis Firehose, Lambda
• Current Advanced Python experience for data transformations and automation.
• Experience in ETL/ELT processes, including ingesting and transforming structured and semi-structured data (e.g., JSON, Parquet, ORC).
• Experience with data security best practices, IAM roles, and encryption standards.
• Hands-on experience with Terraform for infrastructure-as-code (IaC) deployment.
• Experience structuring and managing data in data lakes to support AI applications, such as large language models or enterprise copilots; ideally with a background in preparing data for custom AI analysis and model development.
• Strong problem-solving skills with the ability to diagnose and resolve data pipeline performance issues.
• Excellent communication skills, with the ability to work cross-functionally and explain technical concepts to non-technical stakeholders.
  
  

Preferred Qualifications

• Experience with real-time streaming data processing (Kinesis, Kafka, or equivalent).
• Familiarity with data governance, cataloging, and metadata management in a cloud environment.
• Experience with DevOps CI/CD pipelines for automating data pipeline deployment.
• Background in public safety, law enforcement, fire, EMS, or government-related industries.
  
  

Employee Value Proposition

• Be at the forefront of data-driven decision-making within a leading organization, directly influencing strategic outcomes.
• Work with cutting-edge technology in data visualization and analysis, continuously advancing professional skills.
• Opportunity for Impact: Make a tangible difference in communities by enhancing the efficiency and effectiveness of public safety professionals.
• Mentorship and Collaboration: Work closely with a team of experienced professionals in a supportive environment, offering mentorship and the opportunity to collaborate on meaningful projects.
• Leadership Access: Direct reporting and access to senior leadership, offering visibility and the opportunity to influence strategic decisions.
• The Technology Department is a high performing team focused on supporting the public safety professionals through delivery of high-quality software solutions.
• Ideal for those who thrive in a fast-paced environment, our team values individuals ready to tackle complex challenges, prioritize effectively, and revel in the satisfaction of overcoming obstacles.
• Full time remote position with opportunity to join cross functional meetings at our home office.
• We strive to provide a professional, ethical, and collaborative environment that is largely a remote workforce. Video conference is standard practice.
• This position mostly has predictable weekday work hours with occasional extended workdays.
• The Data Lake Engineer will receive regular weekly check-in meetings with the Director of Internal Technology.
• Cross-Departmental Synergy: Engage in a role that spans across various departments. This position not only allows for a broader impact within the organization but also fosters personal growth through exposure to multiple facets of the business.
  
  

Target Outcomes/ Target Results for 2025 and Beyond

• Complete the full migration from Azure to AWS Redshift for all ETL processes, jobs, and data sources.
• Establish a fully operational AWS data lake, with documented data architecture and job schedules.
• Cost-optimize the data lake, reducing unnecessary data storage and processing expenses.
• Maintain 99.9% uptime for critical data pipelines and analytics infrastructure.
• Reduce query execution time in Redshift by 50% through performance tuning and materialized views.
• Implement role-based access control (RBAC) and security policies for data governance and compliance.
• Mentor and develop at least 2 junior engineers on AWS data engineering best practices.
  
  

Employee Value Proposition

• Work at the forefront of data engineering, designing and building a scalable AWS data lake.
• Solve complex data pipeline and infrastructure challenges in a mission-driven organization.
• Collaborate with a highly skilled, innovative, and supportive team.
• Directly influence strategic outcomes by building a high-performance data infrastructure.
• Engage in a fast-paced, dynamic work environment that values creativity and problem-solving.
• Enjoy a flexible, remote-friendly work environment with opportunities for cross-functional collaboration.
  
  

The Environment

• Our team is highly productive and works with urgency every day to provide the expected high-quality software solutions to our public safety professionals. Individuals who seek out additional responsibilities and have an action-oriented mindset thrive on this team.
• Dynamic, collaborative, and driven by a mission to make a difference. Our team enjoys the challenge of solving complex problems and implementing solutions that have a real impact.
• We celebrate our success, give praise, want to learn from one another, and are dedicated to each member of the team maximizing their potential.
• Our core values of Serve, Innovate, Collaborate, Empower, and Own It are not just words but the principles guiding every decision and action, fostering a culture of impact, growth, and mutual respect. Like the vital relationship between a ship and its crew, we prioritize our collective mission and the well-being of our teammates. This philosophy ensures we navigate challenges successfully and support each other in achieving personal and professional growth, reflecting our commitment to service and innovation.
  
  

Duties listed are not intended to be exhaustive or exclusive; other duties may be assigned. Management retains the discretion to add to or change the duties of the position at any time.

Compensation And Benefits

Lexipol offers a competitive base salary, monthly, quarterly, or annual incentive and a comprehensive benefits package including 401(k) with Company match and a flexible paid time off plan.

Base salary for this role is $160K - $165K with up to an 8% bonus opportunity

About Lexipol

Lexipol empowers first responders and public servants to best meet the needs of their residents safely and responsibly. We are the experts in policy, training and wellness support, committed to improving the quality of life for all community members. Our solutions include state-specific policies, online learning, behavioral health resources, grant assistance, and industry news and information offered through the websites Police1, FireRescue1, EMS1, Corrections1 and Gov1. Lexipol serves more than 2 million public safety and government professionals in over 12,000 agencies and municipalities. For additional information, visit www.lexipol.com.

Lexipol Is an Equal Opportunity Employer (EOE)

Lexipol, LLC provides equal employment opportunities (EEO) to all team members and applicants for employment without regard to race, color, religion, gender, national origin, age, sex, pregnancy, disability, sexual orientation, gender identity or expression, veteran status, genetic information, or any other non-job-related characteristic. Lexipol complies with applicable federal, state and local laws governing nondiscrimination in employment in every location in which the company has facilities. This policy applies to all terms and conditions of employment, including hiring, placement, promotion, termination, layoff, recall, transfers, leave of absence, compensation, and training.

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Information Technology

• Industries

  Public Safety

Referrals increase your chances of interviewing at Lexipol by 2x

Sign in to set job alerts for “Senior Data Engineer” roles.

United States $108,650.00-$141,240.00 2 weeks ago

San Francisco, CA $153,000.00-$210,000.00 4 months ago

New York, NY $153,000.00-$210,000.00 4 months ago

Sr. Data Integrations Engineer (Healthcare, AWS Lambda, DBT & VBC Required)

Senior Software Engineer (Consumer - Growth & App Infra, Growth Foundations)

Healthcare Data Architect / Sr. Data Engineer

Urgent Need Senior Data Center Technical Support Analyst - STATE OF LOUISIANA

Senior Solution Engineer, Data Clean Rooms

California, United States $155,625.00-$288,750.00 3 months ago

Senior Software Engineer II - Smart Trailer & Connected Equipment

United States $200,000.00-$300,000.00 4 months ago

Urgent Need Data Architect - STATE OF LOUISIANA

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.