LEXIPOL
Login

Senior Data Engineer

Lexipol | Frisco, TX

Posted Date 2/21/2025
Description Senior Data Engineer

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

Applicants must be authorized to work for ANY employer in the United States.
No visa sponsorship. We are unable to sponsor or take over sponsorship of an employment Visa (H1-B or Student 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.
  • 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 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


 

Share this job