Note: The job is a remote job and is open to candidates in USA. Law Brothers - Injury Attorneys is seeking a seasoned Data Engineer to enhance their data capabilities and ensure data integrity. The role involves building a centralized cloud data warehouse and developing automated testing frameworks to validate data throughout the pipeline.
Responsibilities
- Architect and build a formal cloud data warehouse ecosystem to establish a single, reliable source of truth, selecting the platform that best fits our scale and budget
- Design custom ingestion systems and caching layers to seamlessly stream data from complex external APIs without hitting rate limits or dropping payloads
- Build pipelines capable of parsing, structuring, and storing unstructured data sets for downstream business intelligence initiatives
- Implement QA frameworks using the tooling we collectively agree on to verify data accuracy, completeness, and freshness at every pipeline stage
- Set up proactive alerting systems to capture data anomalies, null values, or schema drift before bad data impacts business logic or reports
- Track down and debug data discrepancies between source APIs and final warehouse tables
Skills
- 5+ years of hands-on experience architecting and querying cloud data warehouses on a major cloud platform
- Deep proficiency in Python and SQL for writing ETL/ELT pipelines, with experience using at least one modern orchestration or transformation framework
- Strong understanding of managing high-volume API requests, token management, pagination, and error-handling strategies
- Proven track record building test suites for data environments — validating schemas, row counts, uniqueness, and distribution constraints
- Familiarity with how data formatting impacts downstream BI tools; experience migrating off third-party visualization platforms into custom warehouse solutions is highly preferred
Benefits
- 401(k)
- Dental insurance
- Health insurance
- Paid time off
- Vision insurance
Company Overview