Junior Analytics Engineer

Center Street Lending is one of the largest lenders for residential transition (fix/flip) and ground up loans for residential investors. Since its founding in 2010, Center Street has originated over $6\.5 billion of fix/flip, ground-up, bridge and multi-family loans across 40 states. Center Street Lending provides expert guidance, fast approvals, speedy funding, and personalized in-house service that helps it retain one of the highest customer satisfaction ratings in the industry with 4\.8/5\.0 google stars.We provide tailored financial solutions designed to meet the unique needs of real estate developers and residential investors.

Center Street Lending is proud to be a registered “Great Place to Work”, listed on the 2025 #Inc 5000 list of fastest growing companies and featured in Scotsman Guide’s Top Lenders publication since 2023\.

Website: www.centerstreetlending.com

As a Junior Analytics Engineer, you will help build and maintain the data infrastructure that powers our reporting and analytics capabilities. Working closely with senior engineers, data analysts, and business stakeholders, you will transform raw data from our Salesforce CRM, core lending systems, and third-party providers into clean, reliable, and well-documented data models. Your work will directly impact how the company understands loan performance, borrower behavior, and operational efficiency.

Key Responsibilities

Data Modeling \& Transformation

• Build and maintain scalable data models in Snowflake and PowerBI using SQL, Power Query (M), and DAX following dimensional modeling best practices
• Transform raw source data from Salesforce, loan origination systems, and payment processors into clean, analytics-ready datasets
• Ensure data accuracy, consistency, and completeness across all data pipelines and models
• Document data models, table definitions, and business logic in a shared data catalog

Business Intelligence \& Reporting

• Develop and maintain Power BI dashboards and reports for stakeholders across lending, risk, finance, and operations
• Create self-service BI resources enabling business users to explore loan portfolio KPIs independently
• Partner with analysts to translate business questions into well-structured, performant queries and visuals
• Monitor dashboard performance and troubleshoot data discrepancies in a timely manner

Data Quality \& Governance

• Implement data quality checks and alerting to proactively identify pipeline issues
• Follow and contribute to data governance standards including naming conventions, access controls, and lineage tracking
• Participate in code reviews and help enforce engineering best practices

Qualifications

Required

• 1–2 years of experience in data engineering, analytics engineering, or a closely related role
• Proficiency in SQL - ability to write queries involving joins, aggregations, window functions, and CTEs
• Hands-on experience with Power BI including data modeling (star schema), Power Query, DAX measures, and report publishing
• Familiarity with Snowflake or another cloud data warehouse (BigQuery, Redshift)
• Familiarity with Encompass and Salesforce
• Basic understanding of Salesforce data objects and SOQL
• Strong attention to detail and a commitment to data accuracy
• Ability to communicate technical findings clearly to non-technical stakeholders

Preferred

• Knowledge of financial services or lending concepts (LTV, APR, delinquency, originations)
• Familiarity with Python for data manipulation, pipeline scripting, and custom visualizations
• Exposure to ELT/ETL tools such as Fivetran, Airbyte, or similar
• Bachelor’s degree in Computer Science, Data Science, Mathematics, Finance, or equivalent experience

Our Technology Stack

Data Warehouse:

Snowflake

BI / Reporting:

Microsoft Power BI

CRM:

Salesforce (Sales Cloud \& Financial Services Cloud)

What We Offer

• Competitive base salary ($70,304 – $90,000) with annual performance bonuses
• Equity participation in a high-growth fintech company
• Comprehensive health, dental, and vision insurance
• 401(k) with company match
• Flexible hybrid work environment with home office stipend
• $1,500 annual learning \& development budget (certifications, conferences, courses)
• Mentorship from senior analytics and data engineers
• Clear career progression pathways toward Analytics Engineer II and beyond

How to Apply

To apply, submit your resume and a brief cover letter describing a data project you are proud of and the tools you used to [email protected] or via our Linkedin job link. Applications are reviewed on a rolling basis.