Hollstadt Overview

Hollstadt Consulting is a management and technology consulting firm dedicated to placing professionals at engagements where they will excel. When you work with us, you'll work with a refreshingly real company led and staffed by seasoned experts who are also down-to-earth, good people. We're committed to treating you with respect and helping you achieve your career aspirations.

Since 1990, Hollstadt has been a trusted partner to more than 150 domestic and global companies and has successfully completed over 3,000 projects. Our continued growth has created challenging and rewarding opportunities for accomplished IT and Business Consultants. Hollstadt Consulting is an equal opportunity employer including disability/veteran.

By applying for this job, you agree to receive calls, AI-generated calls, text messages, or emails from Hollstadt Consulting and its affiliates, and contracted partners. Frequency varies for text messages. Message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You can reply STOP to cancel at any time.

Role: Database Developer

Location: Remote

Duration: 1 year

Rate: $70/hour W2

Description of Project

The client is seeking a Database Developer to assist in the design and maintenance of various databases, develop and optimize ETL pipelines and workflows, develop and optimize SQL scripts and stored procedures to support data conversion, validation, and ongoing processing needs. The Database Developer will develop stored procedures, views, SQL scripts, and other database components supporting transactional and reporting systems. The Database Developer will also execute large-scale data migrations, including cleansing, validation, and transformation across enterprise systems, build data ingestion and transformation workflows across raw, staging, curated, and analytics layers, maintain various reporting solutions using SSRS and Power BI, and Design and implement logical and physical data models (ERDs) for various applications. The Database Developer will also provide production support, including troubleshooting performance issues and on-call support and collaborate with cross-functional teams and participate in Agile ceremonies, development activities, code reviews, and release cycles.

At a high level, the resource will develop, maintain, and optimize enterprise database solutions and will support data integration, conversion, migration, reporting, and database performance while ensuring the accuracy, reliability, and integrity of enterprise data. The resource will also provide production support and collaborate with cross-functional project teams throughout the system development lifecycle using Agile methodologies.

The work is expected to be done remotely.

Tasks

• Design and maintain various databases, including stored procedures, indexing, and data models.
• Develop and optimize ETL pipelines and workflows using SSIS, Python, PySpark, and SQL Server.
• Execute large-scale data migrations, including cleansing, validation, and transformation across enterprise systems.
• Develop and optimize SQL scripts and stored procedures to support data conversion, validation, and ongoing processing needs.
• Build data ingestion and transformation workflows across raw, staging, curated, and analytics layers.
• Build and maintain various reporting solutions using SSRS and PowerBI.
• Design and implement logical and physical data models (ERDs) for various applications.
• Develop stored procedures, views, SQL scripts, and other database components supporting transactional and reporting systems.
• Provide production support, including troubleshooting performance issues and on-call support when needed.
• Collaborate with cross-functional teams and participate in Agile ceremonies, development activities, code reviews, and release cycles.
• Provide knowledge transfer.

Desired Skills

• 10+ years of experience in database development or data engineering.
• Expertise in SQL Server, T-SQL and performance tuning.
• Experience with ETL tools (SSIS), Python, or PySpark.
• Strong background in data modeling and data integration.
• Experience with reporting tools (SSRS, PowerBI).
• Working knowledge of DevOps tools such as Azure DevOps, GitHub, or Jenkins.
• Experience supporting critical applications in financial, government, or legal industries.