Business Intelligence Developer

$110,000 - $130,000/Yr

Topcon Healthcare - Oakland, NJ

Full-time - Mid Level

Oakland, NJ

About the position

The Business Intelligence Developer at Topcon Healthcare is responsible for building and maintaining business reports, managing the Data Warehouse, and facilitating integrations between various systems. This role requires translating business needs into technical specifications and ensuring data accuracy across multiple sources. The ideal candidate will have extensive experience in BI technologies and a strong understanding of data architecture, enabling the organization to make informed decisions based on accurate data analysis.

Responsibilities

• Translate business needs/requirements to technical specifications and engage with internal users to deliver the best solutions.
• Work with multiple data sources (including legacy data sources) and ensure source of truth is correct.
• Define, design and build BI solutions that enable the business to make decisions.
• Work with integration tools to ensure data is up to date.
• Collaborate with 3rd party vendors on larger projects to meet business needs.

Requirements

• At least 7 years of experience as a Report Developer or BI Developer working with Microsoft SQL Server.
• Background in data warehouse design (dimensional modeling, data mining, etc.).
• Understanding of Microsoft Data Architectures (MS SQL Server, Databricks, Data Fabric).
• Hands-on experience with BI technologies such as Microsoft Power BI, Tableau, etc.
• Experience with SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS), SSMS, and other database platforms and tools.
• Experience with SAP By Design is a plus.
• Must be detail oriented with excellent analytical and creative problem-solving skills.
• Excellent understanding of the organization's goals and objectives.
• Excellent listening, interpersonal, written, and oral communication skills.
• Proficient on MS Office Tools.

Nice-to-haves

• Experience with SAP By Design is a plus.

Benefits

• 401(k) matching
• Dental insurance
• Disability insurance
• Health insurance
• Life insurance
• Paid holidays
• Paid sick time
• Tuition reimbursement
• Flexible paid time off policy