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.

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

This job description is intended to convey information essential to understanding the scope of the position and its general requirements. It is not exhaustive and may be subject to modification at any time to meet the evolving needs of the organization.

#USAL2