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.
How Jobgether works: We use an AI-powered matching process to ensure your application is reviewed quickly, objectively, and fairly against the role's core requirements. Our system identifies the top-fitting candidates, and this shortlist is then shared directly with the hiring company. The final decision and next steps (interviews, assessments) are managed by their internal team. We appreciate your interest and wish you the best! Why Apply Through Jobgether?
Data Privacy Notice: By submitting your application, you acknowledge that Jobgether will process your personal data to evaluate your candidacy and share relevant information with the hiring employer. This processing is based on legitimate interest and pre-contractual measures under applicable data protection laws (including GDPR). You may exercise your rights (access, rectification, erasure, objection) at any time.
#LI-CL1