Data & Reporting Architect

40,000.00 - 65,000.00 USD /year Status: Full Time, Employee Job Category: IT/Software Development Relevant Work Experience: 2+ to 5 Years Career Level: Experienced (Non-Manager) Education Level: Bachelor's Degree Company: Synerfac Technical Staffing Contact: Stacey Campbell Email: Apply by Email Phone: 410-667-3949 Website: www.synerfac.com Data & Reporting Architect Job Title:  Data and Job ArchitectLocation:Linthicum MDDuration:  Direct HireSalary:  40-65kOur client combines skilled partners and advanced technologies to provide expert technical maintenance, repair and installation services nationwide.Responsibilities:• Design and develop reporting and business intelligence (BI) solutions • Primary focus is delivering scheduled, on-demand and ad hoc reporting solutions, as well as, designing, building and provisioning a reporting data warehouse • Support tool evaluation and selection process to conceive and construct data warehouse, ETL (extract-transform-load) processes and BI reporting tools • Work with management, operational personnel and other application developers to ensure reporting and analysis solutions meet required specifications and business logic in a timely and cost effective mannerESSENTIAL DUTIES AND RESPONSIBILITIES: • Organize and maintain library of data exports and reports; fulfill user requests for data/reports • Develop new queries and reports using SQL and various reporting utilities to access and report data from Oracle and SQL Server databases • Design reporting data warehouse and ETL processes to provision optimized reporting data store • Evaluate, select and implement BI reporting tools and critical reports • Derive reporting and BI analysis requirements through working with management and operational personnel • Utilize structured development methodology and artifacts defined for Application Development team • Test computer systems according to specifications, IT standards, procedures and methodologies • Record and update all system requests in System Request and Project tracking logs • Update time tracking logs weekly, detailing time spent on activities throughout the week • Alert IT management of circumstances and conditions that could impact service levels • Embrace and champion the use of productivity tools by the technical staff to improve productivity • Perform other tasks as assigned   EDUCATION and/or EXPERIENCE • College degree or equivalent work experience preferred • Three to Five years of development experience required