***This is a W2 opportunity, and candidates who don't require visa sponsorship are allowed to apply for this role
Title: BI Programmer - Cognos (Healthcare Business Intelligence)
Terms of Employment
W2 Contract, 12 Months
This is a Remote Opportunity
Overview
Our Client is looking for a Senior Health Intelligence Programmer who 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 Skills & Experience
Bachelor s degree and 4-5 years of relative experience, or an equivalent combination of education and experience.
High proficiency in SQL, well-developed analytical skills especially in Database.
High proficiency in Cognos Reporting Tool, Framework Manager and Cognos Server Administration. Additional tools preferred - SSRS, Power BI, Tableau.
Experience in data architecture, data modeling and performance tuning.
High Proficiency with tools Toad, DBeaver, Workbench, SSMS, SSAS, SSIS.
Proficiency in Story Telling via Data Visualization and User Experience Design.
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.
Preferred Skills & Experience
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.