Senior Data Modeler with Security Clearance Job at Dfuse Technologies Inc, San Diego, CA

aHNVNHJ3WThsc1lQam1iRTVpZ0c1dXIz
  • Dfuse Technologies Inc
  • San Diego, CA

Job Description

Job Description: Analyze, design, code and test new or existing application programs. Support the Data Warehouse and Business Intelligence community. Manage, Maintain and Support Day-to-Day Operations of NAVAIR Depot Maintenance System (NDMS), SingleSite, OneNDMS, Data Convergence, Corporate Reporting System (CRS) and Other Initiatives. Support development, standardization, testing, and quality assurance and configuration management procedures. Support standardization and maintenance of data dictionary, data structures and data repositories. Specific Tasks: · Data modeling/architect: o Model in Kimball’s dimensional methodology using the Project Lead’s requirements. o Design/modify logical and physical dimensional models using Erwin to meet business' reporting requirements. o Prepare and document standards and procedures for dimensional data modeling and naming conventions. · Extract-Transformation, Load (ETL) Mapping Specifications: o Prepare high-level ETL mapping specifications. o Develop regression test scripts to validate ETL. · Development: o Develop stored procedures to populate new tables and columns. o Develop regression test scripts to validate stored procedures. · Troubleshooting: o Perform data analysis across multiple databases to identify source of data issues. o Determine best resolution for data issues and anomalies. o Revise ETL mapping specifications and/or stored procedures as required. o Revise associated regression tests as required. · Manage the overall Data Warehouse Data Architecture o Establish and maintain Virtual Private Database (VPD) security policies. o Ensure Data Architecture follows best practices and guidelines for Data Warehousing. Required Skills and Experience: · Active Secret Clearance. · Security+ (may be obtained) and Certified Business Intelligence Professional · Data modeling (Kimball’s or similar methodology preferred). · Bachelor's degree or postgraduate degree in computer science, information systems management, mathematics, operations research, statistics, or engineering or 8 eight years of combined education (at the undergraduate level in any academic field) and experience performing the foregoing functions. Employment Type: Full time

Job Tags

Full time,

Similar Jobs

TRC Talent Solutions

Human Resources Manager Job at TRC Talent Solutions

 ...Ensure internal HR processes align with plant goals and employee needs. Qualifications: ~ Bachelors Degree required (Human Resources, Business, or related field)~10+ years of HR experience, preferably in a manufacturing environment ~5+ years of direct team... 

Little Wheel

Interactive Gaming Platform Reviewer (Hiring Immediately) Job at Little Wheel

 ...earn extra income on a flexible schedule while helping us test online casinos. No prior experience is required, and all training is provided...  ...and responsive. Anonymous, Glassdoor (2025) Read more reviews on Glassdoor , Trustpilot , and Google . Equal... 

Walmart

Deli/Bakery Team Associate Job at Walmart

 ...Location Walmart Supercenter #14532440 W MASON ST, GREEN BAY, WI, 54303, US Job Overview The main priority of Deli / Bakery associates is to prepare quality products for customers. They engage with customers at the service counter and move incoming merchandise... 

Lowes

Sr. Account Manager Job at Lowes

 ...leveraging opportunities to deploy product and account management solutions, resulting in sales gains....  ...portfolio of customers by conducting market research, cold calling, following...  ..., including yearly planned sales. Influences the District Manager and store managers... 

Host Healthcare

Travel Respiratory Therapist (RRT/CRT) - $1,791 per week Job at Host Healthcare

Host Healthcare is seeking a travel Registered Respiratory Therapist for a travel job in Kirksville, Missouri. Job Description & Requirements ~ Specialty: Registered Respiratory Therapist ~ Discipline: Allied Health Professional ~ Start Date: 08/18/2025~ Duration...