Allied Consultants (Texas)
Business Intelligence Analyst
Allied Consultants (Texas), Austin, Texas, us, 78716
OverviewAllied Consultants, Inc. is an Austin-based firm which has for 32 years been a premier provider of technical and business professionals to clients in Texas. We are currently seeking an experienced
Business Intelligence Analyst
to be a key resource on a technical services team.
Allied Consultants offers its family of consultants excellent rates, a local support staff, and an attractive benefits package which includes medical insurance (Allied shares a percentage of the cost), life insurance, a matching 401(k) plan and a cafeteria plan.Candidates selected for interview will be required to undergo criminal background checks and may be required to complete a drug screen in accordance with Federal and State Law.
Offers of Employment are contingent on a successful background checkAllied Consultants is an equal opportunities employer.
ResponsibilitiesAnalysts use data to figure out market and business trends for companies to increase profits and efficiency. They may work directly for a company or as a consultant. They able to look at large chunks of data and understand trends, and then communicate those trends to the company.
The Department of Information Resources (DIR) requires the services of one Business Intelligence Analyst, hereafter referred to as Worker, who meets the general qualification of Business Intelligence Analyst, and the specifications outlined in this document for the above-named customer.
As part of the client's IT Applications – Social Services Applications initiatives, the worker will perform the following activities to accomplish the following goals:
Performs advanced metrics and reporting development in Informatica and Cognos, and performance monitoring & tuning for TIERS DataMart. Work involves providing for the effective and efficient storage, retrieval, customization, and archiving of data by managing diverse data sets and to ensure integrated and stable database systems.
Supports and performs the planning, design, administration, operation and maintenance of the TIERS DataMart database. Performs database design & development and provides database related support to the application development teams that are performing application enhancements planned to support new program & business requests and to enhance Scalability & Stability of the applications. Provides technical expertise for data retrieval and update programs. Writes and debugs complex reports in Informatica and Cognos. Plans, develops, and implements database policies and procedures; and ensures data integrity as maintenance and modification projects to existing applications are undertaken. Participates in the development of and enforces programming standards for programs interfacing with the databases. Provides technical assistance to programming personnel.
Configures and monitors alerts. Develops and implements appropriate monitoring tools. Plans for future data needs ensuring that needed capacity is available. Develops policies and procedures to ensure consistent implementation of database and programming best practices. Contributes to development of budgets and recommendations for future upgrades. Contributes to improving and creating database application processes and procedures
Work with other teams as necessary to accomplish goals.
Create technical and design documentation, as required.
Perform system analysis and problem resolution, as required.
Analyze software for configuration & performance tuning opportunities, as required.
Develop and maintain data and process models, as required.
Employ contemporary testing methods to ensure applications function properly and without error.
Provide technical support for testing and implementation efforts.
Participate in program design, coding and test walk-through meetings to provide input regarding technical standards and customer requirements.
Provide database support (defect repair, maintenance, and production operations support) for State Portal DataMart reports. Perform system analysis, troubleshooting, diagnosis and problem resolution. Analyze software for defects and performance tuning opportunities. Develop and test code/scripts to resolve defects and improve application reliability and performance
Other duties as assigned.
QualificationsMinimum Requirements: Candidates that do not meet or exceed the
minimum
stated requirements (skills/experience) will be displayed to customers but may not be chosen for this opportunity.
Years
Required/Preferred
Experience
8
Required
Knowledge of Informatica 10.5
8
Required
Developing reports in Cognos Analytics 11.1
8
Required
Experience Using Unix cron
8
Required
Experience Writing Unix shell scripts
8
Required
Experience Writing moderate to advance SQL queries
8
Required
Extensive Knowledge of Oracle 19
8
Required
Basic knowledge of star schemas/dimensional data structures
8
Required
Exceptional Technical writing
3
Preferred
Knowledge of TIERS or client's Programs and Types of Assistance
Business Intelligence Analyst
to be a key resource on a technical services team.
Allied Consultants offers its family of consultants excellent rates, a local support staff, and an attractive benefits package which includes medical insurance (Allied shares a percentage of the cost), life insurance, a matching 401(k) plan and a cafeteria plan.Candidates selected for interview will be required to undergo criminal background checks and may be required to complete a drug screen in accordance with Federal and State Law.
Offers of Employment are contingent on a successful background checkAllied Consultants is an equal opportunities employer.
ResponsibilitiesAnalysts use data to figure out market and business trends for companies to increase profits and efficiency. They may work directly for a company or as a consultant. They able to look at large chunks of data and understand trends, and then communicate those trends to the company.
The Department of Information Resources (DIR) requires the services of one Business Intelligence Analyst, hereafter referred to as Worker, who meets the general qualification of Business Intelligence Analyst, and the specifications outlined in this document for the above-named customer.
As part of the client's IT Applications – Social Services Applications initiatives, the worker will perform the following activities to accomplish the following goals:
Performs advanced metrics and reporting development in Informatica and Cognos, and performance monitoring & tuning for TIERS DataMart. Work involves providing for the effective and efficient storage, retrieval, customization, and archiving of data by managing diverse data sets and to ensure integrated and stable database systems.
Supports and performs the planning, design, administration, operation and maintenance of the TIERS DataMart database. Performs database design & development and provides database related support to the application development teams that are performing application enhancements planned to support new program & business requests and to enhance Scalability & Stability of the applications. Provides technical expertise for data retrieval and update programs. Writes and debugs complex reports in Informatica and Cognos. Plans, develops, and implements database policies and procedures; and ensures data integrity as maintenance and modification projects to existing applications are undertaken. Participates in the development of and enforces programming standards for programs interfacing with the databases. Provides technical assistance to programming personnel.
Configures and monitors alerts. Develops and implements appropriate monitoring tools. Plans for future data needs ensuring that needed capacity is available. Develops policies and procedures to ensure consistent implementation of database and programming best practices. Contributes to development of budgets and recommendations for future upgrades. Contributes to improving and creating database application processes and procedures
Work with other teams as necessary to accomplish goals.
Create technical and design documentation, as required.
Perform system analysis and problem resolution, as required.
Analyze software for configuration & performance tuning opportunities, as required.
Develop and maintain data and process models, as required.
Employ contemporary testing methods to ensure applications function properly and without error.
Provide technical support for testing and implementation efforts.
Participate in program design, coding and test walk-through meetings to provide input regarding technical standards and customer requirements.
Provide database support (defect repair, maintenance, and production operations support) for State Portal DataMart reports. Perform system analysis, troubleshooting, diagnosis and problem resolution. Analyze software for defects and performance tuning opportunities. Develop and test code/scripts to resolve defects and improve application reliability and performance
Other duties as assigned.
QualificationsMinimum Requirements: Candidates that do not meet or exceed the
minimum
stated requirements (skills/experience) will be displayed to customers but may not be chosen for this opportunity.
Years
Required/Preferred
Experience
8
Required
Knowledge of Informatica 10.5
8
Required
Developing reports in Cognos Analytics 11.1
8
Required
Experience Using Unix cron
8
Required
Experience Writing Unix shell scripts
8
Required
Experience Writing moderate to advance SQL queries
8
Required
Extensive Knowledge of Oracle 19
8
Required
Basic knowledge of star schemas/dimensional data structures
8
Required
Exceptional Technical writing
3
Preferred
Knowledge of TIERS or client's Programs and Types of Assistance