We are looking for an experienced Senior Software Engineer who has a significant interest and experience focused on data engineering to join this team.

While this is, at the core, a technical, coding, development position, this person will work with internal partners, clients and developers to brainstorm and evaluate technical solutions, product integration opportunities and demonstrations.  This role requires creative thinking, a deep curiosity and understanding of data models and usage, as well as empathy for partner/client challenges and pain points.

_This is a technical role but also requires a diverse range of consultative and project management skills.

_The primary focus of this role is to collaborate with cross-divisional partners to design and implement data ingress strategies that support Data & Insights solutions.

Before we get to the list-y bit of the posting, a few key points:

You must be a resident in the U.S. to be considered for this role.
We are not considering candidates who require visa sponsorship for this position. This is a budgetary decision and due to the significant talent available currently who do not require such sponsorship.
This is not a data analyst or data science role, and it requires significant coding, architecture, and consultative collaboration skills.

Responsibilities

Design data warehouse and management in AWS from multiple source systems
Lead collaborations with cross-functional teams to gather and understand data requirements, providing technical solutions and support for data modeling, extract, transformation, and loading.
Provide mentorship and guidance in the form of technical code reviews for other team members.
Write and refactor existing code for performance and clarity
Design, build, and maintain efficient, reliable, and scalable data models and pipelines.
Create high level project plans and technical documentation to achieve product outcomes
Ensure data quality and consistency across all data stores and pipelines with an eye for metadata and data cataloging.

Qualifications

At least 5 years of software development experience with a focus on data and metadata frameworks and architecture
Amazon Web Services (AWS) experience is required. You must have familiarity and experience with cloud computing platforms
Advanced data transformations using data extract, transform and load (ETL) tools in languages such as Scala, Java, or Python.
Ability to create and optimize advanced SQL queries both for data extraction and as the basis for compelling client-facing Data & Insights solutions.
Familiarity with REST web frameworks.
Experience with developing data lake architecture is ideal.
Ability to communicate at both a technical and a business level, developing trust and confidence with a wide variety of individuals within a client organization.
Ability to “think on your feet” and comfortable architecting creative solutions to data sharing problems by adapting and configuring Data & Insights solutions to meet unique client needs.
Familiarity with terraform for deploying and maintaining infrastructure
Detail oriented and able to define data and metadata frameworks and organizations to support complex integrations
Ability to articulately talk through and whiteboard these concepts and approaches with clients.
Familiarity working with public sector organizations is strongly desired.
Frontend development experience a plus
Ability to focus, balance trade-offs, work within constraints and make good decisions, including managing multiple projects simultaneously, is required.
Comfortable conducting client trainings of data publishing workflows.
Self-directed, self-motivated and the ability to work independently.
Required to undergo and satisfactorily pass a fingerprint background check in accordance with CJIS requirements.