Data Solutions Engineer II
Role details
Job location
Tech stack
Job description
The Data and Integrations Team is seeking a Data Solutions Engineer II to create and maintain pipelines on a data integration, management, and analytics platform. This role involves building pipelines to ingest data using Azure Data Factory, managing data transformations from relational to document models, and integrating with third-party systems. The focus is on creating custom solutions, writing code that interacts with APIs, and supporting the deployment of public safety technology products., * Develop and maintain data pipelines for system integration, data integration, management, and analytics.
- Build and maintain automated processes to support product deployment and evolution at scale.
- Handle projects involving DataStore Deployment, Integration Configuration, Testing, and Data Conversion, with a primary focus on the latter three.
- Work with near real-time data from pipelines and integrate with systems through REST APIs.
- Engage in API integrations, data pipeline development, data normalization, schema mapping, and validation.
- Partner with internal teams and external agencies to make public safety data accessible and actionable.
- Influence peers, advise leaders, and provide coaching and mentorship to junior team members.
- Facilitate cross-team collaboration among engineers, architects, program managers, and analysts.
Requirements
Education & Experience: A Bachelor's Degree in a technical or quantitative field, completion of a coding bootcamp, or 3+ years of technical experience in a related field is required.
Technical Skills:
- Experience developing and maintaining customer production systems.
- Proficiency in writing T-SQL queries.
- Strong programming skills in at least one scripting language (e.g., Python, Bash, JavaScript, TypeScript).
- Experience working with and interpreting JSON and XML data formats.
- Familiarity with using API REST clients like Postman or Insomnia for testing.
- Experience with writing and consuming REST or GraphQL APIs.
- Understanding of deploying hardware-agnostic software to cloud hosts.
- Familiarity with YAML for configuring builds and releases.
- Experience with container-based platforms such as Docker and Kubernetes.
- Must be able to pass a Criminal Justice Information Services (CJIS) background check.
Preferred Qualifications
- Experience with Azure cloud services, particularly Azure Data Factory (ADF), Azure Logic Apps, SQL Server, Azure Storage, and Azure Key Vault.
- Experience with Snowflake and Power BI or Sigma for analytics and reporting.
- Backend or platform engineering experience (Java, Scala, C++, or similar).
- Experience with data from healthcare, compliance, or other regulated industries.