Professional, Data Transformation at Cotality in Irvine, CA

Summary: 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 Required Qualifications: - 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 Preferred Qualifications: - 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 Required Skills: SQL & T-SQL, ETL tools (SSIS), Data Operations Important Skills: Microsoft Suite, Google Cloud Platform (GCP), C# Nice-to-Have Skills: Analytical Thinking, Diligence, Industry Knowledge, 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!