Responsibilities:
1. Interfaces, independently, with high level stakeholders via meetings, emails, and phone calls to manage data projects. Gather and document requirements; and to gather sample data throughout all phases of the project to ensure data quality.
2. Works with District agency resources to analyze, compile. verify, and query data as part of data warehousing services. Develops complex SQL queries used by reporting environments and data-driven dashboard applications Creates metadata and data dictionaries.
3. Designs and documents methods to facilitate the implementation of new database systems. Designs and implements reports using SQL as well as a variety of reporting and business intelligence tools.
4. Develops and administers data standards, policies and procedures; and develops new standards, methods, and techniques. Develops common approaches to problem solving and meeting processing requirements. Develops and analyzes new projects.
5. Creates scripts to identify and correct common errors and data inconsistencies in incoming data. The incumbent will make extensive use of structured query language (SQL).
6 .Troubleshoots problems involved in the input, retrieval or modification of database information and the general operation and maintenance pertinent to any of the enterprise data system elements or sub-elements.
7. Perform complex data analyses including experience validating data and identifying and correcting data inconsistencies and errors. Analyzes and defines requirements and specifications pertinent to OUC and OCTO enterprise systems and applications. Analyzes and plans for anticipated changes in data capacity requirements. Evaluates the impact of technological changes; and/or conceives of solutions to highly complex technical issues. Operate and maintain Business Intelligence systems and ancillary systems for serving up data analytics.
8. Coordinates all activities with the project manager throughout the full software development life cycle (SDLC). to include design, development, and testing.
9. Works with minimal oversight as a technical lead on data-driven reporting and applications development projects.
10. Keep abreast of current trends regarding all aspects of database management. Keep information of latest concepts, developments, approaches, and solutions to effective agency data management.
11. Performs other related duties as assigned.
Minimum Education/Certification Requirements:
Bachelor’s degree in IT or related field or equivalent experience
What we bring:
• Health, Dental and Vision Benefits
• Life, AD&D, Short Term Disability and Long Term Disability paid 100% by the company
• Time off: Public Holidays, Vacation Days & Sick Days
• 401K
...AN ASSISTANT GENERAL MANAGER IS: The AGMs provide overall leadership, supervision and direction on strategic initiatives and operating standards to positively impact business results for selected FOH or BOH areas under guidance of GM. YOU WILL BE GREAT AT D&B IF: You...
...MES Consultant Position : Onsite ( Contract ) Location: Detroit, Michigan We're looking for an experienced MES Consultant to lead the discovery phase of our Manufacturing Execution System (MES) implementation. This role involves evaluating current manufacturing...
...be considered for this position.*** Position Title: Full-Time Police Officer Salary Information: $81,160.43 - $103,669.56... ...Longevity Pay Proficiency Bonuses Tuition Reimbursement OP&F Retirement *Please complete PSSA to be considered for position Close...
...to see their best to live their best. We help people by making quality eye care and eyewear more affordable and accessible.The Lab Manager oversees the operation of the lab and ensures quality and same day service standards are met. This position also supervises the Lab...
...an innovative and established organization looking for SIU Investigator II based in Atlanta, GA to join our team. Family-owned, UAIC... ...detect fraud on high complexity claims involving staged auto accidents, fraud rings, and questionable medical treatment. You will...