BI Developer Sr. or Lead

This position is listed on behalf of a partner company, which manages all applications and next steps. Our partner is looking for a BI Developer Sr. or Lead based in the United States. We are seeking an experienced Business Intelligence Developer to design and deliver reliable, secure, and scalable data solutions that empower informed business decisions. This fully remote opportunity offers the flexibility to contribute at either the Senior or Lead level, depending on your technical expertise and leadership experience. You will develop dashboards, reports, data pipelines, governed datasets, and data models that transform complex information into meaningful insights. Working closely with business stakeholders and technical teams, you will translate requirements into effective solutions while ensuring data quality, security, and operational reliability. You will also help optimize existing systems, strengthen governance practices, and improve the efficiency of enterprise reporting and analytics. For candidates at the Lead level, the role offers additional opportunities to guide technical strategy, mentor colleagues, and drive complex initiatives across the organization.

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.