Senior Cognos Developer - BI (Healthcare)

Metasys Technologies; United States; On-site; USD 85,000 - 110,000; Full time

Job summary

Metasys Technologies is seeking a hands-on Data Reporting Specialist to develop, enhance, and maintain core data processing platforms. You will query databases to build data models and create reporting applications for actionable insights, while ensuring secure, auditable reporting processes.

The role emphasizes 70% programming with strong SQL/PL-SQL skills, plus collaboration with operations, marketing, research, and IT to deliver reliable reports and data-driven decisions.

Qualifications

• Very strong SQL skills.
• Strong experience with PL/SQL programming, stored procedures, and maintaining legacy code.
• Experience troubleshooting applications and improving maintainability and sustainability.
• Ability to walk stakeholders through technical solutions and reporting insights.
• Strong presentation and data visualization skills.
• Excellent communication and stakeholder management abilities.
• Hands-on coding role (70% programming).
• Collaborate with operations, marketing, research and IT to achieve results.

Responsibilities

• Design, develop, and deploy enterprise and external client grade reports.
• Administer, configure, monitor reporting platforms, security, and upgrades.
• Manage report security, access, archival, retention, and audits.
• Collaborate with cross-functional teams to drive business results.
• Prepare accurate reports providing leadership with insights for decisions.
• Profile data independently and test output; produce support documentation.
• Investigate data discrepancies and troubleshoot SQL and ETL processes.
• Communicate data analysis outcomes to managers and stakeholders.

Skills

SQL

PL/SQL

Data analysis

Data visualization

Stakeholder management

Tools

SSIS

SQL Server

Oracle

Job description

This position is responsible for developing, enhancing, and maintaining the core data processing platforms of the company, driving business solutions by querying existing databases to create data models for actionable reporting, and creating and maintaining reporting applications that result in efficient data extraction.

Responsibilities:

• Responsible for designing, developing reports, analyzing raw data and identifying data and report discrepancies and deploying Enterprise and External Client grade critical Reports
• Responsible for administering, configuring, managing and monitoring reporting platforms, security, processes, identifying and troubleshooting issues, managing upgrades
• Responsible for managing report security, access, archival, retention, assistance in audits
• Collaborate with various function teams such as operations, marketing, research, and IT to achieve business results
• Prepare accurate and relevant reports that provide insight regarding key points for leadership and clients
• Able to independently profile data and test output and, produce support documentation
• Research data discrepancies, performance and troubleshoots SQL Code, underlying transformations, SSIS Packages, views, stored procedures
• Utilize reporting methodology to communicate needs to Data Analysts for report programming
• Communicate the results of data analysis in written and verbal form to managers and changes in financial and business trends for leadership decision making
• Read, understand, and adhere to all corporate policies including policies related to HIPAA and its Privacy and Security Rules
• Mentor Juniors, Train peers and, adopt and share Best Practices with the team
• Able to communicate with stakeholders, manage expectations and prioritize deliverables

Required Qualification

• Very strong SQL skill
• Strong experience with PL/SQL programming, stored procedures, and maintaining legacy code
• Experience troubleshooting applications and improving maintainability and sustainability
• Ability to walk stakeholders through technical solutions and reporting insights
• Strong presentation and data visualization skills
• Excellent communication and stakeholder management abilities
• This is a hands-on coding role
• 70% Programming
• 30% Communication and solution discussions with stakeholders