Job Description
Job Title: Solutions Engineer –ETL Developer
Location: Beverly, MA 1915
Duration: 12 Months
Payrate: $82/hr on W2 (all inclusive)
Description:
Solutions Engineer –ETL Developer
Key Responsibilities:
Required Qualifications:
Location: Beverly, MA 1915
Duration: 12 Months
Payrate: $82/hr on W2 (all inclusive)
Description:
- 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.
Solutions Engineer –ETL Developer
- 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 Sensitech’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.
Numbers & Facts
| Location | Beverly, MA |
| Industry | Staffing/Employment Agencies |
| Salary | $80 |
| Company Size | 2,000 to 2,499 employees |
| Year Founded | 2000 |
| Website | http://www.lancesoft.com/ |
About Company
We are a $125 Million, NMSDC-certified Minority & Woman owned Workforce Solutions Company headquartered in the DC metro area with presence across US with global presence - Canada, Mexico, India, UK, Malaysia, Indonasia, Hongkong, Singapore, UAE. We are specialized in providing Workforce Solutions, SOW project delivery, Engineering Solutions, Creative Services. We currently support 100+ Fortune companies globally and across multiple industry segments. We are currently supporting several massive programs across industry segment nationally/globally (Intel, Ally, AMD, QUALCOMM, Morgan Stanley, Kraft/ Mondelez, MNP, Amdocs, Dell, SanDisk, Medtronic, Becton Dickinson, GE, Lockheed Martin, UTC, L-3 Communications, Caterpillar, BMW, Mercedes Benz, National Grid, Dominion, Energy Future Holdings, PSEG, 3M, Fidelity, Aetna, Humana, Johnson & Johnson, Pfizer, Merck etc).
All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender, identity, national origin, disability, or protected veteran status.
Skills
- Application Programming Interface (API)unmatched
- Artificial Intelligence (AI)unmatched
- Business Intelligenceunmatched
- Business Intelligence Softwareunmatched
- Cloud Computingunmatched
- Computer Scienceunmatched
- Continuous Improvementunmatched
- Data Collectionunmatched
- Data Managementunmatched
- Data Martunmatched
- Data Modelingunmatched
- Data Setsunmatched
- Data Warehousingunmatched
- Database Administrationunmatched
- Database Designunmatched
- Database Extract Transform and Load (ETL)unmatched
- Database Programmingunmatched
- Debugging Skillsunmatched
- Desktop PCunmatched
- Dimensional Modelingunmatched
- Food Scienceunmatched
- Identify Issuesunmatched
- Logisticsunmatched
- Machine Toolunmatched
- Microsoft SQL Serverunmatched
- Microsoft Windows Azureunmatched
- Performance Tuning/Optimizationunmatched
- Power BIunmatched
- Predictive Modelingunmatched
- Problem Solving Skillsunmatched
- Process Improvementunmatched
- Professional Servicesunmatched
- Project Lifecycleunmatched
- Project/Program Managementunmatched
- Prototypingunmatched
- Query Optimizationunmatched
- Rapid Prototypingunmatched
- Refrigerationunmatched
- Reporting Dashboardsunmatched
- Requirements Managementunmatched
- SQL (Structured Query Language)unmatched
- SQL Server Integration Services (SSIS)unmatched
- Snowflake Schemaunmatched
- Star Schemaunmatched
- Statisticsunmatched
- Stored Proceduresunmatched
- System Integration (SI)unmatched
- Team Playerunmatched
- Test Plan/Scheduleunmatched
- Warehousingunmatched
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 templatesFree 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