Snowflake & DBT Data Engineer
About the role
We are looking for a Data Engineer with strong hands-on experience in Snowflake and DBT to manage and optimize our data platform, supporting analytical and business operations within the asset management area.
Responsibilities
- Manage Snowflake data platform environments to ensure high availability, predictable performance, and secure access for analytical and operational workloads across the organization.
- Perform DBT testing on Snowflake.
- Configure and optimize Snowflake Tasks to orchestrate complex data pipelines, automate recurring jobs, and maintain reliable scheduling and monitoring for critical data processes.
- Administer Snowflake account-level settings, including roles, policies, resource allocation, and usage monitoring, to support cost-effective and compliant data operations.
- Develop and maintain DBT Core projects that implement robust transformation logic, enforce data quality checks, and standardize modeling patterns for shared enterprise datasets.
- Create and refine DBT macros that encapsulate reusable transformation logic, streamline project implementation, and promote consistent coding practices across multiple data teams.
- Oversee DBT Cloud deployments by managing environments, jobs, and run configurations, ensuring smooth execution of production and non-production data workflows.
- Collaborate with data engineers and analysts to translate business requirements into efficient Snowflake schemas and DBT models that enable accurate reporting and advanced analytics.
- Monitor data pipeline health using platform logs and metrics, proactively troubleshoot issues, and implement remediation steps that minimize disruption to downstream consumers.
- Implement robust data security and governance controls within Snowflake, including role-based access patterns, masking policies, and audited data sharing to protect sensitive information.
- Coordinate with infrastructure and application teams to integrate Snowflake and DBT with enterprise tools such as version control, monitoring platforms, and catalog solutions, supporting hybrid work arrangements.
- Document platform configurations, operational runbooks, and data workflow standards in clear technical references that enable consistent administration and easier onboarding for new team members.
- Drive continuous improvement by analyzing platform utilization trends, recommending optimization strategies, and implementing changes that enhance performance and reduce operational overhead.
- Support asset management operations stakeholders by maintaining reliable data platforms that provide timely, accurate, and well-curated information for portfolio analysis and regulatory reporting.
Qualifications
- Deep experience with Snowflake administration, managing roles, warehouses, databases, and performance tuning to support complex analytical and operational workloads.
- Strong practical knowledge of Snowflake Tasks to design dependable schedules, handle dependencies, and integrate tasks with broader orchestration practices.
- Advanced proficiency in DBT Core, including project structure, model configuration, tests, and documentation, to build maintainable transformation layers.
- Skilled use of DBT macros to define reusable logic, parameterized transformations, and standardized patterns that reduce duplication and improve code consistency.
- Effective use of DBT Cloud, managing jobs, environments, execution policies, and collaboration features that support team-based development and deployment.
- Understanding of asset management operations processes, such as trade lifecycle, positions, valuations, and reporting, to shape data models aligned with domain needs.
- At least 8 years of data engineering or data platform experience, handling complex environments, coordinating with cross-functional teams, and resolving intricate operational issues.
- Ability to adapt to hybrid work arrangements, communicating clearly and maintaining reliable coordination across onsite and remote team members.
Key technical areas
- DBT: Models, macros, custom materialization; migration from other ETL tools to DBT.
- Snowflake: Fundamentals (tables, views, dynamic tables) and architecture; Streams, Tasks, Procedures; database change management; performance improvement.
- Other: Strong SQL, Python, GitHub.
- Nice to have: IDMC, PowerCenter, Teradata.
Languages
- English: fluent communication required.
- Spanish: B2
コグニザントについて
コグニザント（NASDAQ: CTSH）は、AI Builderおよびテクノロジーサービスプロバイダーとして、お客様にフルスタックのAIソリューションを構築することで、AI投資と企業価値を結ぶ架け橋となっています。業界、ビジネスプロセス、エンジニアリングに関する当社の深い専門知識を活かし、組織固有のビジネス環境をテクノロジー・システムに組み込みます。これにより、人間の可能性を最大限に引き出し、確かな成果を実現するとともに、急速に変化する世界においてグローバル企業が常に一歩先を行くための支援を行っています。 詳細については、cognizant.ai をご覧ください。
雇用に関する追加情報
本募集に記載されている報酬情報は、掲載日時点で正確なものです。Cognizantは、適用される法令に従い、いつでも本情報を変更する権利を留保します。
応募者は、対面またはビデオ会議による面接への参加を求められる場合があります。また、各面接の際に、現在有効な州政府または政府発行の身分証明書の提示を求められる場合があります。
Cognizantは機会均等雇用主です。応募および選考において、人種、肌の色、性別、宗教、信条、性的指向、性自認、国籍、障がい、遺伝情報、妊娠、退役軍人の地位、その他連邦法・州法・地方自治体の法律により保護されるいかなる特性に基づく差別も行いません。
