Visa status: U.S. Citizens and those authorized to work in the U.S. are encouraged to apply.
Tax Terms: W2, 1099
Corp-Corp or 3rd Parties: Yes

Job description
SSIS ETL & SSRS Developer
MS SQL Server 2018, SSIS & ETL, SSRS BI tools

8+ yrs Experienced in software design and development process including requirements definition, design and data modeling, Data Querying and Analysis, database architecture and maintenance.
• Strong experience in MS SQL Server Database Development and Administration
• Extensive experience with SQL Server in constructing stored procedures, triggers, tables, user functions, views, indexes, relational database models and SSRS
• Follow specifications provided by the Data Architect for development of SQL Server Integration Services based solutions for migrating data in both OLTP and Data Warehouse environments.
• Develop triggers, functions, stored procedures to support this effort.
• Assist with impact analysis of changing upstream processes to Data Warehouse and Reporting systems.
• Assist with design, testing, support, and debugging of new and existing ETL and reporting processes.
• Work with other developers, data architects, DBAs, project managers, and client business users to develops specifications and resolve client questions around problems and enhancements.
• Support production processes.
• Create and maintain documentation.
• Good Understanding of OLTP and Dimensional data models.
• Experience with Power BI a plus.
• Strong verbal and written communication skills.
• Be able to manage your time efficiently and work with little supervision
• Experience retrieving data from various database platforms, web service APIs, flat files etc.
Skills
APPS NICHE SKILLS - MICROSOFT TECHNOLOGIES-SQL SERVER INTEGRATION SERVICES (SSIS)