Senior or Lead BI Developer

USAble Life•Little Rock, AR

1d•$100,000 - $173,000•Remote

About The Position

USAble Life is seeking a Senior or Lead BI Developer to design, implement, and maintain data solutions across BI reporting, data integration, data extracts, governed datasets, and production data support. This role involves analyzing business requirements to develop and update dashboards, reports, ETL/ELT processes, and data marts. The developer will adhere to development, testing, change management, documentation, data governance, security, and operational support standards. Responsibilities include performing design, management, and administration of BI platforms, exploring emerging technologies, and providing technical leadership. The Lead BI Developer will also provide technical direction, support operational readiness, mentor junior team members, and act as a subject matter expert for complex data and reporting initiatives.

Requirements

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.
Advanced skills creating ETL/ELT processes using Microsoft Integration Services, Informatica or other data integration tools (Lead role only).
Advanced skills supporting data extracts, data integrations, data marts, governed datasets and downstream reporting or analytics consumption (Lead role only).
Strong skills designing and maintaining OLAP cubes, semantic layers and data models using Microsoft Analysis Services or other tools (Lead role only).
Advanced skills with dimensional data modeling and data warehousing methodologies (Lead role only).
Strong skills creating processes to assess and report data quality metrics, validation results, exceptions and reconciliation outcomes (Lead role only).
Strong knowledge of production support practices including scheduling, orchestration, monitoring, incident triage, root cause analysis and operational readiness (Lead role only).
Working knowledge of data governance, metadata, stewardship concepts, reporting governance, access controls, secure handling of sensitive data and auditability expectations (Lead role only).
Ability to lead technical design discussions, influence solution direction, resolve ambiguity and align technical delivery with business outcomes (Lead role only).
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 (Sr role).
7+ years of related IT, BI, data engineering, data integration, reporting or analytics delivery experience (Lead role).
Experience developing and supporting enterprise data solutions in a production environment.
Experience leading at least four large scale projects, initiatives or enhancements that impact systems, operational areas, data assets or business processes (Lead role only).
Experience providing technical leadership, mentoring, peer review or work direction to other developers or analysts (Lead role only).

Nice To Haves

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.
Experience mentoring junior team members (Lead role only).
Experience establishing or improving data engineering, BI development, release readiness, production support or documentation standards (Lead role only).

Responsibilities

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.
Leads complex data integration, data mart, reporting and analytics solutions from source systems through downstream consumption (Lead role only).
Provides technical direction for solution design, development standards, code reviews, testing practices, deployment readiness and operational support (Lead role only).
Performs root cause analysis for complex data, reporting and pipeline issues and coordinates resolution steps, preventive actions and stakeholder communication (Lead role only).
Mentors junior team members in industry best practices, corporate procedures, technical standards, documentation, production support and cross-department dynamics (Lead role only).
Acts as a subject matter expert to support corporate or department initiatives (Lead role only).
Establishes or improves data engineering, BI development, release readiness, production support or documentation standards (Lead role only).