Description:

We are seeking a skilled Snowflake Data Architect to assist with integrating and managing data from various platforms including CRMs, multiple advertising platforms, and organic social platforms.
The ideal candidate will have extensive experience in primarily connecting these platforms to Snowflake using APIs through Databricks, with some capability in API development as needed.
Key responsibilities include establishing connections to CRMs, advertising platforms, and social media platforms using existing APIs through Databricks.
The candidate will develop APIs when necessary to meet specific data integration and transformation needs.
The role involves managing the ETL process to ensure accurate data extraction, transformation, and loading into Snowflake.
The candidate will perform data transformation and cleanup to ensure data quality and usability.
Implementing strategies to efficiently push data from Snowflake to Power BI for analytics and reporting is also a key responsibility.
The candidate will work collaboratively with cross-functional teams to support data integration and business intelligence solutions.

Requirements:

Proven experience as a Data Architect, with a focus on Snowflake is required.
Experience with BI tools such as Tableau and Power BI is necessary.
The candidate must have experience in API development and connecting to APIs, specifically using Databricks.
Knowledge of programming languages such as Python or Java is essential.
Familiarity with data integration tools like Talend, Apache Nifi, or similar is required.
Experience with cloud platforms such as AWS, Azure, or GCP is a plus.
Excellent problem-solving and analytical skills are necessary for this position.
Strong communication skills and the ability to work collaboratively in a team environment are essential.