Role : Business Intelligence Analyst
Location : Remote (Texas)
Duration : Contract (W2 Only)
Not working C2C / C2H on this role. Thanks
Job Description
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.
Minimum Requirements :
- 8 Years of relevant experience
- Knowledge of Informatica 10.5
- Developing reports in Cognos Analytics 11.1
- Experience Using Unix cron
- Experience Writing Unix shell scripts
- Experience Writing moderate to advance SQL queries
- Extensive Knowledge of Oracle 19
- Basic knowledge of star schemas / dimensional data structures
- Exceptional Technical writing
- Knowledge of TIERS or HHSC Programs and Types of Assistance