Data Engineer II (932112)

COMPANY:

Purpose Financial, Inc.

TITLE:

Data Engineer II

DUTIES:

Responsible for building a scalable data infrastructure. Take ownership of building/optimizing data pipelines to increase efficiency and performance. Develop and maintain data ingestion and integration processes that focus on data quality and monitoring. Use AWS and Snowflake tools such as Glue, Lambda, Snowpark, and Snowpipe to build data ingestion pipelines from various sources. Incorporate standards and best practices into data pipeline solutions. Participate in troubleshooting and problem-solving design discussions. Provide logical and physical data design, and database modeling. Solve complex data issues around data integration, unusable data elements, unstructured data sets, and other data processing incidents. Continuously design the future state of our data & reporting process by collaborating with IT and business partners. Partner with enterprise teams, data scientist, architects to define development standards and solutions. Manage cloud infrastructure as code (IaC), using Terraform. Work closely with other members of the data team to better design and build metrics that enhance our analytical capabilities. Manage workflows and data build processes that help the BI team build key business metrics and design dashboard visualizations. Assess the effectiveness and accuracy of new data sources, data points, and data gathering techniques. Troubleshoot problems with data (missing, corrupted, invalid) and build data recovery strategy. Apply best practices for AWS & Snowflake architecture, ELT, and data models. Be a leader for our data journey, act as SME for data and database related topics, and assist with development of data lakes and warehouses. This position is 100% remote.

SCHEDULE:

40 hours per week, Monday through Friday

LOCATION:

Purpose Financial, Inc., 322 Rhett Street, Greenville, SC 29601

REQUIREMENTS:

Bachelor degree (or foreign equivalent degree) in Computer Science, Computer Engineering, Information Systems or other closely related field of study and three (3) years of experience as a Data Engineer or closely related occupation where required experience gained.

SPECIAL SKILLS:

Also requires 3 years of experience in the following: 

• Data warehousing;
• Data architecture and design, with a good understanding of various data systems and structures (i.e., SQL, NoSQL, Key-Value, Streams);
• Building data pipelines and using data orchestration tools and implementing end to end Monitoring & Alerting solutions;
• Working with AWS or public cloud provider;
• Understanding of SQL, data structures, data integrity, and schema design best practices;
• Programming experience required;
• A strong advocate of data governance and data quality;
• Experience with database internals, database design, SQL, and database programming;
• Experience in financial services;
• Experience of authoring CI/CD pipelines, automation elements related to infrastructure composition, deployment orchestration, and monitoring; and
• Familiarity and experience with Agile/SCRUM based development methodology.

CONTACT:

To apply, send resume to: Lalia Taylor at ltaylor@teampurpose.com. Please reference job title and location.