Business Intelligence Solution Architect

 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 


* Participate in team design discussions addressing new BI requirements 


* Deliver quality code to satisfy all requirements/user stories as assigned 


* Fully 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 serve as third tier support when needed 


* Conduct regular self-guided study to stay current on new technologies 

 KEY COMPETENCIES 


* Strong work ethic and dedication to quality results 


* Outstanding analytical and problem-solving skills 


* Excellent written and oral communication skills 


* Ability to work 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


* 2-4 years in SSRS 


* 2-4 years in SSIS 

NON-REQUIRED QUALIFICATIONS 


* Source Control Experience 


* Visual Studio and ADO  


* Azure or other Cloud platforms 


* MicroStrategy 


* Coding in OO language Java/C#  


* Scripting PowerShell/Python 


* HIPPA/Health Car