Professional, Data Transformation
Cotality is a company dedicated to enhancing the property industry through innovative technology and insights. They are seeking a Data Transformation Professional to manage complex data workflows, ensuring quality and efficiency from intake to reporting.
Responsibilities
- Data Pipeline Management: Maintain existing and develop new data curation logic. Monitor the pipeline for bottlenecks, troubleshoot "abnormal job terminations," and ensure data quality before it moves to the next production step
- Technical Execution: Use SQL Server, T-SQL, SSIS, and proprietary tools to query, manipulate, and prepare complex datasets for the Cotality Smart Data Platform
- Cross-Functional Collaboration: Engagement Teams: Coordinate raw data ingestion and resolve "Decision Diamond" triggers requiring external clarification. Central Services: Maintain the "Single Source of Truth" within master databases and collaborate on Entity/Account updates. Analytics & Management: Escalate value mismatches and provide validated datasets to support final client deliverables
- Process Improvement: Research industry trends to incorporate new data capture methods. Proactively identify ways to improve system effectiveness and document results to ensure long-term quality
- Special Projects: Support custom report development, specialized product support for national accounts, and provide mentoring to junior team members
Skills
- Bachelor's degree in Data Analytics, Computer Science, or a related field (or equivalent experience)
- 1+ years of hands-on experience with SQL & T-SQL and ETL tools (SSIS)
- 1+ years of experience monitoring data loads and utilizing Operational Dashboard KPIs for root cause analysis
- Proficiency in Microsoft Suite and Google Cloud Platform (GCP)
- Ability to translate conceptual business needs into technical requirements and functional tasks
- Strong process-oriented mindset with the ability to navigate complex 'swimlane' workflows
- Ability to translate technical data issues into actionable requests for non-technical stakeholders across a geographically dispersed organization
- Extreme attention to detail when managing 'Error' and 'Mismatch' loops to prevent data corruption
- Experience in the Real Estate industry, specifically with MLS, Appraisal, or Building Permit data
- Hands-on experience with C#
- Intermediate to advanced experience with diverse and complex data file formats
Benefits
- Generous PTO and 11 paid holidays, plus well-being and volunteer time off.
- Up to 16 weeks of fully paid parental leave and a baby stipend.
- Multiple medical plan options with mental health and wellness support offerings.
- 401(k) with company match and vesting after one year.
- $400 annual well-being stipend and tuition assistance up to $5,250.
- Recognition Rewards, Referral bonuses, exclusive discounts and more!
Company Overview