Job Details

Position: Business Intelligence Specialists (Ref: 11379)
Location: Nashville, TN 37243 USA
Duration: 1 Years 11 Months 25 Days - Contract
Openings: 2
Deadline: 08/19/2022
Pay Rate:Login


We are seeking a Business Intelligence Specialists who will be assigned to Data Conversion sub-project. Candidate will assist with activities related to extraction of data from legacy applications and querying and presenting data to facilitate mapping and migration decision making. Candidate is responsible for professional business intelligence work of considerable difficulty involving design, development, and maintenance of business intelligence technology solutions; and performs related work as required.

Developing Objectives and Strategies:
• Understands and assists in defining the Business Intelligence and Reporting Architecture and its integration into the overall Technology Service.

Coordinating the Work and Activities of Others:
• Facilitates requirements gathering sessions using expert listening skills and develops unique simple solutions to meet the immediate and long-term needs of business customers.

Processing Information:
• Validates and tests solutions to ensure the business requirements are met. Validates report results to ensure customer requirements are met. Researches, analyzes, and reports on information from a variety of sources.

Analyzing Data or Information:
• Analyzes source systems and develops a logical/business data model to determine the reporting capability of available data.
• Understands pertinent data models and business processes in order to fulfill customer requests for maintenance, support and enhancements.
• Understands, implements, and maintains the security model for business intelligence solutions to prevent unauthorized access.
• Integrates multiple disparate processes to address short and long-term business needs.

Making Decisions and Solving Problems:
• Analyzes and troubleshoots processes to resolve issues.
• Troubleshoots, diagnoses, and resolves problems/issues within the Business Intelligence solution environment.
• Conducts investigations into data anomalies both proactively and as identified by users.
• Analyzes tradeoffs between usability and performance needs.

Interacting With Computers:
• Tunes Extract Transform Load (ETL) processes and reporting queries to maximize performance.
• Develops a physical data model and identifies facts, dimensions, and key values.
• Deploys solutions utilizing Business Intelligence concepts such as: data mining, predictive analytics and trend analysis to provide management with insight into their business.
• Implements Extract Transform Load (ETL) solutions using business intelligence data ETL tools.
• Generate standard or custom reports summarizing business data for review by executives, managers, clients, and other stakeholders.
• Develops queries for validation of work outputs, and source system confirmation.
• Codes solutions using appropriate computer programming language.
• Develops and Extract Transform Load (ETL) schedule that recognizes dependencies, pre-processing tasks, post-processing tasks and notifications for data administration.
• Develops reports based on customer requirements.
• Develops and maintains complex data storage structures needed to support data warehouse functions to ensure data is maintained in consistent formats.
• Designs reports based on customer requirements.
• Integrates Business Intelligence solutions with existing office productivity suites.
• Develops Business Intelligence reporting components within existing business intelligence and reporting platforms in support of strategic initiatives. Implements reporting solutions using business intelligence data presentation tools.

Identifying Objects, Actions, and Events:
• Participates in the identification of key performance indicators and methods for data warehouse to assist with operational and strategic planning.

Estimating the Quantifiable Characteristics of Products, Events, or Information:
• Estimates work plan tasks.

Getting Information:
• Gathers and identifies the information available from various source systems.
• Conducts requirements gathering sessions with business stakeholders to define, formulate and prioritize Business Intelligence requirements.

Updating and Using Relevant Knowledge:
• Understands business intelligence concepts and methodologies.

Establishing and Maintaining Interpersonal Relationships:
• Collaborates with clients to understand technical requirements stemming from the business functional requirements of a particular request.

Provide Consultation and Advice to Others:
• Provides guidance and consultation to users to increase their understanding of the Business Intelligence tool's capabilities in order to better meet their business needs.

Communicating with Persons Outside Organization:
• Acts as liaison between technical and non-technical teams.

Evaluating Information to Determine Compliance with Standards:
• Follows proper configuration management and change controls to promote system stability and to provide an audit trail of modifications.

Documenting/Recording Information:
• Documents use cases to ensure the Business Intelligence solution meets the business requirements. Documents business flows for new and existing systems ensuring long-term maintainability.

Coaching and Developing Others:
• Provides training and assistance to business users in the generation of ad hoc reports.
• Acts as a mentor/teacher to other development resources in the area of business intelligence and reporting development, including usage techniques and best practices.
• Provides technical assistance and cross-training to other team members.

Monitor Processes, Materials, or Surroundings:
• Monitors the reporting component of business intelligence systems to identify performance issues and process failures.
• Monitors the data warehouse and business systems performance and integrity. Monitors and tracks usage of business intelligence systems.

Competencies (KSA’s)
• Intellectual Horsepower, Functional/Technical Competency, Problem Solving, Customer Focus, Business Acumen, Decision Quality, Learning on the Fly, Technical Learning, Process Management, Written Communication, Perseverance

• Knowledge of Business Intelligence Reporting Tools, Knowledge of Data Analysis, Knowledge of Business Intelligence Concepts, Knowledge of Query Languages, Knowledge of Data Modeling Concepts, Knowledge of Dashboard Development, Knowledge of Scorecard Development, Knowledge of Extract Transform and Load (ETL) Development, Knowledge of Office Automation Software, Knowledge of Schedule Maintenance, Knowledge of Programming Languages

• Critical Thinking, Complex Problem Solving, Troubleshooting, Reading Comprehension, Systems Analysis, Writing, Programming, Active Listening, Judgment and Decision Making, Speaking, Negotiation, Time management

• Mathematical Reasoning, Written Comprehension, Information Ordering, Oral Comprehension, Deductive Reasoning, Inductive Reasoning, Oral Expression, Written Expression, Perceptual Speed, Visualization, Problem Sensitivity, Speed of Closure

Tools and Equipment Used:
• Personal Computer, Telephone, Fax Machine, Printer, Copy Machine, Scanner, Mobile Devices, Projector/Audio-Video Equipment

Required / Desired Skills

  • AWS-CSA Professional (cloud) (Required 1 Years)
  • Data Analysis (Required 7 Years)
  • Data Warehousing (Required 7 Years)
  • Microsoft SQL Server (Required 7 Years)
  • MySQL (Required 4 Years)
  • Python (Required 1 Years)
  • SQL Writing (Required 7 Years)
  • Data Analytics Specialist (Required 1 Years)
  • Presentation skills (Required 1 Years)
  • Microsoft Office (Required 7 Years)
  • SQL Server Reporting Services (SSRS) (Required 4 Years)
  • Data migration experience (Required 4 Years)
  • SSIS (Required 1 Years)
  • AWS GLUE (Required 1 Years)

copyright @ All rights reserved
Professional Tech Integration, Inc., Computers  Sys Designers & Consult, Norcross, GA