Data Engineer

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

Requirements:

• 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