IN-OFFICE in Chattanooga, TN

JOB SUMMARY

The Data Warehouse Analyst II will work with data from internal electric and fiber-related systems and external data, integrating them as part of addressing business and operational questions. The Data Warehouse Analyst II will translate information to guide insightful business decisions and conduct a complete lifecycle analysis, including requirements, design, testing, and delivery. The incumbent will also monitor performance and quality control plans to identify improvements.

DUTIES & RESPONSIBILITIES

-Gather analytic requirements from business and operational stakeholders, design analytic approach, implement approach using various tools.

-Take ownership of data quality, data reliability, and ranges of uncertainty around analytic results.

-Partner with various departments to define core metrics; measure and optimize impact and efficiencies; identify opportunities, assess risk potentials, and explain trends; to drive customer and revenue growth.

-Apply strong business judgment to data analysis, and make and defend meaningful conclusions and recommendations.

-Use statistical methodologies to create algorithms for analyzing large data sets.

-Inspect, clean, transform, model, and integrate data from a variety of sources.

-Perform root cause analysis on data anomalies to identify business and operational process improvement areas.

-Implement specified quality assurance procedures to ensure data accuracy, results, written reports, and presentation materials.

-Create appropriate documentation that allows stakeholders to understand the steps of the data analysis process and duplicate or replicate the analysis if necessary.

-Serve as an organizational resource on analytics by providing expertise to assist users in meeting their needs.

-Creates and maintains a data dictionary and metadata.

-Provide training, coaching, and guidance to other analysts.

EDUCATION & EXPERIENCE

-Bachelor's Degree in Mathematics, Statistics, Computer Science, Electrical Engineering, or related field. (An equivalent combination of training and experience may be considered.).

-2-4 years of experience in data engineering, data analysis, or data analysis fields.

-Strong database and SQL skills (Snowflake, Oracle, PostgreSQL, etc.).

-Experience with tools such as Python, R, and Java.

-Experience with data integration tools such as Talend, Informatica, and DataStage.

-Experience with Tableau, PowerBI, Cognos, or other BI reporting tools

-Strong Microsoft Office (particularly Excel) skills.

-Experience with DevOps and Continuous Integration/Delivery (CI/CD) concepts and tools.

CERTIFICATIONS & OTHER REQUIREMENTS

-A self-learner and starter, willing to dig, and able to work independently or with teams.

-Ability to think creatively to solve complex problems.

-Ability to efficiently communicate data analytics methods and complex problems to non-technical teams and stakeholders.

-Ability to think strategically about business, product, and technical challenges in an enterprise environment.

-High-level written and verbal communication skills.

-Experience in Utility or Telecommunication is a plus.