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 Charlotte, North Carolina, USA Office
101 South Tryon Street, Suite 2600, Charlotte, NC, United States, 28280
Similar Jobs at Capco
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
Fintech • Professional Services • Consulting • Energy • Financial Services • Cybersecurity • Generative AI
Lead AI transformation projects, manage client relationships, and ensure high-quality deliverables across multiple workstreams in a consulting environment.
Top Skills:
AIAnalyticsSalesforceSAPServicenowWorkflow Tools
What you need to know about the Charlotte Tech Scene
Ranked among the hottest tech cities in 2024 by CompTIA, Charlotte is quickly cementing its place as a major U.S. tech hub. Home to more than 90,000 tech workers, the city’s ecosystem is primed for continued growth, fueled by billions in annual funding from heavyweights like Microsoft and RevTech Labs, which has created thousands of fintech jobs and made the city a go-to for tech pros looking for their next big opportunity.
Key Facts About Charlotte Tech
- Number of Tech Workers: 90,859; 6.5% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Lowe’s, Bank of America, TIAA, Microsoft, Honeywell
- Key Industries: Fintech, artificial intelligence, cybersecurity, cloud computing, e-commerce
- Funding Landscape: $3.1 billion in venture capital funding in 2024 (CED)
- Notable Investors: Microsoft, Google, Falfurrias Management Partners, RevTech Labs Foundation
- Research Centers and Universities: University of North Carolina at Charlotte, Northeastern University, North Carolina Research Campus
