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

Apex Rehabilitation & Healthcare

Food Service Director Job at Apex Rehabilitation & Healthcare

Overview Food Service Director Apex Rehabilitation & Healthcare. The Food Service Director is responsible for overseeing all aspects of the food service operations. This includes managing staff, ensuring compliance with health and safety regulations, designing menus,... 

DealerOn, Inc.

SEO Consultant Job at DealerOn, Inc.

 ...JOB DESCRIPTION: The SEO Consultant will be responsible for leading the strategy and communications on SEO accounts. The SEO Consultant manages and collaborates on all work performed by SEO Specialists for their book of clients. The SEO Consultant is also responsible... 

Confidential

Part-time Museum Tour Guides (Milford) Job at Confidential

 ...Museum Tour Guide / Cashier Part-Time Okoboji Classic Cars in Milford, IA is looking for a Tour Guide/Cashier. You will assist customers, run cash register, stock inventory and guide group tours. Must be able to work at least 1 weekend per month and some holidays.... 

Healthcare Recruitment Counselors

Wound Care Physician Marion IL Job at Healthcare Recruitment Counselors

 ...Wound Care Physician Marion IL We are looking for an experienced Wound Care Physician to join our medical group in Southern Illinois areas mainly based in the Marion region. We offer 100% mobile wound care so the provider will travel to people s homes and facilities... 

CHRISTUS Health

Armed Security Officer - Mother Frances Hospital Job at CHRISTUS Health

 ...disaster events as needed and/or requested, conducting preliminary investigations of reported incidents, and performing other security related...  ...3 Commission with the Texas Department of Public Safety Private Security Bureau (TDPSPSB).New hires who have completed the TDPSPSB...