Data Engineer

As a senior member of our team, you'll be a technical linchpin, bridging the gap between our domestic Product, Analyst, and Customer Success teams part of our cloud engineering team.

The Mission

Your goal is to design, build, and optimize a modern data ecosystem. We operate in a hybrid environment where legacy stability meets cutting-edge flexibility. You'll be responsible for ensuring our data is performant, compliant (especially within the nuances of the Insurance industry), and ready for both human analysis and machine learning models.

What You'll Do

• Data Modeling and Architecture: Architect and build robust, consistent, and non-redundant Dimensional Models within the Enterprise Data Warehouse (EDW) to solve specific business use cases, ensuring optimal performance for PowerBI consumption.

• ETL/ELT Pipeline Development: Design and implement end-to-end data pipelines, leveraging Matillion and ADF for orchestration, and PySpark for intricate data transformations.

• Data Ecosystem Management: Manage and optimize the data footprint across key platforms, including MS SQL Server, Snowflake, and the MS Fabric environment.

• Innovate with AI: Integrate AI tools (Copilots, LLM-based automation, or predictive features) into our data workflows to increase efficiency and data quality.

• Collaborate Globally: Work closely with our Global Development Centers to ensure architectural consistency while acting as a primary technical partner for Product and Customer Success teams.

• Expert SQL & Python: You can write complex queries in your sleep and build robust, modular scripts in Python/PySpark.

• Cloud Data Platforms: Deep experience with Snowflake (warehousing) and MS Fabric (the future).

• ETL/ELT Mastery: Proven track record with Matillion or similar cloud-native orchestration tools.

• Big Data Savvy: You know how to handle high-volume, high-velocity data without breaking the bank or the server.

• AI Fluency: You aren't just curious about AI; you're actively using AI tools to speed up development or enhance data insights.

The "Nice-to-Haves" (The Secret Sauce):

• Insurance Domain Knowledge: Experience with policy, claims, or underwriting data is a massive plus. You understand the difference between a premium and a loss ratio.

• Remote Pro: You've mastered the art of asynchronous communication and thrive in a US-Remote environment.

Who You Are

• A Technical Diplomat: You can explain a "partitioning strategy" to an engineer and "data reliability" to a Customer Success Manager with equal ease.

• Problem Solver: You don't just fix bugs; you find the root cause and build a system so it never happens again.

• Continuous Learner: The data landscape changes every six months. You're the person who's already experimenting with the latest MS Fabric features or Python libraries., * Minimum 8 years experience

• Engineering or BS degree

Design and optimize data ecosystems, develop ETL pipelines using Matillion and ADF, manage data across platforms, integrate AI tools, and collaborate globally to ensure data reliability and performance. The summary above was generated by AI, This opportunity is expected to remain posted through the date identified below, subject to business needs.

Thrive with Cotality

At Cotality, we offer more than just a job, we provide a benefits experience designed to support your whole self. From a flexible working model to competitive time off and standout health coverage with meaningful perks and growth opportunities, our package is built to help you thrive at work and in life.

Highlights, depending on role classification, include:

• Time off: Generous PTO and 11 paid holidays, plus well-being and volunteer time off.
• Family Support: Up to 16 weeks of fully paid parental leave and a baby stipend.
• Health: Multiple medical plan options with mental health and wellness support offerings.
• Retirement: 401(k) with company match and vesting after one year.
• Financial Perks: $400 annual well-being stipend and tuition assistance up to $5,250.
• Extras: Recognition Rewards, Referral bonuses, exclusive discounts and more!

Please note, Qualifications, locations and experience of the individual ultimately selected for the position may impact the final actual offered compensation, which may vary from the posted range

Cotality is an Equal Opportunity employer committed to attracting and retaining the best-qualified people available, without regard to race, color, religion, national origin, gender, sexual orientation, gender identity, age, disability or status as a veteran of the Armed Forces, or any other basis protected by federal, state or local law. Cotality maintains a Drug-Free Workplace.

Cotality is fully committed to a work environment that embraces everyone's unique contributions, experiences and values. We offer an empowered work environment that encourages creativity, initiative and professional growth and provides a competitive salary and benefits package. We are better together when we support and recognize our differences.

At Cotality, we are driven by a single mission-to make the property industry faster, smarter, and more people-centric. Cotality is the trusted source for property intelligence, with unmatched precision, depth, breadth, and insights across the entire ecosystem. Our talented team of 5,000 employees globally uses our network, scale, connectivity and technology to drive the largest asset class in the world. Join us as we work toward our vision of fueling a thriving global property ecosystem and a more resilient society. Cotality is committed to cultivating a diverse and inclusive work culture that inspires innovation and bold thinking; it's a place where you can collaborate, feel valued, develop skills and directly impact the real estate economy. We know our people are our greatest asset. At Cotality, you can be yourself, lift people up and make an impact. By putting clients first and continuously innovating, we're working together to set the pace for unlocking new possibilities that better serve the property industry.