Finley Gates
Data Architect at Lucet (formerly New Directions + Tridiuum)- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Experience
-
Lucet
-
United States
-
Hospitals and Health Care
-
200 - 300 Employee
-
Data Architect
-
Sep 2021 - Present
• Implemented data governance policy across NDBH to ensure integrity of data • Responsible for all database design updates and process changes across EDI, Appdev, Automation, and Reporting and Analytics • Created ERD for all IT systems • Designed schema and built ETL for benefits data • Created dashboards to monitor data quality • Implemented data governance policy across NDBH to ensure integrity of data • Responsible for all database design updates and process changes across EDI, Appdev, Automation, and Reporting and Analytics • Created ERD for all IT systems • Designed schema and built ETL for benefits data • Created dashboards to monitor data quality
-
-
-
New Directions Behavioral Health (now Lucet)
-
United States
-
Mental Health Care
-
200 - 300 Employee
-
Senior SQL Developer
-
Jun 2018 - Nov 2021
• Led data migration from a legacy application to new application • Analyzed data issues to determine root cause, update data, and fix underlying issues • Worked with multiple departments to define requirements and implement solution to automate authorization approval • Built ETL process from Salesforce to custom application for Provider data • Worked with reporting and analytics to create dashboards for key company initiatives • Led data migration from a legacy application to new application • Analyzed data issues to determine root cause, update data, and fix underlying issues • Worked with multiple departments to define requirements and implement solution to automate authorization approval • Built ETL process from Salesforce to custom application for Provider data • Worked with reporting and analytics to create dashboards for key company initiatives
-
-
-
Evolytics | A Concord Company
-
United States
-
Data Infrastructure and Analytics
-
1 - 100 Employee
-
Manager, Digital Analytics
-
Sep 2017 - Jun 2018
• Manage a team of analysts, ensuring success and growth of each member• Develop and manage client relationships, leading to growth of multiple accounts• Optimized online adverting spend for a $40 million annual budget account• Effectively present analysis in an easy to understand way, including understanding the audience and focusing on actionable insights • Understand business questions and pain points of marketers and translate into technical solutions
-
-
Senior Analyst
-
Dec 2016 - Sep 2017
• Designed a data model that integrated multiple data sources into an analyst friendly data layer• Built SQL queries that were optimized for Tableau reporting and dashboards• Built Tableau dashboards using data visualization best practices to allow stakeholders to monitor performance• Managed multiple accounts simultaneously while ensuring deadlines and key milestones were met• Worked with data from multiple marketing channels, including web, email, paid media, social media, and mobile app• Oversee analytics implementation efforts to ensure tracking meets reporting requirements and data is accurately tracked Show less
-
-
Digital Analyst
-
Dec 2013 - Dec 2016
• Wrote queries to aggregate and join Adobe Clickstream data with backend databases to answer business questions about end-to-end user behavior• Conducted data QA to ensure the quality of data collected and be able to explain the discrepancies between data sources• Created data measurement strategies and requirements by interviewing stakeholders, understanding business goals, and assessing current reporting structures and data collection processes
-
-
-
Kansas City Museum
-
Kansas City, Missouri Area
-
Data Collection Intern
-
Sep 2012 - Sep 2013
-
-
-
Sporting Kansas City
-
United States
-
Spectator Sports
-
200 - 300 Employee
-
Statistical Analyst Intern
-
Jun 2012 - Aug 2012
-
-
Education
-
Oberlin College
BA, Sociology