Solutions Engineer – ETL Developer Job Beverly area,Massachusetts USA,IT/Tech

Position: Solutions Engineer – ETL Developer #26-21521

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 time frames 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.

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 time frames 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 & Styling: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…