Onuorji Doris

As an Analytical Engineer with a focus on financial services, I have developed a robust skill set and substantial experience in managing and analyzing data to support business needs. My expertise includes:

ETL Processes

• SSIS (SQL Server Integration Services): I have utilized SSIS extensively for ETL processes in an Actimize project. This involved extracting data from various sources, transforming it to meet business requirements, and loading it into target systems, ensuring data accuracy and consistency.

Data Transformation

• dbt (Data Build Tool): I have used dbt for transforming data, enabling efficient and scalable data modeling. By defining and managing data transformations in dbt, I ensured that the data was clean, reliable, and ready for analysis, supporting the organization’s analytical needs.

Data Warehousing

• BigQuery: I have managed and utilized BigQuery as the primary data warehouse. My responsibilities included designing and maintaining data schemas, optimizing query performance, and ensuring the efficient storage and retrieval of large volumes of data, which facilitated robust data analysis and reporting.

Reporting and Visualization

• Power BI: I have created interactive and insightful reports using Power BI, enabling stakeholders to make data-driven decisions. My work involved designing dashboards, implementing data visualizations, and providing detailed analyses of key performance indicators (KPIs).
• Looker Studio (formerly Google Data Studio): I have also leveraged Looker Studio for creating dynamic reports and visualizations, ensuring that complex data insights were accessible and comprehensible to various business users.

Additional Responsibilities

• Data Quality Management: Ensuring the accuracy, completeness, and reliability of data through rigorous validation and quality checks.
• Collaboration: Working closely with business stakeholders to understand their data needs and translating them into technical solutions. Collaborating with cross-functional teams, including data scientists, data engineers, and IT professionals, to implement and maintain data solutions.
• Documentation: Creating comprehensive documentation for data processes, models, and reports to ensure transparency, reproducibility, and compliance with organizational standards and regulations.

Tools and Technologies

• ETL Tools: Expertise in SSIS for efficient data extraction, transformation, and loading.
• Data Transformation: Proficiency in dbt for scalable and reliable data transformation.
• Data Warehousing: In-depth knowledge of BigQuery for managing large-scale data warehouses.
• Visualization Tools: Advanced skills in Power BI and Looker Studio for creating impactful reports and dashboards.

I completed my first degree in a prestigious unveristy in Nigeria Obafemi awolowo where I studied Chemistry. 

I have certifications on Data Analytics , Dbt and Google Data Engineering