Senior Business Intelligence Analyst

Performing as a solution and operations leader, under minimal supervision, responsible for a variety of tasks related to: designing, developing, coding, recording, and capturing and extracting data from the Energy Management Database System (EMDS) electronic communication and data from DME energy portfolio management operations, market fundamentals, energy market and associated ERCOT reported data. This role has 2 primary functions that can separated; one is the active management of database and systems to support capture, storage, maintenance and organization of data/systems and secondly the extraction and reporting of data and their solutions in order to facilitate value added decision making and operations from various business users.

Essential Job Functions:
• In a leadership capacity, analyzes, designs, tests and implements applications for the EMO as requested by Market Analytics Manager, Market Operations Manager, and other Analysts
• In a leadership capacity, build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL Server, PostgreSQL, T-SQL, SQL Server Integration Services (SSIS)
• In a leadership capacity, identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability
• In a leadership capacity, work with stakeholders including the Product, Data, Design, Frontend and Backend teams to assist with data-related technical issues and support their data infrastructure needs
• In a leadership capacity, write complex T-SQL, PL/SQL queries, stored procedures, functions, cursors in SQL Server, SSIS and PostgreSQL
• In a leadership capacity, Analyze the long running queries/functions/procures, design and develop performance optimization strategy
• In a leadership capacity, expert in ETL process i.e. cleaning data and importing from and to multiple data sources using SQL Server Integration Services (SSIS)
• In a leadership capacity, develops and leads test plans for all phases of database testing, outside vendor supplied program acceptance testing and implementation
• In a leadership capacity, develops and performs in conjunction with Energy Management staff, solution and application development through entire lifecycle including: coding, testing, debugging, documentation, modification, and reporting.
• In a leadership capacity, leads the maintenance and modification of existing code to conform to ongoing system and/or business requirements
• In a leadership capacity, design and lead the design and implementation of statistical reporting techniques and solutions, web-based interfaces, data retrieval tools, etc., as requested by the Market Analytics Manager, Market Operations Manager, and other Analysts for analysis of the energy market
• In a leadership capacity, lead and ensure data integrity and accuracy through data audits
• Serve as the technical lead and primary contact for DME’s EMO with ERCOT, and stay abreast of all changes regarding electronic interchange of energy market data. Represent the EMO at ERCOT regarding market design and developments for data delivery and formatting.
• In a leadership capacity, lead user training and support for in-house programs.
• Maintains regular and punctual on-site attendance

Additional Duties:
• Performs other duties as assigned

Minimum Qualifications / Acceptable Equivalency:
• Bachelor’s Degree in Information Technology, Business, Computer Information Systems, Engineering, or a related field with 5 or more years’ experience;

OR
• Any combination of related education, experience, certifications and licenses that will result in a candidate successfully performing the essential functions of the job

Competencies:
• Knowledge of wholesale fuel, electric markets
• Expert in cleaning data and importing from and to multiple data sources using SQL Server Integration Services (SSIS)
• Expertise in relational and multidimensional database queries
• Expertise in database objects, schema, tables and dictionaries and table/database structures
• Expert in writing and troubleshoot stored procs, functions, views, triggers, indexes, constraints etc
• Understanding of database objects (entities, attributes, constraints, relationships, joins, etc.)
• Expertise with Business Intelligence lifecycle, designing and planning BI solutions using TSQL and ETL process using SQL Server Integration Services (SSIS)
• Design, maintain and optimize stored procedures and functions using T-SQL
• Experience with business intelligence tools such as SSIS, SSRS, and SSAS
• Promotes a constructive, positive team environment and maintains a spirit of openness, problem-solving and support for common goals
• Knowledge of the following languages: C#, Java, HTML5, CSS3, JavaScript, T-SQL, PowerShell
• Knowledge of NorthStar Utilities Solutions for billing and rates
• Knowledge of Meter Data Management Systems such as ITRON(IEE)
• Skill in planning, organizing, and managing multiple complex projects concurrently
• Skill in data analysis and problem solving
• Skill in oral and written communication
• Skill in handling multiple tasks and prioritizing work
• Ability to work with frequent interruptions and changes in priorities
• Ability to quickly recognize and analyze irregular events
• Ability to prioritize tasks and work efficiently to cope with many deadlines
• Operation of the following equipment: Personal computer with Windows operating system, Microsoft Office (applications for word processing, spreadsheets, databases, and presentations), and Microsoft Outlook email system

Preferences:

NA

Conditions of Employment:
• Must have and maintain a valid Class “C” Driver’s License and valid state required minimum automobile liability insurance prior to employment (must obtain Texas Class “C” driver’s license and state required minimum automobile liability insurance within 90 days of hire per state law)
• Must pass a drug test, driver’s license check, criminal history background check, and social security number verification check

Physical Requirements:

Overall Strength Demands: The italicized word describes the overall strength demand of the functions performed by the incumbent during a typical workday.
• Sedentary – lifting no more than 10 pounds
• Light – lifting no more than 20 pounds; carry up to 10 pounds
• Medium – lifting no more than 50 pounds, carry up to 25 pounds
• Heavy – lifting no more than 100 pounds, carry up to 50 pounds
• Very Heavy – lifting more than 100 pounds, carry more than 50 pounds

Physical Demand Codes: The following describes if the incumbent is expected to exert the following physical demands during a typical workday and the overall frequency.

Codes for "how often":

Y = Yes N = No E = extensive (100-70%) M = moderate (60-30%) I = infrequent (20-10%) A = almost never (<10%)

Task: Code:
• Standing: M
• Sitting: M
• Walking: M
• Lifting: A
• Carrying: I
• Pushing/Pulling: A
• Overhead Work: A
• Fine Dexterity: M
• Kneeling: A
• Crouching: A
• Crawling: A
• Bending: I
• Twisting: I
• Climbing: A
• Balancing: A
• Vision: E
• Hearing: E
• Talking: M
• Video Display: E
• Other:

Machines, Tools, Equipment and Work Aids:

The essential functions of this position require the use of a telephone and computer.

Environmental Factors:

This position is required to work indoors in environmentally controlled areas.

This job description is not an employment agreement, contract agreement, or contract. Management has exclusive right to alter this job description at any time without notice.

ADA/EOE/ADEA

Apply Job!