SQL/SSIS/SSRS Developer

Overview

We are seeking a dynamic and detail-oriented SQL/SSIS/SSRS Developer to join our DevOps team. In this role, you will be responsible for designing, developing, and maintaining robust data solutions that support a variety of client facing and internal ICOMM initiatives, as well as running various data transformation projects and complex reporting solutions. The candidates expertise will enable ICOMM's application suite to continue to evolve for all aspects of the organization by leveraging advanced data management and integration techniques within an Azure cloud environments. This position offers an exciting opportunity to work with leading-edge data systems, an robust Azure environment, and modern software development practices in a fast-paced, and culture-focused workplace.

Duties

• Develop, test, and optimize SQL queries, stored procedures, and functions to support complex reporting and analytics needs.
• Design and implement data pipelines using SSIS to facilitate seamless data integration from diverse sources such as Oracle, Workday, ServiceNow, and other cloud-based applications.
• Create comprehensive reports and dashboards utilizing SSRS and integrate them with ICOMM's application and processes.
• Collaborate with ICOMM's other teams to gather requirements, translate business needs into technical solutions, and ensure data accuracy and integrity.
• Maintain and enhance existing data warehouse architectures.
• Support the development of data models, data management strategies, and query management practices to improve system performance.
• Participate in the full development cycle, contribute to code reviews, and implement best practices for software development in Azure.

Skills

• Strong proficiency in SQL programming with extensive experience in Microsoft SQL Server databases.
• Hands-on experience with SSIS.
• Expertise in SSRS for report creation and business intelligence solutions.
• Knowledge of Azure cloud environments.
• Experience working with data modeling and data warehousing design.
• Understanding of RESTful API integration for connecting various data sources and services.
• Strong analysis skills combined with experience in analytics tools like Looker or similar BI platforms.
• Familiarity with software development methodologies including Agile practices to ensure iterative delivery of high-quality solutions.

ICOMM is a dynamic, fast growing IT and Telecommunications Management firm, specializing in IT and Telecom Expense Management, Telecom Support Services and Enterprise Mobility Management. For over 20 years, ICOMM has built a strong reputation as a trusted partner, providing outsourced support services for mid-size to large corporations, resulting in improved end-user satisfaction and annual cost-savings in the tens of millions of dollars.

Pay: $95,000.00 - $115,000.00 per year

Benefits:

• 401(k)
• 401(k) matching
• Dental insurance
• Flexible schedule
• Health insurance
• Paid time off
• Vision insurance

Work Location: Hybrid remote in Forest Park, IL 60130