Intermediate Software Engineer/Reporting & Analytics - Focused on the reporting supporting capital markets data consumers - strong hands‑on SSRS and Power

Role: Software Engineer - Reporting & Analytics

Location Address: Hybrid - 44 King - 2 days onsite/week

Subject to change: 3-4 days onsite may be required based on business needs

Contract Duration: 6 months

Candidate must be interested in moving to full-time after 6 months

This role is focused on the reporting and analytics layer, supporting capital markets data consumers. The position is approximately 50% development / 50% production support, with strong emphasis on SQL, Power BI, SSRS, and data pipelines.

You will also participate in integration work using Python and Java.

Business Group:

The role sits within the Structured Credit - Mortgage Capital Markets technology team, supporting lending and mortgage services in a high‑availability production environment.

The core application was onboarded approximately one year ago and is now entering its next phase, focused on:

- Production support

- Roadmap delivery

- US market expansion

- Integration with upstream and downstream systems

This is a hands‑on engineering role requiring close collaboration with business partners, architecture, and cross‑functional engineering teams.

Responsibilities:

- Work closely with business users and stakeholders to understand requirements and perform gap analysis

- Partner with Architecture on solution design and system integration

- Deliver enhancements to existing platforms and build new features

- Participate across the full SDLC: design, development, testing, deployment, and production support

- Design and implement database schemas

- Build automated test sets (functional, non‑functional, regression, performance)

- Write deployment scripts and use CI/CD pipelines (Accelerator pipeline)

- Support and troubleshoot production issues

- Improve end‑user experience through scalable, efficient solutions

- Communicate clearly with technical and non‑technical audiences

- Refactor and enhance legacy code as needed

- Coach and support end users where required

- Participate in Agile/SCRUM ceremonies

Must Have Skills:

1) 5+ years of experience writing, reading, and executing SQL scripts

2) Hands-on experience with data technologies and databases, including one or more of the following: PostgreSQL, Microsoft SQL Server, Oracle, Apache NiFi, Apache Kafka, Elasticsearch, with the ability to work comfortably with large datasets

3) 3+ years experience with Power BI, including data modeling, report/dashboard development, and data visualization using SQL-based data sources and with Microsoft SQL Server Reporting Services (SSRS), including designing, developing, and maintaining reports using SQL Server

4) 3+ years experience working with cloud platforms, preferably Microsoft Azure or GCP

5) 4+ years experience developing and consuming Web Services and APIs using Java or Python (Python preferred)

6) Experience with UNIX shell scripting in Linux environments

Nice-To-Have Skills:

1) Hands-on experience with CI/CD and build automation tools such as Maven, Gradle, and Jenkins

2) 5+ years of experience designing, developing, deploying, and maintaining large-scale applications with complex integrations

3) Experience with Messaging BUS/Brokers; IBM MQ/ Kafka/ Redis

• Experience using job scheduling and orchestration tools such as CRON, Tidal, or Airflow

• Experience using application and infrastructure monitoring tools such as Dynatrace for performance monitoring, troubleshooting, and incident analysis

4) Capital Markets product knowledge (mortgage)

Understanding of networking protocols and security principles

Experience working with real-time, high availability and low latency systems

Best Candidate - Reporting & Analytics (SQL / Power BI / SSRS)

Senior reporting engineer with strong hands‑on SSRS and Power BI experience, capable of designing and maintaining complex, production‑critical reports end‑to‑end. Highly proficient in SQL optimization and troubleshooting in live environments, comfortable balancing development and production support. Experience working across the integration layer using Python (preferred) or Java, with exposure to Capital Markets or mortgage data and the ability to clearly translate business needs into scalable reporting solutions.

Education

Bachelor’s degree in Computer Science, Engineering, or equivalent practical experience.