Optimus SBR

Business Analyst

• Lead and support end-to-end business analysis activities for data, analytics, and technology projects.
• Facilitate requirements workshops and interviews to gather business needs, data requirements, user stories, and functional specifications.
• Develop clear and complete business analysis documentation, including:
• o Business Requirement Documents (BRDs)
• o Functional Requirements Documents (FRDs)
• o User stories and acceptance criteria
• o Process maps, swimlane diagrams, and data flow diagrams
• o System-to-system data mapping
• o Requirements traceability matrices
• Participate in project planning, status reporting, and preparation of client deliverables, presentations, and recommendations.
• Support identification of project risks and issues and contribute to the development of mitigation plans.
• Communicate complex data and technical concepts clearly to both technical and non-technical stakeholders.
• Conduct advanced data analysis using SQL to explore datasets, validate requirements, troubleshoot issues, and support solution design.
• Write and optimize queries to join, filter, cleanse, aggregate, and quality-check data from multiple sources.
• Design and develop dashboards, reports, and visualizations using Power BI and Tableau, applying best practices in UI/UX, data storytelling, and analytics.

Technical Data Business Analyst

Solutions Engineer

• Analyze business and technical requirements to design scalable, efficient data architectures.
• Build logical and physical data models using industry-standard tools such as Erwin (or equivalent).
• Design high-quality Entity Relationship (ER) diagrams following best practices in normalization, naming conventions, metadata, and data governance.
• Reverse engineer existing databases and schemas into ERDs, ensuring accuracy, traceability, and clarity.
• Manage schema lifecycle and change control, including versioning, impact assessment, and controlled deployment across environments.
• Translate source system structures into consolidated, analytics-ready data models for data warehouses and marts.
• Design and build end-to-end data pipelines using both low-code/no-code and code-based tools, including SSIS, Azure Data Factory (ADF), Alteryx, Power Automate, and related technologies.
• Develop and optimize data ingestion, transformation, and integration workflows across diverse data sources.
• Implement ETL/ELT best practices to ensure reliability, accuracy, scalability, and performance.
• Support the creation of data warehouses, data marts, and reusable data assets for analytics, reporting, and visualization.
• Troubleshoot pipeline, performance, and data quality issues with a hands-on, solution-focused approach.
• Work with and design solutions across multiple database platforms, including SQL Server, Databricks, MySQL, PostgreSQL.

Technical Data Business Analyst

Data Engineering Solutions Architect