Note: The job is a remote job and is open to candidates in USA. Aneka Talent Solutions is recruiting for a client seeking a Data Warehouse Engineer to develop, administer, and support Snowflake-based data warehousing solutions. The role builds data models and transformations, optimizes performance, supports reporting and platform operations, and applies security and governance standards.
Responsibilities
- Build enterprise level Snowflake models including conformed dimensions, fact tables, and semantic views
- Document ERDs, modeling assumptions, and physical/logical architectures
- Adhere to established data modeling standards, naming conventions, and performance optimization best practices
- Develop, test, and support SQL transformations across Snowflake data warehouse layers using Snowflake SQL and dbt
- Develop and maintain dbt models and tests that support Informatica data pipelines, ensuring data quality, reliability, and successful deployment to Snowflake environments
- Implement and support Snowflake Tasks, Streams, stored procedures, and scheduled workflows
- Perform unit testing, integration testing, and validation of Snowflake objects and dbt deployments prior to production release
- Support schema changes, data integration activities, and production issue resolution in accordance with established standards
- Participate in Snowflake schema and object deployments using established Git version control processes
- Perform testing and validation of models, views, stored procedures, and security changes prior to deployment
- Maintain source control, versioning, and change documentation for Snowflake database objects using Git
- Implement and maintain Snowflake security configurations, including role-based access controls (RBAC), object permissions, row-level security, and masking policies
- Support audit activities, compliance reviews, and evidence collection as directed by Director of Data Engineering
- Work with Data Engineers to coordinate ingestion design, transformation logic, and schema updates
- Partner with BI teams to optimize datasets for Power BI, Qlik, and analytical tools
- Align with Platform Administrators on environment setup, migrations, and operational readiness
- Collaborate with Platform Administrators and the vendor to ensure reporting platform uptime and timely escalation of reporting issues
- Work with Data Governance teams to apply and validate data quality standards, data classifications, masking policies, and other governance requirements within Snowflake
Skills
- Snowflake SQL: 5+ years of advanced SQL development experience, including complex query optimization, data modeling, performance tuning, and ETL/ELT development within Snowflake environments
- Snowflake Administration: 3+ years of hands-on experience administering Snowflake platforms, including security, role-based access control (RBAC), warehouse management, monitoring, performance optimization, and cost governance
- Dbt (Data Build Tool): 4+ years of experience designing, developing, and maintaining scalable data transformation frameworks using dbt, including testing, documentation, and CI/CD integration
- Git / Version Control: 5+ years of experience using Git-based source control systems (GitHub, GitLab, or Bitbucket) for collaborative development, branching strategies, code reviews, and release management
- CI/CD Pipelines & Deployment Automation: 5+ years of experience implementing and supporting CI/CD pipelines for data warehouse and analytics deployments, including automated testing, code promotion, release management, and deployment automation using Azure DevOps, GitHub Actions, GitLab CI/CD, or equivalent platforms
- Financial services experience: Preferred
- Business Objects (SAP BO/Web Intelligence): Preferred
- Informatica IDMC : Preferred
Company Overview