Senior Data Engineer

The Senior Data Engineer works collaboratively within their team to perform feature analysis, research, requirements gathering, defining product architecture, designing features, implementation/coding, testing, deployment, maintenance, and support of Red Sail products. The Senior Data Engineer is a vital member of a Scrum team actively participating in all aspects of the Scrum workflow. The focus of a Senior Data Engineer will be on database design and architecture, ELT/ELT, data lake/warehouses, data security, development, troubleshooting, optimization, design/code reviews, product quality, working within the team, mentoring others, and assisting with product directions.

• Primary focus of work will be across the entire data intake and usage process flow intimately knowing the entire depth and breadth of the flow and any respective schema. Will be able to step into most areas and become proficient within weeks. Will be able to create systems from scratch, optimize them, and assist with production.
• Will assist others in the gathering and creation of feature specifications, requirements, and database design documents.
• Performs designing, coding, optimizing, debugging, testing, and troubleshooting throughout the application development process utilizing appropriate principles and patterns for the given languages and application type.
• Collaborate cross-functionally with product managers, analysts, quality assurance engineers and other team members to achieve elegant and appropriate solutions.
• Adheres to department and product development standards and best practices while working with others to do the same.
• Actively ensures a high level of quality across the product.
• Actively engages and works as a member of the Scrum team contributing to all Scrum ceremonies as needed.
• Builds and maintains effective working relationships with all members of the Scrum team, co-workers, and those in other departments.
• Works directly with the Support department on an as needed basis.
• May provide consultation to other teams on complex projects. May act as a domain/technical expert for the team.
• Will work on advanced, complex technical projects or business issues requiring higher levels of technical and/or industry knowledge.
• Goals may be communicated as a solution or as the outcome of a project.
• Will utilize their experience with OLAP, OLTP, BPM, ETL/ELT and related tools when designing aspects of their current/future systems.
• Strong understanding of database and application performance characteristics, especially in a cloud and/or production environment.
• May act as a technical expert for the team for different subsystems. Participate in mentoring and coaching team members primarily during design and code reviews.
• Performs special projects and other related duties as assigned.

• Bachelor’s degree in Computer Science, an Engineering discipline or equivalent field, required.
• Ten (10) or more years of experience actively developing and/or maintaining production database systems is required.

• Professional and effective written and verbal communication skills. Ability to follow oral and written instructions.
• Excellent organizational skills and attention to detail. Excellent analytical and problem-solving skills. Customer obsessed, self-motivated and a willingness to always learn something new and be curious. Ability to achieve goals in an innovative and fast-paced environment.
• Demonstrated knowledge of database systems, software applications, and programming languages such as T/SQL.
• Demonstrated proficiency with software engineering tools and applications. Ability to operate independently and collaborate with remote teams.
• Extensive experience in database development for highly scalable, distributed and highly resilient relational and non-relational database systems design, deployment and operations.
• Extensive experience of scalable computing systems, software architecture, data structures, and algorithms with a focus on databases.
• Experience with OLAP, OLTP, BPM, ETL/ELT and related tools encompassed within the broader data umbrella.
• Experience building enterprise-class applications and/or…