Fullstack BI Reporting Lead

Role Summary

&

Role Description

This role is for a BI Full stack Developer. Candidate should be very strong in SQL,TSQL/PLSQL, Analyzing, develop and work closely with the team on any issues.

Key Responsibilities:

Formulate automated reports and dashboards using OpenText (Actuate), Jasper and Power BI reporting tools.Understand business requirements to set functional specifications for reporting applications.You should be familiar with SSRS and TSQL, Power Query, MDX, PowerBI, and DAX are just a few of the tools and systems on the MS SQL Server BI Stack.Exhibit a foundational understanding of database concepts such relational database architecture, multidimensional database design, and moreDesign data models that transform raw data into insightful knowledge by understanding business requirements in the context of BI.Develop technical specifications from business needs, and choose a deadline for work completion.Make charts and data documentation that includes descriptions of the techniques, parameters, models, and relationships.Developing Power BI desktop to create dashboards, KPI scorecards, and visual reports.Establish row-level security on data and comprehend Power BI's application security layer models.Examine, comprehend, and study business needs as they relate to business intelligence.Design and map data models to transform raw data into insightful information.Create dynamic and eye-catching dashboards and reports using Power BI.Make necessary tactical and technological adjustments to enhance current business intelligence systemsIntegrate data, alter data, and connect to data sources for business intelligence.Provide production support as needed.End to end understanding of software architecture, design, development and implementation.Continuous integration and build process, test automation and deployment.

Core/Must have skills

Strong Hands-On experience using Scrum, Agile modeling and adaptive software development.Minimum 10 years of development experience using Databases and BI toolsknowledge of data warehousing, data gateway, and data preparation projectsArticulating, representing, and analyzing solutions with the team while documenting, creating, and modeling themKnowledge of executing DAX queries on the Power BI desktopComprehensive understanding of data modeling, administration, and visualizationCapacity to perform in an atmosphere where agility and continual development are prioritizedDetailed knowledge and understanding of database management systems, OLAP, and the ETL (Extract, Transform, Load) frameworkAwareness of BI technologies (e.g., Microsoft Power BI, Oracle BI)In-depth knowledge of standard concepts, practices and procedures related to database managementExperience in troubleshooting and resolving integrity issues, performance issues.Excellent English communications skills (written and verbal)

Good to have skills

Good to have AWS/AZURE Cloud Knowledge

Work Schedule

Hybrid

Keywords (If any)

Power BI, IRD, Java

State Street's Speak Up Line