About the role
We are seeking an experienced and highly motivated candidate to fill a Senior Business Intelligence Engineer, Informatics & Applications position. The position will support Organogenesis’ organization wide reporting and data management needs. This role will work cross-functionally with groups throughout the company to build reporting and data collection systems in Power BI, PowerApps, the Power Platform, and Azure. The Senior BI Engineer will report to the Manager, Data Engineering & Business Intelligence and is a remote position.
How You Will Achieve It:
* Technical liaison with Data Engineering team to build databases and sources for reporting in Power BI and other tools.
* Help guide the direction of the Data Engineering team building an analytical infrastructure for BI and Analytics.
* Technical lead on complex data modeling, measure building, advanced analytics, data science, etc.
* Supports analytic efforts to translate business needs into analytic solutions that provide actionable, decision-making information throughout the organization.
* Support the Informatics & Applications Team by developing and deploying dashboards and reports in Microsoft Power BI.
* Build Power BI and PowerPivot data models using SQL Queries, DAX, M and advanced Excel functions.
* Set up and share dashboards and reports with end users through the Power BI online service.
* Support end users from all departments with questions, navigation, set up and functionality of new and current dashboards and reports.
* Extracts and manages large data sets to develop reports, leverages understanding of data warehouses and information management systems to do so effectively.
* Responsible for data investigations and queries.
* Responsible for ensuring data accuracy throughout all reports.
* Communicate with Project Managers and end users to ensure timelines are agreed upon and being met.
* Participates with varying degree of involvement in cross-functional projects as needed.
* Other requests as needed by the Manager, Data Engineering & Business Intelligence
Requirements
What You Need to Achieve It:
* 4-year college degree or equivalent work experience required.
* 5 years of Business Intelligence experience required.
* Educational background in Computer Science or Engineering, Math, Statistics, Informatics, Information Systems or another quantitative field.
* Experience with relational SQL databases, including MS SQL Server, PostgreSQL.
* Experience with Microsoft Azure cloud services: Azure Data Factory, Data Pipelines, Data Bricks, Azure Functions, Storage, SQL Database and/or Data Warehouse, etc.
* Working knowledge of the differences between different database designs and data storage techniques, i.e. Operational Database vs. Data Warehouse/Star Schema or SQL vs. NOSQL and where or why you might use each.
* Understanding of Data Lake design, implementation, and organization.
* Some familiarity with the Microsoft Dynamics 365 suite, particularly the Finance & Operations and Retail modules.
* Passion for learning new and better ways to do things – you are always tweaking your current processes and finding ways to improve them or make them more efficient.
* Willingness to take ownership of your projects and research new applications, languages, or modalities that you are not familiar with.
* Intellectual curiosity to find new and unusual ways of how to solve data management issues.
* Familiarity with Health data and the healthcare space is a big plus.