Data Engineer

Job Description

Join the new platform that will transform the world of impact investing. We’re looking for the best minds to take the data on impact investing and sustainability to the next level. RockCreek is leveraging its unparalleled experience in sustainable investing to create the preeminent “go-to” resource for inclusion and impact investments. We are investing in a new start-up platform that will create a unique ecosystem of data on inclusion and impactful investments in technology and innovation, education, housing affordability, financial inclusion, and health and well-being. This new company will benefit from RockCreek’s vast experience as the leader in this space and the underlying data assets that have driven above-market performance across the past decade. We are currently assembling a core team of highly motivated, mission-oriented star talent to make this vision a reality. We seek engineers, data scientists and project managers with experience in building out new businesses and a passion for making the world a better place and our society more equitable.

RockCreek is hiring a Data Engineer responsible for the following:

• Design and maintain ETL/ELT pipelines, SQL queries to meet business needs
• Define and construct efficient data models based on business requirements
• Maintain existing RDS Aurora PostgreSQL database
• Work closely with project leads to understand stakeholder needs
• Contribute to a culture of innovation, ideas, and continuous improvement along with a great attitude, solid communication skills, willingness to learn and collaborate

Qualifications

Requirements:

• Experience with PostgreSQL and RDS Aurora (postgres) or similar RDBMS
• Understanding of various objects and technologies in PostgreSQL
• Analytical, detail driven, and excellent problem solver with a keen eye for uncovering actionable insights that can be applied to drive the business
• Ability to find and tune query- or server-scoped performance bottlenecks

Solid understanding of:

• Table inheritance
• Triggers (statement / row) Full-text search capabilities Foreign Data Wrappers
• Willing to work with the team and other developers across the company to continuously improve our approach to development
• Ensure clear documentation of created/modified functionality
• Strong communication skills and critical thinking skills

Desirable Skills:

• Experience with modern “Big Data” technologies such as Apache Airflow, Spark, and Hadoop
• Experience with materialized views, strategies to maintain materialized views up to date
• Knowledge of database construction, management, and experience with ETL pipelines Familiarity with building data solutions in a cloud-native environment such as AWS
• Business Intelligence, Analytics or Finance experience
• Past exposure to Linux, Docker and Kubernetes is a plus

The ideal candidate must be well-organized, flexible, able to anticipate change, able to perform well under pressure, and up to date on current financial markets and business issues with a passion for impact and sustainable investing. It is critical that the candidate can work in a dynamic and fast-paced environment. The candidate must be a team player who takes initiative, anticipates needs, and adapts to demanding and ever- changing situations.

Additional Information

Consistent with our belief that team members are our most valuable asset, RockCreek offers a competitive benefits package.

• Ability to work remotely with support technology
• Medical, dental, and vision insurance; dependents eligible
• 401(k) retirement plan with company match
• Paid time off, sick leave, and company holidays
• Wellness programs including meditation and fitness classes
• Onsite gym

For additional information on RockCreek, please visit https://therockcreekgroup.com

Follow us on LinkedIn:https://www.linkedin.com/company/the-rock-creek-group/

RockCreek is an Equal Opportunity Employer and does not discriminate against any employee or job applicant because of race, color, religion, national origin, sex, gender, gender identity, physical or mental disability, or age.