What are the responsibilities and job description for the Data Engineer - Azure, SQL, SSIS position at Cirrus Group Consulting?
Cirrus is seeking an SQL / SSIS Developer to work in San Francisco Bay Area or remote.
Essential Job Duties and Responsibilities
Development of ETL processes with SQL Server Integration Services (SSIS).
Migration and upgrades of SSIS packages.
Batch automation of ETL Processes.
Build pipelines with Azure Data Factory.
Data integration using with Snowflake databases
Coding and optimization of SQL server stored procedures, triggers and functions.
Development of SQL Server Reporting Services and custom coded reports.
Database testing to ensure programming changes are functional and meet client requirements.
Implementation of SQL Server security best practices.
Basic Qualifications
Bachelor's in Computer Science, Computer Engineering, Computer Information Systems, Information Technology or related field.
5-8 years development production support of ETL integration with at least 2 years in a senior role.
5 years of writing and implementing codes in SQL from scratch.
5 years of development experience with data integration toolsets and writing and maintaining ETL jobs
5 years of experience with SQL Server Integration Services
5 years of experience with SQL Server 2018 and later.
Preferred Qualifications
Azure Data Factory is preferred
Snowflake is nice to have but not a must
Solid experience with SQL Server Integration Services (SSIS).
Senior level experience with SQL / TSQL and ability to create and tune queries.
Solid experience writing SQL code and implementing same.
Experience with Azure Data Factory is desired
Solid experience with optimizing database systems.
Experience with database administration skills like backup and recovery, mirroring / high availability, replication, table partitioning, and index tuning.
Strong attention to detail with excellent analytical, problem solving, and communication skills.
Financial services experience is a plus.
Training and Certifications (required and desired)
Bachelor's in Computer Science, Computer Engineering, Computer Information Systems, Information Technology or related field.
Keep a pulse on the job market with advanced job matching technology.
If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution.
Compensation Planning
Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right.
Surveys & Data Sets
What is the career path for a Data Engineer - Azure, SQL, SSIS?
Sign up to receive alerts about other jobs on the Data Engineer - Azure, SQL, SSIS career path by checking the boxes next to the positions that interest you.
