Database Analyst

Found in: Talent US 2 C2 - 2 weeks ago

Chicago, United States Metropolitan Water Reclamation District of Greater Chicago Full time

General Statement

Under supervision, directs, evaluates, reviews, and manages database resources and services across the District while ensuring high levels of data quality; and develops, implements, and oversees database policies and procedures to ensure the integrity and availability of databases and their accompanying software.

Essential Job Functions

Essential job functions are fundamental, core functions common to positions in a classification. They are not intended to be an exhaustive list of all job duties for any one position in the class. Since class specifications are designed to be descriptive and not restrictive, incumbents may complete one or all of the job duties listed or tasks of similar kind not specifically listed here.

Participates in the design and development of new databases; assists with the installation and testing of new databases. Modifies existing databases and database management systems; tests programs or databases and corrects errors; performs system upgrades as needed. Develops, tests and implements SQL program code and application code for use with databases. Defines, reviews and implements database backup and recovery strategies. Plans, coordinates and implements appropriate security, indexes, access controls, constraints, triggers and other database-related features to safeguard database against accidental or unauthorized damage, modification or disclosure. Monitors performance of application programs with respect to associated databases and performs required performance tuning actions to ensure database stability and efficiency; recommends changes to data storage practices to optimize efficient use of space and prevent unnecessary database growth. Works with application development staff to develop database architectures, coding standards, and quality assurance policies and procedures. Develops long-term goals for production databases in conjunction with data owners and department managers. Conducts research and makes recommendations on database products, services, protocols, and standards in support of procurement and development efforts. Analyzes user requirements for reports, forms, queries, and data extraction. Develops and deploys end-user practices and tools for data extraction, queries, and data manipulation in accordance with business processes. Creates and documents models for new database development and/or changes to existing ones through data flowcharting and entity relationship diagrams.

Other Job Functions

Provides after hours and weekend support when required. Performs other duties as assigned.

Environmental Conditions

Work is performed in a typical office environment and requires the use of standard office equipment including computers.

Desirable Knowledge, Skills and Abilities

Knowledge of the principles, procedures and methodologies relating to database design, control, administration and usage in support of application systems. Knowledge of the operating characteristics and limitations of common computer hardware and software utilized by the District. Skill in writing SQL scripts for queries. Ability to troubleshoot and resolve operational issues related to databases. Ability to work in a team-oriented, collaborative environment. Ability to communicate effectively, orally and in writing.

Minimum Qualification Requirements

Graduation from a four-year accredited college or university majoring in information technology, computer science or a closely related field.

Substitution

Full-time paid experience in database development and/or administration may be substituted for the required education on a year-for-year basis. A Microsoft MCITP SQL Server certification may be substituted for one year of the required education.

Promotional Requirement

