BI Developer Sr. or Lead

Accountabilities

• Business Intelligence Development and Data Solutions

  • Design, develop, implement, and maintain BI reports, dashboards, data extracts, governed datasets, and ETL/ELT processes.

  • Support end-to-end data integration, data mart development, reporting, and analytics solutions, from source systems through downstream consumption.

  • Translate complex business requirements into technical specifications, solution designs, source-to-target mappings, and clearly defined business rules.

  • Conduct detailed data analysis to support requirements gathering, metric definitions, source validation, and data-quality assessments.

  • Develop and maintain dimensional data models, data warehouse components, OLAP cubes, semantic layers, and other analytical structures as required.

  • Testing, Quality Assurance, and Production Support

    • Perform unit testing and support output validation, data reconciliation, and business acceptance criteria.

    • Troubleshoot reports, data extracts, ETL/ELT processes, scheduled jobs, and production data solutions.

    • Conduct root-cause analysis for data, reporting, and pipeline issues, documenting resolutions and preventive measures.

    • Support user acceptance testing, release planning, change management, and deployment activities.

    • Maintain production readiness through effective scheduling, orchestration, monitoring, incident triage, and operational support practices.

    • Documentation, Governance, and Security

      • Create and maintain technical documentation, including business rules, data lineage, technical specifications, source-to-target mappings, runbooks, and support procedures.

      • Support data governance, metadata management, data stewardship, reporting standards, and data-quality initiatives.

      • Help maintain appropriate access controls and ensure the secure handling of sensitive information.

      • Promote consistency, reliability, and compliance across data development and reporting processes.

      • Optimization and Technical Leadership

        • Identify and implement improvements to the performance, reliability, automation, efficiency, and supportability of existing BI solutions.

        • Contribute technical expertise to projects, system enhancements, and enterprise-wide initiatives.

        • At the Lead level, guide technical decisions, establish and improve development standards, mentor developers and analysts, and coordinate the resolution of complex production issues.

        • Lead complex initiatives involving data integration, ETL/ELT, data modeling, data warehousing, and enterprise analytics solutions.

        Requirements

        • Bachelor's degree in Computer Science, Information Systems, Information Technology, Data Analytics, or a related field, or equivalent practical experience.

        • At least five years of relevant experience in IT, business intelligence, data engineering, data integration, reporting, or analytics delivery.

        • Demonstrated experience developing and supporting enterprise data solutions in production environments.

        • Advanced SQL skills using Oracle, Microsoft SQL Server, or another leading relational database management system.

        • Strong experience developing reports and dashboards using tools such as Microsoft Reporting Services, Power BI, Business Objects, or Cognos.

        • Hands-on experience building ETL/ELT processes using Microsoft Integration Services or other data integration technologies.

        • Experience supporting data extracts, integrations, data marts, governed datasets, and downstream reporting or analytics.

        • Knowledge of dimensional data modeling, data warehousing methodologies, OLAP cubes, semantic layers, and analytical data models.

        • Familiarity with data-quality processes, including validation, exception reporting, reconciliation, and quality metrics.

        • Working knowledge of production support practices, including scheduling, orchestration, monitoring, incident management, root-cause analysis, and operational readiness.

        • Ability to prepare and maintain technical specifications, source-to-target mappings, business rules, lineage documentation, runbooks, and support procedures.

        • Understanding of data governance, metadata, stewardship, reporting governance, access controls, and the secure handling of sensitive data.

        • Strong analytical, critical-thinking, and problem-solving skills, with the ability to investigate complex data issues and recommend effective solutions.

        • Excellent communication and collaboration skills, including the ability to translate business needs into technical requirements and work effectively with technical and non-technical stakeholders.

        • Strong organizational skills and the ability to manage multiple priorities in a dynamic environment.

        • Additional requirements for Lead-level consideration: Generally, seven or more years of related experience, demonstrated leadership of multiple large-scale initiatives, and experience providing technical direction to developers or analysts.

        • Preferred qualifications for Lead-level candidates: A master's degree or relevant professional certification; experience gathering and documenting business requirements; familiarity with insurance or other regulated data environments; and experience with enterprise data warehouses, data marts, semantic layers, and governed datasets.

        • Additional preferred technical experience: Familiarity with modern data platforms such as Azure, AWS, Google Cloud Platform, Snowflake, or Microsoft Fabric.

        • Lead-level leadership strengths: Experience mentoring colleagues, guiding technical decisions, and improving BI development, governance, and production support standards.

        • Work authorization: Applicants must be authorized to work for any employer in the United States. Employment visa sponsorship or transfer of sponsorship is not available.

        Benefits

        • Remote work: Fully remote position with company-provided equipment.

        • Competitive compensation — Senior BI Developer: Starting salary range of $100,600–$125,700, with a full range of $100,600–$150,900.

        • Competitive compensation — Lead BI Developer: Starting salary range of $115,700–$144,600, with a full range of $127,200–$190,800. The stated starting range and full range differ, so the applicable compensation level should be confirmed during recruitment.

        • Annual incentive plan: Eligibility for performance-based incentive compensation tied to company and individual results.

        • Paid time off: 3.5 weeks of PTO and 11 paid holidays.

        • Retirement savings: 401(k) plan with an employer match of up to 6%, fully vested from the first day.

        • Health and wellbeing: Comprehensive and affordable benefits package, along with an Employee Assistance Program.

        • Professional development: Tuition reimbursement and opportunities for career advancement.

        • Work-life balance: Recharge Days and Volunteer Time Off.

        • Inclusive workplace: Inclusion Council and Employee Resource Groups that support belonging, engagement, and diverse perspectives.

        • Collaborative culture: Work alongside a team-oriented group of peers committed to innovation, technical excellence, and continuous improvement.

        • Career growth: Opportunities to deepen expertise in enterprise BI, data engineering, analytics, and technical leadership.