The Business Intelligence Analyst 2 works with business and systems partners to ensure rapid thorough analysis of complex business needs, applying analytics techniques and developing solutions to drive strong outcomes. Activities include analyzing and creating reports using documented procedures, assuring quality and data accuracy, and delivering the reports and dashboards on time to internal customers. Must have strong communications skills with the ability to design, report and present data to business partners in a user-friendly format, providing recommendations that drive insights from the data. Successful candidate must be well versed in data analysis, creating, and maintaining data catalogs, data dictionaries, as well as reporting and analytics tools. The Business Intelligence Analyst 2 will have strong PL-SQL and Microsoft PowerBI skills. Technical experience and aptitude are attributes that are necessary for success.
This position is based in Corinth, TX and requires six months of onsite work before transitioning to a hybrid schedule
Primary Position Responsibilities
- Creates, updates and maintains reporting solutions utilizing Power BI, Business Objects Designer and WEBI for multiple business partners with minimal assistance needed
- Ability to design Dashboards and Reports with minimal assistance
- Ability to design and create wireframes for collaborating with business users on requirements
- Ability to lead design and requirements meetings with business and systems partners
- Creates, updates and maintains data consistency and data quality by providing updates to the data catalog / data dictionary
- Engages business partners to understand their needs, map to logical and physical data models and develop thoughtful insights into the data
- Creates and runs PL-SQL queries to analyze data and develop solutions with minimal assistance needed
- Provides great service and technical support of issues, including data validation and maintaining reporting accuracy
- Provides ad hoc query and reporting to business requests, as needed
- Interfaces with Business Units, vendors, and other IT areas in the development of reporting solutions
- Assists manager in developing / revising and documenting policies and procedures for supporting data governance and reporting best practices
- Complies with established CoServ safety and operating rules, procedures and guidelines including reporting unsafe practices to a supervisor
- Complies with established CoServ Information Security Handbook, policies, procedures, and guidelines including reporting suspected information security incidents to Tech Support
Secondary Position Responsibilities
Attends all required company training and employee developmentAttends monthly department meeting or reviews safety material independentlyCross-platform problem solving, solution investigation and deliveryParticipates / represents IT Enterprise Applications during Enterprise and departmental projectsPerforms other duties and activities as directedSupervisory Responsibilities
NonePosition Requirements
Experience, Education and Certifications Required
High School Diploma or G.E.D equivalencyBachelors Degree in Business Analytics, Data Science, Management Information Systems or, Business Computer Information Systems, or equivalent experience.5 + years as a Business Intelligence Analyst or similar roleExperience, Education and Certifications Preferred
PowerBI CertificationAny Cloud CertificationsSkills and Abilities Required
Strong abilities in using Power BI and / or Business Objects for data analysis and report / dashboard creationDemonstrated understanding of data analysis concepts and methodologies such as data warehousing and data modelingAbility to create and execute moderately complex SQL and / or PL-SQL queriesStrong experience with DAX within Microsoft PowerBIStrong verbal and written communication skills with the ability to present to end usersAbility to collaborate and lead meetings with end users and other IT groupsAbility to gather and evaluate functional and technical requirements for medium complexity product enhancementsStrong analytical skills and problem solving skillsStrong attention to detail and accuracyAbility to influence directionStrong experience using Microsoft Office software (Word, Excel, PowerPoint, Teams, Visio, OneNote)Prior business systems analysis experienceAbility to drive root cause analysis activitiesSkills and Abilities Preferred
Experience working in cloud technologies, such as Azure Data Factory and / or Azure SynapseStrong Data analysis and modeling abilitiesKnowledge of software development lifecycle (SDLC) and Agile methodologiesWorking knowledge of relational databases and client-server conceptsExperience guiding medium to large enhancement projects a plusExperience in Business Objects Designer for creating and maintaining universes, WEBI, Derived tables, @functions and schemasPhysical Requirements
Operates office equipment such as a computer, telephone, copier, etcIndoor, office environmentAbility to lift a minimum of 25 poundsAbility to drive occasionally as neededAbility to sit for long periods of timeRequires frequent sitting, standing, walking, bending, and reachingWorks extended hours as needed or directedUses computer for extensive periods of timeOther Requirements
Must have and maintain a valid Texas driver's licenseAttends system user group conferences, as assignedAttends additional required continuing education training and workshops, as assignedThis position is based in Corinth, TX and requires six months of onsite work before transitioning to a hybrid schedule.Equal Opportunity Employer / Protected Veterans / Individuals with Disabilities
This employer is required to notify all applicants of their rights pursuant to federal employment laws.For further information, please review the Know Your Rights notice from the Department of Labor.
#J-18808-Ljbffr