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