Senior BI Engineer: Data Warehousing & Dashboards

Coral Connect LLC; Utah; On-site; USD 100,000 - 150,000; Full time

Job summary

Coral Connect LLC is seeking a Senior BI Analyst/Database Engineer to design, build, and optimize data infrastructure and reporting solutions that empower cross-functional decision-making. You will own BI dashboards, data models, and ETL pipelines, collaborating with Finance, Operations, and other teams to deliver scalable data products.

The role emphasizes data quality, governance, and automation, with a focus on reliable analytics across critical business areas.

Qualifications

• Bachelor’s degree in Mathematics, Statistics, Information Systems, Computer Science, Data Analytics, Data Science, or a related field.
• 5+ years of professional experience in business intelligence, analytics, data engineering, database development, or a related field.
• Advanced experience with Power BI, including dashboard development, data modeling, DAX, Power Query, and performance optimization.
• Advanced SQL skills and experience developing and maintaining relational databases, data warehouses, and analytical data models.
• Experience developing and optimizing ETL/ELT processes and integrating data from multiple source systems.
• Experience with data validation, reconciliation, quality controls, and business-critical reporting.
• Experience managing data and analytics projects through requirements, development, testing, and implementation.
• Experience working with financial and operational data, including accounting, budgeting, forecasting, revenue cycle, procurement, or similar functions, preferred.

Responsibilities

• Design, develop, and optimize Power BI dashboards, scorecards, paginated reports, and automated reporting solutions.
• Develop and optimize data models, data warehouses, and ETL processes to improve the speed, reliability, and scalability of reporting and analytics.
• Support reporting and analytical needs across accounting, budgeting and forecasting, KPI reporting, operational performance, and other key business functions.
• Develop and maintain scalable business intelligence databases and reusable data products, including governed datasets, metrics, and dashboards.
• Partner with business stakeholders to translate reporting and analytical requirements into effective technical solutions.
• Lead data-related projects from requirements gathering and solution design through development, testing, documentation, and implementation.
• Maintain data quality, validation, and reliability standards within the BI Data Warehouse, particularly for critical business areas including Pharmacy and Medical Rebates, Group Purchasing, Procurement, and Revenue Cycle.
• Identify opportunities to automate manual reporting and data processes, improving efficiency and reducing reliance on manual data manipulation.
• Troubleshoot data and reporting issues, identify root causes, and implement sustainable solutions.
• Maintain documentation of data models, reporting logic, business rules, and technical processes.
• Provide technical guidance and promote best practices across the BI team.

Skills

Relational database design

Dimensional modeling

Data warehousing

BI architecture

Analytical thinking

Data quality/validation

Communication skills

Project management

Stakeholder collaboration

Independent work

Education

Bachelor's degree in Mathematics, Statistics, Information Systems, Computer Science, Data Analytics, Data Science, or related field

Tools

Power BI

DAX

Power Query

SQL

Data modeling tools

Job description

Coral Connect LLC is seeking a Senior BI Analyst/Database Engineer to design, build, and optimize data infrastructure and reporting solutions that empower cross-functional decision-making. You will own BI dashboards, data models, and ETL pipelines, collaborating with Finance, Operations, and other teams to deliver scalable data products.

The role emphasizes data quality, governance, and automation, with a focus on reliable analytics across critical business areas.