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.ResponsibilitiesData 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 stepTechnical Execution: Use SQL Server, T-SQL, SSIS, and proprietary tools to query, manipulate, and prepare complex datasets for the Cotality Smart Data PlatformCross-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 deliverablesProcess Improvement: Research industry trends to incorporate new data capture methods. Proactively identify ways to improve system effectiveness and document results to ensure long-term qualitySpecial Projects: Support custom report development, specialized product support for national accounts, and provide mentoring to junior team membersSkillsBachelor'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 analysisProficiency in Microsoft Suite and Google Cloud Platform (GCP)Ability to translate conceptual business needs into technical requirements and functional tasksStrong process-oriented mindset with the ability to navigate complex 'swimlane' workflowsAbility to translate technical data issues into actionable requests for non-technical stakeholders across a geographically dispersed organizationExtreme attention to detail when managing 'Error' and 'Mismatch' loops to prevent data corruptionExperience in the Real Estate industry, specifically with MLS, Appraisal, or Building Permit dataHands-on experience with C#Intermediate to advanced experience with diverse and complex data file formatsBenefitsGenerous 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 OverviewCotality is a technology firm helping property professionals with data, valuations, surveys and retrofit solutions. It was founded in 2005, and is headquartered in Solihull, Solihull, GBR, with a workforce of 1001-5000 employees. Its website is https://www.cotality.com/uk/ .



Apply Now