Job Information
EPB Data Warehouse Analyst II - NOT REMOTE - Chattanooga, TN in Chattanooga, Tennessee
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.