Senior Data Analyst
New York, New YorkOperations /Full-Time /On-Site
APPLY FOR THIS JOB
About the Company
Born from groundbreaking research at Columbia University and Yale University, CertiK is a leading Web3 security company focused on securing blockchain protocols, smart contracts, and decentralized applications through cutting-edge security research, formal verification, and AI-powered technology. Founded in 2017 and headquartered in New York City, CertiK provides end-to-end security solutions including smart contract audits, penetration testing, on-chain monitoring, incident response, and compliance services for some of the largest projects in the digital asset ecosystem.
Today, CertiK supports thousands of enterprise clients and Web3 projects globally, with a distributed international team spanning North America, Asia, and Europe. The company is backed by leading investors including Coatue, Goldman Sachs, Insight Partners, and Sequoia Capital, and has been recognized by organizations such as the World Economic Forum and CB Insights for its contributions to blockchain security innovation.
About the Role
The primary responsibility of this role is to build/maintain ETL pipelines & process large datasets from APIs/databases/third-party platforms to enable real-time team analytics and automate data preprocessing (cleaning/normalization/validation) for client accounts using rule-based logic/statistical checks to ensure data quality & prepare analysis-ready datasets for modeling/reporting.
Responsibilities
Develop data models to extract/classify/summarize metadata from unstructured documents to forecast market dynamics & support data-driven strategy.
Design interactive Tableau dashboards to visualize KPIs/trends/progress & interpret key patterns to support data-driven decisions for stakeholders.
Conduct data analysis on large datasets & apply segmentation/clustering/regression/EDA to support client management/market intelligence/pricing strategies.
Collaborate with business/product/finance/engineering teams to translate business challenges into data projects (e.g., churn prediction, sales funnel analysis) & provide growth/retention recommendations to leadership.
Requirements
Master of Science in Data Science, Business Analytics, or a related field
Minimum 1-year work experience in large-scale data processing/quality management/predictive modeling & working with cloud-based data platforms (Databricks, AWS)/Agile environments using project management tools like Jira/Confluence
Expertise in designing interactive dashboards with Tableau
Familiar with Scikit-learn/XGBoost/LightGBM/NLP
Proficient in Python, SQL (PostgreSQL/MySQL/NoSQL) & ETL tools (Apache Airflow)
Target annual salary compensation for this role performed is $110,000 to $125,000. The exact compensation at which this job is filled will be determined by the skills and experience of qualified candidates.
CertiK is proud to offer medical, vision, and dental insurance, 401(k) plan with company matching, life and accidental death and dismemberment insurance, HSA (with high deductible plan), FSA, and other benefits to all full-time employees, along with flexible paid time off and holidays. CertiK also offers a variable commission program for business development sales roles.
In compliance with federal law, all persons hired will be required to verify identity and eligibility to work in the United States and to complete the required employment eligibility verification form upon hire.
CertiK is proud to be an equal opportunity employer. We will not discriminate against any applicant or employee on the basis of age, race, color, creed, religion, sex, sexual orientation, gender, gender identity or expression, medical condition, national origin, ancestry, citizenship, marital status or civil partnership/union status, physical or mental disability, pregnancy, childbirth, genetic information, military and veteran status, or any other basis prohibited by applicable federal, state or local law.
CertiK will consider for employment qualified applicants with criminal histories in a manner consistent with local and federal requirements.
https://www.eeoc.gov/sites/default/files/migrated_files/employers/poster_screen_reader_optimized.pdf
All CertiK employees are expected to actively support diversity on their teams, and in the Company.
We may use artificial intelligence (AI) tools to support parts of the hiring process, such as reviewing applications, analyzing resumes, or assessing responses and identifying potential inconsistencies or verification signals in application materials based on available information. These tools assist our recruitment team but do not replace human judgment. Final hiring decisions are ultimately made by humans. If you would like more information about how your data is processed, please contact us.
APPLY FOR THIS JOB
CertiK Home Page
Jobs powered by
Listed by CertiK for a position based in the United States. Employers on this board attest they are hiring domestically.
THE 4 BIGGEST BLOCKCHAIN STRENGTHS ARE ALSO ITS WEAKNESS
- Permissionless nature leads to fragmentation of meaning
- Decentralization leads to too many standards https://xkcd.com/927/
- Immutability leads to exponential data + query infrastructure complexity
- Neutrality means that no one is accountable for interpretations
Blockchain data is public. It is not usable at institutional scale. Despite being open, blockchain data is fragmented, hard to interpret, and painful to maintain. Even a simple question like “Who are the largest Ethereum token holders over time?” can require running nodes, ingesting full chain history, decoding contracts, cleaning edge cases, and writing complex SQL.
BLOCKCHAINS ARE OPTIMIZED FOR WRITES, NOT READS.
They are built for consensus and execution, not searchability, standardization, or financial interpretation. Blockchains are computers, not databases https://x.com/Tim_Roughgarden/status/1512847113599729668. Every protocol defines its own schema. The same economic action can be encoded in dozens of different ways. The result:
- Fragmented standards
- Exponential complexity
- No accountability for interpretation
- Events without economic meaning
Finance cannot operate on that, it needs an effective system of record.
ALLIUM IS BUILDING THE SYSTEM OF RECORD FOR ONCHAIN FINANCE
Allium ingests, verifies, and standardizes data across 140+ blockchains and 30+ petabytes of history. We close four structural gaps that prevent blockchains from becoming systems of record:
- Semantic Gap: Translating raw events into financial concepts like payments, trades, deposits, and staking income
- Standardization Gap: Mapping thousands of protocols into a single canonical cross chain schema
- Infrastructure Gap: Read optimized, globally distributed data at web scale
- Accountability Gap: Auditable methodology, SLAs, and SOC 1 and 2 compliance
The result is a neutral, canonical data layer institutions can build on with confidence.
FINANCE IS MOVING ONCHAIN
Stablecoins, tokenized assets, trading, staking, and lending are growing rapidly. Institutions need a trusted source of truth for onchain financial activity, just as they rely on Bloomberg or DTCC in traditional markets. Raw blockchains cannot serve that role.
As AI agents begin transacting autonomously https://x.com/AlliumLabs/status/2019810793324482901?s=20, the requirement becomes even stricter. Agents cannot reason over raw event logs. They need structured data, attribution, condition checks, and auditability.
Allium is the read layer that makes onchain finance usable for humans and machines.
WHO WE SERVE
Allium powers three core personas with the same canonical data foundation:
1. Finance, Accounting, and Risk Teams They need reliable, audit grade answers. They rely on Allium for financial reporting, reconciliation, compliance, risk monitoring, and defensible metrics that can stand up to auditors and regulators.
2. Engineers and Product Teams They need low latency, production ready infrastructure. They use Allium to power wallets, trading systems, payment rails, staking infrastructure, and real time applications that cannot break.
3. Strategy, Research, and Executive Teams They need clarity and insight. They use Allium to understand ecosystem economics, market structure, user behavior, competitive dynamics, and where capital is flowing onchain.
And of course...agents 🦞. Our customers and users include Visa, Stripe, G-SIB Banks, Big 4 Accounting firms, BCG, Coinbase, Phantom, Uniswap and cited by the Federal Reserve.
What You’ll Learn
- How petabyte-scale data infrastructure works - Allium manages 5+ petabytes across every combination of cloud provider x data warehouse (Snowflake, BigQuery, Databricks...) x region. You'll pick up how these systems are designed, where they break, and how to reason about freshness, cost, and correctness tradeoffs between them.
- How to build AI-native support - Tickets that feed runbooks; runbooks that support agentic skills; an agentic loop that builds on itself and compounds - You will learn how to build an AI-native support system that scales.
- How to manage expectations with institutional customers (banks, asset managers, exchanges, foundations) - What incident management best practices look like in production, how to communicate during a data incident, how to set an SLA you can actually keep, and how to thread the needle when two customers' expectations conflict.
- How 100+ blockchains work under the hood - Resolving a ticket often means tracing a number back to raw on-chain data - why a stablecoin supply figure differs between two sources, why a balance snapshot lags, what a reorg does to a table. You'll build genuine depth in EVM, Solana, and the long tail of chains.
- How enterprise data delivery works end to end - warehouse-native shares, APIs, Kafka streams, push vs pull. You'll learn to pick the right mechanism for a customer's problem, because half of support is knowing where in the product the answer already lives.
- How to run a data quality investigation - verification checks, cross-source reconciliation, and separating "the data is wrong" from "the query is wrong" from "the chain did something unusual."
- A path into becoming an Allium Data Wizard https://jobs.ashbyhq.com/allium/6ad02951-721e-48a6-8a95-95a9139393a9, if that's where you want to go. Every Wizard at Allium started on the frontlines; we believe staying close to customers and their use cases is how you learn the data best. This role builds exactly those skills: tracing numbers back to raw on-chain data, debugging SQL at scale, learning protocol mechanics.
What You’ll Do
- Troubleshoot and resolve complex customer issues involving SQL queries, data pipelines, API integrations and other Allium Integrations (e.g. kafka)
- Mapping customer issues to where the solution exists in Allium. Be it a table in the dataset, another delivery mechanism, relevant documentation, another integration pattern (e.g. push vs pull)
- Help customers diagnose problems in their data sources (Snowflake, BigQuery, Postgres, etc.) and optimize performance.
- Collaborate with engineering to investigate bugs, identify patterns, and ship fixes.
- Develop internal tools and scripts to automate troubleshooting and improve customer response times.
- Write clear documentation and knowledge base articles for customers and internal teams.
- Partner with the GTM and product teams to translate customer pain points into actionable insights.
- Participate in daily syncs to discuss ongoing issues, progress, and improvements.
- Synthesize all of the above into an AI-native system that builds leverage.
- Triage and prioritize incoming issues against customer SLAs — distinguishing a P1 data incident for an institutional customer from a routine query question, and sequencing your work so the highest-impact problems get resolved first.
What You’ll Bring
- Fluency in AI tools, common failure modes and modern practices.
- Fluency in SQL - you can confidently write, optimize, and debug complex queries.
- Experience providing technical support for a SaaS or data product.
- A working knowledge of blockchain data primitives across ecosystems like Solana and EVM chains.
- Familiarity with APIs, data connectors, and ETL tools.
- Comfort with scripting or automation in Python, Bash, or similar languages.
- Strong understanding of Linux environments and command-line tools.
- Excellent communication and documentation skills — you can explain complex concepts simply.
- A proactive, empathetic approach to customer relationships.
- The ability to work independently and take full ownership of issues from report to resolution.
Bonus Points
- Experience with data warehouses (Snowflake, BigQuery, Redshift) or BI tools.
- Exposure to infrastructure-as-code tools (Terraform, Ansible, etc.).
- Experience in debugging API or integration issues across cloud environments.
- Familiarity with data modeling or transformation frameworks (dbt, Airbyte, etc.).
- Experience with message queues and event buses (Google Pubsub, Kafka etc)
DON'T TAKE OUR WORD FOR IT, WHAT OUR CUSTOMERS SAY ABOUT US (HTTPS://WWW.ALLIUM.SO/BLOG#LOVE) https://www.allium.so/blog#love
[https://app.ashbyhq.com/api/images/user-content/2f62de56-0dd0-4792-90f8-069c5cb51068/585a3023-4036-4ec0-af76-ed3198f80890/image.png]
WHAT SOME COOL PEOPLE HAVE TO SAY ABOUT US:
- The Information's Top 50 Startups (https://www.allium.so/post/allium-named-to-the-informations-50-most-promising-startups-of-2025)
- Mario Gabriele from The Generalist's Future 50 Startup List: https://www.allium.so/post/allium-named-awardee-of-the-generalists-inaugural-future-50-startups
- Tomasz Tungus from Theory Ventures: https://tomtunguz.com/allium/
- Bucky Moore from Kleiner Perkins: https://www.kleinerperkins.com/perspectives/allium-series-a/
OK, NOW FOR SOME TOUGH LOVE. HERE ARE THE VALUES WE STRIVE FOR AT ALLIUM:
- Obsessiveness - The best people at Allium cannot put a problem down once they pick it up. We care more about the work than is strictly rational. Institutions trust us because our data is right. Right means caring about the small things. The decoded contract that ships with one wrong field. The label that is 99% accurate but wrong on the address that matters. The query that runs in 4 seconds when it should run in 400 milliseconds. Most companies tolerate these. We do not.
Obsessiveness shows up as depth of care. It is not measured in hours worked or visible effort. You should feel something physical when work ships half-right. That instinct is what we hire for.
- Pro Athlete Mindset - Consistency. Day in and day out, in pursuit of excellence. A win yesterday does not guarantee (or even imply!) a win tomorrow. I hope anyone who supports a failing sports team will feel the pain (cough Man United fans) of inconsistency
- Figure It Out & Extreme Ownership - Every day is unexplored territory. There are new engineering frameworks, new legal docs, new compliance, new sales, new regulations, and new operational procedures every single day. If you don’t know it, learn it. If you can’t learn it, find someone or a product that does it. If you can’t find someone, find someone who can find someone. It is never a lack of resources, but lack of resourcefulness.
- High Agency - (One of) the highest commonalities between all successful people is their responsiveness. Most successful billionaire CEOs still reply to emails within minutes (within working hours). And when you reply, respond fast with effective solutions - and even better, resolutions. If you’re looking for a superpower, you can’t go wrong with responsiveness. Well of course this doesn't make sense when you're an engineer coding in flow, but in general high agency of problem solving gets one very far in life
- Leading from the Front - No one is going to listen (and adopt) your suggestion unless you lead by example. It’s one thing to say We need to do XYZ this better & it’s another thing to build an MVP and say “This is the way we should do things”. The proof of work and momentum goes a long way.
- Strong Opinions On the Future (loosely held) - It is okay to be wrong, but what is not okay is not to have an idea of how a better future should be. Alliumites take pride in trying to improving everything about the company all the time.
- Sense of (Allium) business smell - There are number of folks who live to eat at Allium, but the Allium smell we are talking about is that we love folks who naturally want to know why and how the work they are doing builds leverage for their teammates and also relates to the business goals
ABOUT THE TEAM
We invite people of all backgrounds (https://www.allium.so/about). We have engineers who learnt coding much later in life, who learnt coding on the side, we have engineers who are still in school and we also have engineers who went to the top schools (CMU, Stanford, UIUC, UPenn, Oxford, NUS, Cornell), all are welcome if one comes in with a curious mind and an infectious work ethic.
[https://app.ashbyhq.com/api/images/user-content/2f62de56-0dd0-4792-90f8-069c5cb51068/68e40347-6f06-4fcd-a99a-68f539058433/allium%20team%20montage.jpeg]
[https://app.ashbyhq.com/api/images/user-content/2f62de56-0dd0-4792-90f8-069c5cb51068/1d38ca35-e23a-4c10-9a8f-8a79993c8cb3/image.png]
ADMINISTRATIVE BENEFITS
- Medical, Dental, Vision, Life and AD&D insurance - US folks get 100% coverage for Gold plans, 80% for dependents
- Ownership - Meaningful early-stage equity. Every full-time employee receives a stock option grant so you can share directly in Allium's upside
- Time off - Flexible, trust-based paid time off. We encourage people to take the rest they need. In every country we hire, our policies meet or exceed local statutory vacation requirements
- Retirement - Company sponsored 401(k) plan in US so you can save pre-tax for the long term
Note: The sun never sets on Allium - we hire from any geographical location as long as you are willing to overlap 2 hours overlap on NYC mornings Mon-Thurs from 10am-12pm ET. We have people based in New York, Seattle, Singapore and Australia.
All applicants have to answer this pop quiz: "What is an Allium? What is your favorite Allium? https://www.allium.so/post/how-allium-got-its-name". Bonus points for the right pronunciation.
Listed by Allium for a position based in the United States. Employers on this board attest they are hiring domestically.
Program Analyst, Legal Ops, Bellevue, Washington; Denver, Colorado; Seattle, Washington; Washington, D.C.. Join us! Together we can use data to solve the challenges of tomorrow
Listed by Databricks for a position based in the United States. Employers on this board attest they are hiring domestically.
Program Analyst, Legal Ops, Bellevue, Washington; Denver, Colorado; Seattle, Washington; Washington, D.C.. Join us! Together we can use data to solve the challenges of tomorrow
Listed by Databricks for a position based in the United States. Employers on this board attest they are hiring domestically.
Analyst
493 days ago
Planning Analyst
Anduril Industries · Costa Mesa, California, United States
Anduril Industries is a defense technology company with a mission to transform U.S. and allied military capabilities with advanced technology. By bringing the expertise, technology, and business model of the 21st century’s most innovative companies to the defense industry, Anduril is changing how military systems are designed, built and sold. Anduril’s family of systems is powered by Lattice OS, an AI-powered operating system that turns thousands of data streams into a realtime, 3D command and control center. As the world enters an era of strategic competition, Anduril is committed to bringing cutting-edge autonomy, AI, computer vision, sensor fusion, and networking technology to the military in months, not years.
ABOUT THE TEAM
The Planning Analytics team is responsible for deeply understanding our internal planning tooling and process stack and the data that powers them. They will build resources that transform data into ad hoc reporting, dashboards, web applications, and automated workflows to drive measurable improvements to business velocity in the planning space. This team will partner across Anduril's production and CorpTech orgs to establish visibility and accelerate decision making.
WHAT YOU’LL DO
As a Planning Analyst, you will work with our business-wide Analytics Engineering team to ensure their SQL data pipelines are modeled correctly for planning reporting. You will use Palantir's Foundry platform and Databricks as your central resources for conducting ad-hoc analysis for planning teams, as well as producing web applications, dashboards, and automated workflows that write back to our database via Python/Typescript actions. You will gain a deep understanding of the different planning interfaces and craft tools that drive insights and workflows that enable real cost and time savings business impacts. You are onboard with the goal of building out a world-class business analytics layer with truly novel solutions to planning problems.
Use SQL to transform raw ERP data extractions into structured datasets within a centralized GitHub repository
Use Palantir’s Foundry platform to generate dashboards and automated workflows backed by Python/Typescript code repositories
Work with planning leaders to define key performance metrics and implement systems for tracking over time
Eliminate repetitious processes with programmatic automation in Python
Manage cross-functional projects with clear and concise communication on timelines
Assess and incorporate external data sources and software that could bring valuable insight for planners
Educate business users with training/documentation and drive user adoption with a continual feedback loop
Embed AI into workflows via Palantir’s Foundry platform to help summarize and drive signal from noise
REQUIRED QUALIFICATIONS
Bachelor’s degree in Analytics, Data Science, Computer Science, Industrial Engineering or related technical field
2+ years of experience in analytics, operations engineering, data engineering, or software engineering roles, preferably in complex hardware technology industries
Expertise in SQL with demonstrated ability to write complex queries
Experience with data visualization and pipeline modeling using React-based application development
Proficiency with Databricks and Palantir Foundry platforms
Strong proficiency in Microsoft Excel including advanced formulas, live database connections, and VBA
Proficient in at least two programming language such as Python or Typescript for analysis, data visualization, and automation; experience building React applications or frontend data pipelines is a plus
Expertise in manufacturing operations concepts such as demand, supply, and material planning, bill of materials (BOM) management, work and purchase order management, and physical inventory management
Experience working with ERP/MRP systems (SAP, Oracle, NetSuite, or similar) and extracting/analyzing data from these platforms
Working knowledge of Git/GitHub for version control
Experience with APIs and parsing JSON/XML responses into structured datasets
PREFERRED QUALIFICATIONS
You have strong operational instincts and a track record of owning complex, ambiguous planning problems from start to finish.
You think strategically and execute tactically—you’re just as comfortable designing a planning framework as you are diving into the details of a late supplier PO.
You bring a data-driven mindset and can turn analytics into action; you know how to interpret demand signals, build plans, and communicate clearly.
You’re systems fluent, with experience working across ERP platforms (e.g., NetSuite, SAP, Oracle), and can partner effectively with technical teams to improve tooling.
You lead with cross-functional empathy—understanding the needs of engineering, product, deployment, and finance to align priorities and deliver business outcomes.
You’re comfortable with ambiguity and energized by building structure in environments that are scaling fast.
You are high ownership, low ego, and value results over credit.
You anticipate friction before it happens and proactively work to prevent issues rather than react to them.
US Salary Range
$113,000—$149,000 USD
The salary range for this role is an estimate based on a wide range of compensation factors, inclusive of base salary only. Actual salary offer may vary based on (but not limited to) work experience, education and/or training, critical skills, and/or business considerations. Highly competitive equity grants are included in the majority of full time offers; and are considered part of Anduril's total compensation package. Additionally, Anduril offers top-tier benefits for full-time employees, including:
Benefits
At Anduril, we invest in our people. Our comprehensive, competitive benefits package (available at little to no cost to employees) ensures you’re supported in health, recovery, and whatever comes next. For more information, Explore Our Benefits.
Protecting Yourself from Recruitment Scams
Anduril is committed to maintaining the integrity of our Talent acquisition process and the security of our candidates. We've observed a rise in sophisticated phishing and fraudulent schemes where individuals impersonate Anduril representatives, luring job seekers with false interviews or job offers. These scammers often attempt to extract payment or sensitive personal information.
To ensure your safety and help you navigate your job search with confidence, please keep the following critical points in mind:
No Financial Requests: Anduril will never solicit payment or demand personal financial details (such as banking information, credit card numbers, or social security numbers) at any stage of our hiring process. Our legitimate recruitment is entirely free for candidates.
Please always verify communications:
Direct from Anduril: If you receive an email from one of our recruiters, it will only come from an address.
Via Agency Partner: If contacted by a recruiting agency for an Anduril role, their email will clearly identify their agency. If you suspect any suspicious activity, please verify the agency's authenticity by reaching out to contact@anduril.com.
Exercise Caution with Unsolicited Outreach: If you receive any communication that appears suspicious, contains grammatical errors, or makes unusual requests, do not engage. Always confirm the sender's email domain is @anduril.com before providing any personal information or clicking on links.
What to Do If You Suspect Fraud: Should you encounter any questionable or fraudulent outreach claiming to be from Anduril, please report it immediately to contact@anduril.com. Your proactive caution is invaluable in protecting your personal information and upholding the security and trustworthiness of our recruitment efforts.
By submitting your application, you consent to Anduril Industries using a third-party service provider to conduct pre-employment risk, integrity, and due diligence screening and assessing potential risks as part of your application process. This third-party service provider provides risk-intelligence services that may include analysis of sanctions and watchlists, adverse media, public-record information, and other lawful open-source or commercial data sources. This third-party service provider does not act as a consumer reporting agency. Use of this provider helps to ensure compliance with applicable laws and protect technology, intellectual property, and organizational security.
Listed by Anduril Industries for a position based in the United States. Employers on this board attest they are hiring domestically.