30 Jul
|
LanceSoft
|
Telangana
30 Jul
LanceSoft
Telangana
Role & responsibilities
We are seeking a highly experienced Admin Operations Lead with expertise in Snowflake, AWS data services (EMR, Glue), ETL processes, Database administration, SQL, and Power BI reporting. The role involves managing and optimizing data platforms, cloud infrastructure, and analytics environments, ensuring high availability, performance, security, and governance.
Platform & Infrastructure Management
Administer and manage Snowflake data warehouse environments
Monitor and optimize AWS services (EMR, Glue, S3, EC2, Lambda)
Ensure high availability, scalability, and performance tuning
Manage resource provisioning, usage monitoring, and cost optimization
ETL & Data Pipeline Operations
Oversee ETL processes using tools like Informatica / Glue / other ETL tools
Monitor and troubleshoot data pipelines and batch jobs
Ensure data reliability, integrity, and timeliness
Implement data orchestration and workflow automation
Database Administration & SQL
Manage databases (Snowflake, RDS, Redshift, or relational DBs)
Write and optimize complex SQL queries
Perform database tuning, indexing, and partitioning
Ensure backup, recovery, and disaster recovery strategies
AWS Data Ecosystem Management
Manage and optimize:
AWS EMR clusters
AWS Glue jobs and crawlers
Data lakes in S3
Implement best practices for:
Security (IAM roles/policies)
Cost efficiency
Performance optimization
Power BI Reporting & Analytics
Develop and maintain Power BI dashboards and reports
Optimize data models and DAX queries
Work with business stakeholders to deliver actionable insights
Ensure data accuracy and visualization best practices
Monitoring, Security & Governance
Implement monitoring via CloudWatch / Snowflake monitoring tools
Ensure data security, compliance, and governance standards
Manage access control, roles, and permissions
Maintain audit logs and compliance requirements
Team Leadership & Stakeholder Collaboration
Mentor and lead a team of Data Engineers / Admins
Work closely with Data Scientists, BI teams, and Business stakeholders
Coordinate with DevOps and cloud teams
Required Skills
Core Technical Skills
Strong experience in Snowflake Administration
Hands-on expertise in AWS (EMR, Glue, S3, EC2)
Deep knowledge of ETL/ELT processes and tools
Solid SQL skills (advanced querying, optimization)
Experience in database administration and performance tuning
Analytics & Reporting
Strong experience in Power BI (Dashboard development, DAX, Data modeling)
Understanding of data visualization best practices
Cloud & DevOps Knowledge
Familiarity with:
CI/CD pipelines
Infrastructure as Code (Terraform/CloudFormation preferred)
Monitoring & logging tools
Preferred / Good-to-Have Skills
Experience with Big Data technologies (Hadoop, Spark)
Knowledge of Python / scripting for automation
Exposure to data governance tools (Collibra, Alation)
Experience with multi-cloud environments (Azure/GCP)
Understanding of data warehousing concepts (Kimball/Inmon)
📌 Snowflake Administrator (Telangana)
🏢 LanceSoft
📍 Telangana