Responsible for how ERCOT's database is structured, and dataflow between applications. Accountable for analyzing and developing complex logical database designs, logical data models and relational data definitions in support of corporate and customer information systems requirements. Understands the methodologies and technologies that depict the flow of data within and between technology systems and business functions/operations. Key responsibilities cover all tiers of the Enterprise Data Warehouse infrastructure, including but not limited to design and development of database models, database replication, integration, web-enabled applications, data extraction and delivery methods, reporting foundations, and data presentation.
JOB DUTIES
- Understands and applies principles, theories and concepts related to the profession and ERCOT's culture.
- Exercises judgment within defined procedures and practices to determine appropriate action.
- Impact is generally limited to specific assignments or projects.
- May respond to inquiries and/or provide assistance and/or guidance to lower level workers.
ADDITIONAL JOB DUTIES
Level 1 & 2
Responsible for the identification and resolution of information flow, content issues and the transformation of business requirements into logical data models
Identifies opportunities to reduce data redundancy, trends in data uses and single sources of data
Assists in developing applications within existing architecture and under the guidelines of overall technical goals of the data warehousing team
Assists in developing application components in support of data warehousing efforts using Oracle technology
May interface with key groups in the company to ensure quality product delivery (example, project managers, application and technical architects, usability engineers, other development groups, business end users, and external users as appropriate)
Possesses and maintains technical proficiency in the key technical areas
Level Senior - Above +
Analyzes and develops complex logical database designs, logical data models and relational data definitions in support of corporate and customer information systems requirements
Identifies and resolves information flow, content issues and the transformation of business requirements into logical data models
Designs and implements data quality and data auditing processes to reduce data redundancy and optimize performance of existing data structures
Develops applications within existing architecture and under the guidelines of overall technical goals of the data warehousing team
Interfaces with key groups in the company to ensure quality product delivery (examples: line managers, project managers, application and technical architects, usability engineers, other development groups, business end users, and external users as appropriate)
Serves as level 3 production support when needed
Possesses and maintains technical proficiency in the key technical areas like database query toolsets, capacity planning, tuning, multithreading, parallel query and web applications
Provides on-the-job training or oversee the work of other developers
Serves as a Subject Matter Expert providing guidance to lower-level worker
May schedule work, train, mentor, and/or coach other employees
Conveys team goals effectively through strong written and verbal communication skills
Works on moderately complex issues where analysis of situations requires an in-depth evaluation of variable factors. Has the ability to resolve issues in creative and effective ways
REQUIRED EXPERIENCE
- Excellent written and verbal Communication skills
- 5 years of hands-on delivery experience in PL/SQL
- 5 years of experience working in Unix/Linux OS and shell scripting
- 5 years of experience working with an Oracle RDBMS
- Demonstrated ability to work with analysts and stakeholders for requirements definition
- Expertise in data modeling and data modeling concepts
- Mastery of one or more scripting languages
PREFERRED EXPERIENCE
- 3 years of experience in one or more Enterprise BI tools (Cognos, PowerBI)
- 3 years of experience with ETL tools (Informatica preferred) and excellent understanding of data warehousing, business intelligence, ETL, and SDLC, and Agile concepts
- Python
- Data Bricks
- JAVA
- Perl
- DDM/DRP
EDUCATION
- Bachelor's Degree : Computer Science or related field (Required)
- or a combination of education and experience that provides equivalent knowledge to a major in such fields is required
Electric Reliability Council of Texas
Texas United States
www.ercot.com
