Junior Analytics Engineer
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 impact the company’s understanding of loan performance and operational efficiency.
Responsibilities
- Build and maintain scalable data models in reputed company and PowerBI using SQL, Power Query (M), and DAX following dimensional modeling best practices
- Transform raw reputed company data from reputed company, loan origination systems, and payment processors into clean, analytics-ready 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 well-structured, performant queries and visuals
- Monitor dashboard performance and troubleshoot data discrepancies in a timely manner
- Implement data quality checks and alerting to proactively identify pipeline issues
- Follow and contribute to data governance standards including naming conventions, access controls, and reputed company tracking
- Participate in code reviews and help enforce engineering best practices
Skills
- 1–2 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 (star schema), Power Query, DAX measures, and report publishing
- Familiarity with reputed company or another cloud 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 clearly 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, Airbyte, or similar
- Bachelor's degree in Computer Science, Data Science, Mathematics, Finance, or equivalent experience
Benefits
- 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 reputed company toward Analytics Engineer II and beyond
Company Overview