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.
Customer Solutions Consultant responsible for promoting sales and enhancing customer relationships using UPS's expertise in various sectors. Position involves virtual meetings, documentation, and customer training.
Solutions Engineering Supervisor developing and implementing supply chain solutions for UPS. Focused on optimizing warehousing, transportation, and distribution networks with simulation technology.
Principal Solution Architect designing IBM Power system solutions for CDW. This role requires a deep technical depth in IBM Power systems and partnership with sales management.
Solution Architect ABAP designing and developing advanced SAP solutions for the manufacturing industry with focus on quality and modern standards. Engage in technical leadership and innovation within a dynamic IT service provider.
Senior Solution Architect responsible for eProcurement solutions in automotive industry. Analyzing procurement processes and ensuring system integration for Ivalua solutions.
Professional Solutions Manager leading professional services engagements for HPE Nonstop Platform. Collaborating across global teams to deliver complex software projects.
Associate Solution Engineer at Snowflake working with customers to deliver database solutions and sales support. Key responsibilities include product presentations, implementation planning, and customer collaboration.
Solutions Architect designing solutions for on - premise and cloud data center environments in a hybrid role. Join Sentinel Technologies, a leading IT services provider based in the US.
Solutions Engineer working with legal teams to implement AI solutions and improve workflows. Bridging technical concepts with real - world legal applications.
Solutions Architect delivering quality technical solutions in a fast - growing startup focused on vector databases for AI. Building strategic client relationships and contributing to open - source community.