SQL Report Writer

Posted 11 Days Ago
Be an Early Applicant
Union, IL, USA
In-Office
Senior level
Information Technology • Professional Services • Software • Consulting
The Role
Design, develop, and maintain SSRS and Crystal reports and dashboards. Gather business requirements, analyze data, ensure data integrity, troubleshoot production issues, create test scenarios, and implement scalable reporting processes.
Summary Generated by Built In
Company Description

We specialize in Staffing, Consulting, Software Development, and Training along with IT services to small to medium size companies. AG's primary objective is to help companies maximize their IT resources and meet the ever-changing IT needs and challenges.

In addition, AG offers enterprise resource planning and enterprise application integration, supply-chain management, e-commerce solutions, and B2B public exchanges and B2B process integration solutions. Our company provides application analysis, design, development and programming, software engineering, systems development, testing, integration, and implementation, and management consulting services to various clients – including governmental agencies and private companies – throughout the United States and India.

We provide these services in multiple computing environments and use technologies such as client/server architecture, object-oriented programming languages and tools, distributed database management systems, state-of-the-art networking, and communications infrastructures. Our honest and realistic approach to recruiting dictates that AG does not entice or lure engineers from their employers. We represent only high caliber technical professionals who have committed to making a change required by career.

Job Description

Under the direction of the IT Manager, the SSRS Reporting Analyst/Report Writer will be responsible for providing reporting support for our business teams across the organization. Looking for someone who is comfortable working with the business side and gathering requirements from them in order to write the reports. 

 Essential Functions:

•Performs data analysis and creates reports in Crystal and SSRS

•Troubleshoots issues in production environments in a timely manner

•Develops reports and reviews with business teams as needed

•Comprehends concepts like slowly changing dimensions, star schema marts, fact and dimension tables

•Gathers requirements and prepares analysis based on information from internal and external sources to evaluate and demonstrate program effectiveness and efficiency

•Develops scalable reporting processes and querying data sources to conduct ad hoc analysis

•Develops test scenarios and scripts

•Develops and prepares highly complex reports and provide and/or interpret information and data across divisions and departments

•Assumes responsibility for data integrity among various internal groups and/or between internal and external sources

•Expertise in Software Development Life Cycle (SDLC)

 Knowledge/Skillset:

•Bachelor's degree in Computer Science, Computer Information Systems or related field

•Minimum of 5 years of experience in information technology and 2-4 years’ experience with report/dashboard development

•2-4 years’ experience with SSRS, SSIS, T-SQL and Crystal

•Proficiency with Microsoft Office Suite (Word, Excel, Power Point, Outlook)

•Strong communication and presentation skills

•Proven ability to be flexible and motivated, and to work well both independently, and in a team environment, in a high pressure environment with changing priorities.

•Willingness to work occasionally outside of normal business hours.

•Experience in the development and implementation of standards, procedures and guidelines to support operational processes.

•Ability to prioritize, meets deadlines, be flexible and manage multiple projects.

Qualifications

  • Bachelor's degree in Computer Science, Computer Information Systems or related field
  • Minimum of 5 years of experience in information technology and 2-4 years’ experience with report/dashboard development

Additional Information

  1. Good comm skills are a big priority
  2. Duration: long term contract (6 months plus)
  3. Process: phone followed by f2f interview

Skills Required

  • Bachelor's degree in Computer Science, Computer Information Systems or related field
  • Minimum of 5 years of experience in information technology
  • 2-4 years' experience with report/dashboard development
  • 2-4 years' experience with SSRS, SSIS, T-SQL and Crystal Reports
  • Proficiency with Microsoft Office Suite (Word, Excel, PowerPoint, Outlook)
  • Strong communication and presentation skills
  • Expertise in Software Development Life Cycle (SDLC)
  • Ability to develop and implement standards, procedures and guidelines to support operational processes
  • Willingness to work occasionally outside normal business hours
  • Ability to prioritize, meet deadlines, and manage multiple projects
  • Knowledge of data modeling concepts (slowly changing dimensions, star schema, fact and dimension tables)
  • Experience troubleshooting production environments and ensuring data integrity across sources
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
125 Employees

What We Do

Atria Group LLC, also operating as Atria IT, is a specialized IT staffing and consulting firm headquartered in Plano, Texas. The company provides comprehensive workforce solutions, including staffing, consulting, software development, and training services, specializing in enterprise solutions for small to medium-sized businesses. Their primary objective is to assist these enterprises in maximizing their IT resources to meet evolving technological challenges.

Similar Jobs

Caterpillar Logo Caterpillar

Analytics Project Leader

Artificial Intelligence • Cloud • Internet of Things • Software • Cybersecurity • Industrial
Hybrid
Peoria, IL, USA
100000 Employees
113K-169K Annually

Caterpillar Logo Caterpillar

Data Scientist

Artificial Intelligence • Cloud • Internet of Things • Software • Cybersecurity • Industrial
Hybrid
Peoria, IL, USA
100000 Employees
89K-134K Annually

OpenX Technologies Logo OpenX Technologies

Business Development Director

AdTech • Enterprise Web • Information Technology • Machine Learning • Marketing Tech • Sales
Easy Apply
Remote or Hybrid
US
420 Employees
140K-165K Annually

Ahold Delhaize USA Logo Ahold Delhaize USA

Manager III Engineering

AdTech • eCommerce • Food • Marketing Tech • Retail
Hybrid
Chicago, IL, USA
10000 Employees
151K-227K Annually

Similar Companies Hiring

Golden Pet Brands Thumbnail
Digital Media • eCommerce • Information Technology • Marketing Tech • Pet • Retail • Social Media
El Segundo, California
178 Employees
Kepler  Thumbnail
Fintech • Software
New York, New York
6 Employees
Onshore Thumbnail
Artificial Intelligence • Fintech • Software • Financial Services
New York, New York
60 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account