Senior Associate, Analytics Data Engineer

Job Overview Location: 51 Madison Avenue, New York, NY 10010 (Hybrid – 3 days onsite, 2 days remote). Salary Range: $144,400 – $171,500 per year. Responsibilities Design and implement data pipeline architecture and processes, including sourcing, transformation, and extraction to enable seamless analytics integration. Utilize expert-level SQL and Python to manage, query, and transform structured data in relational databases, ensuring performance, scalability, and maintainability. Automate and manage robust data pipelines and workflows using software engineering best practices, including modular design, version control, and testing frameworks to ensure reliability and repeatability. Map data between source systems, data warehouses, and data marts to align with business requirements, ensuring data consistency across analytical workflows. Build and maintain data models that enhance efficiency, performance, and support complex business analytics and reporting needs. Collaborate with analysts, data scientists, and business stakeholders to translate business requirements into actionable, scalable data solutions. Leverage cloud platforms such as AWS, along with big data frameworks like Redshift, to build and scale secure, high‑performance data engineering solutions for large‑scale analytics. Develop and enforce standards for development, testing, and documentation, including data flow maps to support transparency and maintainability. Conduct comprehensive quality assurance processes, including code reviews, test plan development, and rigorous validation to guarantee data accuracy, completeness, and reliability. Provide troubleshooting support for data pipelines and workflows, focusing on system performance, data integrity, and availability to meet evolving business analytics demands. Build strong relationships with IT to work on tooling, data strategy, integrations, and deployments. Stay up to date with the latest analytics engineering trends and emerging technologies, seeking opportunities to improve the stack. Qualifications Education & Experience Master’s degree in Computer Science, Computer Engineering, Business Analytics, or a related field (foreign education accepted) plus 3 years of experience as a Data Analyst or Data Engineer supporting data science and analytics. Or Bachelor’s degree in the same disciplines plus 5 years of experience in a similar data‑engineering role. Required Skills Advanced-level SQL and Python for querying and managing structured data within relational database systems (RDBMS). Designing and implementing data models to enhance efficiency, performance, and fulfill business analytics requirements. Automating and orchestrating SQL workflows using established software engineering best practices, including CI/CD and version control. Developing standards and practices for data and analytics engineering, focusing on scalable architectural data pipeline patterns. Utilizing big data platforms such as Redshift for efficient large‑scale data processing and analysis. Building and deploying scalable data engineering solutions in cloud environments, including AWS using cloud‑native tools and services. Conducting comprehensive quality assurance processes, including code reviews, test plan development, and rigorous validation to ensure data accuracy. Benefits & Additional Details Hybrid work arrangement: 3 days onsite, 2 days remote. Eligible for Employee Referral Program. Overtime eligible: Exempt. Discretionary annual bonus eligibility. #J-18808-Ljbffr New York Life