MIS - Analytics Engineer

<p style="line-height: normal; margin: 0in 0in 8pt; font-size: 12pt; font-family: Aptos, sans-serif;"><u><span style="font-size: 10.0pt; font-family: Arial, sans-serif;">General Description: </span></u></p> <p style="line-height: normal; margin: 0in 0in 8pt; font-size: 12pt; font-family: Aptos, sans-serif;"><span style="font-size: 10.0pt; font-family: Arial, sans-serif;">Phillips & Cohen Associates Ltd. is an award-winning probate estate and debt settlement industry leader. We are seeking an Analytics Engineer to support Strategy & Analytics function here at PCA and help identify opportunities that drive performance. The ideal candidate should demonstrate strategic curiosity, challenge assumptions and translate analysis into insights.  </span></p> <p style="line-height: normal; margin: 0in 0in 8pt; font-size: 12pt; font-family: Aptos, sans-serif;"><span style="font-size: 10.0pt; font-family: Arial, sans-serif;">This role combines analytics engineering, data modeling, automation, and applied analytics to </span><span style="font-size: 10.0pt; font-family: Arial, sans-serif;">transform data into actionable insights, connect data analysis to execution to accelerate growth and competitive advantage. </span></p> <p style="line-height: normal; margin: 0in 0in 8pt; font-size: 12pt; font-family: Aptos, sans-serif;"><span style="font-size: 10.0pt; font-family: Arial, sans-serif;">The Analytics Engineer plays critical role in turning data into strategic asset – ensuring the business can rely on</span><span style="font-size: 10.0pt; font-family: Arial, sans-serif;"> accurate, timely insights to drive performance and growth. </span></p> <p style="line-height: normal; margin: 0in 0in 8pt; font-size: 12pt; font-family: Aptos, sans-serif;"> </p> <p style="line-height: normal; margin: 0in 0in 8pt; font-size: 12pt; font-family: Aptos, sans-serif;"><u><span style="font-size: 10.0pt; font-family: Arial, sans-serif;">Responsibilities:</span></u></p> <ul style="margin-top: 0in; margin-bottom: 0in;"> <li style="margin: 0in 0in 0in 0px; line-height: normal; font-size: 12pt; font-family: Aptos, sans-serif;"><span style="font-size: 10.0pt; font-family: Arial, sans-serif;">Support analytics use cases (segmentation, forecasting, A/B testing).</span></li> <li style="margin: 0in 0in 0in 0px; line-height: normal; font-size: 12pt; font-family: Aptos, sans-serif;"><span style="font-size: 10.0pt; font-family: Arial, sans-serif;">Develop, implement and optimize debt recovery processes, including dialer, scoring and portfolio segmentation. </span></li> <li style="margin: 0in 0in 0in 0px; line-height: normal; font-size: 12pt; font-family: Aptos, sans-serif;"><span style="font-size: 10.0pt; font-family: Arial, sans-serif;">Engineer new data assets and derived datasets when required information is not available in existing source systems.</span></li> <li style="margin: 0in 0in 0in 0px; line-height: normal; font-size: 12pt; font-family: Aptos, sans-serif;"><span style="font-size: 10.0pt; font-family: Arial, sans-serif;">Develop scalable data models and schemas to support portfolio valuation, forecasting, reporting, and operational analytics.</span></li> <li style="margin: 0in 0in 0in 0px; line-height: normal; font-size: 12pt; font-family: Aptos, sans-serif;"><span style="font-size: 10.0pt; font-family: Arial, sans-serif;">Eliminate conflicting metrics and definitions, creating a single source of truth across teams.</span></li> <li style="margin: 0in 0in 0in 0px; line-height: normal; font-size: 12pt; font-family: Aptos, sans-serif;"><span style="font-size: 10.0pt; font-family: Arial, sans-serif;">Build and maintain automated end-to-end analytics workflows, including scheduling, orchestration, alerts, and reporting.</span></li> <li style="margin: 0in 0in 0in 0px; line-height: normal; font-size: 12pt; font-family: Aptos, sans-serif;"><span style="font-size: 10.0pt; font-family: Arial, sans-serif;">Implement data quality rules, validation logic, automated QA checks, and monitoring frameworks to ensure data integrity.</span></li> <li style="margin: 0in 0in 0in 0px; line-height: normal; font-size: 12pt; font-family: Aptos, sans-serif;"><span style="font-size: 10.0pt; font-family: Arial, sans-serif;">Perform exploratory data analysis to identify trends, data gaps, and metric behavior related to portfolio performance.</span></li> <li style="margin: 0in 0in 0in 0px; line-height: normal; font-size: 12pt; font-family: Aptos, sans-serif;"><span style="font-size: 10.0pt; font-family: Arial, sans-serif;">Translate business questions and strategy needs into technical requirements, datasets, and analytical solutions.</span></li> <li style="margin: 0in 0in 0in 0px; line-height: normal; font-size: 12pt; font-family: Aptos, sans-serif;"><span style="font-size: 10.0pt; font-family: Arial, sans-serif;">Create reports, dashboards, and analytical outputs that are usable and interpretable by non-technical stakeholders.</span></li> <li style="margin: 0in 0in 0in 0px; line-height: normal; font-size: 12pt; font-family: Aptos, sans-serif;"><span style="font-size: 10.0pt; font-family: Arial, sans-serif;">Optimize SQL queries and ETL/ELT processes for performance, accuracy, and reliability.</span></li> <li style="margin: 0in 0in 0in 0px; line-height: normal; font-size: 12pt; font-family: Aptos, sans-serif;"><span style="font-size: 10.0pt; font-family: Arial, sans-serif;">Collaborate closely with analytics, engineering, and business partners to align data definitions, metrics, and logic.</span></li> <li style="margin: 0in 0in 0in 0px; line-height: normal; font-size: 12pt; font-family: Aptos, sans-serif;"><span style="font-size: 10.0pt; font-family: Arial, sans-serif;">Document data pipelines, models, transformations, business rules, and data dictionaries to support governance and continuity, ensuring consistent metric definition across the organization. </span></li> </ul> <p style="line-height: normal; margin: 0in 0in 8pt; font-size: 12pt; font-family: Aptos, sans-serif;"> </p> <p style="line-height: normal; margin: 0in 0in 8pt; font-size: 12pt; font-family: Aptos, sans-serif;"><u><span style="font-size: 10.0pt; font-family: Arial, sans-serif;">Qualifications: </span></u></p> <ul style="margin-top: 0in; margin-bottom: 0in;"> <li style="margin: 0in 0in 0in 0px; line-height: normal; font-size: 12pt; font-family: Aptos, sans-serif;"><span style="font-size: 10.0pt; font-family: Arial, sans-serif;">Minimum of 3 years of experience in analytics engineering, data engineering, data analytics, or similar hybrid analytics roles.</span></li> <li style="margin: 0in 0in 0in 0px; line-height: normal; font-size: 12pt; font-family: Aptos, sans-serif;"><span style="font-size: 10.0pt; font-family: Arial, sans-serif;">Advanced SQL skills with hands-on experience building scalable transformations and data models.</span></li> <li style="margin: 0in 0in 0in 0px; line-height: normal; font-size: 12pt; font-family: Aptos, sans-serif;"><span style="font-size: 10.0pt; font-family: Arial, sans-serif;">Proficiency in programming language such as SAS, Python or R for analytics, automation, and modeling.</span></li> <li style="margin: 0in 0in 0in 0px; line-height: normal; font-size: 12pt; font-family: Aptos, sans-serif;"><span style="font-size: 10.0pt; font-family: Arial, sans-serif;">Demonstrated experience designing datasets and data architecture to support advanced analytics and forecasting.</span></li> <li style="margin: 0in 0in 0in 0px; line-height: normal; font-size: 12pt; font-family: Aptos, sans-serif;"><span style="font-size: 10.0pt; font-family: Arial, sans-serif;">Experience with BI and visualization tools such as Power BI, Tableau, or Looker.</span></li> <li style="margin: 0in 0in 0in 0px; line-height: normal; font-size: 12pt; font-family: Aptos, sans-serif;"><span style="font-size: 10.0pt; font-family: Arial, sans-serif;">Strong analytical thinking with the ability to translate complex data into actionable business insights.</span></li> <li style="margin: 0in 0in 0in 0px; line-height: normal; font-size: 12pt; font-family: Aptos, sans-serif;"><span style="font-size: 10.0pt; font-family: Arial, sans-serif;">Ability to work effectively in ambiguous, open-ended problem spaces.</span></li> <li style="margin: 0in 0in 0in 0px; line-height: normal; font-size: 12pt; font-family: Aptos, sans-serif;"><span style="font-size: 10.0pt; font-family: Arial, sans-serif;">Understanding of statistical concepts and predictive modeling techniques.</span></li> <li style="margin: 0in 0in 0in 0px; line-height: normal; font-size: 12pt; font-family: Aptos, sans-serif;"><span style="font-size: 10.0pt; font-family: Arial, sans-serif;">Strong written and verbal communication skills with both technical and non-technical audiences.</span></li> <li style="margin: 0in 0in 0in 0px; line-height: normal; font-size: 12pt; font-family: Aptos, sans-serif;"><span style="font-size: 10.0pt; font-family: Arial, sans-serif;">Experience developing SQL Server jobs, stored procedures, triggers, or similar database objects.</span></li> <li style="margin: 0in 0in 0in 0px; line-height: normal; font-size: 12pt; font-family: Aptos, sans-serif;"><span style="font-size: 10.0pt; font-family: Arial, sans-serif;">Familiarity with Git or version control systems.</span></li> <li style="margin: 0in 0in 0in 0px; line-height: normal; font-size: 12pt; font-family: Aptos, sans-serif;"><span style="font-size: 10.0pt; font-family: Arial, sans-serif;">Background in non-performing debt industry, financial services, portfolio analytics, forecasting, or operations analytics is a plus.</span></li> </ul>