Requisition Id 13803
We are only able to consider Lawful Permanent Residents (US citizens and Green Card holders) at this time for this position.
Overview:
We are hiring a Business Intelligence Analyst with MS Power BI development skills, a proven foundation of Data Science and mid-level Machine Learning and ML Ops skills to design, develop and move BI, Analytics and ML tools to production! Our efforts enhance and evolve business operations and scientific decision-making capability and related activities at ORNL. This position resides in the Enterprise Applications & Business Intelligence group of the Application Development division of the Information Technology Services Directorate at Oak Ridge National Laboratory (ORNL).
This position supports ORNL’s Business analytics applications and data engineering activities which potentially cover all areas of corporate data (business, human capital management, facilities, operations, and research). ORNL’s BI cubes, models and analytics are heavily centered on Microsoft and SAP technologies, to include Visual Studio, SSIS packages and Dimensional Modeling and SQL 2016-2022 and SQL Azure.
Major Duties/Responsibilities:
- Develop and support:
- Corporate reports and dashboards with PowerBI and other Microsoft reporting tools.
- Data warehouse technologies beyond the worlds of Microsoft and SAP. SQL and ML applied experience and a general understanding of their potential use cases.
- Develop and implement master data management strategy to include implementation of measures to ensure data accuracy, cleanliness, transformation, and accessibility.
- Collaborate with business and scientific/technical customers to understand needs and capture detailed actionable requirements.
- Analyze emerging trends and technologies to provide recommendations for roadmaps and BI strategy including Cubes, SSIS, Visual Studio, Azure Data Factory, SQL, SQL Azure, and ML techniques and solution methods.
- Collaboration with other DOE labs and private sector companies to understand capabilities.
- Follow ORNL and ITSD software quality assurance standards, ITIL effective practices, and project management requirements.
- Provide personal training for end users as needed, on Business Intelligence tools and effective practices.
- Deliver ORNL’s mission by aligning behaviors, priorities, and interactions with our core values of Impact, Integrity, Teamwork, Safety, and Service. Promote diversity, equity, inclusion, and accessibility by encouraging a respectful workplace – in how we treat one another, work together, and measure success.
Basic Qualifications:
- A BS in computer science, data science, business analytics management, applied statistical analytics or a related technical field of study and two (2) to four (4) years of aligned experience is required for consideration.
- MS and PhD degree holders in the same fields of study are also encouraged to apply. MS holders should have one (1) to three (3) years of aligned experience. PhD holders may have any amount of experience.
- Prior Microsoft Business Intelligence development experience including requirements gathering, design, and deployment of reporting solutions.
- Candidates must demonstrate:
- a strong emphasis in delighting customer and end-user needs.
- excellent written and verbal communications skills.
- excellent relational client-facing skills, effective exploratory analytical thinking, and attention to detail.
- the ability to innovate as work demands.
- the demeanor of an analytical doer that creatively problem solves.
- a deeply curious approach toward novel development, planning, support, design, modification and testing of data warehouse cubes, models, dimensions, measures, views and reports.
- experience creating BI solutions using MS Power BI, SQL, and MS Azure tool sets.
- experience with Microsoft SQL, Visual Studio or Visual Studio Code tools and APIs for analytic tool and visualization creation.
- Large dashboards, ETL tools and methods (i.e. Power Query) or similar tools.
Preferred Qualifications:
- Microsoft Power BI and data visualization to represent sophisticated data concepts that foster business transparency and support effective decision making.
- Understanding of ETL (extract, transform, load) framework.
- Understanding of multidimensional and tabular modeling.
- Experience using SQL Server Database engine (SSMS), SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), and SQL Server Analysis Services (SSAS).
- Experience using Microsoft Visual Studio or Visual Studio Code, Python.
- Experience with current Data Science or Data Analytic tools including low code-no code.
- Knowledge of current ORNL business processes and applications (or similar).
- Knowledge of Microsoft SharePoint technologies.
Special Requirements:
Visa sponsorship is not available for this position.
Benefits at ORNL:
ORNL offers competitive pay and benefits programs to attract and retain dedicated people. The laboratory offers many employee benefits, including medical and retirement plans and flexible work hours, to help you and your family live happy and healthy. Employee amenities such as on-site fitness, banking, and cafeteria facilities are also provided for convenience.
Other benefits include the following: Prescription Drug Plan, Dental Plan, Vision Plan, 401(k) Retirement Plan, Contributory Pension Plan, Life Insurance, Disability Benefits, Generous Vacation and Holidays, Parental Leave, Legal Insurance with Identity Theft Protection, Employee Assistance Plan, Flexible Spending Accounts, Health Savings Accounts, Wellness Programs, Educational Assistance, Relocation Assistance, and Employee Discounts.
In addition, we offer a flexible work environment that supports both the organization and the employee. A hybrid/onsite working arrangement may be available with this position.
Having difficulty using the online application system or need an accommodation to apply due to a disability? Please email: ORNLRecruiting@ornl.gov or call 1.866.963.9545.
This position will remain open for a minimum of 5 days after which it will close when a qualified candidate is identified and/or hired.
We accept Word (.doc, .docx), Adobe (unsecured .pdf), Rich Text Format (.rtf), and HTML (.htm, .html) up to 5MB in size. Resumes from third party vendors will not be accepted; these resumes will be deleted and the candidates submitted will not be considered for employment.
ORNL is an equal opportunity employer. All qualified applicants, including individuals with disabilities and protected veterans, are encouraged to apply. UT-Battelle is an E-Verify employer.
