Data Engineering Solutions Architect at Optimus SBR designing modern data solutions and collaborating with a high-performing team to transform data usage.
Responsibilities
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.
Requirements
5-7 years of relevant experience in data engineering, data architecture, or combined roles.
Strong, hands-on experience with data modeling tools (e.g., Erwin) and ERD best practices.
Demonstrated capability to reverse-engineer, deploy, and manage schema changes across environments.
Advanced experience with SQL and SQL scripting across multiple RDBMS platforms.
Proven ability to design and build ETL/ELT pipelines using tools such as SSIS, ADF, Alteryx, Power Automate, or similar.
Experience converting OLTP systems into OLAP data warehouses and data marts.
Knowledge of BI/reporting tools, visualization platforms, and their data consumption patterns (asset).
Candidates with consulting experience will be given strong preference.
Experience delivering technology or data projects in a client-facing consulting environment.
Ability to manage stakeholder relationships, clarify complex requirements, and facilitate discussions between business and technical teams.
Strong problem-solving skills with the ability to structure ambiguous challenges into actionable solution paths.
Comfortable preparing and delivering presentations, architectural artifacts, and recommendations to clients and executive audiences.
Experience supporting project scoping, estimation, and proposal development (asset).
Self-directed, with the ability to thrive in a fast-paced, dynamic environment.
Strong verbal, written, and presentation communication skills.
Results-driven, with the ability to meet aggressive timelines and manage competing priorities.
Innovative, dynamic, and entrepreneurial in approach.
Strong work ethic, energy, enthusiasm, and commitment to professional growth.
University degree in a related field.
Benefits
Growth Opportunities: Build your career through challenging, impactful projects and continuous learning.
Diverse Workplace: Collaborate with professionals from unique backgrounds, fostering innovation.
Flexibility & Autonomy: Enjoy the freedom to take ownership of your work and drive meaningful results.
Leadership Development: Develop your skills through mentorship and career-progression opportunities.
Sales Solution Engineer supporting OEM partners in integrating IT security solutions into their offerings. Collaborating with teams to analyze customer needs and conduct technical presentations.
Senior Solutions Engineer acting as trusted advisor to enterprise clients for TeamViewer. Partnering with sales to showcase value across DEX, remote connectivity, endpoint management, observability & automation.
Solutions Engineer supporting sales team with technical knowledge of F5 solutions. Focused on achieving sales targets and delivering value through effective solutions.
Solutions Engineer supporting sales with technical expertise for F5's solutions. Focus on customer business objectives and collaborating with internal teams in a diverse environment.
Senior Solutions Consultant at Intapp, guiding firms on technical evaluations and software solutions. Collaborating with sales and consulting to maximize client value across territories.
Microsoft Dynamics 365 Sales Solution Engineer gathering technical requirements and proposing solutions based on client needs. Contributing to Dynamics CRM implementations across all project phases with a hybrid work environment.
Solution Architect leading design and architecture of RPA solutions with Generative AI at Automation Anywhere. Collaborating with stakeholders to align automation strategies with organizational goals.
Systems Integration Engineer securing and enhancing unmanned systems for Navy and Marine Corps operations. Collaborating with teams to implement advanced cybersecurity measures and conduct risk assessments.
Market Integrations Solution Architect designing secure integration solutions at Cencora, focusing on M&A. Evaluating requirements and ensuring pragmatic designs across cybersecurity and cloud teams.
Sustainability Data Solutions Architect ensuring compliance and sustainability data quality across HP systems. Leading operational performance and data architecture in a complex enterprise environment.