Title: Senior Data Engineer / Analyst Client: NYC Agency Location: Brooklyn, NY (Remote an option with onsite visits for critical meetings as needed) Duration: 10 Months Work Hours: 35 Hours/ week MANDATORY SKILLS/EXPERIENCE
- 12+ years of experience as an Analytics Developer, Data Engineer, or similar role, with a focus on developing reports, dashboards, and data models.
- Strong experience designing and implementing data models and schemas in Snowflake.
- Define Snowflake databases objects to support efficient data storage and retrieval.
- Expertise with data visualization tools such as Power BI, Looker, Tableau, or similar.
- Proficiency in SQL and experience with relational databases (e.g., MySQL, PostgreSQL, Oracle).
- Proficiency in data modeling concepts and techniques (e.g., dimensional modeling, star schema).
- Solid understanding of data engineering principles and experience with data integration and ETL processes.
- Familiarity with cloud platforms, preferably Azure, and experience with integration tools like IICS (Informatica Intelligent Cloud Services).
- Excellent problem-solving skills and attention to detail.
- Strong communication and collaboration skills to work effectively in cross-functional teams.
DESIRABLE SKILLS/EXPERIENCE:
- Proficiency in programming languages such as Python, R, or Java.
- Familiarity with big data technologies (e.g., Hadoop, Spark) is a plus.
- Experience with data integration tools such as Informatica Intelligent Cloud Services and MuleSoft.
- Experience using Azure services for Security, Blob Storage, Data Lake, Databricks, Data Factory etc.
- Experience with Azure Monitoring services
- MS Certified Azure Solutions Architect Expert or a Snowpro Certification or a similar one