SQL Server Reporting Services

CareerCircle
Cedar Rapids, IA, United States
3 months ago
Apply on careercircle.com
Prepare application

Role details

Contract type
Temporary contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Compensation
$93,600.0 - $124,800.0
Working hours
Regular working hours

Tech stack

Microsoft Excel Artificial Intelligence Business Analytics Applications Data Analysis Business Software Configuration Management Databases Data Governance Data Normalization Power BI Software Asset Management SQL Server Reporting Services Technical Data Management Systems
+6 more
Data Processing Enterprise Software Applications Technical Debt Powerquery Network Server Servicenow

Job description

Dashboard Operations Automation Governance ServiceNow, Data Quality Data Analysis Prioritization Risk Reduction Business Valuation Business Intelligence Full Stack Development Artificial Intelligence Business Transformation Attack Surface Management SQL Server Reporting Services Preparing Executive Summaries Enterprise Application Software Configuration Management Databases, We are seeking a high-impact Data Analyst to support our enterprise Tech Debt Remediation Program. This role is critical to transforming fragmented infrastructure, application, and software data into clear, actionable insights that drive risk-based prioritization and executive decision-making.

The ideal candidate is not just a report builder-they are someone who can understand complex data relationships, identify gaps, and translate findings into meaningful actions that accelerate risk reduction and improve overall technology health.

Key Responsibilities

Data Aggregation & Analysis

  • Build and maintain a centralized dataset combining:

o Business applications

o Servers and operating systems

o Software inventory and lifecycle (EOL/EOS)

o Ownership and organizational mapping

  • Reconcile and validate multiple data sources (e.g., CMDB, software inventory tools, Excel datasets, vulnerability data)

Risk & Prioritization Modeling

  • Develop risk-based prioritization models to identify:

o Internet-facing exposure

o End-of-life (EOL) risk

o Attack surface concentration

  • Support tranche-based remediation planning aligned to enterprise risk reduction goals

Reporting & Visualization

  • Design and maintain advanced Excel models and dashboards

o Automated refresh and transformation (Power Query preferred)

o Pivot-driven analysis by BU, LOB, Application, Owner, Criticality

  • Enable clear drilldowns from executive summaries to detailed datasets

Data Quality & Governance

  • Identify and remediate data quality issues in enterprise systems (e.g., ServiceNow CMDB)

o Missing ownership

o Incomplete CI relationships

o Inconsistent classifications

  • Partner with application and infrastructure teams to improve data accuracy

Executive Reporting Support

  • Translate technical data into clear, concise executive outputs

  • Support reporting for stakeholders (CTO, CISO, Head of Infrastructure)

  • Focus on clarity, accuracy, and actionability-no unnecessary noise

AI & Automation Enablement

  • Leverage AI tools (e.g., Copilot, analytics platforms) to:

o Accelerate data processing

o Identify patterns and anomalies

o Enhance insight generation and reporting efficiency

Requirements

Power bi, Data analysis, SSRS, AI enabled analytic tools

Benefits & conditions

Eligibility requirements apply to some benefits and may depend on your job classification and length of employment. Benefits are subject to change and may be subject to specific elections, plan, or program terms. If eligible, the benefits available for this temporary role may include the following:

  • Medical, dental & vision
  • Critical Illness, Accident, and Hospital
  • 401(k) Retirement Plan - Pre-tax and Roth post-tax contributions available
  • Life Insurance (Voluntary Life & AD&D for the employee and dependents)
  • Short and long-term disability
  • Health Spending Account (HSA)
  • Transportation benefits
  • Employee Assistance Program
  • Time Off/Leave (PTO, Vacation or Sick Leave) Workplace Type

About the company

We’re partners in transformation. We help clients activate ideas and solutions to take advantage of a new world of opportunity. We are a team of 80,000 strong, working with over 6,000 clients, including 80% of the Fortune 500, across North America, Europe and Asia. As an industry leader in Full-Stack Technology Services, Talent Services, and real-world application, we work with progressive leaders to drive change. That’s the power of true partnership. TEKsystems is an Allegis Group company., We’re a leading provider of business and technology services. We accelerate business transformation for our customers. Our expertise in strategy, design, execution and operations unlocks business value through a range of solutions. We’re a team of 80,000 strong, working with over 6,000 customers, including 80% of the Fortune 500 across North America, Europe and Asia, who partner with us for our scale, full-stack capabilities and speed. We’re strategic thinkers, hands-on collaborators, helping customers capitalize on change and master the momentum of technology. We’re building tomorrow by delivering business outcomes and making positive impacts in our global communities. TEKsystems and TEKsystems Global Services are Allegis Group companies. Learn more at TEKsystems.com.

The company is an equal opportunity employer and will consider all applications without regard to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.

San Francisco Fair Chance Ordinance: Pursuant to the San Francisco Fair Chance Ordinance, for all positions located in the city and county of San Francisco, we will consider for employment qualified applicants with arrest and conviction records.

Massachusetts Lie Detector: It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability.

Use of Artificial Intelligence (AI): We may use Artificial Intelligence (AI) to support parts of our hiring process, including sourcing, screening, and evaluating candidates. AI helps assess applications and qualifications, but final decisions are made by our hiring team. By applying, you acknowledge and agree that your application may be reviewed using AI tools. Related Jobs Senior Data Analyst - Tech Debt & Risk Prioritization TEKsystems Cedar Rapids, IA*Remote Planning Dashboard Operations Automation Governance ServiceNow Data Quality Data Analysis Prioritization Risk Reduction Business Valuation Business Intelligence Full Stack Development Artificial Intelligence Business Transformation Attack Surface Management

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on careercircle.com
Prepare application

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

3:03 min

Career evolution in data engineering and AI platforms

Maria Apazoglou · Coffee With Developers

56 sec

Integrating automated approval workflows into the portal

Markus Eisele Markus Eisele · World Congress 2025

1:24 min

Moving the semantic layer upstream to avoid vendor lock-in

Piotr Menclewicz Piotr Menclewicz · Europe 2026 Virtual

5:24 min

Identifying hidden architecture issues on SQL Server

Ivan Milanov Ivan Milanov · Europe 2026 Virtual

2:27 min

Establishing a simulated technical environment for the workflow demo

Tobias Dunn-Krahn · LIVE

3:48 min

Standardizing data access schemas with OData

Florian Bader Florian Bader · World Congress 2026 Europe

Videos

See all

Related articles

See all