Senior Business Intelligence Engineer
Role details
Job location
Tech stack
Job description
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., * 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, 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.
Requirements
- 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, * 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, * 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.