Brainspotting - Business Intelligence/Data Warehousing Specialist

Business Intelligence/Data Warehousing Specialist


16 Feb 2021


31 Aug 2021

Cloud, Oracle

București, Cluj-Napoca


Full Time



  • Provide technical leadership on data architecture and technologies to the development teams by designing solutions and blueprints for large projects and continuous mentoring and technical guidance
  • Lead architecture decisions, design guidance and technical analysis of the value of best storage solution, ETL (batch jobs and real-time), optimization processing, best practices, reference architectures, etc.


  • Determine specifications, plan, design complex solutions, utilizing appropriate big data tools and technologies
  • Acquire business requirements for data analytics projects with close contact with the stakeholders
  • Design, setup and support of data governance and data integration processes
  • Design the solutions using cloud infrastructure and architecture best practices
  • Define high availability and elastic architecture solutions (like Rest API) choosing the best Database or storage regarding the needs, etc.
  • Explore and analyze a huge amount of raw data from various data sources for fulfilling business requirements
  • Model and implement the business layers in the DWH using Kimball / Inmon architecture
  • Ensure sustainable growth of the data model as business use cases are incorporated and evolved over time
  • Ensure data security, availability and reliability
  • Create representative data samples and implement automated tests for data transformation scripts
  • Support users with the understanding and usage of the data model in the DWH
  • Deep practical experience in data modeling and data transformation processes
  • Hands-on coding, create data models in both traditional and big data technologies
  • Perform POC’s on tools and new technologies and design patterns
  • Work with various teams in order to produce data assessment for and initiative in a pre-development phase
  • Modeling and designing – producing data flow diagrams and documents explaining conceptual/logical and physical models
  • Interface with key business stakeholders to gather data integration requirements and design solutions accordingly
  • Responsible for creating and overseeing standards for all the pipelines
  • Overseeing projects from a Data flow perspective, suggesting best practices and standards for a given functionality
  • Work as a key member of the core team to support the timely and efficient delivery of critical data integration deliverables.

Competențe necesare

Cloud, Oracle


  • 8+ years of designing technical solutions experience, including 5+ of years hands-on experience in BI/DWH solution architecture, Data integration, design and development of data exchange interfaces
  • Strong understanding of BI principles, architectures, and enterprise-scale BI solutions
  • Academic degree(s) in Computer Science / Information technology
  • Knowledge of Data Governance Frameworks
  • Experience in defining data governance processes and building a data dictionary platform
  • Expertise in SQL databases technologies (like Snowflake, Big Query, Redshift, Spark SQL, Relational Database like Oracle/MS SQL Server) and NoSQL databases technologies (like MongoDB, ElasticSearch, Redis, In-Memory)
  • Experience in design, development, and deployment of data warehouses or relational/analytical/multi-dimensional data marts
  • Cloud based data solutions (on AWS, Azure, GCP)
  • Good understanding of underlying infrastructure for Big Data solutions and technology (Clustered/Distributed/different types of storage/ NoSQL / data format/ DB engines/ ETL at Scale/ Data Center Networking)
  • Expertise in Hadoop ecosystem (Hive, HDFS, MapReduce, Yarn)
  • Experience designing/developing data solutions on AWS (AWS Glue, Spectrum, Redshift, RDS), and Azure (Data Factory, Azure AD, Azure Synapse)
  • Advanced RDBMS experience particularly Oracle and MS SQL Server including complex stored procedures, functions, query optimization, indexing strategy, etc.
  • Experience with enterprise-scale ETL solutions such as Informatica, SSIS, IBM DataStage
  • Knowledge of enterprise BI platforms such as Tableau, Power BI, Qlikview, JasperSoft
  • Strong understanding of data analytics and visualization (e.g. Tableau, Power BI).
  • Coding skills (Design Pattern usage, functional and oriented object programming, abstraction and reusability)
  • Knowledge of Agile/SCRUM is desirable
  • Full project lifecycle experience, from initial concept through to deployment and support
  • UML knowledge
  • Post-graduate qualifications (in a related discipline) would be advantageous
  • Customer-focused, strong collaborator and relationship builder, excellent communication skills
  • Team player that can work independently and think creatively, problem solver

Poziționare în organizație

Departament: It


Posturi similare