Understands and anticipates direction of the business area(s)/unit(s) and, together with other IT functions, identifies opportunities and makes recommendations to support the assigned business area(s)/unit(s) communicated strategy.
Builds data models that describe data and its relationships in a consistent way to support business and technical objectives
Apply advanced analytical and BI skills in order to interpret data and trends to support business activities
Provide business consultancy to guide stakeholders in calibrating the requirements to be in line and benefit from other local/group initiatives and also ICT Local and Group strategy
Ensures IT solutions support the organization’s short-term and long-term business goals/strategy and align with IT strategy.
Development of ETL jobs and reports according to requirements and technical specifications
Responsibilities and main tasks:
Analyzing business requirements as a guide to data modeling
Choosing a suitable data modeling approach for each project, such as by assessing the suitability of existing data models.
Building data models with the flexibility to change when business requirements change.
Reconciling multiple logical source models into a single, logically consistent model.
Ensuring the proposed model follows data architecture guidelines and best practices.
Rationalizing the relationships expressed in the logical data model to the schema of the physical data store (that is, database tables and columns).
Performing detailed analysis and identifying trends defined in the requirements such as weekly, quarterly and annual trends for customer churn.
Identifying patterns and helping the business react to changing business conditions.
Performing root cause analysis.
Collect business requirements through interviews, analysis documents, workshops, use cases, business analysis
Involved in defining and identifying solutions for consistency of reported information, implementing needed processes and qualifying data quality defects
Analyze business requirements and create the functional specifications.
Map business terms from the source systems to the DWH core data model.
Develop ETL scripts and jobs – extract data from the Teradata DWH core data model, calculate measures and KPIs, load them into data marts.
Design and implement new tables and relationships in the data marts
Ensure IT support for applications in scope of the DWH environment (ex. Teradata, IBM DataStage, Process Dispatch Center, Data Extractor application, SVN, MicroStrategy) and also proactive monitoring of reporting recurrent processes that have as a source DWH
University degree or progressive educational certificate
Three years of experience with data modeling
Three years of banking experience
At least 1 year of previous experience in a similar position (IT Business Analyst, Analist CRM , Analist DW, Analist raportare)
Knowledge about banking products
Economic and financial knowledge
Strong SQL skills
Experience in transactional and operational, analytical, and MDM modeling techniques
Knowledge of BI and analytics.
Knowledge of structured data, such as entities, classes, hierarchies, relationships and metadata.
Knowledge of database management system (DBMS) physical implementation, including tables, joins and SQL querying
Experience with Teradata technology is considered an advantage
Experience with reporting tools as Power BI or SAS Visual Analytic ionsidered an advantage
Ability to combine data from multiple sources when needed for the analysis.
Familiarity with the use cases, business purposes and quality of the data.