Job Description:

Join a high impact data and analytics team where you ll lead the design and delivery of trusted BI solutions that help stakeholders make faster smarter decisions
In this role you ll work hands on with the Microsoft BI stack to build reliable data pipelines semantic models and insightful reports that translate complex data into clear business outcomes
You ll collaborate closely with data engineers analysts and business partners to understand requirements improve data quality and optimize performance across the BI ecosystem
If you enjoy owning end to end delivery mentoring teammates and continuously improving how data is modeled processed and presented this is a great opportunity to grow your leadership while building scalable enterprise grade BI solutions

Key Responsibilities:

Key Responsibilities
Lead end to end development and support of MSBI solutions using SSIS SSAS and SSRS across multiple subject areas
Design develop and optimize SSIS ETL packages including data extraction transformation loading scheduling and error handling
Build and maintain SSAS tabular multidimensional models measures KPIs hierarchies and partitions aligned to business reporting needs
Develop SSRS reports datasets and subscriptions ensure report accuracy usability and performance
Write and tune complex SQL queries stored procedures and views to support ETL and reporting workloads
Perform performance tuning for ETL cube model processing and reporting analyze bottlenecks and implement improvements
Drive requirement discussions with stakeholders convert needs into technical designs and ensure timely quality delivery
Implement data validation reconciliation checks and monitoring to improve reliability and data quality
Provide technical guidance code reviews and mentoring to team members promote best practices and standards
Support production deployments troubleshooting and root cause analysis with clear documentation and communication
Minimum Qualifications
BTECH MTECH MCA or MSC
5 8 years of experience delivering BI solutions using SSIS SSAS SSRS and MSBI
Strong hands on expertise in SQL including query writing optimization and database objects views stored procedures
Proven experience building ETL workflows in SSIS with robust logging error handling and scheduling
Experience developing SSAS models and SSRS reports with a focus on performance and correctness
Working knowledge of Python for data processing automation or integration tasks supporting BI delivery

Technical Requirements:

Primary skills Technology Business Intelligence Analytics MSBI SSAS
Technology Business Intelligence Reporting MSBI SSRS
Technology SQL SSIS SQL Server

Additional Responsibilities:

Preferred Qualifications
Experience designing dimensional data models star snowflake and applying BI best practices for analytics ready datasets
Strong troubleshooting skills across ETL semantic models and reporting layers with a structured approach to root cause analysis
Experience with Python libraries for data handling and automation e
g
Pandas to complement BI workflows
Exposure to version control and release practices for BI assets ability to maintain clean reusable well documented code
Demonstrated leadership in coordinating deliveries improving team standards and collaborating effectively with business stakeholders

Preferred Skills:

Technology->SQL SSIS->SQL Server,Technology->Business Intelligence - Reporting->MSBI (SSRS),Technology->Business Intelligence - Analytics->MSBI (SSAS)

"Ssas" Jobs