The Snowflake Data Architect will design and implement data management solutions, lead migrations to Snowflake, and mentor team members while ensuring data quality, security, and best practices.
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
- Apply or recommend best practices in architecture, coding, API integration, CI/CD pipelines
- 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
- 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
Additional Experience Desired:
Top Skills
AI
Apache Nifi
AWS
ETL
Fivetran
Gcp Data Services
Informatica
Matillion
Ml
NoSQL
Power BI
Snowflake
SQL
Tableau
Talend
Similar Jobs
Cloud • Information Technology • Productivity • Security • Software • App development • Automation
As a Senior Data Scientist, you will leverage data science and AI to identify customer friction, build machine learning models, and enhance product quality.
Top Skills:
LlmNlpNumpyPandasPythonRR-ShinyScikit-LearnSQLStreamlitTableau
Cloud • Information Technology • Productivity • Security • Software • App development • Automation
Collaborate to build scalable data models and applications, design ETL processes, ensure data quality, mentor junior engineers, and implement governance procedures.
Top Skills:
AirflowSparkBitbucketDatabricksDynamo DbGitMongo DbPostgresPythonRedshiftScalaSQL
Fintech • Professional Services • Consulting • Energy • Financial Services • Cybersecurity • Generative AI
The Senior Data Analyst will define and source data, manage data migration sets, ensure data quality, and communicate with stakeholders, leveraging 4+ years of experience in financial services and expertise in Python and Pyspark.
Top Skills:
Python,Pyspark,Sql,Hive
What you need to know about the Pune Tech Scene
Once a far-out concept, AI is now a tangible force reshaping industries and economies worldwide. While its adoption will automate some roles, AI has created more jobs than it has displaced, with an expected 97 million new roles to be created in the coming years. This is especially true in cities like Pune, which is emerging as a hub for companies eager to leverage this technology to develop solutions that simplify and improve lives in sectors such as education, healthcare, finance, e-commerce and more.
