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.