Data Warehouse Analyst II (3 days/week remote)

JOB SUMMARYThe 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.