Software Engineer-Database at ROUTE ONE

Farmington Hills, Michigan, United States -

Full Time

Start Date

Immediate

Expiry Date

30 Aug, 26

Salary

0.0

Posted On

01 Jun, 26

Experience

5 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Microsoft T-SQL, SQL Server, Python, Scala, SSIS, Data Modeling, Tableau, PowerBI, Agile, Scrum, DevOps, Data Engineering, Data Integration, RDBMS, Data Warehousing, Data Lake

Industry

Information Technology & Services

Description

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.

Responsibilities

Develop and maintain scalable data pipelines and frameworks for ingestion and transformation within an Agile environment. Collaborate with architects and engineers to ensure high-performance systems and adhere to company quality standards.