Software Engineer-Database

The Software Engineer - Database (SQL) will join an Agile development team responsible for Route One's web applications, data projects, special projects, and/or supporting tools. The Software Engineer - Database should be passionate about code quality and software excellence, with extensive development experience. Collaborating closely with other software engineers, architects, and team members is a must.

Job Requirements

* Understand business needs regarding data integration, data engineering and data operations in order to build end-to-end data pipeline for application and analytical purposes.

* Develop scalable and re-usable frameworks for ingestion and transformation of data sets.

* Participate in design and code reviews, suggesting improvements and troubleshooting.

* Work with other team members at the architecture, design, and code levels to ensure standards-based, high performance systems.

* Actively participate at internal community of practice events to help with continuous learning.

* Perform all work in accordance with company's quality programs, standards, and procedures.

* Maintain safety, security, and privacy standards throughout all areas of responsibility.

Knowledge

* Knowledge of popular software development processes, i.e., Agile, scrum, feature driven development.

* Experience troubleshooting and resolving application defects within a mature production system.

* Experience with relational databases (SQL Server or any RDBMS).

* Experience with structured and unstructured data.

* Knowledge of data modeling tools and data management concepts.

* Knowledge of data management best practices within traditional data warehouse and/or data lake environment.

Skills

* Develop solutions using database development tools and languages such as Microsoft T-SQL.

* Knowledge of Dev Ops, other programming languages such as Python or Scala will be an added advantage.

* Experience working in data integration tools such as SQL Server Integration Services or similar tools.

* Experience with logical/physical database design and Business Intelligence tools is a plus.

* Knowledge of reporting tools (such as Tableau, Power

BI).

Abilities

* Ability to work in a collaborative team environment, think critically, problem solve, learn new technologies, and adapt to change.

* Ability to communicate effectively throughout the organization.

Other Essential Requirements

* 5+ years' experience in Microsoft SQL Server or Microsoft Azure Environment in the role of database developer.

* 4-year degree in Computer Science, certification, or equivalent experience.