Position

Data & Data Warehouse Solution Architect,

Sofia

Location


Sofia

Office Address


Project Description


As part of our strategic partnership with one of the biggest financial institutions in the World, we are hiring various IT specialists, who will become part of their new IT Service Center in Sofia. The bank is an international organization dedicated to providing financing, advice, and research to developing nations to aid their economic advancement. The bank predominantly acts as an organization that attempts to fight poverty by offering developmental assistance to middle- and low-income countries. Our client is a provider of financial and technical assistance to individual countries around the globe. The bank considers itself a unique financial institution that sets up partnerships to reduce poverty and support economic development.

Responsibilities


    The selected candidate is responsible for the data architecture and data management activities within the ITS Data & Analytics Work Program. He/she should have a strong foundation and hands-on experience in Data and Analytics data management design and development, debugging Business Intelligence (BI) existing applications as well as performance tuning.

    The selected candidate will work closely with the team to provide technical leadership to facilitate development projects that involve the computing environment which may include the coordination of software upgrades and the installation of new products. He/she will design and validate data solutions that are practical, flexible, scalable, reusable, and strategic. These efforts enhance data quality, enrich access and provide business decision makers with information upon which they can make more accurate and effective decisions across multiple domains.

Skills


Must have

    The candidate should have the following core skill sets:
    • At least 7 years of hands-on experience in coding complex SQL queries, transform-load (ETL) design and development, performing tasks such developing strategies for data acquisitions as well as developing data structures, archive recovery and associated data policies
    • At Least 5 years of hands-on experience in data integration, data virtualization, data federation and database design techniques
    • Experience with performance tuning for complex SQL queries
    • Experience in data modeling for relational databases - both for logical and physical data models with exposure to designing and developing for large-scale multidimensional databases and data warehouses
    • Experience with managing and maintaining quality data by performing operations such as cleaning, transformation, and ensuring integrity in both on-prem and a cloud-based relational database environment
    • Ensure data is ready for use by consuming application, analyst and scientist using frameworks and microservices to serve data
    • Ability to build and interact with very large data processing pipelines, distributed data stores, and distributed file systems
    • Experience designing and deploying high performance production services with robust monitoring and logging practices
    • Familiarity with various process modeling techniques (activity hierarchy diagrams, data flow diagrams, sequence diagrams, workflow diagrams, system interface diagrams, etc.)
    • Thorough knowledge of complex ETL mappings, data pipelines and workflows in a Cloud-based ETL tool such as IICS and Azure Data Factory/SSIS

    Required Technologies:
    • Database: Oracle 12c/18c/19c, Azure SQL DW, SQL Server 2016/2014/2012/2008
    • Cloud Technologies: Azure Microsoft Technologies, Unix, Linux, Windows
    • Design Language: UML, Visio, Erwin 9.x and above
    • Tools: Informatica Cloud Services (IICS), Informatica PowerCenter 10.x, Tibco Data Virtualization 8.x

Nice to have

    • Technical Degree in Computer Science/Engineering or related field
    • Ability to work independently upon receiving guidance and objectives
    • Experience in various development methodologies such as Agile/Scrum development methodology
    • Ability to juggle multiple tasks in a fast-paced environment
    • A wide degree of creativity and lateral thinking
    • Excellent communication, writing/documentation and facilitation skills
    • Strong diplomatic, interpersonal and teamwork skills
    • Maturity to participate in multiple complex programs at the same time in an Agile environment

Languages


English: C1 Advanced

Relocation package


If needed, we can help you with relocation process. Click here for more details: see more details

Work Type


Data Science

Ref Number


VR-50021

Explore More

LoGeek Magazine
icon Logeek Luxoft
Learn more
Events
icon Events Luxoft
Learn more
Relocation Program
icon Relocation Luxoft
Learn more
Referral
Platform
icon Referral Luxoft
Learn more
Students
and Grads
icon Students Luxoft
Learn more