Business Intelligence Development Lead

At ERCOT, our diverse and dynamic work environment provides a platform on which employees can work together to build the future of the Texas power grid and wholesale market utilizing the latest technologies and resources. We encourage you to join our talented, dedicated workforce to develop world-class solutions for today and tomorrow’s energy challenges while learning new skills and growing your career.

ERCOT is committed to fostering inclusion at all levels of our company. It is the cornerstone of our corporate values of accountability, leadership, innovation, trust, and expertise. We know that individuals with a wide variety of talents, ideas, and experiences propel the innovation that drives our success. An inclusive and diverse workforce strengthens us and allows for a collaborative environment to solve the challenges that face our industry today and in the future.

Job Summary

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.

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

Level Lead – Above +

- Serves as a Subject Matter Expert providing guidance to lower level workers

- Leads projects, schedules work, trains, mentors, and provides coaching for other employees

- Ensures work assignments of team members are completed in a timely manner and reviews work product of team for accuracy prior to submitting for management approval

- Works on the most complex issues where analysis of situations requires an in-depth evaluation of variable factors. Has the ability to resolve complex issues in creative and effective ways

- Maintains knowledge of emerging trends and industry best practices

Job Duties

- Broadly applies principles, theories and concepts related to the profession. A seasoned, experienced professional with an in-depth/full understanding of area of specialization.

- May provide recommendations regarding issues outside the bounds of defined procedures and practices. Demonstrates good judgment in selecting methods and techniques for obtaining solutions.

- Wide latitude for decisions within assignments, programs and projects; impact is generally limited to the project or department.

- Acts as a resource to advise, and may at times a lead the work of lower level professional and/or support employees. Generally represents the department on projects and may perform in a project leadership role.

Experience

- Requires minimum 8 years job related work experience in excess of degree requirements

- Knowledge of TSQL, SQL Profiler, .Net platform, ASP, .Net, C#, VB.NET, Analysis Platform Services preferred

- Knowledge of data warehousing, data integration, and relational data modeling preferred

- Knowledge of programming C#, XML, Java, Reporting Services, UNIX scripting preferred

EDUCATION

- Bachelor's Degree : Computer Science, MIS or related field (Required)

- or a combination of education and experience that provides equivalent knowledge to a major in such fields is required

The foregoing description reflects the minimum qualifications and the essential functions of the position that must be

performed proficiently with or without reasonable accommodation for individuals with disabilities. It is not an exhaustive list of

the duties expected to be performed, and management may, at its discretion, revise or require that other or different tasks be

performed as assigned. This job description is not intended to create a contract of employment with ERCOT. Both ERCOT and

the employee may exercise their employment-at-will rights at any time.

ERCOT is firmly committed to equal employment for all qualified persons without regard to race, sex, medical condition, religion, age, creed, national origin, citizenship status, marital status, sexual orientation, physical or mental disability, ancestry, veteran status, genetic information or any other protected category under federal, state or local law.

Expected Salary Range

$109,165 - $185,571