Business Intelligence (BI) Developer/Analyst

• Must be eligible for a federal security clearance (US Citizen).
• Must be able to work hybrid onsite in Oak Ridge, TN.

Business Intelligence (BI) Developer/Analyst (Machine Learning)

Overview:
We are hiring a Business Intelligence Analyst with MS Power BI development skills, a proven foundation in Data Science, and mid-level Machine Learning and ML Ops skills to design, develop, and deploy BI, Analytics, and ML tools to production. Our efforts enhance and evolve business operations and scientific decision-making capability and related activities.

This position supports the company’s business analytics applications and data engineering activities, which potentially cover all areas of corporate data (business, human capital management, facilities, operations, and research). The company’s BI cubes, models, and analytics are heavily centered on Microsoft and SAP technologies, including Visual Studio, SSIS packages, and dimensional modeling, as well as SQL Server 2016-2022 and SQL Azure.

Major Duties/Responsibilities:

• Develop and support: Corporate reports and dashboards with Power BI 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 a 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 on delighting customers and end-user needs, excellent written and verbal communication 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 who creatively solves problems.
• 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 tools and visualization creation.
• Large dashboards, ETL tools, and methods (i.e., Power Query) or similar tools.
• 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).

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.
• Experience using Microsoft Visual Studio or Visual Studio Code, Python.
• Experience with current Data Science or Data Analytics tools, including low-code or no-code.
• Knowledge of current business processes and applications (or similar).
• Knowledge of Microsoft SharePoint technologies.
• Demonstrated experience with Microsoft CoPilot, OpenAI tools, and API’s for GPT creation, Large Language Models, Generative AI, or similar tools.