Software Engineer-Database

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.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, PowerBI).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 Requirements5+ 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.