> Markdown version of [/jobs/ext/1424681-data-engineer](https://www.wearedevelopers.com/jobs/ext/1424681-data-engineer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Data Engineer - **Company:** City of Charleston - **Location:** Charleston, SC, United States - **Experience:** Experienced - **Salary:** $77,355.0 - $82,784.0 - **Contract:** Permanent contract - **Skills:** Computer-Aided Design, Geographic Information Systems, Application Programming Interfaces (APIs), Amazon Web Services, Data Analysis, ArcGIS (Software), Audit Trail, Microsoft Azure, Information Systems, Databases, Data Validation, Information Engineering, Data Governance, Extract Transform Load (ETL), Data Security, Data Systems, Data Visualization, Relational Databases, Database Development, Database Storage Structures, Intelligence Analysis, Python (Programming Language), Microsoft SQL Server, Power BI, Cloud Services, Spatial Data Infrastructures, SQL Stored Procedures, Esri GIS (Software), Data Processing, Scripting, Freeform SQL, Information Technology, Data Analytics, User Identification - **Published:** July 24, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=d5f7808382bd3440 ## About the Role * Bachelor's degree in Computer Science, Information Systems, Data Engineering, or a related field (or equivalent work experience). * 3+ years of experience in SQL development, data engineering, or analytics. * Strong understanding of relational databases (e.g., SQL Server). * Experience with ETL tools or scripting languages (Python etc.). * Experience creating dashboards and reports in Power BI or similar tools Preferred Qualifications: * Experience with GIS or spatial data systems (ESRI, ArcGIS). * Familiarity with data matching, identity resolution, or investigative analytics. * Understanding of cloud data platforms (Azure, AWS, or GCP). * Experience supporting intelligence-led policing or crime analysis initiatives. * Familiarity with law enforcement data systems, formats, or compliance standards (CJIS, NIBRS, RMS, CAD). * Experience interfacing with APIs. ## Description The Data Engineer supports law enforcement operations by designing, maintaining, and optimizing data systems that collect, transform, and deliver critical information to analysts, investigators, and leadership. This position focuses on ensuring data accuracy, accessibility, and security across multiple law enforcement databases and intelligence systems., * Develop, optimize, and maintain data pipelines and ETL processes connecting internal and external law enforcement data sources (RMS, CAD, etc). * Design relational and analytical database structures to support operational reporting and investigative analytics. * Ensure compliance with data governance, security, and CJIS requirements. * Write and maintain complex SQL queries, stored procedures, and scripts to clean, normalize, and enrich raw law enforcement data. * Implement data validation routines to detect and correct errors, duplicates, or incomplete records. * Collaborate with crime analysts, investigators, and command staff to deliver accurate and timely data sets for intelligence analysis and advanced visual dashboards. * Support data analytics, trend detection, and performance measurement initiatives. * Assist with development of complex data visualizations and dashboards (e.g., Power BI, ArcGIS, etc) to communicate actionable intelligence. * Provide technical support for dashboards used in command briefings and interagency task forces. * Ability to adapt to evolving technologies and business requirements. * Demonstrates a forward-thinking mindset by continuously refining workflows, addressing problems, and welcoming change as a pathway to improvement. * Support training for department staff on data access, usage, and best practices. * Continuously evaluate new tools, technologies, and methodologies relevant to law-enforcement data (e.g., real-time analytics, geospatial data). * Ensure that all data handling complies with CJIS standards, privacy regulations, and agency policy. * Manage access controls, audit logs, and data encryption processes. ## Related Videos - [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag) - [Cyber Sleuth: Finding Hidden Connections in Cyber Data](https://www.wearedevelopers.com/videos/893-cyber-sleuth-finding-hidden-connections-in-cyber-data) - [JavaScript? No. Java Scripts! - Scripting with Java](https://www.wearedevelopers.com/videos/2094-javascript-no-java-scripts-scripting-with-java) - [Kubernetes and Microservices with Multi-Model Databases](https://www.wearedevelopers.com/videos/382-kubernetes-and-microservices-with-multi-model-databases) - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [REST, GraphQL, gRPC, and more: A comparison of modern API styles](https://www.wearedevelopers.com/videos/100247-rest-graphql-grpc-and-more-a-comparison-of-modern-api-styles) ## Related Articles - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [Top-Paying Tech Jobs (with Salaries)](https://www.wearedevelopers.com/magazine/372-top-paying-tech-jobs-with-salaries) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers)