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 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.