Technical Architecture Specialist

Adept Consulting Services, Inc.

$85K — $110K *
Information Technology
Less than 5 years of experience
Job Overview by Ladders

Qualifications

  • 3-5 years of related work experience
  • Excellent verbal and written communication skills
  • 4-year college degree or equivalent technical study desired
  • Extensive knowledge in SSRS development and SQL Server Integration Services for ETL tasks
  • Proficient in .Net Core, MVC, C#, JavaScript, and jQuery
  • Experience with both Oracle and SQL Server databases and their respective SQL languages
  • Strong skills in data modeling and database design analysis.

Responsibilities

  • Develop new SSRS reports and database objects for complex enterprise databases
  • Create and maintain .Net Core MVC applications
  • Design and optimize relational and multidimensional databases
  • Test new SSRS reports and database objects prior to user testing
  • Gather and document business requirements to ensure solution alignment
  • Research and assist in new software release upgrades
  • Implement CI/CD pipelines for automated build and deployment

Benefits

  • Health Care Plan (Medical, Dental & Vision)
  • Retirement Plan (401k)
  • Paid Time Off (PTO)
Full Job Description
Responsibilities include:
• Develops new SSRS reports and database objects against complex enterprise databases (both SQL Server and Oracle) and modifies or enhances existing SSRS reports and database objects as assigned
• Create and maintain .Net Core MVC applications
• Demonstrates experience with the design of relational and multidimensional database
• Demonstrates proficiency in performance tuning to ensure quality and performance of SSRS reports
• Tests the SSRS reports and database objects created and maintained by the service center thoroughly prior to user testing.
• Applies Agile development principles
• Works with business users to gather and document requirements and ensures solutions meet their business needs
• Assists in designing reporting database solutions for the service center and configuring report servers and security
• Researches functionality in new software releases and performs, documents, and assists other staff in the upgrade processes.
• Uses Azure DevOps and work items and provides project statuses and project time estimates to the reporting section supervisor
• Uses GIT for code repository
• Adheres to any standards set by the Service Center and the Governor's Office of Administration
• Demonstrates analytical and customer service skills
• Ensures that best practices are maintained and mentors team members on the best practices, standards, and IT processes
• Documents all work for future reference
• Independently executes all tasks and work assignments
• Create, configure and maintain CI/CD pipelines to automate build and deployment.
• Publishing reports to power BI service workspaces and managing pipeline to deploy the reports to different environments.

Requirements

Skills required:
• 3-5 years of related work experience
• Excellent verbal and written communication required
• 4-year college degree or equivalent technical study desired
• Extensive experience working with Microsoft tools, with in-depth SSRS development knowledge and SQL Server Integration Services to perform ETL operations
• In-depth experience with .net core, MVC, C#, dependency injection, JavaScript, and jQuery experience
• Extensive experience handling large datasets and reporting based on various data sources
• In-depth experience working with Oracle databases and PL/SQL using SQL Developer
• In-depth experience working with SQL Server databases and T-SQL using SQL Server Management Studio
• In-depth experience with data modeling and the ability to analyze and understand database design

Benefits
  • Health Care Plan (Medical, Dental & Vision)
  • Retirement Plan (401k)
  • PTO

Similar Jobs

More Jobs at Adept Consulting Services, Inc.

More Information Technology Jobs

Find similar Technical Architecture Specialist jobs: