Business Intelligence Analyst
Employment Information
Report this job
Job expired or something wrong with this job?
Job Description
BI Analyst developing dashboards, data governance, and enterprise reporting for the National Laboratory of the Rockies. Supporting energy innovation through financial analytics and systems integration.
Responsibilities:
- Participate in stakeholder discussions to define and document requirements for reports and dashboards
- Serve as a subject matter expert for data visualization, reporting best practices, and data management frameworks
- Design and develop dashboards and visualizations
- Conduct data analysis and modeling to identify trends, insights, and recommendations
- Develop and document business requirements for data sets, reports, and dashboards
- Test and validate reports and dashboards against business and technical requirements
- Define, validate, and manage business definitions for data sets and reporting schemas
- Collaborate with ITS on data governance, data set delivery, and BI system troubleshooting
- Enhance data governance policies and ensure enterprise data accuracy and integrity
- Contribute to development of data sets aligned with business requirements and reporting needs
- Provide troubleshooting and support for BI stakeholders and end-users
- Maintain system documentation and training materials
- Support education and training for customers using BI and reporting tools
- Analyze new data sources for integration into the enterprise reporting framework
- Recommend and implement enhancements to the OCFO BI reporting framework for performance and scalability
- Contribute to cross-functional projects aligned with OCFO objectives
Requirements:
- Relevant Bachelor's Degree and 2 or more years of experience or equivalent relevant education/experience; or relevant Master's Degree or equivalent relevant education/experience
- Must meet educational requirements prior to employment start date
- Eligibility may be restricted based on citizenship due to access to Controlled Unclassified Information
- Basic understanding and wide application of technical principles, theories, and concepts
- Basic knowledge of database concepts, data modeling, and schema design
- Basic knowledge of Power BI, SSRS, Tableau, or other reporting tools
- Strong proficiency with Microsoft Office productivity tools
- Ability to access, query, analyze, and model incoming data
- General knowledge of related disciplines
- Ability to work independently under general supervision and exercise judgment within established practices and procedures
- Ability to work effectively in a team-oriented, matrixed organization
- Excellent written and verbal communication skills
- Strong organizational and time management abilities
- Ability to communicate technical concepts to non-technical audiences
- Strong team orientation
- Demonstrated analytical and problem-solving capabilities
- Experience with SQL coding for data extraction, transformation, and optimization
- Experience with Python, including Pandas
- Experience with parquet files
- Experience with Oracle databases
- Experience with Azure SQL or other cloud-based database environments
- Experience with data engineering and data science techniques
- Experience restructuring legacy financial data and optimizing wide tables
- Proficiency in Microsoft Power BI, including DAX and governance best practices
- Experience designing data visualizations and implementing reporting frameworks
- Experience with Microsoft Excel and SmartView reporting
- Experience with financial systems
- Ability to obtain and maintain a federal Personal Identity Verification (PIV) card and pass a favorable background investigation
- Must pass a pre-employment drug test
Benefits:
- Medical, dental, and vision insurance
- Short- and long-term disability insurance
- Pension benefits
- 403(b) Employee Savings Plan with employer match
- Life and accidental death and dismemberment (AD&D) insurance
- Personal time off (PTO) and sick leave
- Paid holidays
- Tuition reimbursement
- Potential eligibility for performance-, merit-, and achievement-based monetary awards
- Potential relocation expense reimbursement
- Robust professional development opportunities
Similar Jobs
Reporting Analyst
Reporting Analyst producing Salesforce, Power BI, and Excel reporting for Precision AQ’s commercial operations. Supporting forecasting, pipeline analytics, dashboards, and business intelligence automation.
Engineer II, Business Intelligence
BI Engineer II building enterprise Power BI reports and Azure data pipelines. Enabling data-driven decisions through scalable analytics, validation, optimization, and automation.
Senior Business Intelligence, Data Engineer
Senior BI & Data Engineer building scalable data architecture and reporting for inexogy, Germany’s independent smart-metering provider. Developing Power BI solutions and leading BI capabilities.
Director, Financial Planning – Business Intelligence
Director leading FP&A, Power BI reporting, and financial decision support at Rain, a national DTC marketing agency. Strengthening forecasting, business partnering, automation, and commercial analysis.
Business Intelligence Specialist
Business Intelligence Specialist developing enterprise reports, dashboards, and data visualizations for TD, a global financial institution. Streamlining reporting and advising senior stakeholders across business units.
Senior Data Intelligence Analyst – Health Equity Analyst
Health system data analyst using SQL, Epic Clarity, and Reporting Workbench to advance health equity. Producing dashboards, reports, and insights for clinical decision-makers.
BI Reporting Analyst
BI Reporting Analyst building Oracle reports and Power BI dashboards for Kyivstar, a Ukrainian telecom operator. Supporting business analytics through data quality analysis, visualization, and internal-client requirements gathering.
Senior Analyst, Financial Planning & Analysis, Business Intelligence
Senior FP&A and BI Analyst scaling performance measurement for The Princeton Review, a tutoring, test-prep, and college-admission services company. Building dashboards, forecasts, and executive insights.
Business Intelligence Team Leader
Business Intelligence Team Leader leading analysts and building Power BI, Fabric, and BigQuery solutions. Job Duck connects skilled professionals with remote US-based employers.
Business Intelligence Associate
Business Intelligence Associate transforming data into actionable fundraising and marketing insights for CDP, which provides analytics and technology services to public media organizations. Supporting Tableau reporting, SQL pipelines, data validation, visualization, and user enablement.
Director, Analytics & Business Intelligence – Digital Product Operations
Director building analytics, dashboards, and adoption metrics for College Board’s digital assessment operations. Driving data-informed improvement across 15+ product teams and ProdOps initiatives.
Business Intelligence Manager
UKG Business Intelligence Manager developing workforce dashboards and analytics for Ascension, a nonprofit Catholic healthcare system. Optimizing staffing, scheduling, labor costs, and patient care operations.
Business Intelligence Manager
Business Intelligence Manager driving strategic analytics and reporting solutions for clinical research operations at Parexel. Collaborating with cross-functional teams to ensure data governance and operational excellence.
Business Intelligence Specialist
Business Intelligence Specialist at Notchwood Landscape transforming raw data into actionable insights. Analyzing business operations and developing BI solutions for improved decision-making.
Investor Reporting Analyst
Investor Reporting Analyst responsible for generating accounting reports and analyzing results for assigned investors. Working remotely for Carrington Mortgage Services offering mortgage loan servicing assistance.
Business Insights Analyst
Business Insights Analyst converting messy data into insights for leadership at Payliance. Collaborating with various departments to improve reporting and decision-making processes.
Business Intelligence Spezialist
Business Intelligence Specialist responsible for data preparation and analysis at Bitac GmbH. Collaborating with IT and departments to implement data extraction scenarios while focusing on Microsoft BI technology.
Senior Business Intelligence, SQL, Power BI
Experienced Business Intelligence professional designing and maintaining data architecture using Power BI and SQL for analytics. Collaborating with teams to ensure data quality and governance in enterprise environments.
Senior Reporting Analyst
Senior Reporting Analyst optimizing customer strategies through data insights and collaborating with business leaders at BMO. Using advanced analytics to support key business decisions and drive performance.
Freelance Trainer – Controlling & Business Intelligence, Power BI, AI Tools
Trainer in Controlling & Business Intelligence teaching using Power BI and AI Tools. Responsible for learner motivation and project work evaluation while working remotely from home.