Data Engineer

KORE1, a nationwide provider of staffing and recruiting solutions, has an immediate opening for Data Engineer Essential Functions We are seeking a skilled and proactive Data Engineer to support our modernization efforts and optimize data workflows across our 300+ applications. This role will be responsible for designing, developing, and maintaining ETL pipelines, data transformations, and legacy systems integrations to ensure seamless data flow between city systems and third-party vendors. You will work closely with integration specialists, database administrators, and business stakeholders to enhance accessibility, reporting, and usability of critical data.. This role is essential in monitoring and maintaining the data health of the city and aiding decision making through analysis and visualization. Therefore, the ideal candidate will have experience in BI and working with stakeholders to create dashboards and reports. Design, build, and maintain ETL pipelines for extracting, transforming, and loading data from legacy and modern systems (Python, Java, SQL, or other). Develop integration solutions to enable data exchange between city applications and external vendors. Collaborate with the Database Administration team to structure and optimize databases for improved performance and accessibility. Ensure data consistency, integrity, and compliance with government regulations such as CJIS. Utilize APIs, web services, and direct database connections to facilitate real-time and batch data processing. Analyze vendor data integration requests and provide balanced solutions that allow applications to access curated data sets.

Work alongside integration specialists to streamline system connectivity and automate workflows. Perform root cause analysis for data discrepancies, failures, and performance bottlenecks. Work with system administrators to ensure data security and access control best practices. Support Business Intelligence (BI) initiatives by structuring data for and helping build dashboards and interactive reports, empowering end-users to access and explore data independently. Maintain technical documentation for data workflows, integrations, and system dependencies. Prepare data migration strategies to help modernize city resources (e.g. database migrations, upgrades, cloud / hybrid integrations, etc.). Conduct data analysis to identify trends, opportunities, and actionable business insights. Work closely with business leaders, analysts, and department heads to gather requirements and ensure BI solutions align with business objectives. Help train and support business users, ensuring they can use BI tools effectively to make data-driven decisions. Research, evaluate, and recommend software tools, platforms, and third-party solutions to meet business and technical requirements. Perform unit testing, integration testing, and code reviews to ensure software quality and maintainability. Contribute to the continuous improvement of development processes and practices, suggesting and implementing improvements to streamline workflows and increase productivity. Education : Bachelor's degree in Computer Science, Business Administration, Information Technology, or a related field. Experience : Minimum of 3 years of hands-on experience in Data Engineering, Integration Engineering, Data Analysis, or a similar field. Proven experience with BI tools such as Power BI, Tableau, Qlik, or similar. Strong proficiency in SQL, Python, or other scripting / ETL languages.

Strong understanding of database systems such as MS SQL Server, MySQL, etc., including database design and optimization. Knowledge of data modeling and creating star / snowflake schemas, and dimensional modeling Hands-on experience with ETL processes and tools (SSIS, Talend, Apache Airflow, or similar) Knowledge of data integration protocols (APIs, SFTP, message queues, XML / JSON data exchanges, etc.) Experience in data visualization and dashboard creation. Familiarity with data warehousing concepts and platforms. Ability to write clear, well-documented code and provide technical support to business users. Excellent problem-solving skills and attention to detail, with the ability to analyze complex technical issues and propose effective solutions. Strong communication skills and the ability to work effectively with cross-functional teams and stakeholders. Familiarity with project management tools and methodologies. Solid understanding of business analysis methodologies, including requirements gathering, process mapping, and documentation. Highly Desirable Experience, Qualifications and / or Certifications : Local government or public sector experience especially public safety (police and fire). Experience with version control systems (e.g., Git or TFS) and collaborative development workflows (e.g., GitFlow). Previous experience in a hybrid role combining technical and business analysis responsibilities. Knowledge of cloud-based data storage and processing (AWS, Azure, etc.).Compensation depends on experience but is typically $111,394 - $148,525 Annually