Redshift Database Engineer

How We Will Help You:

Joining our Data Modeling practice is not only a job, but a chance to grow your career. We will make sure to equip you with the skills you need to produce robust applications that you can be proud of. Whether it is providing you with training on a new programming language or helping you get certified in a new technology, we will help you grow your skills so you can continue to deliver increasingly valuable work.

Once You Are Here, You Will:

• Be responsible for the development of the conceptual, logical, and physical data models, the implementation of RDBMS, AWS Redshift Datawarehouse , operational data store (ODS), data marts, and data lakes on target platforms (SQL/NoSQL).
• Oversee and govern the expansion of existing data architecture and the optimization of data query performance via best practices. The candidate must be able to work independently and collaboratively.
• Implement business and IT data requirements through new data strategies and designs across all data platforms (relational, dimensional, and NoSQL) and data tools (reporting, visualization, analytics, and machine learning).
• Work with business and application/solution teams to implement data strategies, build data flows, and develop conceptual/logical/physical data models

Basic Qualifications:

• 4+ years experience and the ability to Define and govern data modeling and design standards, tools, best practices, and related development for enterprise data models.
• 4+ years experience and the ability to Identify the architecture, infrastructure, and interfaces to data sources, tools supporting automated data loads, security concerns, analytic models, and data visualization.
• 4+ years of Hands-on modeling, design, configuration, installation, performance tuning, and sandbox POC.
• 1 year of Life and Annuity Insurance domain knowledge.

Preferred:

• Ability to work proactively and independently to address project requirements and articulate issues/challenges to reduce project delivery risks.
• Ability to understand business requirements and define entities, attributes, mapping, relationships, and integrity rules with the proper naming conventions/standards
• Willingness to assist business analysts and developers to understand and use data models that organize the data into tables and accounts for access.

Ideal Mindset:

• Lifelong Learner. You are always seeking to improve your technical and nontechnical skills.
• Team Player. You are someone who wants to see everyone on the team succeed and is willing to go the extra mile to help a teammate in need.
• Communicator. You know how to communicate your design ideas to both technical and nontechnical stakeholders, prioritizing critical information and leaving out extraneous details.

This position is a hybrid role, requiring three days per week onsite