The Senior Cloud Data Engineer /Business Intelligence Lead will be responsible for supporting the activities of Energy Trading Credit teams. This may include but is not limited to helping to maintain the report suite, data collection/processing, managing analysis of components of a data warehouse, building Self Service BI Models, Creating visualizations and reports using Microsoft Power BI and/or Paginated Reports (SSRS), assisting with data requests, and other ad-hoc data requests. This individual may also assist with developing common datasets for self-reporting.
Desired Skills:· Creating/editing data flows (AWS S3, Redshift, Oracle PL-SQL), creating/updating existing visualizations in Power BI· PL/SQL development in a cloud based landscape, AWS preferred· ETL/ELT experience utilizing AWS core services, Talend, SSIS, SSAS or other tool is plus. · Dashboard and/or Paginated Reports development utilizing MS Power BI· Programming experience in one or more languages preferred (python etc.)· Strong interpersonal skills· Critical thinking – Thinking strategically about internal processes and striving for efficiency.
Job OverviewThis position assesses designs, develops, integrates and troubleshoots technology to support business processes. Employees provide technical or functional guidance to project or work teams, as needed within specific or multiple disciplines. This position is accountable for ensuring the reliability, performance, security, and continuity of IT systems, as well as ensuring that excellent technical support services are provided.
Job Duties & Responsibilities• Analyzes, designs, develops, tests, debugs, implements, maintains, integrates, customizes, and enhances existing or new systems• Applies appropriate Agile or development methodologies, system development lifecycles, tools, and technology to manage development activities• Automates the handoff of code releases from development to operations (DevOps)• Participates in the change management and service ticket management processes including receiving, resolution monitoring, and ensuring customer satisfaction• Leads projects when needed and builds strong working understanding of the solution being delivered• Ensures user satisfaction by providing preventative maintenance, troubleshooting, and timely resolution of more complex problems• Designs, develops, and tests experimental application work to test new ideas with bounded cost and time frames• Ensures that applications processes are conducted in line with corporate social responsibility, security, compliance, environmental, and technical policies and applicable standards and legislation• Acts as liaison with regulatory agencies, vendors, and contractors on matters relating to computer systems as required• Defines metrics and monitors Service Level Agreements (SLAs) for systems being developed• Performs other job-related duties as assigned
Required Qualifications• Bachelor’s or Equivalent Experience• Experience: 7+ years