Business Analyst (Data Warehouse // Data Modeling)

Business Analyst (Data Warehouse // Data Modeling)

26 Nov 2024
Colorado, Denver, 80201 Denver USA

Business Analyst (Data Warehouse // Data Modeling)

Vacancy expired!

Job Title - Business Data Analyst (Intermediate)

Location – Denver CO

Length – (5 Months Contract to Hire)


Job Description
We are actively seeking a

Business Data Analyst (Intermediate) to join our Denver-based team and support technical assistance efforts for our federal customer. The successful candidate will work with business sponsors and other relevant stakeholders to define and document the business requirements for complex government software systems and advises on the design and build of relational databases for secure data storage or processing. The ability to work with both technical and non-technical audiences is very important, so having a solid understanding of the software development process is key. Most of the work will be performed virtually, but some work at the government site in Denver can be expected.
We are a technical, professional services company providing state-of-the-art solutions to government and commercial clients. Our services include custom-engineered solutions that integrate with the latest technology, resulting in advanced information technology systems; business and management consulting services to assess client; and strategic and tactical program expertise to support continuity and provide comprehensive oversight for mission-critical initiatives.
We partner with government and commercial agencies that require the development of systems, such as communication systems, asset management, network deployment and engineering services, power and energy management solutions, portal applications, command and control, and GIS to operate more efficiently and profitably.
As a leading IT consulting and strategic outsourcing leader, we are always looking for exceptionally bright and motivated people to join our team. We are thought leaders in our market space – providing comprehensive solutions to our clients, throughout the enterprise. Our staff members enjoy a collaborative working environment and recognize our staff member’s contributions to the team’s success as well as individual professional accomplishments. We offer competitive salaries and a comprehensive employee benefits package. If you are looking for an opportunity to use your skills in innovative ways, in an environment that promotes freethinking, presents positive challenges, and makes a real impact – This is the place for you!

Responsibilities
Experience with DBMS design and system analysis, current operating systems software internals and data manipulation techniques and languages required to perform the specific job activities are key skillsets. Works closely with peers to evaluate the effects of systems tools or equipment changes on the database and to ensure continuing integration of the database. An understanding of Agile development lifecycle is important in defining Minimal Viable Data (MVD) specifications when legacy applications are targeted for migration to modern platforms.

Key Tasks
  • Perform business analysis to support the project managers in defining project scope and objectives as well as eliciting information and documenting functional requirements from product owners and business sponsors through oral and written communication.
  • Understand data standardization and data governance methodologies and develop strategy towards successful implementation of these methodologies.
  • Develop strategies for full-lifecycle data usage, including data acquisition, legacy data migration, warehouse implementation, and archive recovery.
  • Ensure that designed systems provide enough controlled avenues for access to and update of the database.
  • Ensure the currency, accuracy, and integrity of the data.
  • Assist in cleaning and maintaining database by removing and deleting old data.
  • Evaluate new data sources for adherence to the organization's quality standards and ease of integration.
  • Support the development of Legacy to Target data mapping (for Extract, Transform, Load/ETL processes.)

Education and Experience
  • A BA/BS Degree in Computer Science or related discipline (or an equivalent combination of education and experience)
  • Minimum of five (5) years in business analysis experience and at least three (3) years in data analysis including data modeling (conceptual, logical, and physical) data analysis, data migration, database tuning, and database administration.

Required Skills and Competencies
  • Client Interaction: Facilitating meetings with subject matter experts from various levels of the business to organize work and priorities. Discuss data standardization and data governance methodologies and help guide the client towards successful implementation of these methodologies.
  • Business analysis: Creating required business process deliverable documents. Examples of documents include concept of operations, business case, business requirement specifications (BSR), workflow diagrams, context diagrams, use cases, user stories, and alternatives analysis documentation.
  • Data analysis: Understanding and interpreting facilities, infrastructure, and planning data to include comparatives, gaps, needs, values, limits, applications, matrices, processes, models, impacts, issues, manipulation, organizational, performance, conformity, and recommendations. Includes fusing data from several sources to conduct analysis and provide reports, tables, graphs, and charts.
  • Data modeling: Creation of conceptual, logical, and physical data models and defining data interfaces between systems.
  • Data migration: Planning and executing data migration efforts. Define plans for data that needs to be brought forward from legacy system and that does not meet new data standards (bad data planning). Preparing data, documents, and files for entry and upload within established standards.
  • Strong technical writing skills, with the ability to concisely describe data requirements and functional requirements. Documentation is a primary deliverable for this position.

Desired Skills
  • Business Process analysis skills
  • Possess a solid understanding of Agile development methodologies.
  • Experience with working with Geospatial Data.
  • Data mining: Mining enterprise systems and applications for data and information in support of infrastructure investment strategy and planning. Extensive knowledge of querying databases using structured query language (SQL) is required.
  • Data collection: Includes identifying, compiling, arranging, sorting, organizing, incorporating, reviewing, and determining applicability from various sources.
  • Prior government work experience (as a federal employee or a government contractor) a plus.
  • Experience working with a wide range of personnel, including business sponsors, product owners, project managers, development teams, and end users at all levels of the organization.
  • Familiarity with formalized requirements management concepts (including requirements traceability) such as those defined by PMI and IIBA.

Related jobs

Job Details

  • ID
    JC23507623
  • State
  • City
  • Job type
    Contract
  • Salary
    Depends on Experience
  • Hiring Company
    APN Software Services, Inc
  • Date
    2021-11-24
  • Deadline
    2022-01-23
  • Category

Jocancy Online Job Portal by jobSearchi.