Enterprise Asset Management Reporting Specialist

Columbus Technologies and Services; Pasadena (CA); On-site; USD 110,000 - 160,000; Full time

Benefits offered by this job

Full benefits

W-2 employment

Job summary

Columbus Technologies and Services in Pasadena seeks an Enterprise Reporting Specialist to administer NASA OSI/FRED Power BI reporting, building dashboards, and KPIs while enforcing secure data access. You will manage data gateways, perform upgrades, and work with stakeholders to translate requirements into scalable solutions.

The role requires 6+ years in enterprise reporting, strong Power BI and SQL skills, and experience with data modeling.

Qualifications

• Bachelor's degree in Computer Science, IT, or related field (or equivalent).
• 6+ years in Enterprise Asset Management Reporting and/or Power BI reporting.
• Experience with application security and RBAC.
• Familiarity with Windows and Linux operating systems.
• Strong troubleshooting and problem-solving skills.
• Experience with scripting and automation tools.
• Excellent communication and collaboration skills.
• Working knowledge of Power BI data modeling, DAX, and publishing workflows.

Responsibilities

• Administer NASA's OSI/FRED Power BI Enterprise Reporting Platform.
• Develop reports, dashboards, and KPIs for strategic decisions.
• Ensure secure data access with Row- and Column-Level Security.
• Maintain reporting infra, data gateways, and performance monitoring.
• Collaborate with stakeholders to gather requirements and train users.

Skills

Power BI reporting

Enterprise Asset Management

RBAC / data security

SQL

Data modeling

Python

Team collaboration

Education

Bachelor's degree in Computer Science or related field

Tools

Power BI

Tableau

SQL Developer

Python

Maximo/MAS

Job description

Must be a US Citizen

Location - Any NASA Center

W2 position with full benefits

Estimated Duration: Ongoing

Offer contingent on ability to successfully pass a background check and drug screen.

Our salary ranges are determined by role, level, and location. The range displayed on each job posting reflects the minimum and maximum target for new hire salaries for the position across all US locations. Within the range, individual pay is determined by work location and additional factors, including job-related skills, experience, and relevant education or training.

JOB DESCRIPTION

We are seeking an Enterprise Reporting Specialist to administer NASA's Office of Strategic Infrastructure (OSI) Facilities and Real Estate Division (FRED) PowerBI Enterprise Reporting Platform by developing custom and out-of-box reports, building advanced dashboards and KPIs, and managing secure data access through Row- and Column-Level Security (RLS). This role includes maintaining reporting infrastructure, administering Power BI / Data Gateway platform, conducting system upgrades and performance monitoring, and ensuring compliance with security and access-control policies. The position works closely with stakeholders to gather requirements, translate them into actionable reporting solutions, and provide end-user training while maintaining thorough documentation, operational guidelines, and troubleshooting procedures.

• Support NASA's Enterprise CMMS reporting server and report repository, ensuring optimal performance, availability, and secure integration with Power BI reporting environments.


• Build custom reports for end users as needed, including advanced analytics and visualizations.


• Develop creative methods of joining multiple, disparate datasets to produce meaningful insight.


• Optimize and maintain Power BI data models, including improving metadata, calculation groups, and model performance.


• Develop and deliver advanced dashboards, metrics, and analytical reports using Power BI, Tableau, SQL, and other enterprise reporting tools to support strategic decision-making and performance monitoring.


• Define, configure, and maintain KPIs aligned with organizational strategy and reporting requirements to measure the effectiveness of business decisions, ensuring consistent measurement across platforms.


• Demonstrate soft skills to work with a team of analysts in an ad-hoc environment to process information.


• Collaborate with team members to collect and analyze data.


• Partner with database administrators and the data manager to ensure robust data operations.


• Structure large data sets to find usable information (mapping).


• Design, develop, and modify data infrastructure to accelerate data analysis and reporting processes.


• Maintain data management plans and instructions for operating complex business systems.


• Evaluate the design, selection, and implementation of database changes by comparing them with business requirements and design documents.


• Map and join together siloed, disparate data sets using Python or Power BI DAX.


• Update data architecture and data models as needed to support evolving requirements.


• Implement and continuously improve Row- and Column-Level Security (RLS/CLS) across reporting environments (e.g., Power BI) to ensure secure, role-appropriate data access across facility organizations.


• Manage and maintain Power BI Data Gateway configurations to support secure hybrid connectivity for on-premises MAS/Maximo data sources.


• Perform necessary software installations, upgrades, patches, and configuration changes.


• Monitor system performance, conduct routine maintenance, and implement improvements for facility maintenance and operations reports and related reporting infrastructure.


• Manage user access, roles, and security settings following compliance policies across all reporting platforms.


• Work closely with stakeholders to gather reporting requirements and implement scalable solutions.


• Develop and maintain report documentation, including specifications, mappings, gateway configurations, and troubleshooting procedures.


• Provide end-user reporting support and training on Power BI and related reporting tools.


• Develop and maintain comprehensive documentation and standard operating procedures (SOPs) related to reporting workflows, tools, and operational guidelines.

REQUIRED SKILLS

• Bachelor's degree in Computer Science, Information Technology, or a related field (or equivalent experience).


• 6+ years of experience in Enterprise Asset Management Reporting and/or PowerBI reporting.


• Experience with application security, authentication methods, and role-based access controls.


• Familiarity with Windows and Linux operating systems.


• Strong troubleshooting and problem-solving skills.


• Experience with scripting and automation tools.


• Excellent communication and collaboration skills.


• Working knowledge of Power BI reporting environments, including data modeling, DAX, and publishing workflows.


• Hands-on experience with Power BI Data Gateway management for on-premises data access.

DESIRED SKILLS

• Experience with SQL Developer.


• Knowledge of Maximo database tables and structures.


• Experience with Maximo 7.6 and MAS-9 reporting capabilities.


• Experience with enterprise analytics environments, hybrid data integrations, and RLS/CLS management at scale.


• Experience using Tabular Editor for enterprise-level data model optimization and governance.


• Certifications in relevant technologies (e.g., Power BI, Azure, Maximo/MAS, ITIL).

Equal Opportunity/Affirmative Action

Columbus is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, creed, sex, marital status, age, national origin, veteran status, disability status, or any other characteristic protected by applicable federal, state, or local law. As a federal contractor, Columbus participates in the E-Verify Program to confirm eligibility to work in the United States.