As a Business Intelligence (BI) Engineer, you will play a crucial role in the design, development, and maintenance of data-driven solutions that enable effective decision-making within the organization. Leveraging your technical expertise and analytical mindset, you will collaborate with stakeholders to understand their reporting and data analysis requirements and translate them into robust and scalable BI solutions. This position requires a strong foundation in data analysis, proficiency in BI tools and technologies, and a passion for transforming raw data into meaningful insights.This role will be a hybrid role working 3 days per week (Tuesday, Wednesday, Thursday) out of our Deerfield, IL HQ, using Monday and Friday as remote optional days. Key Responsibilities:1. Solution Development:· Design, develop, and implement BI solutions using SQL, ETL tools, and data visualization platforms.· Gather requirements, define data models, and ensure data accuracy and integrity.· Optimize database structures, queries, and ETL processes for improved performance.2. Report and Dashboard Development:· Create visually appealing and user-friendly reports, dashboards, and data visualizations using BI tools.· Collaborate with users to understand reporting needs and provide self-service reporting capabilities.· Enhance and optimize existing reports and dashboards.3. Data Modeling and ETL:· Create specifications for data models to support business use cases.· Partner with Data Engineers to ensure effective ETL processes.· Ensure data quality through cleansing, validation, and error handling.4. Data Analysis and Insights:· Perform data analysis and mining to uncover patterns and trends.· Collaborate with stakeholders to understand analytical requirements and provide actionable insights.· Develop statistical models and predictive analytics for decision support.5. Data Governance and Security:· Ensure compliance with data governance policies and data security standards.· Collaborate with data stewards and IT teams to establish and enforce governance standards.· Conduct data profiling and analysis to identify and resolve data quality issues.
