CohnReznick LLP is seeking a IT Senior Software Developer II for its growing and fast-paced Technology team. This opportunity is both full-time and remote. The IT Senior Software Developer II is responsible for the creation of applications, web development and mobile application solutions based on a demand pipeline centered around innovation. The goal is to create new solutions using cutting edge tools so that the client service staff can add more business value to our clients and back office/administrative staff can work more efficiently. The IT Senior Software Developer will work with members of the Enterprise Development team and other IT peers and reports into the Senior Manager of Business Solutions. You will be responsible for: Design and develop Data Pipelines using Azure Data Factory Migrate existing SSIS packages into Azure Data Factory Optimize data pipelines for performance and cost efficiency Train other team members on the use if Azure Data Factory Design and develop SQL Server stored procedures, functions, views and triggers to be used during the ETL process Builds data transformations with SSIS including importing data from files, moving data from one database platform to another Debug and tune SSIS or other ETL processes to ensure accurate and efficient movement of data Design, implement and maintain database objects (tables, views, indexes, ) and database security Experience working with SSIS packages Proficient with ETL tools such as Microsoft SSIS Experience in using DevOps Repository check in and check out process for the technical changes Analyze and develop strategies and approaches to import and transfer data between source, staging, and ODS/Data Warehouse destinations Test and prepare ETL processes for deployment to production and non-production environments Support system and acceptance testing including the development or refinement of test plans Qualifications: Minimum 5years software development experience and knowledge of SDLC methodology Bachelor’s degree or higher in a computer or business-related field (Computer Information Systems, Computer Science, Management Information Systems, etc.) or an equivalent combination of education and work experience. Minimum 5 years’ experience designing, creating, customizing, and configuring innovative solutions to solve complex business requirements and streamline/automate business processes. Candidate should be able to speak to examples in detail during an interview. Experience working with Relational Data Modeling solutions and related industry best practices. Strong SQL skills building complex queries, tuning and optimizing Read, write, and speak English fluently and communicate effectively. Experience developing within Microsoft Visual Studio and utilizing Git for source control. Required Knowledge/Skills ADF (Azure Data Factory) API Azure SQL SSIS C# SQL Azure Data Lake storage Azure DataBricks Data modeling Functions and Triggers Stored Procedures, Views Why CohnReznick? Endless opportunities to contribute to one of the top advisory, assurance, and tax firms Network of 2,700 professionals committed to a diverse and inclusive workplace and giving back to the communities in which we live and work Creative culture that values collaboration in everything we do Team of professionals motivated by a sense of excellence, integrity, commitment to lifelong learning, respect for one another, adaptability, and making a difference Varied career paths supported by strong professional development programs and resources Learn more: www.cohnreznick.com Connect with us: www.linkedin.com/company/cohnreznick-llp www.facebook.com/cohnreznick https://twitter.com/cr_careers CohnReznick is an organization committed to diversity and inclusion to drive our business results and create a better future every day for our diverse employees, clients, partners, and communities. We believe a diverse workforce allows us to match our growth ambitions and drive inclusion across the business. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, age, national origin, or protected veteran status and will not be discriminated against on the basis of disability. For more information, please see Equal Employment Opportunity Posters Equal Opportunity/Affirmative Action Employer Minorities/Females/Protected Veterans/Persons with Disabilities Show more Show less