SQL/ Power BI Developer

Reporting Developer

About this Role:

We are seeking a detail-oriented and analytical Reporting Developer to join our team. The ideal candidate will be responsible for collecting, analyzing, and presenting data-driven insights to support business decisions. This role requires knowledge of healthcare data ((Eligibility, Claims processing & Reimbursements, Benefits Configuration etc.), strong analytical skills, proficiency in data visualization tools, and the ability to communicate findings effectively to stakeholders.

Responsibilities

Implement the reporting responsibilities in the data warehouse

• Design report solutions that align with data management principles, policies, standards and best practices
• Support reporting cycles (i.e. daily, weekly, monthly)
• Adhere and develop all documentation standards, development lifecycle tasks, and status reporting requirements
• Efficiently deliver high-quality solutions through formalized technical design documents and specifications, proactive testing and on-going quality monitoring
• Work under the direction of the Manager to provide technical application solutions for assigned business areas.
• Identify the common causes of the defects, prioritize them and systematically remove them so that they do not reoccur in further development work.
• Possess technical knowledge of assigned application technology.
• Work with Business Analyst to understand the customers product-specific requirements and configuration and translate them to technical design specifications and data flow from which programs are developed and coded.
• Codes, tests, debugs, implements, and documents programs or technical configuration.
• Ensure programs meet technical specifications and standards.
• Interact with Business Analysts during the software build or configuration and testing process.
• Perform technical application configuration and configure /run reports at user request.
• Design and execute unit, system and integration test plans for new developments/releases/reports.
• Manage and support team members for requests with reporting services (SSRS) and support some SSIS functions.
• Maintain technical documentation based on standard operating procedures in support of the assigned application.
• Perform application maintenance activities.
• Provide production support.
• Interface with Business Analyst to assist in resolving support calls escalated by the Service Desk.
• Collaborate with different teams to understand reporting requirements and deliver solutions accordingly.
• Automate and optimize reporting processes to improve efficiency and accuracy.
• Ensure data integrity and accuracy by performing regular audits and validation checks.

Skills and Qualifications

• Bachelor's or Master's Degree (preferred) in Computer Science or related field.
• Minimum 5 years of experience in SQL and report development
• Proficient in MS SQL Server 2014/2016/2019 MS SQL SERVER including T-SQL, SSRS, Excel, and data visualization tools such as Tableau, Power BI, or similar.
• Effective troubleshooting and performance tuning skills - should be able to identify and resolve moderate performance issues.
• Demonstrated understanding of relational database design and architecture.
• Demonstrated ability to develop online reporting solutions that meet business need.
• Experience designing and building interactive and visual dashboards for delivering information for senior leadership.
• Strong communication (written and verbal) and analytical skills.
• Ability to organize, plan, and carry out multiple concurrent objectives or activities, and effectively make judgments in prioritizing and time allocation.
• Ability to work independently as well as under the direction of senior team members.
• Ability to communicate complex data insights in a clear and concise manner.
• Strong organizational skills and the ability to manage multiple tasks simultaneously.