Business Intelligence Analyst
Austin, Texas
As part of client 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.
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 HHSC Programs and Types of Assistance
Indotronix is an Equal Opportunity Employer
• 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.
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 HHSC Programs and Types of Assistance
Indotronix is an Equal Opportunity Employer
Created: 2024-09-28
Reference: JPC - 180495
Country: United States
State: Texas
City: Austin
ZIP: 78749
About Indotronix International Corporation
Founded in: 1986
Number of Employees: 750
Website: https://www.iic.com/
Career site: https://www.iic.com/current-openings/
Similar jobs:
-
Business Intelligence Analyst
Esolvit, Inc. in Austin, Texas -
Business Intelligence Analyst, Operations
PenFed Credit Union in San Antonio, Texas -
Principal Security Market Analyst, Market Intelligence
Amazon in Austin, Texas💸 $127800 per year -
Business Intelligence Analyst
University of North Texas System in Denton, Texas -
35N Signals Intelligence Analyst
Army National Guard in Houston, Texas -
35F Intelligence Analyst
Army National Guard in Fort Bliss, Texas -
DPS - ICT - Criminal Intelligence Analyst I-III - 6170-6174
CAPPS in Austin, Texas💸 $5844.72 per month -
Signals Intelligence Analyst
US Air force in Goodfellow AFB, Texas -
35F Intelligence Analyst
Army National Guard in Houston, Texas -
Supply Chain Risk Intelligence Analyst, Supplier Governance
Amazon in Austin, Texas -
Business Intelligence Analyst
Esolvit, Inc. in Austin, Texas -
35F Intelligence Analyst
Army National Guard in Austin, Texas -
Cyber Intelligence Analyst
US Air force in Goodfellow AFB, Texas -
Business Intelligence Analyst
Indotronix International Corporation in Austin, Texas -
Signals Intelligence Analyst (35N) Instructor - HTASC - 111
Jacobs in Goodfellow AFB, Texas -
Intelligence Analyst I
Chenega MIOS SBU in Ft Bliss, Texas -
Intelligence Analyst I
Chenega MIOS SBU in Ft Bliss, Texas -
35N Signals Intelligence Analyst
Army National Guard in San Antonio, Texas -
35N Signals Intelligence Analyst
Army National Guard in Austin, Texas -
Market Research Analyst, Market Intelligence
Amazon in Austin, Texas💸 $70900 per year