DATA ENGINEER (ECONOMIC RESEARCH)

Description

• Collaborate with business leaders to identify, track, and share key metrics
• Leverage tools like R, Power BI, Python, and SQL to conduct statistical modeling.
• Lead in the development of programming code to automate internal and external reporting requirements.
• Responsible for project workstreams and participate in multidisciplinary analytics project teams. Interview subject matter experts, plan and conduct individual interviews with experts to gain valid information and data needed for analysis and process improvement.
• Monitor department systems to ensure uptime and performance availability target levels are met.
• Assist in review and audits to ensure accurate data, reports, schedules and presentations.
• Retrieve, synthesize, and present critical data in a format that is immediately useful to answering specific questions regarding auditing controls.
• Monitor Commission open meeting activities for both the PUCT and the NMPRC, Review proper compatibility of new software, hardware, and systems, including replacement equipment to ensure continued integrity of department software.
• Troubleshoot data quality issues – Identifying root cause, system & documentation, and communication of resolution.
• Develop, test, validate and refine models to optimize customer experiences, revenue generation, operational effectiveness, marketing success and other business outcomes.
• Assist in the development of data warehousing solutions.
• Locate new data sources, analyze statistics, and implement quality procedures. Find new uses for existing data sources.
• Complies with all applicable Company policies, procedures and code of ethics as well as all applicable governmental laws and regulations to include employment, safety and environmental standards and regulations.
• Identify gaps and process improvement opportunities and present solutions to standardize, partnering with IT to design and implement solutions.
• Assists with special projects as required.
• Using business intelligence tools, create dashboards, visualizations and/or other advanced analytics reports to adequately tell the business narrative and offer recommendations that are practiced, actionable, and have material impact, in addition to being well supported by analytical models and data
• Evaluate gaps in existing data platforms and aid the implementation of modern data platforms.
• Manage the mining of various large data sets for actionable insights and trends through the development of metrics, dashboards, and deep dive analysis.
• Establish, recommend, coordinate, and review technical specifications required for effective system functionality, to include hardware and software.
• Ensure the effective collection, organization and distribution of data, from a variety of data sources.
• May be called upon to perform data submission activities to internal departments and external entities as required.
• Proactively anticipate the need for system enhancements and provide guidance in optimizing technical reliability to improve the system database performance.
• Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery.
• Acts as a liaison between Department and Information Technology.

Requirements

• Ability to provide guidance on strategic database architecture and deployment, as well as to lead application migration projects, including optimizing technical reliability and improving database performance.
• Ability to start and finish projects with minimal supervision.
• Ability to push conventional thinking to drive change and innovation
• Analytical and troubleshooting skills.
• PowerBI and SQL for accessing and wrangling data experience required.
• Experience with process improvement, evaluating client needs and data management sharing practices preferred.
• Understanding of and ability to use programming languages for analytics modeling, like R and Python.
• Strong verbal and written communication skills to share insights and recommendations to audiences of varying levels of technical sophistication.
• Craft and construct visually engaging, creative, and easy-to-use data delivery solutions including dashboards, scorecards, infographics, and reports that enable users to be more productive and better informed
• Ability to maintain effective working relationships with officers, managers, fellow employees and the general public.
• Understanding of relational database management systems (RDBMS), data modeling, and data warehousing.
• Proficient in the use of several software applications, including spreadsheets, databases, word processing, scheduling and presentation packages. Experience in EPE standard packages preferred (Currently Microsoft Applications).
• Valid driver’s license and be in compliance with the Company’s Driving Program policy.
• Ability to effectively manage several tasks at the same time.
• Ability to maintain a strong sense of propriety concerning confidential matters.
• Ability to evaluate new system capabilities to determine a fit within the existing platform
• Business background with ability to interface with IT technical resources preferred.

Benefits

Training + Development

Interview process

Visa Sponsorship

Security clearance