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.
