ComplexCare Solutions is looking to build a next generation data & reporting platform to provide insights & forecasting to understand the current state of business, improve decision-making for tactical and strategic goals & KPIs.
Requirements
- Hands-on SQL, data & reporting tools (Power BI) and databases (MS SQL Server)
- 10+ years of experience in design and architecture of data warehouse, ETL, data exports, analytics & reporting
- 5+ years of experience in Microsoft SQL Server, SQL, SSIS packages
- 2+ years of experience in Databricks pipeline, lakehouse, Unity Catalog, DLTs etc.
- 3+ years of experience in application development using Angular, .Net, APIs
- 3+ years on designing reporting on Power BI analytics tool and web application
- 3+ years’ experience working on Azure Cloud is preferred utilizing ADF (Azure Data Factory), Azure Delta Lake, Azure SQL Server, Data Sync, Log Insights and Analytics
Responsibilities
- Collaborate with business stakeholders, product owners, business analysts to understand various LOBs data and reporting needs to create architecture & design for data & reporting platform on Azure Public Cloud.
- Architect & design end to end platform components including data ingestion, ETL, data warehouse (star, snowflake, traditional), data export framework, data marts, data analytics & visualization design on Power BI.
- Create quality diagrams (architecture, component, flow, contextual etc.) and detail design documents & groom user stories for engineers to work.
- Design various components of data & reporting platform including data ingestion pipeline, validation & cleansing framework, data warehouse, data marts/sets, data export to generate files & populate data marts utilizing MS SQL Server and ADF (Azure Data Factory) or like technologies.
- Design optimized & organized data marts for data analytics and visualization with SQL Server and Power BI.
- Design custom web app for custom query, confirmation management, role management and embed Power BI dashboards and custom export & query framework.
- Lead performance improvement efforts utilizing caching techniques, API integrations & SQL queries to load large amount of data.
Other
- Minimum 10 years of relevant industry experience in data & reporting field, Healthcare experience is big plus
- Bachelor's degree in Computer Science or a related technical field preferred.
- Travel for this position will include less than 5% locally usually for training purposes.
- Manage stressful situations with calm, courtesy, and confidence
- A penchant for thinking outside the box to solve complex and interesting problems
