ETL Developer

Responsible for data gathering before development of a database. They design, develop, test, implement and maintain new and existing databases. Database developers create management methods and systems to access efficiently to information stored in databases. They work with consultants and other members of the company to improve processes.

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 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:

o Data Architecture & Modeling: Design, implement, and optimize conceptual, logical, and physical data models (Dimensional/Star Schema, Data Vault, or 3NF).

o ETL/ELT Development: Build, deploy, and orchestrate scalable, automated data pipelines to ingest data from disparate internal and external sources.

o Warehouse & Mart Management: Develop and maintain enterprise Data Warehouses and specialized Data Marts tailored to specific business units.

o Report & Dashboard Development: Develop and maintain interactive dashboards and paginated reports for data modeling and operational reporting.

o Support & Optimization: Monitor daily data loads, troubleshoot pipeline failures, and continuously optimize SQL queries and ETL jobs for maximum performance.

o Collaboration: Partner with Program Managers, Solutions Engineers, and stakeholders to understand data requirements and deliver clean, reliable datasets.

Required Qualifications:

o Experience: 5+ years of proven experience in Data Engineering, Data Development, or a similar role.

o Data Modeling: Strong proficiency in relational and dimensional data modeling techniques (Fact and Dimension tables).

o SQL Mastery: Advanced SQL skills, including writing complex queries, stored procedures, and performance tuning.

o ETL Tooling: Hands-on experience with modern ETL tools (e.g. Azure Data Factory).

o Visualization: Proficient in developing interactive dashboard in Power BI Desktop and paginated reports using PBI Report Builder.

o Data Warehousing: Experience working with modern cloud data warehouses (e.g., Snowflake, BigQuery, Redshift) or traditional systems (SQL Server).

o Experience leveraging AI/ML tools or LLM APIs to optimize data pipelines, automate data cleansing/transformation, or enhance predictive data modeling capabilities.

o Infrastructure: Experience in Azure cloud administration (deploying and managing enterprise solutions).

o Problem Solving: Strong debugging and support skills to quickly triage and resolve data pipeline interruptions.

Technical Skills:

o Microsoft SQL Server

o Experience with .NET programming

o Strong SQL Server skills is a must along with Dynamic SQL queries and stored procedures

o Experience with predictive analytics and applied statistics

o Experience with SSIS, SSRS

o Candidates should have excellent verbal and written communication skills.

o Excellent organizational and time management skills

o Able to handle multiple priorities with excellent time management skills

Nice to Have:

o Experience with programming languages like Python for data manipulation.

o Experience deploying and managing Azure infrastructure using Terraform.

o Experience designing and implementing robust system-to-system integrations (via REST/SOAP APIs, webhooks, or middleware)

o Familiarity with CI/CD practices and version control (Git).

Pay: $70.00 - $82.00 per hour

Expected hours: 40.0 per week

Work Location: Hybrid remote in Beverly, MA 01915