702 IT & Software Developer jobs in the US
SQL Server ETL Developer with SSIS
$96,000 - 96,000
VALIANT TECHNOLOGIES LLC
East Warren Avenue 315, Warren
$96,000 - 96,000
Requirements
Must:
- Proven experience in leading and mentoring a team focused on ETL development, data pipelines, and managing data warehouse loads.
- Proficient in designing, developing, and refining complex SQL queries, stored procedures, functions, and views.
- Skilled in constructing and sustaining workflows for data ingestion, cleansing, transformation, and transfer using SQL Server Integration Services (SSIS) and SQL.
- Solid background with Microsoft SQL Server 2019 or later, including database management.
- Significant experience in utilizing Microsoft SSIS to create and deploy ETL packages.
- Expertise in writing and troubleshooting T-SQL statements, as well as creating stored procedures, views, and SQL functions.
- Familiar with various data models such as normalized, denormalized, star, and snowflake schemas.
- Strong SQL coding skills with a focus on performance optimization for data queries.
- Ability to handle multiple tasks effectively in a dynamic and fast-paced environment.
- Collaborative mindset to work with team members to troubleshoot and resolve technical challenges promptly.
- Analytical thinker with the ability to communicate effectively with stakeholders to assess needs and find optimal solutions.
- In-depth knowledge of data warehousing principles.
- Experience with Azure DevOps and CI/CD processes for efficient deployments.
- Strong familiarity with data structures and formats including JSON and XML, along with SSIS scripting capabilities.
Responsibilities
- Lead and mentor team members engaged in ETL development, data pipeline construction, and data warehouse management.
- Design, develop, and optimize complex SQL queries and database objects including stored procedures and views.
- Create and maintain workflows for data ingestion, cleansing, transformation, and transfer utilizing SSIS and SQL.
- Manage and administer Microsoft SQL Server databases effectively.
- Develop and deploy SSIS packages for extracting, transforming, and loading data.
- Write and troubleshoot T-SQL statements to ensure data integrity and performance.
- Evaluate and apply different data modeling techniques to support data architecture needs.
- Optimize SQL queries for performance improvement.
- Navigate and thrive in a rapidly changing, high-pressure environment while managing multiple priorities.
- Collaborate with team members to identify technical issues and drive timely resolutions.
- Analyze and communicate effectively with stakeholders to clarify requirements and deliver optimal solutions.
- Apply deep knowledge of data warehousing concepts to enhance data management processes.
- Utilize Azure DevOps and CI/CD pipelines to facilitate seamless deployments.
- Implement awareness of data formats such as JSON and XML in scripting within SSIS.
Description
We are a forward-thinking technology firm located in Warren, NJ, seeking a SQL Server & SSIS ETL Developer to join our dynamic team for a long-term engagement lasting over 12 months. Our work environment is collaborative, fast-paced, and driven by innovation. We offer competitive compensation and the opportunity to work on challenging projects that leverage cutting-edge technologies. We pride ourselves on being an equal opportunity employer and celebrate diversity, ensuring that all employment decisions are made based on merit and aligned with business needs.
Something wrong or incorrect with this job? Tell us in the chat 💬 on the right ➡️
You can find Database Engineer salaries in the United States here.
How many Database Engineer jobs are in the United States?
Currently, there are 702 Database openings. Check also: PostgreSQL jobs, SQL jobs, VBA jobs, MongoDB jobs - all with salary brackets.
Is the US a good place for Database Engineers?
The US is one of the best countries to work as a Database Engineer. It has a vibrant startup community, growing tech hubs and, most important: lots of interesting jobs for people who work in tech.
Which companies are hiring for Database Engineer jobs in the United States?
Jump, D3 Security Management Systems, TherapyNotes.com, Redwood Strong LLC, Astrion, Accenture Federal Services, BROAD MANAGEMENT GROUP L LC among others, are currently hiring for Database roles in the United States.
The company with most openings is Robotics technology LLC as they are hiring for 42 different Database Engineer jobs in the United States. They are probably quite committed to find good Database Engineers.
The company with most openings is Robotics technology LLC as they are hiring for 42 different Database Engineer jobs in the United States. They are probably quite committed to find good Database Engineers.