Description

You will own the ETL lifecycle and data quality processes for multifamily and mortgage datasets.

This role is on-site.

Responsibilities

• Develop and optimize SQL scripts for data extraction, transformation, and reporting.
• Design and implement data models and pipelines using RDBMS and NoSQL databases.
• Utilize Informatica Cloud and Informatica Data Quality (IDQ) for integration and profiling.
• Define data quality rules and create visualizations to communicate findings to stakeholders.
• Support data governance initiatives and mentor junior analysts.

Required Skills

• 5+ years experience as a Data Analyst, including 2+ years in multifamily real estate or mortgage.
• Advanced SQL proficiency with MySQL, PostgreSQL, and SQL Server.
• Hands-on experience with MongoDB and other NoSQL databases.
• Proven experience with Informatica Cloud and Informatica Data Quality (IDQ).
• Experience with ETL processes, data warehousing, and pipeline development.
• Proficiency in data visualization tools like Tableau or Power BI.

Preferred Skills

• Experience with Python or AWS.

Key Skills

Education

Any Graduate