Possession of a bachelor’s degree in information technology, computer science or a closely related field. One year of service with the District as an IT Support Analyst II, IT Support Analyst I, Systems Support Specialist II, Administrative Assistant, Administrative Specialist, Human Resources Assistant, Secretary or Senior Administrative Specialist. Civil service status in one of the foregoing classifications.

  • Database Analyst

    Found in: beBee jobs US - 2 weeks ago

    Chicago, Illinois, United States Mitchell Martin Inc Full time

    Our client, a member owned health insurance company, is seeking a Database AnalystLocation: Chicago, ILPosition Type: ContractJob Responsibilities:This position is responsible for designing and developing applications, databases and reports based on long-term business strategy including major enhancements to existing functionality and user tools. Develop,...

  • Database Administrator

    Found in: Talent US 2 C2 - 2 weeks ago

    Chicago, United States Metropolitan Water Reclamation District of Greater Chicago Full time

    General Statement Under direction, designs, implements, administers and maintains the District’s relational database systems that support the functional requirements of the application systems used by the operating departments; and develops, implements, and oversees database policies and procedures to ensure the integrity and availability of...

  • Web and Database Analyst

    17 hours ago

    Chicago, United States City of Chicago School District - Chicago Public Schools Full time

    Chicago Public Schools (CPS) is the third-largest school district in the United States, serving over 330,000 students in 600 schools and employing nearly 36,000 people, most of them teachers. CPS has set ambitious goals to ensure that every student, Part-Time, Database, Analyst, Salesforce, Systems Analyst, Business Analyst, Technology

  • Senior Database Administrator

    Found in: Talent US 2 C2 - 2 weeks ago

    Chicago, United States Metropolitan Water Reclamation District of Greater Chicago Full time

    General Statement Under direction, leads the design, implementation, administration and maintenance of the District’s relational database systems that support the functional requirements of application systems used by the operating departments. This classification is also responsible for developing, implementing, and overseeing database policies and...

  • GIS Database Developer

    Found in: Appcast US C2 - 2 weeks ago

    Chicago, United States Clarity Partners Full time

    Voted one of Chicago's Best Places to Work by the Chicago Tribune for the seventh year in a row, Clarity Partners is hiring!Clarity Partners is seeking a GIS Database Developer, local to Chicago, IL. The primary responsibility of the Developer position will include the effective design and development of enterprise-wide database systems with specific...

  • GIS Database Developer

    Found in: Appcast Linkedin GBL C2 - 2 weeks ago

    Chicago, United States Clarity Partners Full time

    Voted one of Chicago's Best Places to Work by the Chicago Tribune for the seventh year in a row, Clarity Partners is hiring!Clarity Partners is seeking a GIS Database Developer, local to Chicago, IL. The primary responsibility of the Developer position will include the effective design and development of enterprise-wide database systems with specific...

  • GIS Database Developer

    2 weeks ago

    Chicago, United States Clarity Partners Full time

    Voted one of Chicago's Best Places to Work by the Chicago Tribune for the seventh year in a row, Clarity Partners is hiring!Clarity Partners is seeking a GIS Database Developer, local to Chicago, IL. The primary responsibility of the Developer position will include the effective design and development of enterprise-wide database systems with specific...

  • Business Analyst

    3 days ago

    Chicago, United States Optomi Full time

    API Business Analyst Optomi, in partnership with a leading non-profit company serving the welfare and pension fund industry, is seeking an API Business Analyst in a remote position in the Chicago, IL area. This candidate will work with the Technology Services team to define needs and find solutions. This Business Analyst will be the liaison between business...

  • Procurement Analyst/ Accounting

    3 days ago

    Chicago, United States TekwissenGroup Full time

    **Competencies**: - Basic knowledge of accounting principles and accounts payable practices/techniques - Ability to communicate effectively and professionally both verbal and written - Ability to participate as a team player and positively influence group activity - Proven problem solving and analytical skills - Working knowledge of interfaces between...

  • Financial Analyst

    5 days ago

    Chicago, United States Strategic Staffing Solutions Full time

    STRATEGIC STAFFING SOLUTIONS HAS AN OPENING!This is a Contract Opportunity with our company that MUST be worked on a W2 Only. No C2C eligibility for this position. Visa Sponsorship is Available! The details are below.Financial Analyst Duration- 3+ months Location- Chicago, IL Hybrid scheduleJob Order #:235026Role Overview: Support updating the annual plan...

  • Data Analyst

    2 days ago

    Chicago, United States Indotronix International Corporation Full time

    Job Summary:A Data Analyst interprets data and turns it into information which can offer ways to improve a business, thus affecting business decisions. Data Analysts gather information from various sources and interpret patterns and trends as such a Data Analyst job description should highlight the analytical nature of the role. Once data has been gathered...

  • Business Data Analyst

    2 weeks ago

    Chicago, United States Qlarant Full time

    Description We are seeking a talented and analytical Business Data Analyst to join our team. As a Business Data Analyst, you will be responsible for providing valuable insights and actionable recommendations to drive informed business decisions. You will work closely with cross-functional teams to gather, analyze, and interpret data to identify trends,...

  • Business System Analyst

    2 weeks ago

    Chicago, United States Optomi Full time

    Business System Analyst The Business Analyst enables change by working with our Business to define their needs and working with our Technology Services teams to recommend solutions. The Business Analyst is responsible for collecting and documenting business requirements from various business teams and provides written functional requirements for various...

  • Business System Analyst

    Found in: Appcast US C2 - 2 weeks ago

    Chicago, United States Optomi Full time

    Business System Analyst The Business Analyst enables change by working with our Business to define their needs and working with our Technology Services teams to recommend solutions. The Business Analyst is responsible for collecting and documenting business requirements from various business teams and provides written functional requirements for various...

  • Business System Analyst

    Found in: Appcast Linkedin GBL C2 - 3 weeks ago

    Chicago, United States Optomi Full time

    Business System Analyst The Business Analyst enables change by working with our Business to define their needs and working with our Technology Services teams to recommend solutions. The Business Analyst is responsible for collecting and documenting business requirements from various business teams and provides written functional requirements for various...

  • Data Analyst

    2 weeks ago

    North Chicago, United States Vision It US Full time

    Job Description Job Description As a Data Analyst in our client's Genomics Research Center's Bioinformatics Engineering team, you will be responsible for developing and running workflows to standardize and load project datasets in a centralized environment. You will work closely with Bioinformatics Engineering, as well as therapeutic area facing...

  • Supplier Relationship Analyst

    21 hours ago

    Chicago, United States TekWissen ® Full time

    Position: Supplier Relationship Analyst - 100% RemoteLocation: 6054 S. Drexel Avenue, Chicago, IL 60637 United StatesDuration: 4 months, Possible Extension Job Type: Contract Work Type: HybridShift: Mon - Fri, 8:00 AM - 5:00 PM Pay Rate: $29-$29.00/hourOverview:TekWissen Group is a workforce management provider throughout the USA and many other countries in...

  • Computer Programmer Analyst

    2 weeks ago

    Chicago, United States CareerBuilder Full time

    Aspire Systems Digital Transformation, Inc. has an opening for a Computer Programmer Analyst at our offices in Oak Brook, Illinois. The Computer Programmer Analyst will work with ASDTs customers to design, develop and deliver highly customized software services using development methodologies and processes developed by our company. The Computer Programmer...

  • Computer Programmer Analyst

    2 weeks ago

    Chicago, United States Aspire Systems Retail Full time

    Aspire Systems Digital Transformation, Inc. has an opening for a Computer Programmer Analyst at our offices in Oak Brook, Illinois. The Computer Programmer Analyst will work with ASDT’s customers to design, develop and deliver highly customized software services using development methodologies and processes developed by our company. The Computer Programmer...

  • Benefits Analyst

    1 week ago

    Chicago, United States LaSalle Network Full time

    LaSalle is partnering with a top-notch Benefits Solutions provider to uncover their next Benefits Analyst. As a Benefits Analyst, immerse yourself in the excitement of ensuring client satisfaction. Dive into maintaining the benefits website, orchestrating benefits-related processes and offering stellar support to clients and their participants. Elevate your...