Tri-State Generation and Transmission Association, Inc. IT Business Intelligence Developer-Exempt (IRC34348) in Westminster, Colorado
Brief Posting Description
This position has primary responsibility for analysis design, development and maintenance of business intelligence reporting and analytical systems as well as any ETL processes. This is an end to end data solution delivery position which includes data ingestion, virtualization, data analysis, and production support of delivered solutions.
The job grade for this position is: NB23
Tri-State recognizes the value of a highly-engaged and committed workforce and provides an excellent benefits program that includes: Medical Insurance, Dental Insurance, Vision Insurance Health Savings Account (HSA), Flexible Spending Accounts (FSA), Tuition Reimbursement, Life Insurance, Retirement Security Pension Plan, 401K, Long Term Disability (LTD), Short Term Disability (STD), Employee Assistant Program (EAP) and Paid Leave Benefits.
Hiring Salary Range: $99,000-$123,000
Actual compensation offer to candidate may vary outside of the posted hiring salary range based upon work experience, education, and/or skill level.
ESSENTIAL FUNCTIONS AND RESPONSIBILITIES:
Responsible for the design, development and implementation of systems to extract and analyze data from multiple sources to generate actionable insights
Support the business operation processes, focused on data driven deliverables as they pertain to business goals.
Provide reporting solutions, data validation, and presentation in a format that allows the stakeholders to make strategic decisions.
Research, validate and maintain data to develop reports and scorecards aligned to business needs
Collaborate and work with data analysts in various departments to ensure that data meets their reporting and analysis needs.
Provide technical guidance for design and implementation of data governance.
Design, develop and test high-quality Extract, Load and Transform (ELT) processes, programs and scripts
Troubleshoot data integration issues , analyze reasons for failure, implement optimal solutions, and revise procedures as needed
Conduct unit and integration testing to ensure quality implementation.
Use best practices to test and deploy changes from staging environments to production.
Prepare high level design and architecture diagrams.
Collaborate with project managers to track and repot status of key efforts to the organization.
Provide guidance and technical leadership for data analytics initiatives/projects as needed
Document Standard Operating Procedures and Process Flows for Change Control and Sarbanes-Oxley Act Of 2002 (SOX) compliance.
Adhere to and demonstrate compliance with appropriate electric utility industry regulatory requirements. Attain knowledge and remain knowledgeable of development in regulations, laws, standards and best practices applicable to the functional area including, but not limited to, Standards of Conduct, Environmental, Employment Law, NERC Reliability Standards and Safety. Must be familiar with, and comply with, all aspects of Corporate Policy C-54, Compliance.
Demonstrate behavior consistent with Tri-State's culture embodied in the Cooperative principles and spirit and core values of technical competency, respect and dignity, accountability, integrity, trustworthiness, and servant leadership to empower or otherwise enable others to optimally perform their job responsibilities. Demonstrate and promote ethics and behaviors consistent with Tri-State's culture, Board policies, and business practices. Understand and fulfill the role and responsibility for all compliance programs within the company.
Because Tri-State is an electric utility with continuous service obligations to its customers, regular, reliable, and predictable performance of the essential functions and responsibilities is an essential function of the job.
Because Tri-State has an obligation to provide continuous, reliable electric service to its customers, the ability to work overtime at any time of the day or week is considered an essential function of the job.
- Perform other related duties as assigned.
SUCCESS FACTORS/JOB COMPETENCIES:
Planning: ability to think ahead and plan within timelines and resources; develop scope, plan and schedule work; set priorities and goals; anticipate and adjust for problems; evaluate workloads; measure and evaluate performance against established goals.
Time management: ability to successfully plan and implement objectives within established timelines and work schedules.
Ability to analyze problems and develop effective solutions at technical, strategic and functional levels.
Demonstrate behavior consistent with company values.
Excellent interpersonal and communication skills.
Strong team player: accomplishes tasks by working with others and being a good team player. Recognizes how his/her decisions may impact others; seeks input from others.
Computer proficiency in operating a personal computer and standard business office applications including Microsoft Office suite, databases, and other related applications as described in previous section.
Ability to work independently, with minimal direction as a highly motivated self-starter.
Ability to collaborate with others and act in an objective manner in order to effectively solve problems and stay on track towards accomplishing organizational goals.
Detail oriented and ability to perform thorough analysis of assigned work.
REQUIRED JOB QUALIFICATIONS:
Education and Training:
- Bachelor's degree in Computer Science, Information Technology, Management Information Systems, Engineering, or equivalent combination of education and/or experience.
Knowledge, Skills, and Ability:
Positive, people-oriented, versatile and energetic attitude
Analytical, creative, and innovative approach to solving problems
Ability to clearly explain technical and analytical information (verbally, written & in presentation format)
Demonstrates knowledge of Data Warehouse concepts
Ability to lead and take accountability as well as ownership with minimal direction
Knowledge of IT Service Management processes and best practices.
8+ years of professional experience.
Expertise in Microsoft Data & Analytics platforms and tools
Experience with modern data analytics tools such as Power BI or Tableu is preferred
Expertise in SSIS, Azure Data Factory (ADF)
Advanced SQL skills including complex query building and query performance tuning
Strong optimization and performance skills
Experience with Master Data Management (MDM)
DESIRED JOB QUALIFICATIONS:
Strong negotiation, facilitation and consensus building skills.
Besides Microsoft, understanding of various Data & Analytics platforms as well as high level architecture
PHYSICAL AND MENTAL DEMANDS : The physical demands and work environment characteristics described here are representative of those that must be met by an employee to successfully perform the essential functions of the position. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
Physical demands: While performing the duties of this position, the incumbent is required to sit for long periods of time and occasionally stand, walk, stoop, bend, reach above and below shoulder level, and push/pull objects up to 30 lbs. Incumbent is frequently required to use hands and fingers to handle, or feel objects, tools, or controls, talk and hear. Incumbent must have finger dexterity, good vision, good color vision, good hearing, and ability to speak clearly, and handle intricate work.
Mental demands: While performing the duties of this job, the incumbent is required to read, write, perform basic math, analyze data and reports, maintain and troubleshoot related applications and software, exercise judgment, develop plans, procedures and goals, and present information to others and work under pressure.
Work Environment : While performing the duties of this position, the incumbent is exposed to moderate level of noise. Majority of duties are performed indoors primarily at a desk.
INTERNAL Non-Bargaining How-to Apply
Log into Oracle and click on the iRecruitment Employee Candidate Link. Search for Job and click 'Apply Now' Icon.
Tri-State Generation and Transmission Association is a wholesale electric power supplier owned by the 43 electric cooperatives that it serves. Tri-State generates and transmits electricity to its member systems throughout a 200,000 square-mile service territory across Colorado, Nebraska, New Mexico and Wyoming.
Serving approximately 1.5 million consumers, Tri-State was founded in 1952 by its member systems to provide a reliable, cost-based supply of electricity. Headquartered in Westminster, Colo., about 1,480 people are employed by Tri-State throughout its four-state service area.
Tri-State's power is generated through a combination of owned baseload and peaking power plants that use coal and natural gas as their primary fuels, supplemented by purchased power, federal hydroelectricity allocations and renewable resource technologies. Tri-State delivers power to its members through a transmission system that includes substation facilities, telecommunications sites and over 5000 miles of high voltage transmission lines.
Interested? Here is how to Apply:
Go to www.tristategt.org/ and click on the 'Careers' Link. Search for Job and click 'Apply Now' Icon. You will be required to register in order to apply.
Tri-State: Join the people behind the power. Tri-State recognizes the value of a highly-engaged and committed workforce and provides an excellent benefits program that includes medical, dental, retirement and life insurance. Please visit our careers site at www.tristategt.org/careers/ for more details.
Equal Opportunity Employer - Minority/Female/Disabled/Veteran