Data Engineer

Tech Army, LLC; Town of Florida (NY); On-site; USD 80,000 - 100,000; Full time

Job summary

Tech Army, LLC is seeking a Data Engineer to design, develop, and maintain BI solutions, transforming complex transportation datasets into actionable insights. In this role, you'll build dashboards for traffic operations and develop automated reporting solutions to enhance roadway safety and optimize traffic flow.

The ideal candidate will have 3–5 years of experience in Power BI development and data programming, with strong technical skills in SQL and Python. Join us to drive data-driven decision-making for essential infrastructure improvements.

Qualifications

• 3–5 years of experience in Power BI development or data engineering roles.
• Experience with large datasets, relational databases, and APIs.
• Familiarity with transportation system technologies.

Responsibilities

• Develop dashboards and visualizations for traffic data.
• Support data-driven decisions for infrastructure planning.
• Create and maintain data pipelines and ETL processes.

Skills

Advanced SQL queries

Business intelligence tools (Power BI)

Python programming

Data engineering

Analytical problem solving

GIS tools (ArcGIS, QGIS)

ETL design

Tools

Power BI

Python

C#

SQL

Job description

In this role, you will design, develop, and maintain business intelligence solutions that transform complex transportation datasets into actionable insights that help improve roadway safety, optimize traffic flow, and support long‑term infrastructure planning. In this role you will identify and interpret data patterns and trends, build data visualization tools such as charts, graphs, develop custom applications and tables for management, ensure the integrity of the data in various ITS systems, and work with stakeholders to establish key performance indicators.

Key Responsibilities

• Build and maintain dashboards, reports, and visualizations for traffic operations, congestion analysis, and safety metrics.
• Develop custom applications, scripts, and automation tools using Python, C#, or other programming languages.
• Develop automated reporting solutions to support daily, weekly, and monthly transportation performance monitoring.
• Assist with developing specific Departmental goals, standards and objectives which directly support the strategic plan and vision of the organization.
• Assist in the development of Quality Management procedures.
• Work closely with cross‑functional teams, including traffic engineers, traffic operators, and leadership to understand business requirements and translate them into technical solutions.
• Support data‑driven decision‑making for congestion mitigation, safety initiatives, transit planning, and infrastructure investments.
• Create and maintain data pipelines, ETL processes, and data models to support operational and analytical needs.
• Ensure data accuracy, consistency, and reliability across multiple transportation data sources.
• This role requires strong technical skills in data analysis, data visualization, and database management.
• Troubleshoot and optimize BI systems, applications, and reports.

Required Qualifications

• Ability to develop advanced SQL queries, stored procedures, functions and data transformations to support analytics and operational reporting.
• Ability to develop reports and interactive, user‑friendly dashboards, utilizing business intelligence tools like Power BI.
• Ability to design and implement data extraction, transformation, and automation workflows using programming languages such as Python and C#.
• Experience working with large datasets, relational databases, and APIs.
• 3–5 years of professional experience in Power BI development, software programming, or data engineering roles, preferably within an IT or government environment.
• Strong analytical, problem solving, and data processing skills required.
• Familiarity with transportation systems such as ATMS, ITS infrastructure, and traffic management platforms.
• Understanding of GIS tools (ArcGIS, QGIS) and spatial data.
• Provide technical guidance on data best practices, visualization standards, and performance metrics.

Soft Skills

• Must have effective verbal and written communication skills.
• Ability to work independently with minimal supervision as well as participating in cross‑functional teams.
• Ability to deal with ambiguity and adapt quickly to changing client needs.
• Must demonstrate the ability to manage multiple priorities/tasks, deliver timely and accurate work products with a customer service focus, and respond with a sense of urgency as required.
• Proactively identify opportunities to automate, streamline, and improve processes while fostering collaboration and delivering value to customers.
• Advanced analytical thinking and complex problem‑solving abilities.
• Strong proficiency in data modeling, ETL design, and data architecture.
• Ability to write clean, efficient, and well‑ documented code in Python, C#, or similar languages.
• Expertise in SQL, including performance tuning and optimization.
• Proficiency in BI visualization best practices and dashboard usability design.
• Strong understanding of relational databases, APIs, and integration methods.
• Ability to interpret business needs and translate them into technical specifications.
• Competence in version control systems such as Git, Azure DevOps or TFS.
• Ability to troubleshoot complex data, application, and ETL issues.
• Strong quality assurance mindset, ensuring accuracy and consistency across data products.