ENT and Allergy Associates, LLP is looking for a Data Engineering Analyst who thrives in managing databases and turning complex data sets into meaningful insights that drive business decisions. This role will support the day-to-day operation and maintenance of our data warehouse. They will monitor the health, performance, and configuration of the system. They will also be heavily involved in creating data driven business analysis solutions, developing automated KPI dashboards and creating reports to monitor practice and provider performance. This role will work closely across all business functions, to investigate data and analysis and deliver solution prototypes; collaborate with other developers to ensure incremental DataMart additions deliver high value insights for answering key strategic business questions.

Essential responsibilities Include but are not limited to the following:

Responsibilities

• Develop, enhance, maintain, and integrate Data Warehouse/DataMart and Business Intelligence Solutions
• Month end reconciliation between EHR/EMR system and Data Warehouse
• Monitor system health and performance
• System configuration and integration with other systems
• Create and edit queries and stored procedures using SQL
• Develop and Implement ETL processes
• Develop technical specifications and design documents
• Automate and deploy daily, weekly, and monthly reports
• Create ad-hoc reports for on-demand business questions and needs
• Create and maintain agent jobs with SSIS/SSRS
• Perform off-hours maintenance as required
• Assess the effectiveness and accuracy of new data sources and data gathering techniques
• Develop custom data models and algorithms to apply to data sets
• Develop and maintain new and existing dashboards for various level stakeholders within Tableau
• Recommend opportunities for optimized data reporting and analysis

Requirements:

• Bachelor's Degree with specialization in Computer Science, Statistics, or related field.

• Experience with data visualization a plus ie Tableau, PowerBI etc.
• Ability to present ideas in user-friendly language.
• Highly self-motivated and directed.
• Keen attention to detail.
• Proven analytical and problem-solving abilities.
• Ability to effectively prioritize and execute tasks in a high-pressure environment

Other Duties

Please note this job description is not designed to cover or contain a completely comprehensive listing of activities, duties, or responsibilities that are required for this position. Duties, responsibilities, and activities may change at any time, with or without notice