The SQL Developer / BI Developer will design, develop, and maintain ETL processes using SSIS, support reporting with SSRS, and enhance SSAS solutions.
CAPCO POLAND
*We are looking for a Poland based candidate.
Hybrid: 2x per week in Warsaw office.
At Capco Poland, we’re not just another consultancy - we’re the spark behind digital transformation in the financial world. As a global leader in technology and management consulting, we thrive on helping clients tackle the toughest challenges across banking, payments, capital markets, wealth, and asset management.
Our secret?
A culture that’s fast, flexible, and fiercely entrepreneurial. We move quickly, think creatively, and always put our people first.
We’re passionate about growth - both for our clients and ourselves - and that means attracting the very best talent to join us on this exciting journey.
We’re proud to be:
• Trailblazers in banking, payments, capital markets, wealth, and asset management
• Champions of an agile, nimble, and innovative work environment
• Dedicated to building a team of top-notch professionals who share our drive and vision
• Trailblazers in banking, payments, capital markets, wealth, and asset management
• Champions of an agile, nimble, and innovative work environment
• Dedicated to building a team of top-notch professionals who share our drive and vision
ROLE OVERVIEW
We are seeking an experienced SQL Developer / BI Developer with a strong focus on SQL Server Integration Services (SSIS) to design, develop, and maintain data integration and reporting solutions. The role primarily involves building robust ETL processes, with additional responsibilities in reporting (SSRS) and multidimensional analytics (SSAS).
WHAT YOU WILL DO
- Design, develop, and maintain SSIS packages for data extraction, transformation, and loading (ETL)
- Optimize and troubleshoot SSIS workflows to ensure performance, reliability, and scalability
- Develop and maintain SQL Server databases, including stored procedures, views, and functions
- Create and maintain SSRS reports, dashboards, and data-driven subscriptions
- Support and enhance SSAS multidimensional cubes, including dimensions, measures, and aggregations
- Collaborate with business stakeholders to gather reporting and data integration requirements
- Ensure data accuracy, consistency, and integrity across reporting and analytical solutions
- Document ETL processes, data flows, and reporting solutions
- Participate in deployments, upgrades, and ongoing support of BI solutions
SKILLS AND EXPERIENCES TO GET THE JOB DONE
- Strong experience with Microsoft SQL Server
- Advanced proficiency in SSIS (primary and most critical skill)
- Solid experience with SSRS for report development and maintenance
- Working knowledge of SSAS (Multidimensional) for cube development and reporting
- Strong T-SQL skills (queries, performance tuning, indexing)
- Experience with data warehousing concepts and ETL best practices
- Ability to analyze data issues and provide effective solutions
- Experience with .NET
ONLINE RECRUITMENT PROCESS STEPS
- Screening call with the Recruiter
- Hiring Manager Technical Interview
- Client Interview
- Feedback/Offer
We offer a flexible collaboration model based on a B2B contract, with the opportunity to work on diverse projects.
Top Skills
.Net
SQL Server
Ssas
Ssis
Ssrs
T-Sql
Capco New York, New York, USA Office
Inside the Empire State Building in the heart of NYC is where you will find our office. Near all public transportation it is a commuters dream.
Similar Jobs at Capco
Fintech • Professional Services • Consulting • Energy • Financial Services • Cybersecurity • Generative AI
Assist in the migration of users from a data analytics platform, providing technical support and collaborating with cross-functional teams. Responsibilities include troubleshooting issues, documenting processes, and contributing to risk tracking.
Top Skills:
Data Virtualization ToolsDatabasesMS OfficePythonSQL
Fintech • Professional Services • Consulting • Energy • Financial Services • Cybersecurity • Generative AI
The Business Analyst will act as an SME in Trading and Market Risk, lead projects in technology solutions, and mentor team members while engaging with users for support.
Top Skills:
AdoJIRAPythonSQL
Fintech • Professional Services • Consulting • Energy • Financial Services • Cybersecurity • Generative AI
The Business Analyst role focuses on cash and loan products, analyzing business needs, improving processes, and ensuring compliance with regulations.
Top Skills:
AgileBpmnUmlWaterfall
What you need to know about the NYC Tech Scene
As the undisputed financial capital of the world, New York City is an epicenter of startup funding activity. The city has a thriving fintech scene and is a major player in verticals ranging from AI to biotech, cybersecurity and digital media. It also has universities like NYU, Columbia and Cornell Tech attracting students and researchers from across the globe, providing the ecosystem with a constant influx of world-class talent. And its East Coast location and three international airports make it a perfect spot for European companies establishing a foothold in the United States.
Key Facts About NYC Tech
- Number of Tech Workers: 549,200; 6% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Capgemini, Bloomberg, IBM, Spotify
- Key Industries: Artificial intelligence, Fintech
- Funding Landscape: $25.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Greycroft, Thrive Capital, Union Square Ventures, FirstMark Capital, Tiger Global Management, Tribeca Venture Partners, Insight Partners, Two Sigma Ventures
- Research Centers and Universities: Columbia University, New York University, Fordham University, CUNY, AI Now Institute, Flatiron Institute, C.N. Yang Institute for Theoretical Physics, NASA Space Radiation Laboratory
