Join Our Team

Senior Data Engineer

Senior Data Engineer

This is a remote role.  
Remote position. Candidates must already live in the United States.
#LI-Remote

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 data lake and Redshift data warehouse to support enterprise-wide data needs.
  • Build and optimize data pipelines using AWS services such as Glue, Kinesis, Firehose, Lambda, Step Functions, and Athena.
  • 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:
  • 5+ years of experience in data engineering, with a focus on AWS cloud-based data solutions.
  • 5 years work experience in the United States required
  • Proven expertise with AWS data lake services, including Glue, S3, Kinesis, Firehose, Lambda, Redshift, and Athena.
  • Strong SQL and Redshift experience, including query optimization, workload management, and performance tuning.
  • Hands-on experience with Terraform for infrastructure-as-code (IaC) deployment.
  • Experience in ETL/ELT processes, including ingesting and transforming structured and semi-structured data (e.g., JSON, Parquet, ORC).
  • Ability to lead large-scale migrations, particularly moving ETL pipelines and data sources from Azure to AWS/Redshift.
  • Experience with data security best practices, IAM roles, and encryption standards.
  • 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).
  • Knowledge of Python or PySpark for data transformations and automation.
  • 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 $150-160k with up to a 5% 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.  #LI-AD1


 
* Required fields
First name*
Last name*
Email address*
Location *
Phone number*
Resume*

Attach resume or Paste resume

Attach resume as .pdf, .doc, .docx, .odt, .txt, or .rtf (limit 5MB) or paste resume

Paste your resume here or attach resume file

What’s your citizenship / employment eligibility?*
What’s your highest level of education completed?*
Are you 18 years of age or older?*
LinkedInLinkedIn profile URL:*
Twitter*
Are you authorized to work in the United States?*
Will you now or in the future require sponsorship for employment in the U.S?
What is your preferred first name?*
Are you currently on a visa in the United States? (H-1B, Student, or OPT visa?)*
Are you a US Citizen or Green Card holder?*
Were you referred by a Lexipol employee or from a recruiting agency?
If so, please list their name.*
Please answer all questions professionally. Note: Applications with only periods or dashes for answers, or vague answers such as “Open” or “will discuss in interview” will not be considered.
If you do not have experience in the area of the question, please state "no experience with this". We appreciate you taking the time to thoroughly answer all of the questions.*
Describe your exact role in building and scaling AWS data lakes? List the employer you built the data lake at and what you personally actually did regarding both the design and building as well as scaling of the AWS data lakes.*
Do you currently have a H1-B or Student Visa?*
How many years of experience creating and scaling AWS data lakes do you have?*
Which employers did you personally both Design and Build Redshift data warehouses at while working in the United States?*
How many years of experience creating and scaling Redshift data warehouses do you have while working in the United States for a tech or SaaS employer?*
Describe your hands-on experience with Redshift data warehouses? List the employer(s) you built Redshift data warehouses at and what you personally actually did regarding both the design and building as well as scaling of the Redshift data warehouse (s).*
What is your desired annual salary for this position? If you would like to be considered, please list a realistic annual salary $ amount. Note: Applications with blank answers or dots will not be considered.*
Is there anything else you would like to share regarding your experience and match for this role and Lexipol?*
How many years experience working in the United States do you have?*
The following questions are entirely optional.
To comply with government Equal Employment Opportunity and/or Affirmative Action reporting regulations, we are requesting (but NOT requiring) that you enter this personal data. This information will not be used in connection with any employment decisions, and will be used solely as permitted by state and federal law. Your voluntary cooperation would be appreciated. Learn more.
Gender
Race/Ethnicity
Invitation for Job Applicants to Self-Identify as a U.S. Veteran
  • A “disabled veteran” is one of the following:
    • a veteran of the U.S. military, ground, naval or air service who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Secretary of Veterans Affairs; or
    • a person who was discharged or released from active duty because of a service-connected disability.
  • A “recently separated veteran” means any veteran during the three-year period beginning on the date of such veteran's discharge or release from active duty in the U.S. military, ground, naval, or air service.
  • An “active duty wartime or campaign badge veteran” means a veteran who served on active duty in the U.S. military, ground, naval or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense.
  • An “Armed forces service medal veteran” means a veteran who, while serving on active duty in the U.S. military, ground, naval or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985.
Veteran status
I IDENTIFY AS ONE OR MORE OF THE CLASSIFICATIONS OF PROTECTED VETERAN LISTED ABOVE
I AM NOT A PROTECTED VETERAN
I DON’T WISH TO ANSWER
Voluntary Self-Identification of Disability
Voluntary Self-Identification of Disability Form CC-305
OMB Control Number 1250-0005
Expires 04/30/2026
Why are you being asked to complete this form?

We are a federal contractor or subcontractor. The law requires us to provide equal employment opportunity to qualified people with disabilities. We have a goal of having at least 7% of our workers as people with disabilities. The law says we must measure our progress towards this goal. To do this, we must ask applicants and employees if they have a disability or have ever had one. People can become disabled, so we need to ask this question at least every five years.

Completing this form is voluntary, and we hope that you will choose to do so. Your answer is confidential. No one who makes hiring decisions will see it. Your decision to complete the form and your answer will not harm you in any way. If you want to learn more about the law or this form, visit the U.S. Department of Labor’s Office of Federal Contract Compliance Programs (OFCCP) website at www.dol.gov/ofccp.

How do you know if you have a disability?

A disability is a condition that substantially limits one or more of your “major life activities.” If you have or have ever had such a condition, you are a person with a disability. Disabilities include, but are not limited to:

  • Alcohol or other substance use disorder (not currently using drugs illegally)
  • Autoimmune disorder, for example, lupus, fibromyalgia, rheumatoid arthritis, HIV/AIDS
  • Blind or low vision
  • Cancer (past or present)
  • Cardiovascular or heart disease
  • Celiac disease
  • Cerebral palsy
  • Deaf or serious difficulty hearing
  • Diabetes
  • Disfigurement, for example, disfigurement caused by burns, wounds, accidents, or congenital disorders
  • Epilepsy or other seizure disorder
  • Gastrointestinal disorders, for example, Crohn's Disease, irritable bowel syndrome
  • Intellectual or developmental disability
  • Mental health conditions, for example, depression, bipolar disorder, anxiety disorder, schizophrenia, PTSD
  • Missing limbs or partially missing limbs
  • Mobility impairment, benefiting from the use of a wheelchair, scooter, walker, leg brace(s) and/or other supports
  • Nervous system condition, for example, migraine headaches, Parkinson’s disease, multiple sclerosis (MS)
  • Neurodivergence, for example, attention-deficit/hyperactivity disorder (ADHD), autism spectrum disorder, dyslexia, dyspraxia, other learning disabilities
  • Partial or complete paralysis (any cause)
  • Pulmonary or respiratory conditions, for example, tuberculosis, asthma, emphysema
  • Short stature (dwarfism)
  • Traumatic brain injury
Please check one of the boxes below:
YES, I HAVE A DISABILITY, OR HAVE HAD ONE IN THE PAST
NO, I DO NOT HAVE A DISABILITY AND HAVE NOT HAD ONE IN THE PAST
I DO NOT WANT TO ANSWER

PUBLIC BURDEN STATEMENT: According to the Paperwork Reduction Act of 1995 no persons are required to respond to a collection of information unless such collection displays a valid OMB control number. This survey should take about 5 minutes to complete.

Name Date
Human Check*