Menu
Skills in this repository
SkillsMP has collected 1,540 skills from MadewellRD/skills-lab. Open a skill to review its source and details.
MadewellRD/skills-labShowing 40 of 1,540 collected skills.
design data classification and access control covering pii phi and pci classification of physical columns, roles groups and actual grants, row-level security predicates, column masking and tokenization, enforcement points, purpose limitation per audience,…
respond to bad data in production covering severity by consumer exposure rather than row count, containment that pauses dependents and holds exports, evidence capture before any re-run, lineage-derived blast radius including external recipients, the backfill…
plan data platform migration covering scope and what is deliberately retired rather than carried, dual-run design, parity reconciliation across row counts control totals and metric values with a stated tolerance, historical backfill depth, consumer cutover…
design conceptual logical and physical data models with a declared grain per fact, transaction periodic snapshot and accumulating snapshot fact types, conformed dimensions and the bus matrix, slowly changing dimension type per attribute with effective dating,…
design data observability monitors and alert routing covering freshness sla, row volume anomaly, schema drift detection, distribution and null rate drift, job failure, consumer lag, lineage-aware alert grouping and suppression, detection coverage, alert noise…
analyze data platform spend covering the compute storage and transfer breakdown from the billing export, top cost drivers named as specific queries pipelines and dashboards, spend attribution and the unattributable share, efficiency findings across partition…
define a data product as the decision it serves, naming consumers and external recipients, output port, accountable owner, criticality tier, regulatory or contractual use, and agreed freshness completeness and accuracy targets, plus the tables dashboards and…
design data quality tests and validation, writing out the actual assertions for freshness, volume, uniqueness at the declared grain, not null, referential integrity, accepted values, distribution drift and business rules, deriving thresholds from history or…
design data retention and erasure covering retention schedules with their regulatory contractual or operational basis, deletion mechanisms that actually remove data given table format snapshots time travel and backups, the propagation map of every derived…
design batch and change data capture ingestion, covering extraction pattern and watermark selection, snapshot plus stream stitching at a consistent log position, delete propagation, idempotency and deduplication keys, raw record preservation for replay,…
build data lineage and metadata covering column-level and table-level lineage from sql parsing, orchestrator metadata and query history, upstream and downstream impact analysis, blast radius, catalog registration and stewardship, business glossary mapping,…
define metrics and the semantic layer covering metric expressions with filters exclusions and denominators, entity dimension and measure modeling, grain validity, additive semi-additive and non-additive aggregation, distinct counts that do not roll up, time…
profile source systems before extraction, establishing record grain, candidate and actual primary keys, uniqueness violations, null rates, cardinality, value ranges, encoding and type surprises, arrival cadence and lateness, hard versus soft delete behavior,…
design streaming data pipelines covering event time versus processing time, partition keys and the ordering they buy, tumbling hopping sliding and session windows, watermarks and allowed lateness, delivery semantics as the consumer observes them, state store…
design the layered sql transformation stack from staging through intermediate to marts, covering materialization and incremental strategy with merge keys and lookback windows, deduplication and record selection, slowly changing dimension implementation with…
design warehouse and lakehouse storage, covering zone and layer architecture, table format and its transactional guarantees, partitioning against real query predicates, clustering and sort order, file sizing and compaction, snapshot and time travel retention…
reconcile balance sheet accounts to their supporting detail, tie subledgers to their general ledger control accounts, reconcile bank statements to book balances with outstanding items listed individually, age reconciling items and flag those surviving…
set the chart of accounts structure and its segments, the accounting policy elections in force, technical accounting memos, materiality thresholds with their benchmark, and the mapping from operational systems into the general ledger. use for coa design,…
classify three way match exceptions by cause, build the received-not-invoiced accrual from receipts rather than from arrived invoices, prepare the payment proposal with terms and early payment discounts captured, detect duplicate and near-duplicate invoices,…
produce the receivable aging tied to its control account, days sales outstanding with the formula stated, dispute triage separating billing defects from delivery problems from credit risk, a collections plan with an action owner and date per account, the…
run the audit request list with an owner due date and state per item, assemble traceable support packages that let a sampled item be followed from the ledger to its source document, tie the financial statements to the trial balance, respond to samples and…
review the billing run against executed contract terms, find contracts billed at the wrong amount or schedule or not billed at all, quantify unbilled and over-billed positions, tie invoiced amounts to recognized revenue, prepare credit memo and rebill…
build the annual operating plan by department and account with a named budget holder on every line, the driver and headcount model with start date timing and fully loaded cost, committed contractual spend separated from discretionary spend, the revenue build…
build the cash position by bank account and entity, the direct thirteen week receipts and disbursements forecast with its low point week, runway with the burn definition named explicitly, working capital movements explaining profit against cash, covenant…
tie the cap table grant by grant to the board consents that authorized each one, report the option pool position across authorized granted exercised forfeited and available, compute stock compensation expense with its model and inputs stated, produce the…
review travel and expense reports against the policy provision each item breaches, reconcile the corporate card program including unsubmitted spend and the accrual it drives, code entertainment benefits and non-deductible categories for their tax treatment,…
orchestrate accounting and finance operations across month-end close, revenue recognition and deferred revenue, accounts receivable and collections, accounts payable and three way match, expense management, spend approval and delegation of authority, chart of…
produce financial statements and the consolidation with eliminations shown, the disclosure set the framework requires, the board and investor package narrative, non-gaap and adjusted measures with their reconciliations, covenant computations built on the…
produce the reforecast with actuals to date separated from projection, driver-based scenarios distinguished by specific named assumptions rather than by percentage haircuts, the step changes a run rate cannot see such as contract ends launches and hiring,…
build the control matrix mapping each control to the risk it addresses with its owner frequency and evidence of operation, analyze segregation of duties conflicts across the erp banking and billing systems, run user access and privileged access reviews,…
run the close calendar and name the dependency holding up anything late, test cutoff at the period boundary, assemble the journal entry package with a preparer and a separate reviewer on every entry, establish accrual completeness from what was received…
run the five step revenue analysis per contract covering performance obligations, transaction price and variable consideration, standalone selling price and allocation, over time versus point in time recognition, the revenue schedule and deferred revenue…
build arr and mrr with the movement bridge from opening through new expansion contraction and churn to closing across the whole customer base, reconcile the run rate to recognized revenue, define and compute net and gross revenue retention and logo and…
determine the approver a commitment requires under the delegation of authority matrix, compute total commitment value including renewal and auto-renewal exposure rather than the first invoice, check budget headroom on the specific line the spend consumes,…
prepare the income tax provision with its current and deferred components, the effective tax rate reconciliation, the deferred tax roll-forward and valuation allowance evidence, nexus and registration exposure by jurisdiction, the indirect tax position for…
explain budget to actual and forecast to actual variances at the level the budget holder can act on, decompose movements into price volume mix timing and classification effects, separate timing differences from run rate changes, identify variances caused by…
triage cloud cost anomalies and trace each spike to the specific change that caused it rather than to the service the charge landed under. covers detection basis and baseline per anomaly, delta amount and duration, triage into explained expected waste or…
build cloud and vendor spend budgets scoped to named budget holders with a stated basis per line. covers run-rate baselines separated from growth assumptions and step changes, cost estimates for planned launches migrations and decommissions built from…
design and operate internal cloud chargeback and showback covering the model and its rationale, the internal rate card with the basis for any markup or subsidy, a chargeback ledger that balances to the provider invoice with the residual shown rather than…
prepare cloud and vendor negotiation positions covering the evidence pack with spend history and growth case modeled the way a vendor account team models it, commit sizing options with shortfall and true-up exposure quantified per option, an ask list valued…