Sign upLog in
See more jobs

Solutions Engineer – ETL Developer #26-21521

US Tech Solutions, Inc.
  • Beverly, MA
  • Quick Apply
Today

Job Description

Duration: 12 Months

Description:
  • The Solutions Engineer specializing in Business Intelligence, Data Modeling and Data Warehousing is responsible for designing, creating and managing reports, dashboards, system integrations, data models, data warehouses, tools, SSIS packages, ETL processes and related systems used by customers and client’s Professional Services team.
  • The Solutions Engineer works with business users throughout the project lifecycle, including requirements definition, prototyping, development, testing, deployment and support. Projects typically have short timeframes with multiple iterations, combine data from multiple sources, and utilize input from specialists in the areas of statistics, computer science, logistics and industry-related fields such as food science, refrigeration, security and packaging.
  • As the needs of our customers and available business intelligence tools are rapidly evolving, this position provides substantial opportunity to engage in creative problem-solving and rapid prototyping techniques. The Solutions Engineer must seek to continuously improve and broaden their expertise so that the best tools can be applied to a given situation.
  • The Solutions Engineer also supports existing data warehouses, reports, system integrations, SSIS packages and tools, which require periodic maintenance, troubleshooting and upgrades to leverage new capabilities. The Solutions Engineer works in a team environment, participates in meetings, proactively addresses issues and completes other tasks as assigned.
 Key Responsibilities:
  • Data Architecture & Modeling: Design, implement, and optimize conceptual, logical, and physical data models (Dimensional/Star Schema, Data Vault, or 3NF).
  • ETL/ELT Development: Build, deploy, and orchestrate scalable, automated data pipelines to ingest data from disparate internal and external sources.
  • Warehouse & Mart Management: Develop and maintain enterprise Data Warehouses and specialized Data Marts tailored to specific business units.
  • Report & Dashboard Development: Develop and maintain interactive dashboards and paginated reports for data modeling and operational reporting.
  • Support & Optimization: Monitor daily data loads, troubleshoot pipeline failures, and continuously optimize SQL queries and ETL jobs for maximum performance.
  • Collaboration: Partner with Program Managers, Solutions Engineers, and stakeholders to understand data requirements and deliver clean, reliable datasets.
 Required Qualifications:
  • Experience: 5+ years of proven experience in Data Engineering, Data Development, or a similar role.
  • Data Modeling: Strong proficiency in relational and dimensional data modeling techniques (Fact and Dimension tables).
  • SQL Mastery: Advanced SQL skills, including writing complex queries, stored procedures, and performance tuning.
  • ETL Tooling: Hands-on experience with modern ETL tools (e.g. Azure Data Factory).
  • Visualization: Proficient in developing interactive dashboard in Power BI Desktop and paginated reports using PBI Report Builder.
  • Data Warehousing: Experience working with modern cloud data warehouses (e.g., Snowflake, BigQuery, Redshift) or traditional systems (SQL Server).
  • Experience leveraging AI/ML tools or LLM APIs to optimize data pipelines, automate data cleansing/transformation, or enhance predictive data modeling capabilities.
  • Infrastructure: Experience in Azure cloud administration (deploying and managing enterprise solutions).
  • Problem Solving: Strong debugging and support skills to quickly triage and resolve data pipeline interruptions.
 Technical Skills:
  • Microsoft SQL Server
  • Experience with .NET programming
  • Strong SQL Server skills is a must along with Dynamic SQL queries and stored procedures
  • Experience with predictive analytics and applied statistics
  • Experience with SSIS, SSRS
  • Candidates should have excellent verbal and written communication skills.
  • Excellent organizational and time management skills
  • Able to handle multiple priorities with excellent time management skills
 Nice to Have:
  • Experience with programming languages like Python for data manipulation.
  • Experience deploying and managing Azure infrastructure using Terraform.
  • Experience designing and implementing robust system-to-system integrations (via REST/SOAP APIs, webhooks, or middleware)
  • Familiarity with CI/CD practices and version control (Git).
 
Schedule:  (Hybrid: Tue, Weds & Thurs onsite) and (Mon & Fri remote) 8-hour workday, flex start/end (between 8am - 6pm)

About US Tech Solutions:
US Tech Solutions is a global staff augmentation firm providing a wide range of talent on-demand and total workforce solutions. To know more about US Tech Solutions, please visit www.ustechsolutions.com.
 
US Tech Solutions is an Equal Opportunity Employer.  All qualified applicants will receive consideration for employment without regard to race, colour, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.
 
AI Statement: By applying, you acknowledge that AI-assisted tools may be used during hiring. 

IND01

#LI-AS140

Numbers & Facts

LocationBeverly, MA

Skills

  • Application Programming Interface (API)unmatched
  • Artificial Intelligence (AI)unmatched
  • Business Intelligenceunmatched
  • Business Intelligence Softwareunmatched
  • Cloud Computingunmatched
  • Communication Skillsunmatched
  • Computer Scienceunmatched
  • Continuous Deployment/Deliveryunmatched
  • Continuous Improvementunmatched
  • Continuous Integrationunmatched
  • Data Managementunmatched
  • Data Martunmatched
  • Data Modelingunmatched
  • Data Setsunmatched
  • Data Warehousingunmatched
  • Database Extract Transform and Load (ETL)unmatched
  • Debugging Skillsunmatched
  • Desktop PCunmatched
  • Dimensional Modelingunmatched
  • Food Scienceunmatched
  • Gitunmatched
  • Identify Issuesunmatched
  • Logisticsunmatched
  • Machine Toolunmatched
  • Microsoft .NETunmatched
  • Microsoft SQL Serverunmatched
  • Microsoft Windows Azureunmatched
  • Middlewareunmatched
  • Multitaskingunmatched
  • Organizational Skillsunmatched
  • Performance Tuning/Optimizationunmatched
  • Power BIunmatched
  • Predictive Modelingunmatched
  • Presentation/Verbal Skillsunmatched
  • Problem Solving Skillsunmatched
  • Professional Servicesunmatched
  • Programming Languagesunmatched
  • Project Lifecycleunmatched
  • Project/Program Managementunmatched
  • Prototypingunmatched
  • Python Programming/Scripting Languageunmatched
  • Query Optimizationunmatched
  • REST (Representational State Transfer)unmatched
  • Rapid Prototypingunmatched
  • Refrigerationunmatched
  • Reporting Dashboardsunmatched
  • Requirements Managementunmatched
  • SOAP (Simple Object Access Protocol)unmatched
  • SQL (Structured Query Language)unmatched
  • SQL Server Integration Services (SSIS)unmatched
  • SQL Server Reporting Services (SSRS)unmatched
  • Snowflake Schemaunmatched
  • Source Code/Configuration Management (SCM)unmatched
  • Star Schemaunmatched
  • Statisticsunmatched
  • Stored Proceduresunmatched
  • System Integration (SI)unmatched
  • Team Playerunmatched
  • Test Plan/Scheduleunmatched
  • Time Managementunmatched
  • Warehousingunmatched
  • Writing Skillsunmatched

Be found by employers

5,500+ employers search our resume database daily. Add yours to get found by recruiters looking for candidates like you.

Level up your application

Professional resume templates

Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.

Free resume templates

Free resume builder

Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.

Free resume builder