Data Analyst | SQL, Python, Cloud ETL tools

We are looking to fill a new Data Analyst role with our direct health insurer client in NYC. This is a remote spot for now, however would ne...

We are looking to fill a new Data Analyst role with our direct health insurer client in NYC. This is a remote spot for now, however would need to be local to NYC once pandemic is over. Candidate should be focused on optimizing and building our marketing data infrastructure working alongside a wide variety of data, product and business teams. This person will work closely with marketing management, data science, data visualization, and analytics teams to support them by building data sets and data pipelines using multiple data tools, who would consume this data for producing business-driven insights, data solutions and campaigns.
The right candidate will have strong experience with data infrastructure, data architecture, ETL, SQL, automation, data frameworks, and processes to rapidly integrate disconnected and disparate data sources into automated datasets for analytics consumption. The candidate will also have a proven track record working with enterprise metrics, strong operational skills to drive efficiency and speed, expertise building repeatable data engineering processes, strong project management skills, and a vision for how to deliver data products.*Experience with marketing data sets is a huge plus.

Responsibilities:

• Work closely with Marketing and /business analysts to understand business requirements.
• Write sophisticated yet optimized data transformations in SQL/Python
• Design and Implement of data pipelines, both batch and real-time, that produces reliable data for various data consumption use cases.
• Help manage Marketing data platforms which include the Segment, Amazon Web services, and traditional data-warehouses.
• Manage all aspects of dataset design, creation, and curation; including the frameworks to derive metrics to deliver data products for KPI's, visualization, data science, analyst and stakeholder teams
• Build and own the automation and monitoring frameworks that showcase reliable, accurate, easy-to-understand metrics and operational KPIs to stakeholders for data pipeline quality and performance.
• Drive design, building, and launching of new data models and data pipelines in production systems
• Be the subject matter expert for data, pipeline design, and other related big data and programming technologies.
• Proactively identify reliability & data quality problems and drive triaging and remediation process
• Partner with data producers in understanding data sources, enable data contracts, and define the data model that drives analytics
• Partner with Analysts and Data Scientists on delivering reliable data that powers actionable insights
• Understanding data governance practices such as metadata management, data lineage, and data glossaries a huge plus.
• Foster strong collaboration between globally distributed team members
• Harness operational excellence & continuous improvement with a can-do attitude.

Job Requirements