BI Developer

USAble Life
United States
3 days ago
Apply on www.builtincolorado.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
5 years minimum
Compensation
$101,000.0 - $191,000.0
Working hours
Regular working hours

Tech stack

Amazon Web Services Business Analytics Applications Data Analysis Unit Testing Microsoft Azure Business Intelligence Development Big Data Cloud Computing Information Systems Information Engineering Data Governance Data Infrastructure
+27 more
Data Integration Extract Transform Load (ETL) Data Mart Data Systems Data Warehousing Relational Databases IBM Cognos Business Intelligence Metadata Microsoft SQL Server Online Analytical Processing Operational Databases Oracle (Applications) Release Management Power BI Runbook Systems Integration Enterprise Data Management Microsoft Reporting Google Cloud Sql Optimization Snowflake Sap Business Objects Data Layers Microsoft Fabric Information Technology Data Lineage Data Analytics

Job description

In this role, you will develop dashboards, reports, data extracts, governed datasets, ETL/ELT processes, data marts, and other BI solutions. You will work with business and technical partners to translate complex requirements into reliable, secure, supportable, and cost-effective data solutions. You will also help maintain development, testing, documentation, change management, data governance, security, and production support standards.

What You’ll Do

  • Develop and support BI reports, dashboards, data extracts, governed datasets, and ETL/ELT processes.
  • Support data integration, data mart, reporting, and analytics solutions from source systems through downstream consumption.
  • Translate complex business requirements into technical specifications, source-to-target mappings, and solution designs.
  • Perform complex data analysis to support requirements gathering, metric definitions, source validation, and data-quality reviews.
  • Conduct unit testing and assist with output validation, reconciliation, and business acceptance criteria.
  • Troubleshoot reports, data extracts, ETL/ELT processes, scheduled jobs, and production data solutions.
  • Perform root-cause analysis for data, reporting, and pipeline issues and document resolution steps and preventive actions.
  • Create and maintain technical documentation, including business rules, data lineage, technical specifications, runbooks, and support procedures.
  • Support testing, user acceptance testing, change management, and release planning.
  • Support data governance, metadata, lineage, data quality, access control, and reporting governance expectations.
  • Identify opportunities to improve the performance, reliability, efficiency, automation, and supportability of existing solutions.
  • Serve as a senior technical contributor or technical lead for projects, enhancements, and corporate initiatives.

What You’ll Bring:

  • Advanced SQL skills using Oracle, Microsoft SQL Server, or another leading relational database management system.
  • Advanced experience developing reports and dashboards using tools such as Microsoft Reporting Services, Power BI, Business Objects, or Cognos.
  • Strong experience developing ETL/ELT processes using Microsoft Integration Services or other data integration tools.
  • Experience supporting data extracts, data integrations, data marts, governed datasets, and downstream reporting or analytics.
  • Experience with dimensional data modeling and data warehousing methodologies.
  • Experience designing or maintaining OLAP cubes, semantic layers, or data models.
  • Knowledge of data-quality processes, including validation, exception reporting, reconciliation, and data-quality metrics.
  • Working knowledge of production support practices, including scheduling, orchestration, monitoring, incident triage, root-cause analysis, and operational readiness.
  • Experience preparing technical specifications, source-to-target mappings, business rules, lineage documentation, runbooks, or support procedures., Provides technical leadership for designing, developing, implementing, and supporting Microsoft Dataverse, Dynamics 365, and Power Platform solutions. Translates architecture and business requirements into technical approaches, leads proofs of concept and troubleshooting, guides engineers, and develops complex components using C#, .NET, JavaScript, Azure services, APIs, plug-ins, and PCF controls. Partners with architecture, delivery, quality, and DevOps teams on integrations, CI/CD, application lifecycle management, releases, and production support. Top Skills: .NetAgileApi ManagementApplication Lifecycle ManagementAzureAzure FunctionsC#Ci/CdCustom ApisDynamics 365JavaScriptLogic AppsMicrosoft DataversePcf ControlsPlug-InsPower AppsPower AutomatePower PlatformRest ApisService BusSource ControlSQL MetLife

Requirements

