OLSYS Ltd provides full-service solutions for mid-market and enterprise organizations.
As an enterprise software development company, we are building long term partnerships helping our clients accelerate their digital experiences with reasonable IT investments.
Our tailored approach, e-commerce focus, and flexible solutions allow us to design, develop, and deliver scalable, integrated commerce platforms that drive profits and boost the business.
15+ years of experience, 100+ projects, 50+ specialists
The Client is a global institutional asset management firm. Founded in 1986 and headquartered in San Francisco, our Client has offices in London, Singapore, Hong Kong, Tokyo, São Paulo and New York. The firm’s investments include public and private debt and equity securities, direct investments in private companies, and real estate.
We are looking for a talented Data Engineer who will join a small, dedicated, global team of professional developers. The position affords the unique opportunity for an individual with a passion for creating high-end data pipelines to make a significant contribution within a respected firm and to participate in the full life-cycle development process.
- Passion for dimensional modelling, data warehouse performance, and user experience
- 5+ years of development experience [Azure (generally), Azure Data Factory, Azure SQL]
- Expert in Kimball-style dimensional modelling and ETL practices
- Capable of presenting complex ideas to a wide audience of technical and non-technical professionals
- Ability to transition seamlessly between deep technical responsibilities and big picture objectives
- Excellent interpersonal skills with ability to effectively complete tasks on time in a cross-functional global work environment
- Strong communication (verbal and written) and presentation skills
- Exceptional project management and organizational skills
- Demonstrated success with complex problem solving and ideation constructs
English level: Upper-Intermediate
- Data modelling inside the data warehouse (logical and physical), including building out new models and managing changes to existing models
- Data integration from sources into the warehouse, including development of stored procedures for merging various table types, including Stage, ODS, fact, dimension, bridge, etc.
- Develop processes for data integrity checks, performance of maintenance, auditing ETL, etc.
- Participate in design sessions which include open and technical vetting of design proposals and strategies
- Become an expert in the client's data and the related business processes in order to ask the right questions and understand how we can deliver the most effective data warehouse
- Produce quality solutions to support all business units including investment research, operational functions, accounting, tax, risk management, as well as at the enterprise level.
- Assist in other team or firm data integration development initiatives and projects