Business Systems Analyst Prin in Fort Worth, TX at DynCorp International LLC

Date Posted: 4/11/2018

Job Snapshot

Job Description

Job Summary
 
The IT Business Analyst Principal establishes appropriate methods through project planning, analysis, program development and implementation to achieve effective functional solutions in meeting objectives and priorities.
 
Principal Accountabilities
(Typical duties include the following, although specific duties vary by assignment or contract)
  • Serves as a liaison between the business community and the IT organization in order to provide technical solutions to user needs.
  • Analyzes business operations to understand strengths and weaknesses to determine opportunities to automate processes and functions.
  • Coordinates with business user to define problems, data availability, requirements and implements complex systems which are most cost-effective.
  • Devises or modifies procedures to solve complex problems.
  • Trains, assigns, and checks the work of lower level business analysts.
  • Provides guidance to other business systems analysts in obtaining solutions to complex business problems.
  • Manage projects with limited budgets and duration.
  • Designated as “lead” business systems analyst.
  • Applies advanced understanding of company’s business needs in the resolutions.
  • Facilitates team and client meetings.
  • Responsible for project deadlines and schedules.
  • Performs other duties as assigned.

Knowledge & Skills
  • Requires technical and business knowledge in multiple disciplines/processes.
  • Performs work that is highly complex and varied in nature.
  • Develops integrated solutions to resolve highly complex technical and business issues.
  • Recognized expert internally and externally within a discipline(s) and often provides strategic direction, guidance and integration of products and services.
  • Exhibits confidence and an extensive knowledge of emerging industry practices when solving business problems.
  • Pushes creative thinking beyond the boundaries of existing industry practices and client mindsets.
  • Minimum 3 years of full-time experience in Business Intelligence as BI Developer in data modeling, development and maintenance of database applications on SQL Server in OLTP/OLAP/BI environments
  • Well-versed knowledge of SQL profiler and Query analyzer to enhance performance of SQL server by tracing and tuning the query
  • Expertise in building complex cubes using SSAS SQL Server Analysis Services by implementing dimension table and fact table either form of Star schema or Snow-flex schema.
  • Experience developing ETL packages using SSIS SQL Server Integrated Services
  • Experience designing complex reports such as Drill-down, Cascading, Matrix, cross tab and Map reports using SSRS SQL Server Reporting Services tools.
  • Experience extracting data from various data sources: Oracle, SQL server, raw files, flat files, Excel, and OLE DB sources from Client servers
  • Expertise tuning ETL procedures and STAR schemas to optimize load and query Performance
  • Experienced in using SSIS catalog, File System SQL Server deployment process to deploy ETL packages
  • Email notifications using SSIS
  • Build complex cubes using SSAS SQL Server Analysis Services by implementing dimension table and fact table either form of star schema or snow-flex schema
  • KPI dashboards
  • Create MDX Multidimensional Expressions scripts and built reports on top of cubes.
  • Build regular ad-hoc reports using SSRS SQL Server Reporting Services
  • Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS
  • Designed and developed the reports
  • Involved in Installation, Configuration and Deployment of Reports using SSRS

Experience & Education
  • Bachelor’s degree in Computer Science, MIS, or equivalent professional experience.  Two (2) years of experience in related field may be substituted for each year of the four (4) years of college.  
  • Minimum six (6) plus years experience with IT business, systems, or testing analysis.
  • Client facing/consulting experience
  • Microsoft Certified Technology Specialist: SQL Server, Business Intelligence Development and Maintenance - Desired
  • Microsoft Certified IT Professional: Business Intelligence - Desired

       Software
           • SQL Server Reporting Services, (SSRS)
           • SQL Server Integration Services, (SSIS)
           • SQL Server Analysis Services, (SSAS)
           • Power BI
           • Querying relational data using T-SQL
           • Relational data warehouse design

Physical Requirements/Working Environment
  • Work is in normal office environment.

Travel
  • Ability to travel domestically and internationally will vary by assignment.

CHECK OUT OUR SIMILAR JOBS

  1. Business Analyst Jobs
  2. Systems Analyst Jobs