Senior or Lead BI Developer

At USAble Life, we’re committed to making a meaningful difference in the lives of our customers, our communities, and each other. We are a diverse team united by a shared drive to go the extra mile. Through our DEI initiatives, employees feel empowered to bring their unique talents, perspectives, and voices to our culture.
Our dedication to delivering exceptional products is matched by our passion for supporting our people. We believe that making an impact extends beyond our office walls, and our longstanding tradition of community involvement reflects that commitment. We’re proud that our employees consistently embrace and uphold this spirit of service.
Recognized as a “Best Places to Work” in Arkansas, Florida, and Hawaii, USAble Life offers opportunities for personal and professional growth, along with avenues for career advancement. Combined with our engaging culture and comprehensive benefits package, we are committed to ensuring our employees feel valued, supported, and inspired.
Check out how we make a meaningful difference in the lives of others!
<https://player.vimeo.com/video/518665804>
What We Offer You:
A culture that values employees and celebrates, empowers, and inspires a diverse workforce
Outstanding and affordable benefits package
3.5 weeks of PTO and 11 paid holidays
401(k) with up to 6% match; fully vested from day 1
Remote opportunities with company-provided equipment
Team-oriented, collaborative group of peers
Career advancement opportunities
Tuition Reimbursement
Employee Assistance Program
Inclusion Council and Employee Resource Groups
Recharge Days and Volunteer Time Off
This is a remote position.
Life Takes You Places! Are you ready to join us?
Pay Transparency:
The anticipated pay
for new hires entering as a Senior BI Developer is between $100,000 to $125,000. The anticipated pay for new hires entering as a Lead BI Developer is between $115,000 to $144,000.
The full pay range for Sr. is $100,000 to $150,000, and the Lead is $115,000 to $173,000. Pay is based on non-discriminatory factors including but not limited to work experience, education, location, licensure requirements, proficiency and qualifications, and company tenure & equity. In addition to base compensation, this role is eligible for an annual incentive plan based on company performance and individual performance.
Before You Apply:
Please review these qualifications carefully before applying. This role is best suited for candidates with demonstrated experience designing and supporting enterprise business intelligence, reporting, data integration, and analytics solutions. Candidates without strong SQL, dashboard/report development, ETL/ELT, data warehousing, and production support experience may be less competitive for this role.
Senior Business Intelligence Developer Overview
The Senior Business Intelligence Developer (Sr BI Developer) will support the needs of the business by designing, implementing and maintaining data solutions across BI reporting, data integration, data extracts, governed datasets and production data support. The primary focus of this role includes analyzing business requirements to design, develop and update dashboards, reports, data extracts, ETL/ELT processes, data marts and other BI solutions. The solutions developed by the Sr BI Developer should focus on timely, cost-effective, reliable and supportable methods for achieving deliverables. The Sr BI Developer should adhere to development, testing, change management, documentation, data governance, security and operational support standards. Performs design, management and administration of BI platforms, data processes and reporting environments. The Sr BI Developer also explores emerging technologies to support and enhance BI and Data Services capabilities and provides technical leadership to junior team members.
Lead Business Intelligence
Developer Overview
The Lead Business Intelligence Developer (Lead BI Developer) is responsible for designing, implementing, maintaining and supporting data solutions to support the needs of the business and the Data Services function. This includes analyzing business requirements to design, develop and update dashboards, reports, data extracts, ETL/ELT processes, data marts, governed datasets and other BI solutions in a timely, reliable and cost-effective manner. The Lead BI Developer is also responsible for adhering to development, testing, change management, documentation, data governance, security and operational support standards, as well as exploring emerging technologies to enhance BI and Data Services capabilities. This role provides technical direction, supports operational readiness, mentors junior team members and acts as a subject matter expert for complex data and reporting initiatives.
Sr BI Developer Essential Duties:
Develops BI reports, dashboards, data extracts, governed datasets and ETL/ELT processes based on requirements specified
Supports data integration, data mart, reporting and analytics solutions from source systems through downstream consumption
Serves as a technical senior technical contributor for large-scale projects, enhancements and corporate initiatives
Understands complex business requirements and translates them into technical specifications, source-to-target mappings and solution designs
Performs complex data analysis to support requirements gathering, metric definition, source validation, documentation and data quality validation
Conducts unit testing of solutions developed and assists in validating outputs, reconciliation results and business acceptance criteria
Conducts troubleshooting and support of existing reports, data extracts, ETL/ELT processes, scheduled jobs and production data solutions
Performs root cause analysis for data, reporting and pipeline issues and documents resolution steps and preventive actions
Creates and maintains documentation related to solutions being developed, including business rules, data lineage, technical specifications, runbooks and support procedures
Translates business requirements into technical design documentation and supports testing, UAT, change management and release planning for solutions being deployed
Supports data governance, metadata, lineage, data quality, access control and reporting governance expectations for supported data assets
Optimizes existing solutions and identifies key areas where efficiency, reliability, automation, performance and supportability can be improved
Works on personal development
Performs other related duties and responsibilities as assigned
Lead BI Developer Essential Duties:
In addition to all duties listed above:
Leads complex data integration, data mart, reporting and analytics solutions from source systems through downstream consumption
Serves as a technical lead for large-scale projects, enhancements and corporate initiatives
Provides technical direction for solution design, development standards, code reviews, testing practices, deployment readiness and operational support
Performs complex data analysis to support requirements gathering, metric definition, source validation, documentation and data quality validation
Conducts unit testing of solutions developed and assists in validating outputs, reconciliation results and business acceptance criteria
Leads troubleshooting and support of existing reports, data extracts, ETL/ELT processes, scheduled jobs and production data solutions
Performs root cause analysis for complex data, reporting and pipeline issues and coordinates resolution steps, preventive actions and stakeholder communication
Creates, reviews and maintains documentation related to solutions being developed, including business rules, data lineage, technical specifications, runbooks and support procedures
Supports and reinforces data governance, metadata, lineage, data quality, access control and reporting governance expectations for supported data assets
Mentors junior team members in industry best practices, corporate procedures, technical standards, documentation, production support and cross-department dynamics
Acts as a subject matter expert to support corporate or department initiatives
Performs other related duties and responsibilities as assigned
Sr BI Developer Required Knowledge, Skills, and Abilities:
Advanced skills writing SQL queries in Oracle, Microsoft SQL Server, or other industry leading RDBMS
Advanced skills in creating reports and dashboards using Microsoft Reporting Services, Microsoft Power BI, Business Objects, Cognos or other reporting tools
Strong skills creating ETL/ELT processes using Microsoft Integration Services, or other data integration tools
Strong skills supporting data extracts, data integrations, data marts, governed datasets and downstream reporting or analytics consumption
Competent skills designing and maintaining OLAP cubes, semantic layers and data models using Microsoft Analysis Services or other tools
Strong skills with dimensional data modeling and data warehousing methodologies
Competent skills creating processes to assess and report data quality metrics, validation results, exceptions and reconciliation outcomes
Working knowledge of production support practices including scheduling, orchestration, monitoring, incident triage, root cause analysis and operational readiness
Experience writing effective technical specifications or other documentation, including source-to-target mappings, business rules, lineage, runbooks and support procedures
Working knowledge of data governance, metadata, stewardship concepts, reporting governance, access controls and secure handling of sensitive data
Ability to effectively communicate in writing and orally with a wide range of audiences and maintain interpersonal relationships
Ability to persuade, negotiate, influence and interact effectively with other people in the organization
Ability to work within time constraints and manage multiple tasks against critical deadlines
Ability to perform complex problem solving and apply critical thinking, deductive reasoning and inductive reasoning to identify solutions
Ability to analyze systems, data flows or processes to determine impacts of changes and perform root cause analysis
Lead BI Developer Required Knowledge, Skills, and Abilities:
In Addition to all Required Knowledge Above:
Advanced skills creating ETL/ELT processes using Microsoft Integration Services, Informatica or other data integration tools
Advanced skills supporting data extracts, data integrations, data marts, governed datasets and downstream reporting or analytics consumption
Strong skills designing and maintaining OLAP cubes, semantic layers and data models using Microsoft Analysis Services or other tools
Advanced skills with dimensional data modeling and data warehousing methodologies
Strong skills creating processes to assess and report data quality metrics, validation results, exceptions and reconciliation outcomes
Strong knowledge of production support practices including scheduling, orchestration, monitoring, incident triage, root cause analysis and operational readiness
Experience writing effective technical specifications or other documentation, including source-to-target mappings, business rules, lineage, runbooks and support procedures
Working knowledge of data governance, metadata, stewardship concepts, reporting governance, access controls, secure handling of sensitive data and auditability expectations
Ability to lead technical design discussions, influence solution direction, resolve ambiguity and align technical delivery with business outcomes
Ability to persuade, negotiate, influence and interact effectively with other people in the organization
Sr BI Developer Required Education and Experience:
Bachelor's Degree in Computer Science, Information Systems, Information Technology, Data Analytics or related field or equivalent experience
5+ years of related IT, BI, data engineering, data integration, reporting or analytics delivery experience
Experience developing and supporting enterprise data solutions in a production environment
Or, equivalent military experience
Lead BI Developer Required Education and Experience:
Bachelor's Degree in Computer Science, Information Systems, Information Technology, Data Analytics or related field or equivalent experience
7+ years of related IT, BI, data engineering, data integration, reporting or analytics delivery experience
Experience leading at least four large scale projects, initiatives or enhancements that impact systems, operational areas, data assets or business processes
Experience providing technical leadership, mentoring, peer review or work direction to other developers or analysts
Experience developing and supporting enterprise data solutions in a production environment
Or, equivalent military experience
Sr BI Developer Preferred Education and Experience:
Master's Degree in related field or professional certification in relevant area
IT related experience in the Health or Ancillary Insurance industry or another regulated data environment
Experience gathering and documenting business requirements
Experience with ODS, enterprise data warehouse, data mart, semantic layer or governed reporting dataset development
Applied experience supporting data governance practices for enterprise data assets, including metadata capture, lineage documentation, data quality validation, reporting governance or audit readiness
Experience with cloud, hybrid or modern data platforms such as Azure, AWS, GCP, Snowflake, Microsoft Fabric or similar technologies
Lead BI Developer Preferred Education and Experience:
Master's Degree in related field or professional certification in relevant area
IT related experience in the Health or Ancillary Insurance industry or another regulated data environment
Experience gathering and documenting business requirements
Experience mentoring junior team members
Experience with ODS, enterprise data warehouse, data mart, semantic layer or governed reporting dataset development
Applied experience supporting data governance practices for enterprise data assets, including metadata capture, lineage documentation, data quality validation, reporting governance or audit readiness
Experience with cloud, hybrid or modern data platforms such as Azure, AWS, GCP, Snowflake, Microsoft Fabric or similar technologies
Experience establishing or improving data engineering, BI development, release readiness, production support or documentation standards
Sr and Lead BI Developer Working Conditions (Physical Demands):
Occasional travel (one to two times per year) as required
Normal, no adverse or hazardous conditions