The Software Engineer – Database (SQL) will join an Agile development team responsible for RouteOne’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 DevOps, other programming languages such as Python or Scala will be an added advantage.