Software Engineer-Database

RouteOne LLC

Farmington Hills, MI

JOB DETAILS
SKILLS
Agile Programming Methodologies, Analysis Skills, Best Practices, Business Intelligence Software, Code Reviews, Communication Skills, Community of Practice (CoP), Computer Certifications, Computer Science, Data Lake, Data Management, Data Modeling Tools, Data Sets, Data Warehousing, Database Design, Database Programming, DevOps, Feature Driven Development (FDD), Identify Issues, Internet Application, Microsoft SQL Server, Microsoft Transact-SQL (T-SQL), Microsoft Windows Azure, Needs Assessment, Power BI, Privacy Controls, Problem Solving Skills, Production Systems, Programming Languages, Programming Tools, Python Programming/Scripting Language, Relational Databases (RDBMS), SQL (Structured Query Language), SQL Server Integration Services (SSIS), Scala Programming Language, Scalable System Development, Scrum Project Management and Software Development, Software Development, Software Engineering, Structured Data, Tableau, Team Player, Unstructured Data
LOCATION
Farmington Hills, MI
POSTED
30 days ago

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.

About the Company

R

RouteOne LLC