Senior Business Intelligence Engineer

Harris Computer

1d • $118,000 - $125,000

About The Position

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. Harris provides mission critical software solutions for the Public Sector, Healthcare, Utilities and Private Sector verticals throughout North America, Europe, Asia and Australia. Working for Harris is the perfect opportunity to fulfill your professional goals as well as achieve your personal dreams! Our employees enjoy a casual work environment that offers comfort while providing superior service to our customers. We offer a comprehensive benefit package as well as other additional “Perks”! We empower our employees to make a difference We have an award winning culture We offer opportunity to learn We are financially strong and we are owned by the largest software company in Canada (CSI) We have fun! Follow us on social media to learn more about our company values, culture and initiatives! Harris is an Equal Opportunity/Affirmative Action Employer. We consider applicants without regard to race, color, religion, age, national origin, ancestry, ethnicity, gender, gender identity, gender expression, sexual orientation, marital status, veteran status, disability, genetic information, citizenship status, or membership in any other group protected by federal, state or local law. If you would like to contact us regarding the accessibility of our website or need assistance completing the application process, please contact us at (1)-613-226-5511 or at [email protected] This contact information is for accommodation requests only and cannot be used to inquire about the status of applications.

Requirements

• 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

Nice To Haves

• 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.

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

Benefits

• Our employees enjoy a casual work environment that offers comfort while providing superior service to our customers.
• We offer a comprehensive benefit package as well as other additional “Perks”!
• We empower our employees to make a difference
• We have an award winning culture
• We offer opportunity to learn
• We are financially strong and we are owned by the largest software company in Canada (CSI)
• We have fun!

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level