Sr Data Engineer

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

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 oppo