Data Analyst - SQL Report Writer
SGT, Inc. - Greenbelt, MD

This job posting is no longer available on washingtonpost.com. Find similar jobs: Data Analyst jobs - SGT jobs

SGT, Inc. is an award winning government contractor inGreenbelt, Maryland with over 1,600 employees nationwide. We are currently seeking a Data Analyst - SQL Report Writer at our HQ office. Individual will be responsible for a wide variety of detailed data analysis and report writing. Efforts include: gathering and documenting business requirements and writing the appropriate Microsoft Access, and Microsoft SQL or Cognos 8 reports.
The following duties and responsibilities apply but are not limited to:

• Write Data Definition Language or Data Manipulation Language SQL commands

• Monitoring the performance of reports and taking corrective action to optimize or improve the performance of the reports when necessary.

• Reconciling discrepancies between the expectations of data managers and information presented in their reports.

• Writing complex time sensitive reports needed for different teams, managers, decision makers or departments by combining data from multiple locations into a data warehouse.

• Draft or review Process, Procedural, and Work Instruction Documentation.

• Perform written test case scenarios for testing programs and proper operation of code.

• Importing, cleaning, transforming, validating business data

• Lead, plan and design highly complex business processes reports and make recommendations to improve and support business activities.

• Analyzes and document customer's complex business requirements and processes; construct conceptual data and process models, including data dictionaries and report structures.

• Coordinate and facilitate meetings with customer on projects to gather and document requirements and explore complex solutions.

• Coordinate data analyst tasks on program/projects and provide team member guidance/support throughout the program life cycle.

• Create complex sets of stored procedures using SQL Server and related views to process and retrieved stored data used in reports, executive dashboards, performance metric, and OLAP cubes.

• Very good knowledge of Microsoft Access, Services Design & Development, with significant experience in using pivot tables, OLAP cubes, and joining tables.

Requirements
• Minimum 4 years of relevant experience as a Data Analyst – SQL Report Writer.

• Significant experience

o Strong analytical skills and strong communication skills are essential

o Strong facilitation skills and the ability to proactively communicate with all levels of SGT management.

• At least 4 years of experience with SQL Server Reporting Services

• Minimum 2 years of experience writing Virtual Basic script or VB .Net.

• Solid understand of data analysis techniques or processes

• Relevant training or certification in Microsoft Access and Microsoft SQL.

• Experience with Deltek MPM and MPM Data Warehouse.

• Experience with OLAP Cube is desired.
SGT offers a comprehensive benefits package, including health, dental, vision, life, long and short term disability, 401k with employer contribution, and tuition assistance. Interested applicants should submit their resumes on-line at https://cr.sgt-inc.com/careers . SGT is an equal opportunity employer. EOEm/f/d/v.

washingtonpost.com - 2 years ago - save job
About this company
SGT, Inc. (http://www.sgt-inc.com) is a 500-person aerospace engineering company providing systems engineering, electrical and electronic...