Senior Data Analyst - SQL/Microstrategy
Pylon Consulting
3d ago
source :

Job Description :

The senior data analyst job description entails providing support in the creation of detailed analytical models by providing expert opinion related to the integration and processing of data relevant to the business.

It also involves analysing business process and discrepant data scenarios.

Senior data analysts are also responsible for providing high level advanced triage support to stakeholders, business partners, and product teams in managing specific issue resolution activities.

They utilize Programmatic and quantitative methods to identify patterns and relationships in large data sets, as well as apply mathematical, statistical, and other data - driven analysis to address intelligence questions.

They are also responsible for performing quantitative analysis of complex business situations, such as strategies, performance, and solutions involving sales and customer performance.

Besides using quantitative tools, they may also apply advanced computer modelling, database tools and / or other approaches in conducting the analysis.

The senior data analyst work description also entails providing leadership to junior analysts and brainstorming with the line manager and teams on approaches or solutions to a business problem.

It also involves suggesting solutions for moderate to complex sales / customer opportunities and internal processes, as well as overseeing cross - departmental projects as needed.

Responsibilities includes :

  • Providing innovative analytical insights within the Data Products Program
  • Conducting detailed data analysis on data used across business units to evaluate business processes and improve on / create new feature
  • Responding to data and product related inquiries in real - time to support business and technical teams
  • Performing various data analytics in SQL and MS Excel using statistical models or industry accepted tools
  • Providing relational database expertise to construct and execute SQL queries to be used in data analysis activities
  • Providing data solutions, tools, and capabilities to enable self - service frameworks for data consumers
  • Providing expertise and translate the business needs to design; and develop tools, techniques, and metrics, and dashboards for insights and data visualization
  • Responsible for developing and executing tools to monitor and report on data quality
  • Responsible for establishing appreciation and adherence to the principles of data quality management, including metadata, lineage, and business definitions
  • Providing support to Tech teams(Data Engineering & Data Governance) in managing security mechanisms and data access governance.
  • Qualifications for Data Analysts :

  • Education : A Master's degree in Analytics, Computer Science, or Data Science; Mathematics or in a related field and 3 - 5 years of industry experience in data analysis using SQL & MicroStrategy technologies.
  • Certifications : Certification in any of the Financial Domain or Banking Domain , Data Science , AI is desirable. SQL and relational database knowledge are required for the senior data analyst position in the financial sector especially in financial crime compliance domain.
  • Knowledge : An advanced data management techniques with extensive experience. 7 - 10 years of industry experience as a Business / Data Analyst with 3 - 5 experience in data analysis using tools such as SQL and Excel
  • Technical Skills :

  • Understanding of Scripting experience in (Python, Perl, JavaScript, Shell);
  • Practical knowledge of data in various forms (data warehouses / SQL, unstructured data environments / PIG,HIVE, Impala);
  • Familiarity with BI reporting tools (i.e. MicroStrategy, Tableau and Business Objects);
  • Experience working within process management and improvement methodologies - Lean, Six Sigma, etc. and demonstrating knowledge of data governance, data quality management concepts and data quality tools (i.
  • e. Informatica DQ); Understanding of Agile development methodologies, software design patterns, network design and architecture;
  • Experience in quantitative analysis and statistical modelling
  • Stress Management : The senior data analyst must be able to work well under pressure and achieve results within the scheduled timeframe
  • Communication skills : The role of a senior data analyst involves working with people and managing junior team of analysts.
  • It is crucial that they have exceptional writing and verbal communication skills to perform their job duties and manage others.

    Regulatory & Business Conduct :

  • Display exemplary conduct and live by the Group's Values and Code of Conduct.
  • Take personal responsibility for embedding the highest standards of ethics, including regulatory and business conduct, across our Bank.
  • This includes understanding and ensuring compliance with, in letter and spirit, all applicable laws, regulations, guidelines and the Group Code of Conduct.

  • Effectively and collaboratively identify, escalate, mitigate and resolve risk, conduct and compliance matters.
  • About :

    We're an international bank, nimble enough to act, big enough for impact. For more than 160 years, we've worked to make a positive difference for our clients, communities, and each other.

  • We question the status quo, love a challenge and enjoy finding new opportunities to grow and do better than before. If you'
  • re looking for a career with purpose and you want to work for a bank making a difference, we want to hear from you. You can count on us to celebrate your unique talents.

    And we can't wait to see the talents you can bring us.

    Our purpose, to drive commerce and prosperity through our unique diversity, together with our brand promise, to be here for good are achieved by how we each live our valued behaviours.

    When you work with us, you'll see how we value difference and advocate inclusion.

    Together we :

  • Do the right thing and are assertive, challenge one another, and live with integrity, while putting the client at the heart of what we do
  • Never settle, continuously striving to improve and innovate, keeping things simple and learning from doing well, and not so well
  • Be better together, we can be ourselves, be inclusive, see more good in others, and work collectively to build for the long term
  • In line with our Fair Pay Charter, we offer a competitive salary and benefits to support your mental, physical, financial and social wellbeing.

    Core bank funding for retirement savings, medical and life insurance, with flexible and voluntary benefits available in some locations

  • Time - off including annual, parental / maternity (20 weeks), sabbatical (12 weeks maximum) and volunteering leave (3 days), along with with minimum global standards for annual and public holiday, which is combined to 30 days minimum
  • Flexible working options based around home and office locations, with flexible working patterns
  • Proactive wellbeing support through Unmind, a market - leading digital wellbeing platform, development courses for resilience and other human skills, global Employee Assistance Programme, sick leave, mental health first - aiders and all sorts of self - help toolkits
  • A continuous learning culture to support your growth, with opportunities to reskill and upskill and access to physical, virtual and digital learning
  • Being part of an inclusive and values driven organisation, one that embraces and celebrates our unique diversity, across our teams, business functions and geographies - everyone feels respected and can realise their full potential.
  • ref :

    Report this job

    Thank you for reporting this job!

    Your feedback will help us improve the quality of our services.

    My Email
    By clicking on "Continue", I give neuvoo consent to process my data and to send me email alerts, as detailed in neuvoo's Privacy Policy . I may withdraw my consent or unsubscribe at any time.
    Application form