BI Fullstack Developer – Senior Associate

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