Data Architect- Snowflake

Embark on an exciting journey into the realm of data analytics with 3Pillar We extend an invitation for you to join our team and gear up for a thrilling adventure. As a Snowflake Data Architect you will be at the heart of the organization and support our clients to take control of their data and get value out of it by defining a reference architecture for our customers. This means that you will work closely with business leaders and information management teams to define and implement a roadmap on data management, business intelligence or analytics solutions..

If your passion for data analytics solutions that make a real-world impact, consider this your pass to the captivating world of Data Science and Engineering

**Relevant Experience**: 10+ years in Data Practice

**Must have Skills**: Snowflake, Data Architecture, Engineering, Governance, and Cloud services

**Responsibilities**:

- Assessments of existing data components, Performing POCs, Consulting to the stakeholders
- Lead the migration to Snowflake
- In a strong client-facing role, proposing, advocating, leading implementation of end to end solutions to an enterprise's data specific business problems, and taking care of data collection, extraction, integration, cleansing, enriching and data visualization.
- Ability to design large data platforms to enable Data Engineers, Analysts & scientists
- Strong exposure to different Data architectures, data lake & data warehouse, including migrations, rearchitect and platform modernization
- Define tools & technologies to develop automated data pipelines, write ETL processes, develop dashboard & report and create insights
- Continually reassess current state for alignment with architecture goals, best practices and business needs
- DB modeling, deciding best data storage, creating data flow diagrams, maintaining related documentation
- Taking care of performance, reliability, reusability, resilience, scalability, security, privacy & data governance while designing a data architecture
- Coordinate with data scientists, analysts, and other stakeholders for data-related needs
- Help the Data Science & Analytics Practice grow by mentoring junior Practice members, leading initiatives, leading Data Practice Offerings
- Provide thought leadership by representing the Practice / Organization on internal / external platforms

**Qualification**:

- Translate business requirements into data requests, reports and dashboards.
- Strong Database & modeling concepts with exposure to SQL & NoSQL Databases
- Strong data architecture patterns & principles, ability to design secure & scalable data lakes, data warehouse, data hubs, and other event-driven architectures
- Expertise in designing and writing ETL processes.
- Strong experience to Snowflake, and its components.
- Knowledge of Master Data management and related tools
- Strong exposure to data security and privacy regulations (GDPR, HIPAA) and best practices
- Skilled in ensuring data accuracy, consistency, and quality
- Experience of AWS services viz., AWS S3, Redshift, Lambda, DynamoDB, EMR, Glue, Lake formation, Athena, Quicksight, RDS, Kinesis, Managed Kafka, API Gateway, CloudWatch
- AWS S3, Redshift, Lambda, DynamoDB, EMR, Glue, Lake formation, Athena, Quicksight, RDS, Kinesis, Managed Kafka, Elasticsearch and Elastic Cache, API Gateway, CloudWatch
- Ability to implement data validation processes and establish data quality standards.
- Experience in Linux, and scripting
- Proficiency in data visualization tools like Tableau, Power BI or similar to create meaningful insights

**Additional Experience Desired**:

- Experience working with data ingestion tools such as Fivetran, stitch, or Matillion
- AWS IOT solutions
- Apache NiFi, Talend, Informatica
- Knowledge of GCP Data services
- Exposure to AI / ML technologies