Senior Business Intelligence Engineer
United States
Job Req code 637
Category: Information Technology
About Us
We are a leading regenerative medicine company in the advanced and acute wound care space and are always looking for exceptional talent. Join a company where you will have an opportunity to grow professionally and personally and give strength to others by Empowering Healing. Our advanced wound care products are specially developed for the successful treatment of chronic and acute wounds. Our comprehensive portfolio of skin substitutes and other regenerative medicine products empower our patients with life-changing solutions. Our mission is to advance healing and recovery beyond expectations.
What You Will Achieve:
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.
The anticipated annualized base salary for this role is $140,000 - $155,000 and reflects current market data for similarly-sized life science companies and internal equity. Organogenesis is a multi-state employer, and this salary range may not reflect positions that work in other states. Base salary is part of our total rewards package which also includes the opportunity for merit-based increases, eligibility for our 401(k) plan with competitive company match, medical, dental, vision, education assistance, life and disability insurances and leaves provided in line with your work state and federal law. Our time-off policy includes paid vacation days, paid company holidays, and paid sick time. Total compensation, including base salary to be offered, will depend on elements unique to each candidate, including candidate experience, skills, education, and other factors permitted by law.
We are an equal opportunity/affirmative action employer. All qualified applicants will receive consideration for employment without regard to age, sex, gender identity, sexual orientation, race, color, religion, national origin, disability, protected veteran status, genetic information or any other characteristic protected by law.
We do not accept unsolicited agency resumes and we are not responsible for any fees related to unsolicited resumes.