-
Job Description
Pay Range: $73,689 - $95,796 annual compensation
Job Posting Closing on: Wednesday, June 18, 2025
Workdays & Hours: Monday - Friday 8:00am - 5:00pm; Some evening/weekend work required.
Benefits for this position include: 11 Paid Holidays, Medical, Dental, Vision, Paid Time Off, Pension Plan, Professional Development Opportunities. Find Out More!
The City of Fort Worth is one of the fastest growing large cities in the U.S. Our employees serve the needs of over 1,000,000 residents, promoting our values of exceptional customer experience, mutual respect, embracing our diversity, continuous improvement, ethical behavior, and accountability.
A Business Process Analyst II - SQL job is available with the City of Fort Worth Fire Department Emergency Services Division. This position serves as a technical liaison and project analyst with a strong emphasis on SQL applications and spatial data solutions. Administers and maintains SQL projects, systems, and geospatial business processes to support departmental objectives. Provides end-user support, conducts spatial analysis, and helps identify opportunities to enhance workflows through SQL technology. Acts as the primary point of contact for SQL-related system issues, user training, data integration, and application testing.
Minimum Qualifications:
- Bachelor’s degree from an accredited college or university with major course work in Business Administration, Public Administration, or related field.
- Four (4) years of business experience and business analysis experience.
- Valid Driver’s License.
Preferred Qualifications:
- Knowledge of SQL.
- Knowledge of visualization software such as Power BI.
- Proficiency with ArcGIS.
The Business Process Analyst II - SQL job responsibilities include:
- Utilizes SQL to extract, manipulate, and analyze historical dispatching data, combined with Power BI to develop advanced spatial and network analytics dashboards that optimize ambulance deployment and enhance emergency response strategies.
- Designs and manages large-scale datasets using SQL databases; builds Power BI reports and visualizations to support fire operations, planning, and incident analysis.
- Develops interactive Power BI dashboards by integrating multiple data sources (e.g., SQL databases, APIs), providing real-time, actionable insights for emergency services stakeholders.
- Writes complex SQL queries to generate recurring and ad-hoc reports, ensuring accurate, timely information delivery to internal and external stakeholders.
- Builds and maintains automated ETL processes using SQL scripts and Power BI dataflows to streamline data integration between CAD systems, SQL databases, and fire department applications.
- Conducts data quality assurance and validation within SQL databases and Power BI datasets to ensure data integrity and compliance with city and departmental standards.
- Collaborates with fire department teams to gather requirements, develop SQL-based solutions, and design Power BI reports that address business needs and improve decision-making.
- Acts as the technical liaison for SQL and Power BI tools with IT, other city departments, and vendors; pursues ongoing training to stay updated on database management and business intelligence best practices.
Apply Now! Come be part of something special in Fort Worth.
Working Conditions
Depending on assignment, positions in the class typically require touching, talking, hearing, seeing, grasping, standing, walking and repetitive motions.
The successful applicant for this position must pass a Criminal Justice Information Systems (CJIS) fingerprint-based background check and maintain CJIS eligibility. Due to CJIS requirements related to system access, the following will result in being disqualified for this position: Felony Convictions, Felony Deferred Adjudication, Class A Misdemeanor Conviction, Class B Misdemeanor Convictions in the last 10 years, Class A Misdemeanor Deferred Adjudication, Class B Misdemeanor Deferred Adjudication in the last 10 years, an Open Arrest for any Criminal Offense (Felony or Misdemeanor), and ALL Family Violence Convictions regardless of class.
Physical Demands
Sedentary Work - Depending on assignment, positions it this class typically exert up to 10 pounds of force occasionally, a negligible amount of force frequently, and/or constantly having to lift, carry, push, pull, or otherwise move objects. Sedentary work involves sitting most of the time. Jobs are sedentary if walking and standing are required only occasionally and all other sedentary criteria are met.
Conditions of Employment
The City of Fort Worth is proud to be an Equal Employment Opportunity employer. It is the policy and practice of the City to recruit, hire, train and promote a diverse workforce without regard to race, color, religion, sex (including pregnancy and gender identity), national origin, political affiliation, sexual orientation, marital status, disability, genetic information, age, membership in an employee organization, parental status, military service, or another non-merit factor.
The City of Fort Worth is committed to full compliance with the Americans with Disabilities Act. Reasonable accommodations may be made to enable qualified individuals with disabilities to participate in the job application or interview process and to perform essential job functions.
Candidates who do not meet the Education requirement, may be considered if they have more relevant work experience than the position requires. Those selected for employment will be required to pass Pre-Employment checks depending on the position requirements. Those could include, but are not limited to: criminal background check, drug screen, education verification, etc. criminal convictions will be considered on a case-by-case basis. Employees are paid by direct deposit only. -
ABOUT THE COMPANY
-
-
City of Fort Worth
Show moreThe Community
The City of Cowboys & Culture is known for its Texas hospitality. The stunning and sprawling City of
Fort Worth is one of the fastest-growing cities in the U.S. And it’s no wonder — With great neighborhoods, scenic terrain and a rich history of arts and culture, paired with world-class opportunities for business and education, it’s not only fun to visit Fort Worth, it’s even more rewarding to call it home.Fort Worth truly offers all the benefits and amenities of a bustling metropolitan city, while keeping the small- town charm that keeps it unpretentious and charismatic in all the right ways. Designated as one of America’s “Most Livable Communities” by the Partners for Livable Communities, the city truly offers a melting pot of culture, commerce, community and yes, cowboys.
There are over a dozen remarkable districts full of treasured history among modern luxuries and unique places to have fun, making it the No. 1 tourist destination in Texas and welcoming more than 9.4 million visitors annually.
Being one of the fastest-growing among large cities in the country, Fort Worth has received multiple accolades, including number one downtown (Livability), and the second-best City in the nation for job seekers (Forbes). Our employees serve the needs of over 900,000 residents representing culturally diverse communities.
Exciting Growth & Future Development
One of the most fascinating aspects of the City of Fort Worth is its almost unprecedented growth over the past several years. Both in terms of population and industry, and as the 12th largest city in the United States, Fort Worth is truly booming — which presents both challenges and opportunities to truly develop this city in the right way. Every 30 minutes a new person moves to Fort Worth, so we’re looking for candidates who can embrace an evergrowing and changing environment and improve on it with solutions that work for the entire community of Fort Worth.
Mission
We are working together to build a strong community that others can look to as a pillar of unity and excellence. Through grassroots efforts within the community, and large scale construction and transportation plans that continue to add the infra- structure a growing city like Fort Worth needs, we’ll provide the public services our community requires to continually cultivate the unique city we call home.
Vision
Fort Worth’s vision is to be the most livable and best managed city in the country. We’ll do this by taking care of our citizens, implementing the highest quality standards in our schools, continually improving the neighborhoods we thrive in and the facets of the city that make our town so unique.
Benefits That Are Well Worth It
The City of Fort Worth continues to be dedicated to its employees’ well-being by providing competitive health benefits, a well-rounded wellness program and a Zero Accident Philosophy® workplace. All regular full-time employees and those employees who work 30–39 hours per week are eligible for all City of Fort Worth Benefits. Part-time employees who work 20–29 hours per week are eligible for dental, basic life insurance, supplemental life insurance, flexible spending accounts, 457 Deferred Compensation plan and other voluntary benefits.
Medical Program
The City offers two plan options through Meritain Health, an Aetna company.
The Health Center Plan – Offers employees and their family’s
primary health care services that are 100% completely free and unlimited. Employees can visit any one of the three City of Fort Worth Employee Health Centers and receive guaranteed same or next day appointments for sick visits. Also, services are available at any one of the five satellite locations that serves employees across the city.
The Consumer Choice Plan – Is offered to employees at no cost or low monthly premiums to cover eligible dependents and provides the financial benefits of a Health Savings Account (HSA).
• Preventative services are covered at 100% on both plans.
• Prescription Drug coverage including mail order pharmacy are also included.Vacation
Eligible for 3 weeks of vacation: After successful completion of probationary period (usually
6 months), employees may take time off for rest, relaxation, vacation, illness, religious observances, and personal business.Holidays
Available on the first day of employment, the city provides employees with paid holidays, including two personal holidays.
Wellness Program
The city’s Healthy Challenge Wellness Program rewards all full-time, benefit-eligible employees on the city’s health insurance. The Healthy Challenge Program utilizes a points system. Participants may earn points throughout the year (Jan. 1-Dec. 15) for completing specific program activities and participants can redeem points at the end of the year for a cash reward. By participating, individuals can earn $150, $200 or $250 by accumulating program points.
-