What you will own:

• Assemble large, complex data sets that meet functional business requirements

• Harden, optimize, and productize prototypical ETL logic created by analysts to support business needs

• Maintain optimal data pipeline architecture, including looking for and proposing improvements to the existing architecture

• Engage with and bring insights to current projects, building out an updated data warehouse and ETL processes using a modern data stack.

• Assist analyst teams in identifying the best data to use to answer business questions through data dictionary maintenance and overall data knowledge

• Work to identify, design, and implement internal process improvements including: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc…

• Work with functional business leaders to integrate new data sources and software solutions into the reporting environment

• Assist analyst teams with data gathering and provide insight for improving SQL query construction.

What you’ll need to be successful:

• Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases

• Advanced knowledge of modern data pipeline architecture, e.g. AWS, Snowflake, etc…

• Proficient knowledge of Python, JS, or, another data-focused programming language.

• Experience with dbt and Snowflake optimization is a plus.

• Experience building and optimizing data pipelines, architectures, and data in a near real-time environment

• Experience working with data ingestion tools or API integrations to pull data from and push data into various business software solutions, e.g. Adobe Analytics, CRM, etc…

• Experience performing root cause analysis on internal and external data and processes to provide required data to analysts in answering business questionsStrong analytic skills related to working with unstructured datasets

• Experience working with business process owners and analysts to create and maintain purpose-built data infrastructure, not clean/pure data in a bubble

• Strong project management and organizational skillsAbility to proactively identify opportunities for improvement and propose changes without specific instructions
• Experience supporting and working with cross-functional teams in a dynamic environment
• 6+ years of experience in a Data Engineer role, or 4+ years of experience as an analyst with an accompanying technical portfolio.
• Degree in Computer Science, Statistics, Informatics, Information Systems or another data-centric discipline or Lambda School preferred.

Pay Range:

Benefits

• Be part of a high-performing, collaborative team, and have fun at work each day

• Competitive pay

• A full suite of traditional benefits

• Untracked PTO (Paid Time-off)

• 401(k) with company match

• Company-contributed HSA

• Onsite gym and standing desks

• Wellness program

• Discounted cellular plans

• Company-contributed travel benefit

Get to know Lendio:

Lendio is the nation’s leading small business financial solutions provider, with a mission to help small businesses survive and thrive. With its diverse network of lenders, Lendio enables small business owners to apply for multiple business financing options with a single application. In addition to creating access to small business capital, Lendio offers time-saving financial SaaS products that are designed to streamline business operations.

Lendio is a mission-driven organization striving to provide equal access to capital to underserved communities and America’s smallest businesses. For every new marketplace loan Lendio facilitates, Lendio Gives—an employee-contribution and employer-matching fund, in partnership with KIVA–provides a microloan to low-income entrepreneurs around the world, continuously re-investing the fund.

Lendio is an equal opportunity employer committed to diversity and inclusion. We welcome anyone who wants to help small businesses survive and thrive and aligns with our core values, regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability, gender identity, veteran status, or other applicable legally protected characteristics. If you have a disability or special need that requires accommodation, please let us know.