Business Intelligence Lead

Accountabilities: Solve complex and varied business problems by analyzing data from internal and external sources and translating findings into actionable insights for decision-makers. Develop and maintain advanced data solutions using Python/PySpark, SQL, and Databricks. Build and optimize production-grade data pipelines with enforced schemas, validation gates, structured error logging, and reliable operational controls. Refactor and optimize Python/PySpark codebases to improve performance, maintainability, scalability, and reliability. Design and implement Databricks solutions using capabilities such as Unity Catalog, Delta Lake, scheduled jobs and workflows, and service principal authentication. Develop advanced SQL solutions, including stored procedure execution and read/write integration with SQL Server systems of record. Apply Git-based engineering practices, including branching strategies, pull requests, code reviews, and CI/CD workflows. Translate business and project requirements into effective technical solutions while bridging communication between business stakeholders, project teams, and technical teams. Contribute to data engineering and analytics modernization through improved orchestration, data quality, observability, and engineering practices. Communicate complex findings, technical approaches, and recommendations clearly to senior and executive leadership. Collaborate across functions to ensure data solutions align with business priorities and deliver reliable, measurable value. Requirements Bachelor’s degree with 5+ years of technical experience in data analysis, or a Master’s degree with 3+ years of relevant experience. Advanced Python/PySpark expertise, including experience optimizing and refactoring production code. Advanced Databricks experience, including Unity Catalog, Delta Lake, scheduled jobs/workflows, and service principal authentication. Proven experience building production data pipelines with enforced schemas, validation controls, structured error logging, and operational reliability. Advanced SQL skills, including stored procedures and integration with SQL Server systems of record. Strong understanding of Git-based software engineering practices, including branching, pull requests, code reviews, and CI/CD. Ability to work effectively with cross-functional teams and translate requirements between business stakeholders, project management, and technical teams. Excellent written and verbal communication skills, particularly when presenting to senior and executive leadership. Strong analytical, problem-solving, and critical-thinking abilities with the capacity to work independently on complex assignments. Willingness to learn and become proficient across multiple systems, policies, tools, and business processes. Commitment to remain in the position for at least 12 months before applying for other internal opportunities. Preferred advanced degree in a quantitative discipline such as Mathematics, Economics, Finance, Statistics, Computer Science, Engineering, or a related field. Preferred experience with ETL and orchestration technologies such as Azure Data Factory, Airflow, dbt, Delta Live Tables, or Lakeflow. Preferred experience with data quality frameworks, pipeline monitoring, alerting, SLAs, and incident runbooks. Familiarity with front-end development using TypeScript, Angular, or React, including component architecture and REST API consumption, is a plus. Knowledge of ontology or knowledge-graph modeling using technologies such as LinkML, RDF/OWL, SHACL, or equivalent approaches is advantageous. Benefits Fully remote position available nationwide across the United States. Base salary range of $117,600–$161,700 per year , depending on qualifications, skills, experience, education, and other job-related factors. Eligibility for a bonus incentive plan based on company and/or individual performance. Medical, dental, and vision coverage. 401(k) retirement savings plan. Paid time off, company holidays, and personal holidays. Paid parental and caregiver leave. Short-term and long-term disability coverage. Life insurance. Additional programs supporting employee well-being and financial security. 40-hour workweek in a fully remote environment. Remote work support requiring reliable internet service of at least 25 Mbps download and 10 Mbps upload. Dedicated home workspace required to protect confidential and regulated information. Occasional travel may be required for training or meetings. Application deadline: October 10, 2026 .