Join Our Team

Senior Reporting Analyst

Senior Reporting Analyst
This is a remote role. 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 Reporting Analyst will play a crucial role in dashboard development, data table and pipeline development, and maintaining data integrity within our warehouse and sources of truth.

Role Responsibilities:
  • Develop and maintain Power BI dashboards and reports that provide actionable insights to business stakeholders.
  • Work closely with business stakeholders to gather and document visualization requirements, ensuring dashboards and reports align with business needs and objectives.
  • Employ creative design principles in the development of dashboards and visualizations, aiming for clarity, user-friendliness, and impactful data presentation.
  • Proactively engage with users to refine and iterate on visualizations based on feedback, usability testing, and evolving business questions.
  • Answer business questions through ad-hoc reporting and data analysis, providing insights and recommendations to inform strategic decisions.
  • Design and develop data tables and stored procedures to support efficient reporting and analytics.
  • Optimize SQL queries and stored procedures to enhance report performance and scalability.
  • Extract, transform, and load data from various sources into the data warehouse, ensuring its availability for reporting and analysis.
  • Collaborate with the data analytics team to understand data requirements and implement efficient data models for visualization purposes.
  • Perform rigorous quality control on all data, visualizations, and reports to ensure accuracy, reliability, and consistency across all outputs.
  • Contribute to the development and enhancement of our data lake, ensuring robust and scalable data architecture.
  • Automate the transformation of manual data sets to increase efficiency and accuracy in data handling.
  • Facilitate knowledge-sharing sessions on the use of BI tools and data-driven decision-making processes.
  • Utilize Power BI's alerting capabilities to monitor key metrics and thresholds, enabling proactive management of business-critical data and timely responses to emerging trends.
  • Design and configure alerts within Power BI dashboards to notify stakeholders of significant changes or anomalies in data, facilitating immediate action and decision-making.

Requirements:  To be considered for this role, you will have this experience:
  • Excellent communication and collaboration skills, with the ability to translate complex data into understandable and actionable insights for non-technical stakeholders.
  • Outstanding analytical skills with the capacity to adapt to changing priorities and projects.
  • Passion for storytelling through data and a keen eye for detail in data visualization design.
Qualifications:
  • Bachelor’s degree in Computer Science, Information Technology, Data Science, or a related field.
  • Minimum of 6 years of experience in data visualization, data analysis, or a related field, with a proven track record of creating impactful dashboards and reports using Power BI.
  • Strong proficiency in SQL, including experience in writing and optimizing complex queries and stored procedures.
  • Demonstrated experience in data modeling, ETL processes, and data pipeline development.
  • Experience in designing, building, and maintaining data tables to support reporting and analytics.

Preferred Experience:
  • Experience with cloud data technologies (e.g., AWS, Azure) to support data lake development and management.
  • Advanced certification in Power BI or related data visualization tools.
  • Proficiency in additional programming languages (e.g., Python, R) for data analysis and automation tasks.
  • Demonstrated leadership in project management or team lead roles, indicating readiness to guide projects and mentor junior team members.
  • Experience in public safety, law enforcement, fire, EMS, corrections, or local government sectors.

Target Outcomes/ Target Results
  • Leading the creation of visually compelling, user-friendly dashboards that succinctly convey complex data insights, enhancing stakeholder understanding and engagement.
  • Establishing best practices for data visualization within the company, ensuring consistency and quality in visual reporting across all departments.
  • Innovating in the area of data presentation by incorporating interactive elements and advanced visualization techniques to bring data stories to life.
  • Successfully delivering comprehensive dashboards for all major departments by the end of 2024, providing critical insights and enhancing departmental decision-making processes.
  • Automating the transformation of manual data sets to increase efficiency and accuracy in data handling, reducing time spent on data preparation.
  • Developing production-ready data tables that serve as foundational elements for multiple data sources, ensuring consistency and reliability across analytical applications.
  • Contributing to the design and implementation of the data lake, facilitating advanced data analysis and supporting the organization's broader data strategy.

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.
  • Collaborate with a dynamic, innovative team dedicated to creating impactful visual stories that drive business success.
  • 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 Senior Reporting Analyst will receive regular weekly check-in meetings with the Director of Internal Business Systems and Data Services.
  • 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.

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.

The targeted base salary is $125,000 plus an annual bonus.

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.
* 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

Are you at least 18 years of age*
Do you reside in the United States?*
Are you authorized to work in the United States?*
Will you now or in the future require sponsorship for employment in the U.S., (e.g. H1-B/F1 status)?*
Our office is in Frisco, TX. Do you reside in the Dallas/Fort Worth area?*
As a government contractor, Lexipol is required to collect certain demographic information, including veteran status, to ensure compliance with federal regulations. Providing this information is voluntary and will not affect your application. We appreciate your response on the next 2 questions.

1. Do you identify as a veteran of the U.S. Armed Forces? (A veteran is someone who has served in the Army, Navy, Air Force, Marine Corps, Coast Guard, or Space Force, including the Reserves and National Guard.)*
2. Do you identify as a protected veteran under the Vietnam Era Veterans’ Readjustment Assistance Act (VEVRAA)? Protected veterans include disabled veterans, recently separated veterans, active duty wartime or campaign badge veterans, and Armed Forces service medal veterans.*
Were you referred by a Lexipol employee or from a recruiting agency? If so, please list their name.*
What is your salary expectation? Provide a realistic $ amount if you wish to be considered. single digit or blank answers will not be considered.*
What business intelligence tools do you have most experience with?*
If you had to pick an area to focus, what would be your preference?
- Data Warehousing
- Data Visualization*
Please describe in DETAIL your experience regarding data modeling, ETL processes, and data pipeline development*
Do you have experience with PowerBI?*
What cloud data technologies are you most comfortable with?*
Do you have any certifications? if so, please list.*
How many years experience in data visualization and/or data analysis?*
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*