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.
Minimum 4 years of relevant experience as a Data Analyst SQL Report Writer.
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
SGT, Inc. (http://www.sgt-inc.com) is a 500-person aerospace engineering company providing systems engineering, electrical and electronic...