Senior Software Engineer with Data Engineering Focus

Description

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.