Senior BI Data Engineer
Posted 2 days ago · 78 applicants
Saving, applying or scoring takes a few seconds to set up your free account.
The role in plain words
This role involves designing, building, and maintaining production-grade data pipelines and data models in Snowflake. You will own data flows from source systems like Salesforce, model datasets into star schemas, and build governed, AI-ready semantic models. Additionally, you will apply security governance, cost optimization (FinOps), and maintain live data assets end-to-end.
- 5+ years of hands-on experience building production data solutions for SaaS organizations as a Data Engineer, BI Developer, or Analytics Engineer
- Snowflake
- Snowflake objects and capabilities (warehouses, roles, schemas, views, stored procedures, tasks, streams, performance tuning)
- ELT/ETL pipeline building using incremental loads, CDC, backfills, reconciliation, and idempotent processing
- Dimensional modeling and data warehousing (facts, dimensions, star schemas, marts)
- Python for data processing, automation, or testing
- AWS cloud data experience
- Snowpark or Snowpark ML
- BI tools such as Sisense, Tableau, or Power BI
- Data observability, orchestration, CI/CD, or automated testing for data pipelines
Extracted from the job description · kept up to date automatically
Who this suits
This role suits experienced data engineers or BI developers with 5+ years of hands-on experience building production SaaS data solutions on Snowflake and Salesforce. It is less ideal for junior candidates or those without strong dimensional modeling and Snowflake experience.
Full job description
Original listing · kept for referenceWho are we?
Checkmarx is the AI-powered application security leader helping the world’s most security-conscious enterprises secure the software that powers modern life. For more than two decades, our unified platform and services have helped organizations protect human- and AI-generated code from the first line through runtime, reducing risk across applications, cloud, and the software supply chain without slowing innovation.
We’re trusted by 1,600+ customers in 70+ countries, including some of the largest enterprises and governments in the world. Guided by research-led innovation and a developer-first mindset, we help every developer, security team, and enterprise build software that is risk-free by design.
What we are looking for:
Checkmarx is looking for a hands-on BI Data Developer to design, build, and own the pipelines, models, and governed datasets that power analytics, business decisions, and AI use cases in a fast-moving SaaS environment.
You will own foundational data assets end to end, from ingestion and transformation through modeling, validation, delivery, monitoring, security, and cost optimization. This is a production-focused role where engineers own live systems, not only task-level deliverables.
What will you do:
• Build and maintain production-grade Snowflake pipelines using incremental loading, CDC patterns, backfills, reconciliation, and idempotent processing.
• Own data flows from Salesforce and other source systems into Snowflake, including ingestion, transformation, validation, monitoring, and delivery.
• Model data into analytics-ready datasets, dimensional models, facts, dimensions, star schemas, and reusable business entities.
• Develop core Snowflake objects
• Create governed, AI-ready semantic models and curated datasets for Cortex Analyst, Cortex Search, BI tools, and enterprise AI integrations
• Apply Snowflake FinOps practices for cost-aware design.
• Apply security and governance best practices, including RBAC, least privilege, masking policies, row access policies, secure views, auditability, and safe handling of sensitive data.
• Partner with stakeholders to define certified metrics, source-to-target mappings, trusted data contracts, and reusable analytical entities.
Requirements:
• 5+ years of hands-on experience building production data solutions for SaaS organizations on Snowflake as a Data Engineer, BI Developer, Analytics Engineer, or similar role.
• Strong experience with Snowflake objects and capabilities, including warehouses, databases, roles, schemas, views, stored procedures, tasks, streams, and performance tuning.
• Experience building reliable ELT or ETL pipelines using incremental loads, CDC, backfills, reconciliation, and idempotent processing.
• Strong dimensional modeling and data warehousing foundations, including facts, dimensions, star schemas, marts, and reusable business entities.
• Salesforce data experience, including core objects, relationships, API limitations, and Salesforce-to-warehouse pipelines.
• Hands-on experience with Snowflake Cortex capabilities such as Cortex Analyst, Cortex Search, Cortex LLM functions, and governed AI data access patterns.
• Experience building AI-ready semantic models and curated datasets for governed analytics, BI, and enterprise AI use cases.
• Understanding of secure enterprise AI integration patterns, including governed structured data access and MCP-based integrations.
• Strong knowledge of data governance, privacy, security, RBAC, masking policies, row access policies, secure views, and compliance-aware data handling.
• Proven Snowflake FinOps experience, including credit monitoring, warehouse sizing, workload optimization, storage awareness, and query cost reduction.
• Strong system analysis, requirements gathering, source-to-target mapping, lineage, impact analysis, and stakeholder communication skills.
Nice to have
• Python for data processing, automation, testing, or operational tooling.
• AWS cloud data experience.
• Experience with Snowpark or Snowpark ML.
• Experience with BI tools such as Sisense, Tableau, or Power BI.
• Experience with data observability, orchestration, CI/CD, or automated testing for data pipelines.
What we have to offer:
Checkmarx offers a great work environment, professional development, challenging careers, competitive compensation, great work-life balance, as well as great benefits and perks throughout the year.
Checkmarx is an Equal Opportunity Employer. Employment decisions are made without regard to race, color, religion, national or ethnic origin, gender, sexual orientation, gender identity or expression, age, disability, or other characteristics protected by law.
Questions about this role
- This listing did not state a salary. We only show pay when the employer publishes it.
- 5+ years of hands-on experience building production data solutions for SaaS organizations as a Data Engineer, BI Developer, or Analytics Engineer, Snowflake, Snowflake objects and capabilities (warehouses, roles, schemas, views, stored procedures, tasks, streams, performance tuning), ELT/ETL pipeline building using incremental loads, CDC, backfills, reconciliation, and idempotent processing, Dimensional modeling and data warehousing (facts, dimensions, star schemas, marts)