Atria Group LLC Logo

Atria Group LLC

SQL Report Writer

Reposted 3 Months Ago
Be an Early Applicant
In-Office
Union, IL, USA
Senior level
In-Office
Union, IL, USA
Senior level
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.
The summary above was generated by AI
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

Similar Jobs

49 Minutes Ago
Hybrid
Northbrook, IL, USA
50K-72K Annually
Junior
50K-72K Annually
Junior
Automotive • Professional Services • Software • Consulting • Energy • Chemical • Renewable Energy
Supports UL sales professionals and customers through inquiry follow-up, quote generation, case development, order processing, and pre- and post-sale activities. Coordinates customer requirements, processes quotes into ERP orders, tracks account information, resolves inquiries, and connects customers with appropriate internal teams. Provides administrative support to account managers and sales engineers, mentors less-experienced colleagues, and contributes customer insights to sales strategy and service improvement.
Top Skills: Crm SoftwareErpExcelMicrosoft OutlookMicrosoft PowerpointMicrosoft Word
An Hour Ago
Remote or Hybrid
United States
66K-89K Annually
Junior
66K-89K Annually
Junior
Cloud • Fintech • Software • Business Intelligence • Consulting • Financial Services
Provides Oracle NetSuite optimization consulting for clients, including requirements analysis, discovery sessions, solution recommendations, configuration support, user acceptance testing, documentation, and client working sessions. Tracks project work, budgets, and deliverables; communicates status and issues; mentors junior consultants; and supports research, sales, marketing, and cross-selling initiatives.
Top Skills: ExcelMicrosoft OutlookMicrosoft PowerpointMicrosoft VisioMicrosoft WordOracle Netsuite
An Hour Ago
Remote or Hybrid
United States
80K-108K Annually
Senior level
80K-108K Annually
Senior level
Cloud • Fintech • Software • Business Intelligence • Consulting • Financial Services
Leads full-cycle iSolved HCM and payroll implementations, including requirements discovery, configuration, data validation, testing, training, go-live, and post-implementation transition. Manages multiple customer projects, timelines, resources, risks, and deliverables while recommending solutions and coordinating internal teams. Mentors junior consultants, reviews implementation work, and improves implementation processes. Requires knowledge of payroll, time and attendance, benefits, HR administration, and software implementation in a client-facing consulting environment.
Top Skills: HcmHrisIsolvedSaaS

What you need to know about the Chicago Tech Scene

With vibrant neighborhoods, great food and more affordable housing than either coast, Chicago might be the most liveable major tech hub. It is the birthplace of modern commodities and futures trading, a national hub for logistics and commerce, and home to the American Medical Association and the American Bar Association. This diverse blend of industry influences has helped Chicago emerge as a major player in verticals like fintech, biotechnology, legal tech, e-commerce and logistics technology. It’s also a major hiring center for tech companies on both coasts.

Key Facts About Chicago Tech

  • Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
  • Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
  • Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
  • Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
  • Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account