Business Intelligence Solution Architect

SENIOR BUSINESS INTELLIGENCE (BI) ENGINEER

JOB SUMMARY:

We are looking for a skilled Sr BI Engineer who exemplifies the key competencies laid out below. This person will serve as an extension of the Ingenious Med R&D department reporting to the development manager of our BI and DBA teams.

This position will serve as a hands-on engineer to design and implement new features and optimize existing solutions. This includes data modeling, ingestion and integration strategies, implementing best practices, and analysis of new BI platforms. In this role, you will work closely with developers and DBAs in a small Agile Scrum team. This position will use their expertise to assist developers in resolving production issues as well as lead, design, and assist in technical decisions on all new BI projects as defined by our Product team. Once project requirements have been provided, this position will serve as a project lead by seeing new initiatives through QA, UAT, and production contributing to larger team goals.

ESSENTIAL DUTIES AND RESPONSIBILITIES:

• Develop a solid understanding of existing Ingenious Med solutions
• Develop a sense of ownership as a technical lead, moving existing solutions toward target architectures
• Provide guidance and mentorship to junior team members
• Participate in team design discussions addressing new BI requirements
• Participate in cross-functional team discussions to identify business risks and opportunities, and contribute to the overall data strategy
• Deliver quality code to satisfy all requirements/user stories as assigned
• Fully test functional units of code before committing to source control
• Create clear documentation for reports, application design, and processes
• Assist with system integration, regression, and performance testing as needed
• Identify opportunities for new tools to improve integration processes
• Troubleshoot production issues and serve as third-tier support when needed
• Conduct regular self-guided study to stay current on new technologies

TRAVEL REQUIREMENTS

• None

KEY COMPETENCIES

• Strong work ethic and dedication to quality results
• Solution focused with outstanding analytical and problem-solving skills
• Proactively takes initiative and ownership in areas of opportunity
• Ability to design and implement effective data models for data accuracy and integrity
• Excellent written and oral communication skills
• Ability to work on several projects in parallel in an organized manner
• Ability to explain complex technical concepts in layman’s terms when needed
• Adaptable to shifting priorities and works effectively in a fast-paced environment
• Team oriented and very collaborative
• Provide technical leadership and mentorship to BI developers
• Ensure security, scalability, and performance optimization of BI solutions

REQUIRED QUALIFICATIONS

• Bachelor’s Degree, preferably in Computer Science or related field
• 7+ years of experience in BI, data engineering, or analytics roles
• 5-7 years in SQL Server, TSQL
• 3-5 years of ETL data ingestion pipelines
• 2-4 years in Power BI Embedded
• 2-4 years in SSRS
• 2-4 years in SSIS

NON-REQUIRED QUALIFICATIONS

• Source Control Experience, preferably Git
• Visual Studio and ADO
• Azure or other Cloud platforms
• Strategy (formerly known as MicroStrategy)
• Coding in OO language Java/C#
• Scripting PowerShell/Python
• Agile Scrum
• HIPAA/Health Care
• Experience with migration from Strategy to Power BI Embedded a plus
• The ideal candidate has experience migrating data platforms or being involved in creating data platforms from the ground up.

ADDITIONAL INFORMATION

This summary is not an all-inclusive description of job duties. Other job duties and responsibilities may also be assigned by the incumbent’s manager at any time based upon Company need.

ABOUT US

Ingenious Med is a healthcare technology company dedicated to enhancing physician productivity and hospital performance through intuitive, point-of-care tools. Their easily implemented web and mobile solutions assist physician practices and health systems in optimizing revenue, gaining valuable data insights, and automating workflows. By integrating seamlessly with existing Electronic Health Records (EHRs), Ingenious Med empowers healthcare providers to manage practices more effectively, ensuring high-quality care at reduced costs. With over 20 years of experience, they have partnered with a diverse range of healthcare organizations, including national health systems, regional hospitals, and large physician management groups. Their commitment to innovation and excellence has made them a trusted partner in the healthcare industry.

SALARY RANGE

The hiring range for this role is $118,000 to $125,000 USD per year. Final compensation will be based on experience, skills, market conditions, and internal equity.