Back to all jobs
dataSpecta

Senior/Expert Analytics Engineer

dataSpecta

Istanbul · Istanbul · Turkey Full-time 5-10 2d ago

Job description

About the job: Innovance provides the latest generation & high-quality digital transformation initiatives for banks and other financial institutions since 2017 from near-sourcing services to technology advisory services. Innovance focuses on impact & delivery by providing world-class strategic IT leadership, and remote or on-site support to clients at all layers with measurable results on operational & financial verticals. We are looking for a Expert or Senior Analytics Engineer who is passionate about data and will be a part of a team that enables Banking Data Warehouse. This is a remote position for a banking transformation project. Join us if you are motivated to drive success using the power of data. Responsibilities: Responsible for analyzing and identifying the data needs of the business Interpret existing data preparation logic in ETL flows and reports, define requirements, and guide engineers to generate new data assets Generate source to target data mapping guidelines and required SQL scripts Discover and find patterns, anomalies, and trends in large data sets Support team in data modeling, design phase, and data quality testing life cycle Develop and maintain working relationships with key cross-functional stakeholders to understand business and build a roadmap Qualifications: Bachelor’s degree in a quantitative field (Computer Engineering, Mathematics Engineering, Industrial Engineering, Management Information Systems, Mathematics, Statistics, etc.) 5+ years of experience in Data Warehouse or Data Lakehouse Proven experience in Dimensional Modeling (Kimball/Inmon); ability to design efficient Star and Snowflake schemas. Experience in one of the following fields is a huge plus; Financial Reporting, Regulatory Reporting, IFRS, Risk, and Profitability Strong SQL knowledge to extract information and data profiling skills Experience in Business Intelligence tools like Tableau, PowerBI, Qliksense, and SAP BO Experience in SQL Server or Oracle Experience in building Data Catalogs and maintaining business glossaries. Ability to communicate data concepts to both technical and non-technical participants clearly Fluency in English, excellent writing skills Experience in DWH modernization project is a plus Experience in Data Governance project is a plus Familiarity with data technologies on cloud providers like Google, AWS, and Azure is a plus Familiarity with Data Vault 2.0 principles is a significant plus (especially for large-scale banking environments) Experience in ETL pipeline implementations in Data Factory, SSIS, ODI or Informatica is a plus Experience with working in an agile scrum environment is a plus Desired Characteristics: Strong analytical and problem-solving skills Strong teamwork and communication skills Eager to learn new tools and technologies Data-driven analytical mindset Detail-oriented Solution-oriented Self-starter Follow us: LinkedIn: https://www.linkedin.com/company/innovance-consultancy LinkedIn: https://www.linkedin.com/company/dataspecta Instagram: https://www.instagram.com/innovanceconsultancy Instagram: https://www.instagram.com/dataspecta