Business Intelligence Solution Architect
Overview:
We seek a skilled Business Intelligence Solution Architect to join our Research & Development (R&D) department, reporting to the Development Manager of our BI and Database Administration (DBA) teams at Ingenious Med. This role involves hands-on architecture, designing and implementing new features, and optimizing existing BI solutions. Responsibilities include data modeling, developing data ingestion and integration strategies, implementing best practices, and evaluating new BI platforms. The Technical Lead will collaborate closely with developers and DBAs within a small Agile SCRUM team, providing technical leadership and mentorship.
Key Responsibilities:
- Gain a thorough understanding of existing Ingenious Med solutions.
- Take ownership as a technical lead, guiding existing solutions toward target architectures.
- Participate in team design discussions to address new BI requirements.
- Deliver quality code to meet assigned requirements and user stories.
- Thoroughly test functional units of code before committing to source control.
- Assist with system integration, regression, and performance testing as needed.
- Identify opportunities for new tools to improve integration processes.
- Troubleshoot production issues and provide third-tier support when necessary.
- Engage in continuous learning to stay current with new technologies.
Key Competencies:
- Strong work ethic and commitment to quality results.
- Excellent analytical and problem-solving skills.
- Outstanding written and oral communication abilities.
- Ability to manage multiple projects simultaneously in an organized manner.
- Capacity to explain complex technical concepts in simple terms when needed.
- Adaptability to shifting priorities and effectiveness in a fast-paced environment.
- Team-oriented and highly collaborative.
- Provide technical leadership and mentorship to BI developers.
- Ensure security, scalability, and performance optimization of BI solutions.
Required Qualifications:
- Bachelor’s Degree in Computer Science or a related field.
- 7+ years of experience in BI, data engineering, or analytics roles.
- 5-7 years of experience with SQL Server and T-SQL.
- 3-5 years of experience with ETL data ingestion pipelines.
- 2-4 years of experience with MicroStrategy.
- 2-4 years of experience with Power BI.
- 2-4 years of experience with SSRS.
- 2-4 years of experience with SSIS.
Preferred Qualifications:
- Experience with source control systems.
- Proficiency with Visual Studio and Azure DevOps (ADO).
- Experience with Azure or other cloud platforms.
- Coding experience in object-oriented languages such as Java or C#.
- Scripting experience with PowerShell or Python.
- Knowledge of HIPAA and healthcare industry standards.
This position offers an opportunity to lead and innovate within our BI initiatives, contributing significantly to our organization's success.
Top Skills
What We Do
For over 25 years, Harris Healthcare has been rising to the challenge of bringing together the most innovative and sustainable solutions for today’s ever-changing healthcare environment, in order to improve patient care and safety. Each one of our solutions brings organizational efficiencies on its own. Powerful synergies are achieved when multiple solutions are implemented together. The Harris Healthcare portfolio includes the following solutions:
♦ HARRIS Flex - an enterprise-level EHR solution that improves patient safety and clinical workflows. It includes a full complement of applications integrated in one single database, provides solid clinical decision support to your clinicians and helps standardize care while enforcing protocols and best practices at any Healthcare Organization. HARRIS Flex conveys the digital solution’s flexibility and strength.
Healthcare organizations are continuously faced with new challenges and situations and require flexible EHR’s that can be rapidly adapted to their evolving clinical practice. Contrary to other EHR solutions which are inflexible and where customizations require costly support from the vendor, HARRIS Flex gives you the freedom to "flex" your EHR as you need it entirely on your own.
The enhanced HARRIS Flex solution comes with new functionality including:
♦Flex Telehealth which enables virtual visits directly from within the EHR/EPR, and
♦Flex Clinical Insight which facilitates extraction and analysis of your EHR/EPR data to improve your processes and outcomes.
♦ SynergyCheck – a proactive interface monitoring solution watching over Clinical, Financial and other interfaces 24/7 to ensure data is flowing between systems
