Description
Summary
The Business Intelligence/Data Analyst II (BI/DA2) works as a full-time employee of Zeiders Enterprises (Zeiders) at the corporate headquarters. The BI/DA2 is responsible for matrixed Data Warehouse, Data Analytics, Business Intelligence and Reporting support to the Contracts and Corporate Operations. The BI/DA2 will actively seek opportunities for process improvement / automation and information reporting through active participation in planning sessions and certain operational meetings where data gathering and reporting needs are anticipated. The BI/DA2 is also a hands on position, actively leading Data Analytics and Business Intelligence projects, including application development, for both the Contracts and Corporate Operations.
Essential Duties and Responsibilities:
Providing technical expertise on data storage structures, data mining, and data cleansing.
Gather business requirements for data gathering, retention, processing and reporting.
Lead and Assist with reporting and analysis projects.
Managing and designing the reporting environment, including data sources, security, and metadata.
Assessing tests and implementing new or upgraded software and assisting with strategic decisions on new systems.
Supporting the data warehouse in identifying and revising reporting requirements.
Supporting initiatives for data integrity, normalization and reporting automation.
Provide quality assurance of imported data, working with other quality assurance personnel if necessary.
Manage or assist in managing vendors that provide data warehousing or management services.
Managing master data, including creation, updates, and deletion.
Managing users and user roles.
Commissioning and decommissioning of data sets.
Processing confidential data and information according to guidelines.
Generating reports from single or multiple systems.
Troubleshooting the reporting database environment and reports.
Evaluating changes and updates to source production systems.
Training end users on new reports and dashboards.
Supervisory Responsibilities:
The BI/DA2 may serve as project lead, specifying work expectations, timelines and deliverables to a matrixed group of project participants and will supervise the BI/DA 1.
Required Education, Certifications and/or Experience Qualifications:
Zeiders is a COVID-19 vaccination-required company and requires all employees to be vaccinated or seek an approved accommodation for a protected reason (medical or religious).
Bachelor's degree with five years' experience in fields that require a high degree of Data Analytics and/or Business Intelligence studies OR Associate's degree with six years' experience
Demonstrated expertise and at least five years' experience in the use of SQL based database products such as MS-SQL, Access, MySQL, Oracle.
Demonstrated use of Agile/SCRUM or Waterfall SDLC methodologies.
Demonstrated Project Lead or Project Management experience using standard planning tools such as MS-Project, Asana or OpenProject.
Demonstrated experience in requirements gathering, analysis and Business Analysis.
Demonstrated knowledge and understanding of Cyber Security concepts and practical application as they relate to Data Management and Information Assurance.
Knowledge of cloud based Business Intelligence systems such as Domo or Tableau.
Preferred Qualifications:
Knowledge of the Cybersecurity Maturity Model Certification, NIST 800-53 or NIST 800-171
Professional Certification (or the ability to obtain) that centers on Data Analysis or Business Intelligence such as the AICPA's Data Analytics Certification or the MCSE: Data Management and Analytics
Knowledge of network management protocols, network architecture and server virtualization.
Experience working with U.S. Government agencies and responding to their reporting requirements
Excellent written, including technical writing, and verbal communication skills for problem solving and the creation of technical and end user documentation
Familiarity with Power BI
Other Skills and Abilities:
Competencies:
To perform the job successfully, an individual should demonstrate the following competencies:
Customer Service - Manages difficult or ad hoc related customer situations; Responds promptly to customer needs; Solicits customer feedback to improve service; Responds to requests for service and assistance; Meets commitments.
Interpersonal Skills - Focuses on solving conflict, not blaming; Maintains confidentiality; Listens to others without interrupting; Keeps emotions under control; Remains open to others' ideas and tries new things.
Oral Communication - Speaks clearly and persuasively in positive or negative situations; listens and gets clarification; Responds well to questions; Demonstrates group presentation skills; Participates in meetings.
Written Communication - Writes clearly and informatively; Edits work for spelling and grammar; Varies writing style to meet needs; Presents numerical data effectively; Able to read and interpret written information.
Teamwork - Balances team and individual responsibilities; Exhibits objectivity and openness to others' views; Gives and welcomes feedback; Contributes to building a positive team spirit; Puts success of team above own interests; Able to build morale and group commitments to goals and objectives; Supports everyone's efforts to succeed.
Judgment - Displays willingness to make decisions; Exhibits sound and accurate judgment; Supports and explains reasoning for decisions; Includes appropriate people in decision-making process; Makes timely decisions.
Professionalism - Approaches others in a tactful manner; Reacts well under pressure; Treats others with respect and consideration regardless of their status or position; Accepts responsibility for own actions; Follows through on commitments.
Quality - Demonstrates accuracy and thoroughness; Looks for ways to improve and promote quality; Applies feedback to improve performance; Monitors own work to ensure quality.
Ability to work both independently and as part of a team.
Physical Demands: Works in office areas. Sits, stands, bends, lifts, and moves intermittently during working hours. Uses personal computer, telephones, copiers, printers and other office equipment. The employee must occasionally lift and/or move up to 10 pounds.
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.
Work Environment: 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 usually quiet.
Zeiders Enterprises, Inc. is an Equal Opportunity Employer
Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities
The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor's legal duty to furnish information. 41 CFR 60-1.35(c)
