Senior Associate, Analytics Data Engineer

Job Requisition ID: 93907 Location: 51 Madison Avenue, New York, New York 10010 • Designation: Fully Onsite Salary Range: $144,400.00 - $171,500.00/year Pay Transparency: Overtime eligible: Exempt 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. Automate and manage robust data pipelines and workflows using software engineering best practices including modular design, version control, and testing frameworks. Map data between source systems, data warehouses, and data marts in alignment with business requirements. 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 including 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 ensure 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, and look for opportunities to improve the stack. Education & Experience Requirements Master's degree in Computer Science, Computer Engineering, Business Analytics or related field (foreign education accepted) plus 3 years of experience as a Data Analyst or Data Engineer supporting data science and analytics. Alternatively, Bachelor's degree in Computer Science, Computer Engineering, Business Analytics or related field (foreign education accepted) plus 5 years of experience as a Data Analyst or Data Engineer supporting data science and analytics. Specific skills: advanced-level SQL and Python for querying structured data; designing and implementing data models; automating and orchestrating SQL workflows using CI/CD and version control; developing scalable architectural data pipeline patterns; utilizing big data platforms (Redshift) and cloud environments (AWS); conducting comprehensive QA processes. Additional Information Hybrid – 3 days in office, 2 days remote. Eligible for Employee Referral Program. Benefits We provide a full package of benefits for employees, including leave programs, adoption assistance, and student loan repayment programs. Additional benefits are available on the company benefits site. #J-18808-Ljbffr New York Life