Reporting Analyst Description
Affiliated Computer Services, Inc. (ACS) is expertise in action™. We are a FORTUNE 500 company with 74,000 employees worldwide supporting client operations reaching more than 100 countries. We provide business process outsourcing and information technology solutions to world-class commercial and government clients. Our employees operate with integrity, and are flexible, reliable and responsive. If you meet the requirements of this position and want to work for a world-class company with a great marketplace reputation, apply today.
Job Description Reporting Analyst:
· Developing and optimizing business intelligence and reporting solutions.
· Works with internal customers in understanding reporting requirements, defining scope, developing and testing reports and cubes to meet user requests.
· Identifies issues related to database that show up in the reports and subsequently communicates to resolve and eliminate Data Quality problems.
· Documents business requirements, enhancements, scope change, data mapping.
· Knowledge of Software Development Life Cycle (SDLC) required.
· Familiarity with metadata modeling techniques and best practices.
· Ability to perform SQL statements to perform data validation & analysis.
· Understanding of effective report/dashboard design and standards.
· Employ analytical, conceptual, and creative thinking skills to improve overall business and systems performance.
· Study, evaluate, and document current and future business processes.
· Support overall project management and business strategy related to Business Intelligence
· Strong database skills
· Demonstrated ability to work effectively in a cross functional team environment
· Ability to quickly learn new systems, adapt and refocus in a fast paced, agile development environment
· Strong investigative and troubleshooting skills
· Strong organizational, verbal and written communication skills
Responsibilities
· Work with project lead, analyst, and business users to understand business processes, gather and document project requirements and translate them into functional and non-functional specifications for BI reports and applications.
· Develop parameterized reports through Reporting Services (SSRS) from a variety of data sources including Analysis Services Cubes and prepare for Web deployment.
· Utilize Analysis Services (SSAS) to design multi-dimensional models, including the construction of Data View, Dimensions, and Cubes while adhering to enforced development methodologies.
· Create ad-hoc queries and reports as requested and provide on-going analytical support for these requests. Convert existing reporting tools to a standardized reporting infrastructure using SQL and Microsoft products.
· Identify project risks and impediments, notify management, and proactively work with other members of the team to complete assigned tasks as defined by project scope, timelines, and budgets.
· Determine testing needed to assure the functionality and integrity of reporting solutions, create test plans, and evaluate testing results taking corrective action as necessary.
· Identify data quality issues and support the data governance initiative by participating in necessary activities including data profiling.
· Assist in configuration and upgrades of BI software.
Experience
· Minimum 2 years experience with T-SQL
· Minimum 2 years experience with SQL Databases – SQL 2005 or SQL 2008
· Minimum 1 year experience with Reporting Services
· Experience using Visual Studio
· Experience using Team Foundation Server (TFS)
· Experience publishing reports / dashboards via SharePoint
· Experience creating dashboards using Performance Point & Proclarity BI tools
· Experience in data validation techniques
ACS is an Equal Opportunity Employer and does not Discriminate against any applicant on the basis of race, color, religion/creed, national origin, gender, or sex, marital status, age, disability, use of a guide dog or service animal, sexual orientation, military/veteran status, or any other status protected by Federal or State law or local ordinance. People with disabilities who need a reasonable accommodation to apply or compete for employment with ACS may request such accommodations by calling 866-419-2226 .
|
