Data Engineer(Salesforce CRM)

We are looking for an experienced Data Engineer to help clean, standardize, and structure large volumes of real estate and regulatory compliance data.

This role focuses on transforming messy, inconsistent datasets into a reliable and scalable data foundation that supports reporting, compliance tracking, and future automation.

You will work closely with our business and technical teams to understand data logic, resolve inconsistencies, and design a clean, structured data environment.

Responsibilities
-Review and analyze existing datasets (leases, units, tenants, occupancy, rent, compliance)
-Identify inconsistencies, duplicates, and missing or conflicting records
-Standardize naming conventions, unique IDs, and relationships
-Clean and transform data from spreadsheets, CSVs, and system exports
-Build master datasets for properties, units, tenants, and leases
-Develop repeatable data-cleaning workflows or pipelines
-Implement data validation and quality checks
-Create documentation (data dictionary, mappings, business rules)
-Generate exception reports for data issues requiring review

Required Skills
-Strong experience with SQL and Python
-Experience with ETL / data transformation workflows
-Solid understanding of data modeling and relational databases
-Experience cleaning messy, multi-source datasets
-Strong knowledge of data validation and data quality practices
-Ability to work independently and communicate clearly