Job Title: Health Intelligence Programmer - Cognos & Power BI
Location: Remote
Position Type: Contract position
Working Hours: As per EST timings
Responsibilities:
Manager Notes: The key is - technical skills with Cognos, SSRS and Power BI, the manager is looking for someone with great communication and soft skills. This person will interact with Ops directors & VP’s to understand their needs and accordingly plan deliverable and comply with the need.
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 Qualifications:
• Requires a bachelor’s degree and 4-5 years of relative experience, or an equivalent combination of education and experience.
• Requires High proficiency in SQL, well-developed analytical skills especially in Database.
• Requires High proficiency in Cognos Reporting Tool, Framework Manager and Cognos Server Administration. Additional tools preferred - SSRS, Power BI, Tableau
• Requires experience in data architecture, data modeling and performance tuning
• Requires High Proficiency with tools – Toad, DBeaver, Workbench, SSMS, SSAS, SSIS
• Requires Proficiency in Story Telling via Data Visualization and User Experience Design.
• Requires strong organizational and multitasking skills, and the ability to meet time-sensitive deadlines.
• Experience in working on Data Warehouse or similar data repository environments.
• Intermediate to advanced knowledge of Excel is required.
Preferred Qualifications:
• Master's degree preferred
• General knowledge of business operations, programs, outcomes, system inputs and outputs to support accurate reports to clients.
• Prior experience working with healthcare claims, utilization / case management data
• Knowledge or Experience in Healthcare domain or industry
• Familiarity with Visual Studio and TFS/Azure DevOps source control.
• Familiarity with agile methodology.
• Experience supporting ETL development.
• Experience in scripting languages - Unix/Shell, Python, etc.
• Experience with development methodology – Agile, SDLC in regulated industry