Business IntelligenceParticipates in evaluation and selection of Semantic Layer Modeling and BI tools.Participates in documentation and understanding of scoped source systems for identification of key business functions & domain information.Participates in documenting, designing, developing, testing and deploying the Data Models and Business Layers that comes from various source systems integrated into the Enterprise Data warehouse.Using the data flow design, develops and maintains the BI semantic Layer scripts that acquire data from underlying data model to load information into business layer.Identifies and develops opportunities to utilize objects and code where appropriate to reduce development effort and enforce consistent business rules.Identifies opportunities for analysis and reporting solutions within the company.Providing technical leadership, strategizing effort distributions and supervising team assignments.Acting as a liaison between Project Management and technical team for successful project deliveries.Enterprise Data Warehouse /ETLIdentify important business features & information to be sourced into enterprise data warehouse responsible for Reporting and Analytical insights.Work closely with the Data Integration team to translate data available in the EDW into business requirements initiated by client.Supports Data Integration team in establishing datasets, ADS and data snapshots.Translates business requirements into technical Business and Framework Model(s).Contributes to the overall technical development of the team within the company.Provides valuable input and feedback to the vision of the overall department and company’s strategy.Communicates and promotes healthy, responsible and goal-oriented work culture within the company.Reporting & DraftingClearly documents all development to company standards.Assists in establishing new standards and processes for ETL/BI data modeling.

Data analysis projects that involved business decision-makingNew analytics models developed and implemented that were driven by or fulfilled key business needsEvents where you provided subject matter expertiseAll data management experience, Collect data from sales, marketing, and finance departments to use in establishing organizational structure.Organize, extrapolate, and disseminate data across departments to be used for drawing conclusions about the success of current methods.Present detailed reports about the meaning of gathered data to members of management and help them identify scenarios utilizing modifications in the data.Building Analysis Services reporting models.Developing visual reports, KPI scorecards, and dashboards using Power BI desktop.Connecting data sources, importing data, and transforming data for Business intelligence.Analytical thinking for translating data into informative reports and visuals.Capable of implementing row-level security on data along with an understanding of application security layer models in Power BI.Expert in using advanced-level calculations on the data set.Responsible for design methodology and project documentaries.

Identifying data sourcesCollecting dataSourcing missing dataOrganising data in to usable formatsAnalysing data to find answers to specific questionsSetting up data infrastructureDeveloping, implementing and maintaining databasesAssessing quality of data and removing or cleaning dataGenerating information and insights from data sets and identifying trends and patternsPreparing reports for executive and project teamsCreating visualisations of data

Assess current database for weaknessesUpgrade current system or propose a new designPerform data entry to transfer informationEnsure the security of our dataProvide technical support to employees