Energy Data Analyst

The Data Analyst II provides analysis of both quantitative and qualitative healthcare data from various data sources in support of institutional decisions. This person will bring significant value to both the technical and non-technical sides of the organization by performing advanced exploratory analysis for further technical development or by developing high quality, impactful dashboards using charts, graphs, drilldown, navigation and other data visualization techniques. The position is responsible for the day-to-day design, development, monitoring, documentation and support of all products as well as mentoring and guiding junior staff members.

Job Responsibilities:

• Design and develop structured and unstructured databases and/or data loading processes to optimize information use.
• Document data model, database, ETL, data mapping, and data integration including documentation of business processes and data storage.
• Write testable ETL processes and/or code, using industry best practices and Continuous Integration-Continuous Delivery (CICD) / DevOps processes.
• Implement data quality and departmental standards in line with organizational expectations.
• Prepare and submit reports on data validation and loading to communicate data load progress to stakeholders and management.
• Supports and recommends improvements to databases and/or ETL operational processes including automation, monitoring, and job scheduling.
• Perform database, SQL, and/or ETL performance tuning.
• (For Analytics Development) Assist with processes/activities within area with limited guidance (e.g., business requirement analysis; technical design; dashboard development, testing, maintenance, and refresh).
• Maintains regular and predictable attendance.
• Performs other related duties as assigned in order to meet the goals of the department and institution.

Minimum Education and/or Training:

• Bachelor's degree in computer science, data science, information science, business, or related field required.

Minimum Experience:

• Minimum experience: 2+ years of IT experience in the design of databases and ETL processes preferably in comparable industry.
• Familiarity with SDLC methodologies (e.g. Agile, Waterfall, CI/CD).
• Experience in programming querying languages.
• Some experience with enterprise reporting tools for development of reports as applicable.
• Some experience creating dashboards using data visualization tools (e.g. PBI, Tableau, Qlik, and data warehousing applications) as applicable.
• Proven performance in earlier role/comparable role.

Physical Demands and Working Conditions:

• The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job.
• Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
• While performing the duties of this job, the employee is regularly required to stand; walk; sit; kneel, use hands to finger, handle, or feel; and talk or hear.
• The employee must occasionally lift and/or move up to 25 pounds.
• Specific vision abilities required by this job include close vision, depth perception and the ability to adjust focus.
• The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job.
• Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
• The noise level in the work environment is usually quiet.
• An essential function of the job is to be able to comply with all applicable federal, state and local safety and health regulations that would apply to this job.
• The employee must move about the work space to access work surface and shelves, cabinets, drawers, and equipment that are at, below or above the work surface.
• Nothing in this job description limits management’s right to assign or reassign duties and responsibilities to this job at any time as business needs dictate. This job description reflects management’s assignment of essential functions; it does not proscribe or restrict the tasks that may be assigned. The information contained herein is not intended to be an all-inclusive list of the duties and responsibilities of the job, nor is it intended to be a