Lead Data Modeler

Are you a technology leader with a passion for database design and development and have experience in a collaborative agile team environment? If so, join the FindLaw technology group as a Lead Data Modeler, where you will contribute to the design and delivery of critical public-facing and internal applications.

FindLaw is the leading provider of business marketing solutions for law firms and has the largest online destination for people with legal needs (findlaw.com).   We provide access to justice for consumers who want to find an attorney, complete a DIY form, or collect information to better understand a legal issue.  Our solutions help law firms grow their practice through strategic digital marketing approaches that drive results. As part of Thomson Reuters, we leverage extensive resources and use industry leading tools and technologies like AI and cloud computing to enable our success. 

About the Role

In this opportunity as Lead Data Modeler, you will:

• Work with our business partners, data architects, application and ETL developers, and other members of the FindLaw Team to develop, maintain and enhance data models and objects associated with transactional, data warehouse, and reporting databases.
• Provide guidance related to security, governance, and best practices as it relates to databases and data modeling.
• Design dimensional and relational physical data models.
• Work independently with minimal direction to meet commitments.
• Follow enterprise data architecture principles.

About You

You're a fit for the role of Lead Data Modeler if your background includes:

• Minimum 7 years of prior data modeling experience
• A bachelor’s degree in architecture, engineering, computer science, or a related field. 
• In depth knowledge of PostgreSQL, Oracle, and MySQL databases
• Experience with AWS cloud services
• Experience with Snowflake, Python, ETL, MySQL, Cloud Services, and/or tuning is preferred
• Experience designing dimensional and relational physical data models
• Experience implementing database objects, deployment activities
• Experience with PowerDesigner modeling tool or other data modeling tools
• Strong knowledge of data modeling principles and best practices
• Strong communication skills; experience communicating with data engineers, data analysts, business users, and management to explain technical and functional concepts
• Understanding of enterprise data architecture principles
• Strong data analysis and SQL writing skills; including query performance tuning
• Experience writing and executing complex SQL
• Demonstrated success working in a team-based, agile environment
• Strong facilitation and negotiation skills
• Ability to multitask in a fast-paced environment
• Knowledge of Fivetran’s HVR replication tool
• Knowledge of Snowflake database

#LI-MW1

What's in it For You?
You will join our inclusive culture of world-class talent, where we are committed to your personal and professional growth through:

• Hybrid Work Model: We’ve adopted a flexible hybrid working environment (2-3 days a week in the office depending on the role) for our office-based roles while delivering a seamless experience that is digitally and physically connected

• Wellbeing: Comprehensive benefit plans; flexible and supportive benefits for work-life balance: flexible vacation, two company-wide Mental Health Days Off; work from another location for up to a total of 8 weeks in a year, 4 of those weeks can be out of the country and the remaining in the country, Headspace app subscription; retirement, savings, tuition reimbursement, and employee incentive programs; resources for mental, physical, and financial wellbeing.

• Culture: Globally recognized and award-winning reputation for equality, diversity and inclusion, flexibility, work-life balance, and more.

• Learning & Development: LinkedIn Learning access; internal Talent Marketplace with opportunities to work on projects cross-company; Ten Thousand Coffees Thomson Reuters café networking.

• Social Impact: Ten employee-driven Business Resource Groups; two paid volunteer days annually; Environmental, Social and Governance (ESG) initiatives for local and global impact.

• Purpose Driven Work: We have a superpower that we’ve never talked about with as much pride as we should – we are one of the only companies on the planet that helps its customers pursue justice, truth and transparency. Together, with the professionals and institutions we serve, we help uphold the rule of law, turn the wheels of commerce, catch bad actors, report the facts, and provide trusted, unbiased information to people all over the world.

<