Apply on Employer Site

Tri-State Generation and Transmission Association, Inc. · 1 month ago

IT Data Analytics Engineer I, II, III or Senior

Westminster, CO

Full-time

Hybrid

Entry, Mid, Senior Level

$106K/yr - $135K/yr

8+ years exp

Tri-State Generation and Transmission Association, Inc. is a wholesale power supply cooperative focused on delivering reliable and affordable energy services. The Data Analytics Engineer role is designed to implement and support the company’s data landscape and analytics goals, involving tasks such as developing ETL pipelines and creating reporting solutions.

Natural Resources

Responsibilities

Help design and implement the organization’s data warehousing strategy to support scalable analytics and long-term data needs, including data from multiple applications and diverse data sources to enable effective data solutions

Develop and maintain ETL/ELT pipelines for seamless integration of third-party applications and internal data sources

Help create organizational gold standard reporting solutions to meet business needs

Provide mentorship on development, data, and analytical best practices

Develop and design various dev ops solutions to enable consistent and automated team operations

Support ad-hoc data needs for a wide range of various business requirements

Design systems with an eye towards the future to support MLOps and demonstrate knowledge of advanced analytics including modeling needs and practices

Troubleshoot data integration issues and bugs, 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 report the status of key efforts to the organization

Collaborate and work with data analysts in various departments to ensure that we are effectively capturing and providing their data needs

Provide technical guidance for the design and implementation of data governance systems and policy

Support and be familiar with requirements of SOX compliance

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

Qualification

Data WarehousingETL/ELT PipelinesAdvanced SQLPythonBI ToolsMaster Data ManagementModern StatisticsCommunication SkillsProblem SolvingTeam PlayerDetail Oriented

Required

Bachelor's degree in Computer Science, Mathematics, Statistics, or similar degree

8+ years of professional data experience

5+ years' worth of experience working with Python, including familiarity with OOP and tools such as Pandas, PySpark, Dash, Sklearn, Sci-Py, FastAPI, etc

Advanced SQL abilities including complex query building, window functions, and query performance tuning

Experience with BI tools such as Power BI, Tableau, or Dash

Experience with Master Data Management (MDM)

Knowledge of modern statistics implementation and algorithms including things like XGBM, Causal Systems, Latent Dimensional Management, etc

Analytical, creative, and innovative approach to solving problems

Ability to clearly explain technical and analytical information (verbally, written & in presentation format)

Ability to provide total analytic support which includes data extraction, cleaning, manipulation, modern statistics, visualization, and presentation

Knowledge of IT Service Management processes and best practices

Positive, people-oriented, and energetic attitude

Demonstrates knowledge of Data Warehouse concepts (e.g. Data Marts, Facts/Dimension, Star schema etc.)