Business Intelligence Solution Architect

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 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.
- Familiarity with MicroStrategy.
- 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.