Summary:
The primary responsibility is to define and analyze enterprise business intelligence requirements and design, develop, and deploy data reporting/analysis tools and decision support applications. Acts as a liaison between information technology and business units. Ensures data accuracy. Assesses data extraction, report generation, and bugs involving operational reporting, data warehouse, and data marts. Requires thorough knowledge of database concepts, practices, and procedures. Relies on extensive experience and judgment to plan and accomplish goals. Performs a variety of tasks. A wide degree of creativity and latitude is expected.
Essential Duties and Responsibilities include the following. Other duties may be assigned:
· Gather, document, and analyze enterprise data reporting, analytical, and decision support requirements.
· Interacts with user community to understand requirements.
· Design enterprise business intelligence applications/solutions that leverage historical and operational data repositories to enhance strategic decision making.
· Develop and test business intelligence applications as per solution specifications.
· Review and validates report and analytical data for accuracy.
· Maintain enterprise business terms definitions, coding definitions, and metadata for enterprise data management in cooperation with ongoing data stewardship initiatives.
· Assist with developing and maintaining extract, transform, and load (ETL) processes for loading and validating integrated historical and operational data repositories.
· Maintain and enhance assigned core/legacy software applications/systems.
· Create project deliverables, including project plans, requirements documents, design documents, test plans, test cases, etc.
· Review and report project progress to management and to project team through status reports and regularly scheduled meetings.
· Develop technical and user documentation on current systems / processes.
· Act as primary support for business intelligence and assigned core/legacy applications.
· Communicate with site users regarding system enhancements and or scheduled upgrades
· Analyze, review and alter systems, programs, and applications to increase operating efficiency or to adapt to new requirements.
· Provide accurate estimates of effort required to complete assigned project/requests.
· Prioritize and deliver assigned tasks on schedule to meet business needs based on approved project plans.
· Conduct job duties and responsibilities according to GVTC application and Systems Development Life Cycle (SDLC) methodologies.
· Conduct research on emerging application development software products, languages, and standards in support of procurement and development efforts.
· Develop new software programs and applications in support of the business needs of GVTC.
· Appropriately test all new/modified applications and programs to verify correctness of results and compliance with original user requirements.
· Regressions test all program/application modifications to ensure that existing functionality has not been adversely impacted by changes.
· Administer critical analysis of test results and deliver solutions to problem areas.
· Develop and maintain user manuals and guidelines.
· Assists users to troubleshoot/solve operating problems with applications under their responsibility.
· Become in-house expert on third party applications supported and provide first line support for those applications.
· Assist in generating statistics and reports for management on the efficiency and effectiveness of the application development and support process.
· Partner with team members and users to assist in resolving problems with software products or company software systems.
· Establish and maintain appropriate working relationships with colleagues, users and management
· Become familiar with and follow all general company policies as well as any policies or procedures that are specific to the IT department.
· Become the subject matter expert for all applications for which he/she has been designated as the primary contact.
· Troubleshoot, analyze, and correct system issues and software errors in accordance with the company’s defined methodology and procedures for technical support, application development, and change control.
· Provide weekly status reports of all assigned projects/requests.
Qualifications: To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
Education/Experience:Associates or bachelor’s degree in the field of computer science or software engineering, and 3+ years’ work experience. Telecommunications experience preferred.
Language Ability:
· Strong written and oral communication skills.
· Ability to read and comprehend technical documentation.
· Ability to create training/instructional documents for end users of technical systems.
· Ability to present ideas in user-friendly language.
Core Competencies:
· Flexible and adaptable in regard to learning and understanding new technologies.
· Strong interpersonal skills.
· Highly logical.
· Technically proficient.
· Highly self motivated and directed.
· Keen attention to detail.
· Ability to effectively prioritize and execute tasks.
· Able to work both independently and in a team-oriented, collaborative environment.
Technical Skills (Required):
· Working knowledge of database design and development concepts.
· Working knowledge of Microsoft Transact/SQL, stored procedures, triggers, etc.
· Familiarity with Microsoft SQL Server Management Studio.
· Working knowledge of Microsoft Visual Studio.
· Working knowledge of PowerBI
· Hands on troubleshooting experience.
· Working knowledge of Python or other machine learning system
· Working knowledge of business systems principles.
· Ability to conduct research into software-related issues and products.
· Proven analytical and problem-solving abilities.
· Knowledge of applicable data privacy practices and laws.
Technical Skills (Preferred):
· Working knowledge of the Microsoft .NET Development Framework.
· Working Knowledge of MicroStrategy platform
· Working knowledge of Microsoft SQL/Server Reporting Services (SSRS).
· Working knowledge of Microsoft SQL/Server Analysis Services (SSAS).
· Working knowledge of Microsoft SQL/Server Integration Services (SSIS).
· Familiarity with object-oriented analysis & design (OOA) principles.
· Familiarity with the Microsoft Office Suite
Professional Appearance: Employees will professionally represent GVTC by adhering to GVTC’s Attire and Grooming Policy.
Supervisory Responsibilities: None
Working Conditions: The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
The noise level in the work environment is moderate.
This job requires working in a business office with computers, printers, and light traffic.
Overtime hours may occasionally be required to meet project deadlines.
Physical Demands: The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
While performing the duties of this job, you must be able to sit for extended periods of time.
This position requires dexterity of hands and fingers to operate a computer keyboard, mouse, and other devices.
The job duties listed in this job description may not be inclusive of all requirements of this position. Other duties may be assigned by your supervisor.
Job Type: Full-time
Pay: $72,315.00 - $100,000.00 per year
Compensation Package:
- Bonus opportunities
- Performance bonus
Application Question(s):
- Will you be able to successfully take and pass a drug and alcohol screening?
- Will you be able to work in the office 3 days a week? This question must be answered.
- Will you now or in the future require employer sponsorship to work in the U.S.? This is a required question and must be answered.
Ability to Commute:
- New Braunfels, TX 78132 (Required)
Work Location: Hybrid remote in New Braunfels, TX 78132
