SSIS/SSRS Developer

2 weeks ago

Independence, United States Strategic Systems Full time
  • Job Title: SSIS/SSRS Developer
  • # of openings: 1
  • Start Date: ASAP
  • Duration: 6-month contract
  • Hours: 8am-5pm
  • Max Subs: N/A
  • Bill Rate: up to $70/hr.
  • Location ....remote Does want the candidate to be in the eastern or central time zone
  • Fully Approved and funded? Yes PO is in Hand
  • Contract-or Contract to Hire- or Perm: Contract
  • Chance for extension (if contract)? N/A
  • Work Status acceptable (USC/GC/H1B): USC or GC
  • Interview Process - how many, with whom, when interviews start, how long will process take start to finish:1- 30-minute phone interview and possibly a 2nd 30 minute interview.
Detailed Job Description - highlight 3-5 Must Haves

Job Description
We are seeking a highly skilled SSIS/SSRS Developer to join our team on a 6-month contract basis. The ideal candidate will have strong experience in developing and maintaining SQL Server stored procedures using T-SQL, as well as expertise in leveraging SSIS (SQL Server Integration Services) and SSRS (SQL Server Reporting Services) to meet business requirements.
You will be responsible for designing, developing, and deploying ETL processes, reports, and dashboards, ensuring high performance and scalability in a fast-paced environment.

Key Responsibilities:
  • Design, develop, and maintain ETL solutions using SSIS to support data integration and transformation.
  • Develop and maintain complex T-SQL stored procedures, functions, and scripts to support SSIS and SSRS processes.
  • Create, manage, and enhance reports and dashboards using SSRS based on business requirements.
  • Collaborate with business analysts, stakeholders, and other developers to understand data and reporting needs.
  • Optimize and troubleshoot existing ETL workflows and reports for performance and reliability.
  • Ensure data accuracy, consistency, and security across all solutions.
  • Conduct testing and validation of ETL processes, stored procedures, and reports.
  • Provide documentation for developed solutions, including technical specifications and user guides.
Required Qualifications:
  • Strong experience with SSIS and SSRS development.
  • Proficiency in T-SQL, with the ability to write, debug, and optimize complex stored procedures.
  • Experience working with SQL Server databases, including database design, performance tuning, and indexing strategies.
  • Solid understanding of data warehousing concepts and ETL best practices.
  • Strong problem-solving skills and the ability to work independently.
  • Excellent communication and interpersonal skills to collaborate effectively with team members and stakeholders.
Preferred Qualifications:
  • Experience with Power BI or other reporting tools is a plus.
  • Familiarity with Agile or Scrum methodologies.
  • Experience in handling large datasets and optimizing data pipelines.

  • SSIS/SSRS Developer

    2 weeks ago

    Independence, United States Strategic Systems Full time

    Job Title: SSIS/SSRS Developer # of openings: 1 Start Date: ASAP Duration: 6-month contract Hours: 8am-5pm Max Subs: N/A Bill Rate: up to $70/hr. Location ....remote Does want the candidate to be in the eastern or central time zone Fully Approved and funded? Yes PO is in Hand Contract-or Contract to Hire- or Perm: Contract ...