Business Intelligence Reporting, Web Developer

• Design, develop, test, and deploy SSRS reports for internal stakeholders, client-facing statements, and regulatory outputs
• Build and maintain Power BI dashboards with drill-down, filtering, and KPI visualizations
• Translate business requirements into accurate, well-documented reporting solutions
• Manage SSRS subscriptions, permissions, and scheduled report delivery
• Ensure report accuracy and consistency with source data and business rules
• Design and develop web applications and internal tools supporting the Unique Assets platform
• Build responsive, accessible front-end interfaces using HTML, CSS, and Java Script
• Leverage AI-assisted development tools to accelerate web development, improve code quality, automate repetitive tasks, and enhance productivity
• Collaborate with the development team on architecture, code reviews, and best practices
• Apply Git version control and participate in SDLC processes including code review and QA
• Write complex T-SQL queries, stored procedures, views, and functions
• Optimize query performance for large financial and trust accounting datasets
• Work with data warehouses, OLTP databases, and staging environments to source and shape data
• Collaborate with DBAs to maintain data quality, integrity, and access patterns
• Partner with business analysts, QA, and operations through requirements gathering, UAT, and post-deployment validation
• Engage stakeholders on adjacent legacy systems to understand source data structure and lineage
• Document report logic, data sources, API contracts, and field definitions
• Support end-users with report and application questions, training, and ad hoc analysis

• 3+ years of hands‑on SSRS report development in a production environment
• 2+ years of Power BI development
• 3+ years of SQL Server development with strong T-SQL proficiency
• 2+ years of web application development with HTML, CSS, JavaScript, and at least one modern front‑end framework
• Experience working in financial services, trust accounting, wealth management, or another regulated industry preferred
• SQL Server Reporting Services (SSRS): paginated reports, subscriptions, RDL authoring, Report Builder
• Power BI:
  Desktop, Service, DAX, Power Query, dataflows, row-level security
• T-SQL: stored procedures, CTEs, window functions, query tuning, and execution plan analysis
• Web: HTML5, CSS3, JavaScript (ES6+), React or Angular, REST API integration
• SQL Server: SSMS, profiler, database objects
• Git-based workflows, branching, and pull requests
• Data modeling fundamentals, including star schema and normalization
• Experience with trust accounting or financial portfolio management platforms preferred
• Familiarity with data conversion and ETL processes preferred
• Familiarity with legacy database platforms such as Rocket Universe (Uni Data/Uni Verse) preferred
• Experience with server‑side web technologies (.NET, Node.js, or similar) preferred
• Understanding of TDD and automated testing practices in a regulated software environment preferred
• Bachelor's degree in Computer Science, Information Systems, Finance, or a related field; or equivalent professional experience

Demonstrates expertise in SSRS report development, Power BI dashboard creation, and T-SQL query optimization, with a strong focus on data accuracy and integrity in financial services. Proficient in web application development using HTML, CSS, JavaScript, and modern frameworks, while collaborating effectively with cross-functional teams.

• SSRS Report Development
• Power BI Development
• T-SQL Proficiency
• Web Application Development
• Data Modeling Fundamentals

• SSRS
• Power BI
• T-SQL
• HTML
• CSS
• Java Script
• React
• Angular
• Git
• Data Modeling

• Collaboration
• Communication
• Problem-Solving

• Financial Services
• Trust Accounting
• Wealth Management
• Regulated Industry

• SQL Server
• SSMS
• Power Query
• REST API
• ETL Processes