- Designs, develops, and implements customized tables, queries, and reports.
- Gathers information about report needs, objectives, functions, and features and makes recommendations for solutions
- Analyzes and consolidates data to create desired output
- Create enhancements to existing reports
- Researches new reporting methods, processes, and tools.
Determines usage and recommends plan for implementation - Coordinates with other departments to revise current reports and ensure that business requirements are designed into new reports.
- Assist other report writers with technical approach and issues.
- Monitors customer usage, upgrades and reporting tools.
- Manage projects/processes
- Other duties as assigned
WHAT YOU LL BRING
Required Education, Experience, Certification/Licensure
- Bachelors degree or equivalent combination of education and experience
- 5+ years of report writing experience
KNOWLEDGE, SKILLS, AND ABILITIES (KSAs)
- Key skillset:
- Expert PostgreSQL query building skills
- Expert in optimizing PostgreSQL queries to minimize load on system resources and take best advantage of the database architecture.
- Deep understanding of Postgres database environment
- Proficient in building and testing automated reports.
- Prefer experience in Apache Superset and/or Power BI/Power Automate
- Experience with Jira Software Project tool preferred
- Other KSAs:
- Excellent technical reporting and data analysis skills
- Advanced understanding of development processes, including design, programming, and quality assurance
- Aware of business issues as they impact overall project plans
- Must understand business requirements and database technology
- Strong communications and interpersonal skills
- PCs and various reporting software applications
- Experience with project management and methodology
COMPLEXITIES & IMPACT
- Errors may be difficult to detect and would normally result in loss of time or customer dissatisfaction.
- Performs work that is complex and varied in nature.
Defines and discerns key aspects of a problem and develops an integrated solution within a broad technical and business context of significant impact.
May provide guidance/training to team members. - Provides resolutions to a diverse range of complex problems.
SUPERVISION RECEIVED OR EXTENDED
- No responsibility for the supervision of others
- Works independently under broad supervision
- Determines methods and procedures on new assignments and may coordinate activities of other personnel
- Represents the organization on projects and may act in a project leadership role
- May provide direction to less experienced team members
Skills Required
Query Optimization, Project Management, Postgresql, Data Analysis, Report Writing