BI Engineer

Description

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.
  

• 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

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