BI Engineer

Description

The BI Engineer is responsible for designing, developing, and implementing custom business intelligence solutions for Clearwaters IRM|Pro platform customers. This role requires strong technical skills in data modeling, ETL processes, data lake architectures, and visualization frameworks.

Specific Job Responsibilities

• Design and develop custom BI solutions and self-service reporting platforms for IRM|Pro customers.
• Build interactive dashboards, data visualizations, and analytical tools using modern frameworks and libraries.
• Modernize and replace legacy Crystal Reports implementations with contemporary BI solutions.
• Design and implement data models optimized for reporting and analytics from both relational databases and data lake sources.
• Develop ETL/ELT pipelines to transform and prepare data from multiple sources including data lakes.
• Architect and implement data lake solutions for scalable, future-proof analytics capabilities.
• Create intuitive self-service interfaces that enable non-technical users to generate custom reports and dashboards.
• Implement role-based access controls and data security measures in BI solutions.
• Optimize query performance and data retrieval for large-scale reporting operations across diverse data sources.
• Build embeddable analytics components that integrate seamlessly into the IRM|Pro platform.
• Translate customer business requirements into technical BI specifications and solutions.
• Develop documentation for BI solutions and self-service reporting capabilities.
  
  

5+ years of experience designing and implementing BI solutions and reporting platforms.

• 3+ years of experience with data modeling, data warehousing, and dimensional modeling concepts.
• Experience with data lake technologies and modern data architectures (AWS S3, Azure Data Lake, or similar).
• Experience building custom dashboards and visualizations using modern frameworks (D3.js, Chart.js, Plotly, or similar).
• Experience with ETL/ELT processes and data pipeline development for both relational and non-relational data sources.
• Strong SQL experience with complex query optimization.
• Experience with data lake query engines (AWS Athena, Presto, Spark, or similar).
• Experience building self-service reporting solutions for end users.
• Experience replacing or modernizing legacy reporting systems (Crystal Reports, SSRS, or similar).
• Experience with REST API integration for data retrieval and delivery.
  
  

Requirements

Bachelors degree in Computer Science, Information Technology, Data Science, Business Analytics, or related field (or equivalent practical experience).

Strong understanding of data architecture, data modeling, and dimensional design patterns (star schema, snowflake schema).

Deep knowledge of SQL, query optimization, and database performance tuning.

Understanding of modern data lake architectures, data lakehouse concepts, and cloud-native storage patterns.

Understanding of data security, role-based access control, and compliance requirements (HIPAA, NIST).

Proficiency In The Following Technologies

• SQL and advanced query optimization techniques
• MariaDB/MySQL database systems
• Data lake technologies (AWS S3, Azure Data Lake, or Google Cloud Storage)
• Data lake query engines (AWS Athena, Presto, Apache Spark, or similar)
• Data visualization frameworks and libraries (D3.js, Chart.js, Plotly, Highcharts, or similar)
• Frontend technologies (JavaScript, TypeScript, HTML5, CSS3)
• Modern JavaScript frameworks (React, Angular, or Vue.js)
• ETL/ELT tools and data pipeline development
• RESTful API design and integration
• Git and version control systems
• Data modeling and schema design (relational and non-relational)
• Python or similar scripting languages for data processing
  
  

Familiarity with AWS services (S3, Athena, Glue, RDS, QuickSight), Docker containerization, BI tools (Tableau, Power BI, Looker for reference), Angular framework, Parquet and columnar storage formats, healthcare/compliance data, data governance practices, and embedded analytics patterns.

---