Data Solutions Engineer

Company: Aligned Solutions
Location: Deerfield Beach
Posted on: April 2, 2026

Job Description:

ONSITE Location:Boca Raton Reports To: Director of IT Collaborates With: Lead Software Engineer Job Summary: The Data Solutions Engineer will design, build, and optimize scalable data architecture, backend services, and system integrations that power enterprise reporting and automation initiatives. This role requires independent work in production environments and a focus on strong data architecture, backend engineering, and systems thinking. While Power BI is required, the emphasis is on robust data solutions and backend development rather than dashboard creation. Key Responsibilities: Design and optimize scalable SQL-based data architecture. Build and maintain ETL pipelines and staging layers. Develop and consume REST APIs for system integrations. Build lightweight backend services (C# / .NET preferred). Improve system performance through indexing, tuning, and execution plan analysis. Replace manual workflows with automated backend processes. Design reusable data services across ERP, WMS, and external vendor systems. Build and optimize Power BI semantic models with strong DAX logic. Ensure clean separation between data modeling and visualization layers. Qualifications: Education: Bachelor’s degree in Computer Science, Information Systems, or a related field. Experience: 7 years of professional experience in data development, backend development, or data engineering. 5 years of advanced SQL Server development. 3 years working with APIs and system integrations. 3 years building BI semantic models (Power BI or similar tools). Proven ability to operate independently in production environments. Core Technical Requirements: 1. Advanced SQL & Data Architecture Strong T-SQL skills: stored procedures, CTEs, window functions, indexing strategies. Performance tuning and execution plan analysis. Experience designing star schema and hybrid models. ETL and staging layer design. Handling medium-to-large datasets (10M rows). Understanding normalization vs. denormalization trade-offs. 2. API & Backend Development Experience consuming REST APIs (JSON-based). Backend development experience (C# / .NET preferred). Familiarity with OAuth, token-based authentication, and API keys. Error logging, retry logic, and resilient integration design. Ability to design lightweight integration services. Understanding asynchronous processing concepts. 3. Automation & Systems Thinking Experience replacing manual processes with automated workflows. Ability to design reusable backend data services. Understanding cross-system dependencies (ERP, WMS, external vendors). Strong architectural thinking and problem-solving ability. 4. Business Intelligence & Power BI Advanced DAX knowledge (row vs filter context, CALCULATE, SUMX, DATEADD, time intelligence). Experience building reusable semantic models. Power BI performance optimization. Understanding incremental refresh and dataset sizing. Ability to separate data modeling from visualization design. Power BI experience required, with emphasis on modeling and DAX rather than visual design.

Keywords: Aligned Solutions, Port St. Lucie , Data Solutions Engineer, IT / Software / Systems , Deerfield Beach, Florida