Full-time/Permanent role; No third party resumes please.
Hybrid - 3 days/week onsite in NYC.
We are looking for a Sr. Data Engineer who can build a high-performing cloud data platform to meet our analytical and BI reporting needs. This role will work as a key member of a data management team to drive development, delivery, and continuous improvement of the enterprise data warehouse architecture in support of our cloud data strategy.
REQUIREMENTS:
Experience in building large cloud data warehouses using Snowflake; including database architecture design, data transformations, stored procedures, account and security principles, performance management, etc.
Experience in data modeling tools (e.g. Erwin, ER/Studio, etc.) and data modeling methodologies such as data vault and dimensional data models.
5+ years of strong technical experience in building scalable data pipelines to integrate structured and unstructured data in both cloud and on-premise environments.
8+ years of overall experience in data warehousing, advanced database design, SQL, stored procedures, views, performance tuning and optimization, database indexing techniques, and database maintenance.
Understanding of data security and cloud security methodologies, and experience in configuration and management of data security to meet compliance and IT security requirements.
Experience using Airflow or similar tools for developing scheduling and monitoring batch-oriented workflows.
Working knowledge of Microsoft Power BI and Tableau.
Experience with SDLC processes, agile development, and source code repositories (e.g. Git or Bitbucket).
Experience in AWS services, related data and storage services is a plus.
Working knowledge of Salesforce or other CRM systems is a plus.
Understanding of micro services architecture and methodology is a plus.
Excellent communication, organization, and problem-solving skills.