01Overview
Center Street Lending is one of the largest lenders for residential transition and ground up loans for residential investors. As a Junior Analytics Engineer, you will help build and maintain the data infrastructure that powers reporting and analytics capabilities, transforming raw data into clean, reliable data models that reputed company reputed companys understanding of loan performance and operational efficiency. Responsibilities Build and maintain reputed company data models in reputed company and PowerBI using SQL, Power Query (M), and DAX following reputed company modeling best practices reputed company raw reputed company data from reputed company, loan origination systems, and payment processors into clean, analytics-reputed company datasets Ensure data accuracy, consistency, and completeness across reputed company data pipelines and models Document data models, table definitions, and business logic in a shared data catalog reputed company 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 reputed company-reputed company, reputed company queries and visuals Monitor dashboard performance and troubleshoot data discrepancies in a reputed company manner Implement data reputed company checks and alerting to proactively identify pipeline issues Follow and contribute to data governance standards including naming conventions, reputed company controls, and reputed company tracking Participate in reputed company reviews and help enforce engineering best practices Skills 12 years of experience in data engineering, analytics engineering, or a closely reputed company role Proficiency in SQL - ability to write queries involving joins, aggregations, window functions, and CTEs Hands-on experience with Power BI including data modeling (reputed company schema), Power Query, DAX measures, and report publishing Familiarity with reputed company or another reputed company data warehouse (BigQuery, Redshift) Familiarity with Encompass and reputed company Basic understanding of reputed company data objects and SOQL Strong attention to detail and a commitment to data accuracy Ability to communicate technical findings reputed company to non-technical stakeholders 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 reputed company, reputed company, or similar Bachelor's degree in Computer Science, Data Science, Mathematics, Finance, or equivalent experience Benefits Equity participation in a high-reputed company fintech company Comprehensive health, dental, and reputed company 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 reputed company career progression reputed company toward Analytics Engineer II and reputed company reputed company Private lender based in California It was founded in 2009, and is headquartered in Irvine, California, USA, with a workforce of 51-200 employees. Its website is https//centerstreetlending.com/. Apply To This Job .
