Data Warehouse Developer
- Full-time
Company Description
Who we are
Miratech is a global IT services and consulting company that brings together global enterprise innovation and start-up innovation. Today we support digital transformation for the largest enterprises on the planet. Our highly professional team achieves success with 99% of IT projects in financial, telecommunication and technology domains since Miratech inception in 1989. Technical complexity is our passion, stability is our standard, friendly work environment is our style. We empower our employees to grow together with the company, to achieve ambitious goals, to be a part of international relentless team which helps the visionaries to change the world.
Job Description
We are looking for a Data Warehouse Developer who will join the DWH-BI team to support a large debt management company with operations in several European countries. You will be part of a geographically distributed team that works in the multinational European environment.
Responsibilities:
- Elaborate on the requirements with business users and analysts
- Map data sources to Data Warehouse including development of data full way transformation
- Implementation of Power BI reports and other SQL scripts into production
- Develop code of Data Warehouse, Master Data and Data Marts (MS SQL Server, SSIS)
- Support users with testing of the delivered solutions
- Maintenance and monitoring of the production solutions, addressing issues and improvements
- Performing data quality checks for data source systems
Qualifications
- Good knowledge of T-SQL and Microsoft SQL Server
- Good knowledge of data modeling
- Experience with Power BI or other reporting tools (e.g. QlikView, Business objects, Tableau, Microstrategy)
- Experience in development of ETL (stored procedures)
- Basic knowledge of database architecture
Nice to have:
- Good experience in query tuning
- Experience with SSRS and SSIS
- Database administration and performance optimization experience
Professional qualities and characteristics:
- Demonstrated ability to understand, communicate, and translate the business needs and requirements into technical solutions
- Experience in development of technical projects, preferably with experience in implementation of Business Intelligence and/or Data Warehouse solutions
- Experience in development and performance tuning of complex Transact-SQL scripts.
- Experience within debt collection, financial services is an advantage.
- Good command of English (able to communicate in an international environment) and Spanish
Additional Information
We offer
- Strong career opportunities for professionals
- A variety of international projects and mobility across projects
- Professional development support and professional certification opportunities
- Competitive compensation, advanced bonus systems
- Flexible work schedule with a possibility for teleworking
- Corporate, social and cultural events