Business Information Consultant
Core
Develops and maintains reporting databases and ETL solutions, creates operational and financial reports and KPI dashboards, and supports data warehouse architecture.
Role type
Senior Business Information Consultant (Data Engineering & Reporting)
Builds
Operational and financial reporting solutions, KPI dashboards, and data warehouse components for healthcare members.
Domain
Healthcare / Data Engineering & Business Intelligence
Deliverable
production ML models | product features | dashboards & analysis
Required skills
SQL Server (TSQL), ETL development (SSIS, Informatica), Data Warehouse Architecture, Tableau, Agile/Scrum methodologies, Code deployment, Workflow automation (JIRA, ServiceNow)
Preferred skills
Mentorship of junior associates, Subject matter expertise in complex data architecture
Technologies
SQL Server, SSRS, Tableau, SSIS, Informatica, Tidal, Control-M, Subversion, Bitbucket, TFS, JIRA, ServiceNow
Responsibilities
Develop database objects (Stored Procedures, Functions, Views, Tables); Facilitate automation of manual reporting via ETL packages; Analyze data sources for end-to-end reporting solutions; Maintain reporting database integrity; Participate in peer reviews and UAT; Develop financial and operational KPI dashboards; Mentor junior associates on databases and applications.
Seniority
Senior, hands-on IC with mentorship responsibilities