Senior Data Engineer

Job Summary

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 RedSail 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.

Key Duties:

• 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.

Education/Training

• 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.

Work Experience/Skills

• 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 distributed systems in the public cloud, hosted, or on-site.
• Proven track record of leading delivery of large scale, distributed, high quality database systems. Experience in building and operating complex distributed data systems, data lakes, and data warehouse. Strong understanding of data security and compliance design principles such as data auditing, data privacy/encryption, retention policies, archiving strategies, etc.

Discretionary Judgement

• Can work autonomously requiring little to no oversight

Physical Demands, Working Conditions, and General Employment Guidelines

• Sitting and standing for most of the workday.
• Moderate levels of stress may be experienced in the performance of the job
• Position is performed in a general office environment, home office, or approved remote workspace

Equipment

• Moderate use of the telephone, computer, printer, and other routine office equipment

Safety to Self and Others

• Little responsibility for safety of others. Job is performed in an office setting where there are not hazardous materials or equipment

Work Location

• RedSail Office-Remote