Pay Transparency: Our salary ranges are structured to provide opportunities for growth and advancement within a role. As a result, most new hires are placed between the minimum and midpoint of the range based on qualifications and experience, while the top of the range is generally reserved for employees who have demonstrated sustained expertise and performance in the position. 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., We are seeking an experienced BI Developer to design, develop, implement, and support data solutions that help the business make informed decisions. This position may be filled at the Senior or Lead level, depending on the selected candidate’s experience, technical expertise, and demonstrated leadership., * Working knowledge of data governance, metadata, stewardship, reporting governance, access controls, and the secure handling of sensitive data.

  • Strong analytical, critical-thinking, problem-solving, and communication skills.
  • Ability to manage multiple priorities and work effectively with both technical and business partners., * Bachelor’s degree in Computer Science, Information Systems, Information Technology, Data Analytics, or a related field, or equivalent experience.
  • Five or more years of related experience in IT, business intelligence, data engineering, data integration, reporting, or analytics delivery.
  • Experience developing and supporting enterprise data solutions in a production environment.
  • Equivalent military experience may also be considered.

Lead-Level Opportunity:

Lead-level candidates will have greater depth in data integration, ETL/ELT, data modeling, data warehousing, data quality, and production support. They will also lead complex initiatives, guide technical decisions and standards, mentor team members, and coordinate the resolution of complex production issues.

Lead-level consideration generally requires seven or more years of related experience, leadership of multiple large-scale initiatives, and experience providing technical guidance to developers or analysts.

Lead Preferred Qualifications

  • Master’s degree or relevant professional certification.
  • Experience in insurance or another regulated data environment.
  • Experience gathering and documenting business requirements.
  • Experience with enterprise data warehouses, data marts, semantic layers, or governed datasets.
  • Knowledge of data governance, lineage, data quality, and reporting governance.
  • Experience with modern data platforms such as Azure, AWS, GCP, Snowflake, or Microsoft Fabric.
  • For Lead-level consideration, experience mentoring others or improving BI development and support standards.

Applicants must be authorized to work for ANY employer in the U.S. We are unable to sponsor or take over sponsorship of an employment Visa at this time.

Benefits & conditions

Posted Yesterday In-Office or Remote Hiring Remotely in United States 101K-191K Annually Senior level In-Office or Remote Hiring Remotely in United States 101K-191K Annually Senior level Develop and support enterprise BI solutions, including dashboards, reports, governed datasets, data marts, and ETL/ELT processes. Translate business requirements into technical designs, perform data analysis and validation, troubleshoot production issues, and maintain documentation, governance, security, and data-quality standards. Lead-level candidates will guide technical decisions, mentor team members, and coordinate complex initiatives and incidents. The summary above was generated by AI

At USAble Life, every application is reviewed by a member of our recruiting team. We do not use AI to make hiring decisions. Applications are reviewed for authenticity and may be disqualified if inconsistencies, misrepresentations, or evidence of fraudulent activity are identified during the resume review and hiring process.

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., * Sr. BI Developer starting is $100,600 $125,700. The full range is $100,600 to $150,900
  • Lead BI Developer starting is $115,700 to $144,600. The full range is $127,200 to $190,800, Remote or Hybrid United States 62K-83K Annually Entry level 62K-83K Annually Entry level Fintech * Information Technology * Insurance * Financial Services * Big Data Analytics Provides centralized support to four Assistant Vice Presidents through business reporting, analytics, executive presentations, calendar and meeting coordination, expense and travel administration, leadership event support, and tracking of priorities and deliverables. The role analyzes business information, coordinates cross-functional requests, supports strategic initiatives and operational improvements, and identifies opportunities to streamline processes through automation and AI. Top Skills: ExcelMicrosoft OutlookMicrosoft PowerpointMicrosoft Word

What you need to know about the Colorado Tech Scene

With a business-friendly climate and research universities like CU Boulder and Colorado State, Colorado has made a name for itself as a startup ecosystem. The state boasts a skilled workforce and high quality of life thanks to its affordable housing, vibrant cultural scene and unparalleled opportunities for outdoor recreation. Colorado is also home to the National Renewable Energy Laboratory, helping cement its status as a hub for renewable energy innovation.

Key Facts About Colorado Tech

  • Number of Tech Workers: 260,000; 8.5% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: Lockheed Martin, Century Link, Comcast, BAE Systems, Level 3
  • Key Industries: Software, artificial intelligence, aerospace, e-commerce, fintech, healthtech
  • Funding Landscape: $4.9 billion in VC funding in 2024 (Pitchbook)
  • Notable Investors: Access Venture Partners, Ridgeline Ventures, Techstars, Blackhorn Ventures
  • Research Centers and Universities: Colorado School of Mines, University of Colorado Boulder, University of Denver, Colorado State University, Mesa Laboratory, Space Science Institute, National Center for Atmospheric Research, National Renewable Energy Laboratory, Gottlieb Institute

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.builtincolorado.com
Prepare application

Good distractions

Loading talks and stories from around this role…