- Work closely with Business Analyst teams to understand their information needs, ensuring that BI solutions are an excellent fit for their evolving needs.
- Build ETL and data pipelines from various data sources to transform it into easy to use datasets.
- Performance Optimization of SSIS packages, Stored Procedures, complex SQL Queries
- Creation/Maintenance of ETL mapping documents.
- Designing and processing of Data Cubes for analysis and data mining using Star Schema/Snow Flake Schema.
- Contribute to the development of the BI team’s tools, skills, culture and impact for Business and for CareStack.
- Provide strategic and tactical guidance with respects to data warehousing/data mart best practices.
- Coordinate with the development team to translate business requirements into technical specifications for custom development and systems integration requirements.
- Manage, drive and deliver multiple BI work-streams, both on an ongoing and ad-hoc basis.
- Work with Engineering partners to help shape and drive the development of data warehousing, reporting and analytics platforms.
- Maintain and guide the technical architecture, standards and infrastructure of the technologies and tools used in the BI program.
- Lead the data warehouse maturity with continuous improvement towards an enterprise data model.
- Hands on experience in Data Warehouse design and management
- Knowledge in creating Power BI custom visualizations