Analytics Engineer
Location
United States
Posted
44 days ago
Salary
$100K - $150K / year
Seniority
Mid Level
Job Description
Analytics Engineer
Phillips & Cohen Associates Ltd.
Role Description Phillips & Cohen Associates Ltd. is seeking an Analytics Engineer to support the Strategy & Analytics function and help identify opportunities that drive performance. The ideal candidate should demonstrate strategic curiosity, challenge assumptions, and translate analysis into insights. This role combines analytics engineering, data modeling, automation, and applied analytics to transform data into actionable insights, connecting data analysis to execution to accelerate growth and competitive advantage. The Analytics Engineer plays a critical role in turning data into a strategic asset, ensuring the business can rely on accurate, timely insights to drive performance and growth. - Support analytics use cases (segmentation, forecasting, A/B testing). - Develop, implement, and optimize debt recovery processes, including dialer, scoring, and portfolio segmentation. - Engineer new data assets and derived datasets when required information is not available in existing source systems. - Develop scalable data models and schemas to support portfolio valuation, forecasting, reporting, and operational analytics. - Eliminate conflicting metrics and definitions, creating a single source of truth across teams. - Build and maintain automated end-to-end analytics workflows, including scheduling, orchestration, alerts, and reporting. - Implement data quality rules, validation logic, automated QA checks, and monitoring frameworks to ensure data integrity. - Perform exploratory data analysis to identify trends, data gaps, and metric behavior related to portfolio performance. - Translate business questions and strategy needs into technical requirements, datasets, and analytical solutions. - Create reports, dashboards, and analytical outputs that are usable and interpretable by non-technical stakeholders. - Optimize SQL queries and ETL/ELT processes for performance, accuracy, and reliability. - Collaborate closely with analytics, engineering, and business partners to align data definitions, metrics, and logic. - Document data pipelines, models, transformations, business rules, and data dictionaries to support governance and continuity, ensuring consistent metric definition across the organization. Qualifications - Minimum of 3 years of experience in analytics engineering, data engineering, data analytics, or similar hybrid analytics roles. - Advanced SQL skills with hands-on experience building scalable transformations and data models. - Proficiency in programming languages such as SAS, Python, or R for analytics, automation, and modeling. - Demonstrated experience designing datasets and data architecture to support advanced analytics and forecasting. - Experience with BI and visualization tools such as Power BI, Tableau, or Looker. - Strong analytical thinking with the ability to translate complex data into actionable business insights. - Ability to work effectively in ambiguous, open-ended problem spaces. - Understanding of statistical concepts and predictive modeling techniques. - Strong written and verbal communication skills with both technical and non-technical audiences. - Experience developing SQL Server jobs, stored procedures, triggers, or similar database objects. - Familiarity with Git or version control systems. - Background in non-performing debt industry, financial services, portfolio analytics, forecasting, or operations analytics is a plus.
Related Guides
Related Categories
Related Job Pages
More Analytics Engineer Jobs
Role Description The Supervisor Workforce Management Real-Time and Analytics is responsible for 24/7/365 intraday workforce management to ensure optimal alignment between staffing and contact center demand across the Alignment Health enterprise. This role is both leadership as well as tactical supporting a team of Real Time Analysts (RTA) that monitors real-time performance against forecast and staffing plans, identifies variances, and executes immediate corrective actions to achieve service level, ASA, occupancy, and efficiency targets. - Lead and coach the RTA team by supporting real-time operational oversight. - Foster a culture of caring connections, accountability, and service excellence aligned with Alignment’s serving-heart culture. - Set clear performance expectations tied to quality, turnaround time, productivity, compliance, and member satisfaction. - Conduct regular coaching sessions, intraday performance to ensure high standards of service and KPI attainment. - Support onboarding, training, and continuous skill development to strengthen workforce management knowledge and collaboration skills. - Hands-on leader that steps in to support tactical execution as well as leading RTA. - Collaborative with emotional intelligence to engage and influence teams outside of supervisory responsibility. - Ensures team compliance with Alignment policies, CMS regulations, and applicable laws. - Creates a strong culture of engagement, accountability, and professional development. Qualifications - Minimum 8+ years in a contact center environment. - Minimum 5+ years in Workforce Management, Real-Time. - High School Diploma or GED required. - Bachelor’s degree or equivalent experience highly desired (preferred). - WFM or Contact Center related certification (preferred). Requirements - Intraday management and service recovery strategies. - Understanding of Erlang-based staffing principles and interval planning. - Knowledge of key WFM drivers: shrinkage, occupancy, service level, ASA, AHT, forecast accuracy. - Advanced Excel skills (data analysis, pivot tables, trend analysis). - Ability to interpret interval-level performance data and translate insights into operational actions. - Strong problem-solving and decision-making in a high-volume, real-time environment. - Effective communication and collaboration with Operations and WFM partners. - Experience with WFM and telephony platforms (Talkdesk or equivalent). - Shift, Weekend and Holiday coverage support as required. Benefits - Pay Range: $64,384.00 - $96,577.00. - Pay range may be based on a number of factors including market location, education, responsibilities, experience, etc.
• Design and build Playbook's data warehouse from the ground up in Dataform or dbt on BigQuery — defining our raw/staging/intermediate/marts architecture, modeling conventions, naming, and testing standards. • Own our ingestion layer — manage and extend our Hevo setup across Stripe, production Postgres (AWS), Mixpanel, GA4, HubSpot, Meta Ads, Google Ads, Ahrefs, PostHog, and new sources as they come. • Establish CI/CD, testing, and data quality practices for the warehouse — environments, automated tests, lineage, freshness checks, and alerting so we can trust what we ship. • Be the Growth team's data partner — turn their questions into production-grade data models, define and codify business metrics (MRR, churn, LTV, CAC, activation, retention, attribution), and make self-serve analytics actually self-serve. • Own, build, and evolve Playbook's creator-facing analytics product — the data layer that powers the metrics and insights creators see inside the platform about their own business performance. • Support product and engineering teams on data-heavy features — partner on data models, pipelines, and metric definitions for features that rely on the warehouse. • Own data requests across the company — triage, prioritize, and either solve them directly or invest in the models that unblock them at scale. • Maintain and evolve our BI layer — making sure dashboards and reports are trustworthy, documented, and built on top of our modeled layer rather than raw tables. • Set the direction for Playbook's data platform — what to build vs. buy, where to invest, and how the stack should evolve as we grow.
DBT/ Snowflake Junior Engineer
NTT DATA ServicesNTT DATA is a $30 billion business and technology services leader, serving 75% of the Fortune Global 100. We are committed to accelerating client success and positively impacting society through responsible innovation. We are one of the world's leading AI and digital infrastructure providers, with unmatched capabilities in enterprise-scale AI, cloud, security, connectivity, data centers, and application services. Our consulting and Industry solutions help organizations and society move confidently and sustainably into the digital future. As a Global Top Employer, we have experts in more than 50 countries. We also offer clients access to a robust ecosystem of innovation centers as well as established and start-up partners. NTT DATA is a part of NTT Group, which invests over $3 billion each year in R&D.
Role Description We are currently seeking a DBT/ Snowflake Junior Engineer to join our team in Remote, Karnātaka (IN-KA), India. - Translate Informatica mappings, transformations, and business rules into dbt models (SQL) on Snowflake. - Design and implement staging, core, and mart layers using standard dbt patterns and folder structures. - Develop and maintain dbt tests (schema tests, data tests, custom tests) to ensure data quality and integrity. - Implement snapshots, seeds, macros, and reusable components where appropriate. - Collaborate with Snowflake developers to ensure physical data structures support dbt models efficiently. - Work with functional teams to ensure functional equivalence between legacy Informatica outputs and new dbt outputs. - Participate in performance tuning of dbt models and Snowflake queries. - Integrate dbt with CI/CD pipelines (e.g., Azure DevOps, GitHub Actions) for automated runs and validations. - Contribute to documentation of dbt models, data lineage, and business rules. - Participate in defect analysis, bug fixes, and enhancements during migration and stabilization phases. Qualifications - 7+ years of experience in Data Engineering / ETL / DW, with 1–3+ years working with dbt (Core or Cloud). - Strong SQL skills, especially on Snowflake or another modern cloud DW. - Experience with dbt concepts: models, tests, sources, seeds, snapshots, macros, exposures. - Prior experience with Informatica (developer-level understanding of mappings/workflows) is highly desirable. - Understanding of CI/CD practices and integrating dbt into automated pipelines. - Knowledge of data modeling (dimensional models, SCDs, fact/dimension design). - Experience working in offshore delivery with onshore coordination. - Good communication skills and ability to read/understand existing ETL logic and requirements documentation. Company Description NTT DATA is a $30 billion business and technology services leader, serving 75% of the Fortune Global 100. We are committed to accelerating client success and positively impacting society through responsible innovation. - One of the world's leading AI and digital infrastructure providers. - Unmatched capabilities in enterprise-scale AI, cloud, security, connectivity, data centers, and application services. - Consulting and Industry solutions help organizations and society move confidently and sustainably into the digital future. - Global Top Employer with experts in more than 50 countries. - Access to a robust ecosystem of innovation centers as well as established and start-up partners. - Part of NTT Group, which invests over $3 billion each year in R&D.
DBT/Snowflake Junior Engineer
NTT DATA ServicesNTT DATA is a $30 billion business and technology services leader, serving 75% of the Fortune Global 100. We are committed to accelerating client success and positively impacting society through responsible innovation. We are one of the world's leading AI and digital infrastructure providers, with unmatched capabilities in enterprise-scale AI, cloud, security, connectivity, data centers, and application services. Our consulting and Industry solutions help organizations and society move confidently and sustainably into the digital future. As a Global Top Employer, we have experts in more than 50 countries. We also offer clients access to a robust ecosystem of innovation centers as well as established and start-up partners. NTT DATA is a part of NTT Group, which invests over $3 billion each year in R&D.
Role Description We are currently seeking a DBT/Snowflake Junior Engineer to join our team in Remote, Karnātaka (IN-KA), India (IN). - Translate Informatica mappings, transformations, and business rules into dbt models (SQL) on Snowflake. - Design and implement staging, core, and mart layers using standard dbt patterns and folder structures. - Develop and maintain dbt tests (schema tests, data tests, custom tests) to ensure data quality and integrity. - Implement snapshots, seeds, macros, and reusable components where appropriate. - Collaborate with Snowflake developers to ensure physical data structures support dbt models efficiently. - Work with functional teams to ensure functional equivalence between legacy Informatica outputs and new dbt outputs. - Participate in performance tuning of dbt models and Snowflake queries. - Integrate dbt with CI/CD pipelines (e.g., Azure DevOps, GitHub Actions) for automated runs and validations. - Contribute to documentation of dbt models, data lineage, and business rules. - Participate in defect analysis, bug fixes, and enhancements during migration and stabilization phases. Qualifications - 7+ years of experience in Data Engineering / ETL / DW, with 1–3+ years working with dbt (Core or Cloud). - Strong SQL skills, especially on Snowflake or another modern cloud DW. - Experience with dbt concepts: models, tests, sources, seeds, snapshots, macros, exposures. - Prior experience with Informatica (developer-level understanding of mappings/workflows) is highly desirable. - Understanding of CI/CD practices and integrating dbt into automated pipelines. - Knowledge of data modeling (dimensional models, SCDs, fact/dimension design). - Experience working in offshore delivery with onshore coordination. - Good communication skills and ability to read/understand existing ETL logic and requirements documentation. Company Description NTT DATA is a $30 billion business and technology services leader, serving 75% of the Fortune Global 100. We are committed to accelerating client success and positively impacting society through responsible innovation. - We are one of the world's leading AI and digital infrastructure providers, with unmatched capabilities in enterprise-scale AI, cloud, security, connectivity, data centers, and application services. - Our consulting and Industry solutions help organizations and society move confidently and sustainably into the digital future. - As a Global Top Employer, we have experts in more than 50 countries. - We also offer clients access to a robust ecosystem of innovation centers as well as established and start-up partners. - NTT DATA is a part of NTT Group, which invests over $3 billion each year in R&D.

