Job Description
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 more
- Design 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 systems
- Integrate 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 tools
- knowledge of data warehousing, data gateway, and data preparation projects
- Articulating, representing, and analyzing solutions with the team while documenting, creating, and modeling them
- Knowledge of executing DAX queries on the Power BI desktop
- Comprehensive understanding of data modeling, administration, and visualization
- Capacity to perform in an atmosphere where agility and continual development are prioritized
- Detailed knowledge and understanding of database management systems, OLAP, and the ETL (Extract, Transform, Load) framework
- Awareness of BI technologies (e.g., Microsoft Power BI, Oracle BI)
- In-depth knowledge of standard concepts, practices and procedures related to database management
- Experience 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
