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

eTUwU05LeFROMjVnZkR6OGMyOXZnd2pQ
  • 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

AdNet AccountNet, Inc.

Customer Service Representative - Part-Time Job at AdNet AccountNet, Inc.

About Us: AdNet/AccountNet, Inc. is an 8(a), WOSB, and WBE owned management consulting firm founded in 1990. We blend the best in people with the ongoing demands of the workplace by providing high quality staffing and executive search services. We are seeking aVirtual...

G2 Secure Staff

Ramp Agent, Passenger Service (Ticketing) Agent NOW HIRING At the Yampa Valley Airport Job at G2 Secure Staff

NOW HIRING At the Yampa Valley Airport Passenger Service (Ticketing) Agent $26.00/hr Ramp Agent - $26.00/hr (must have valid drivers license) -Sign on / Retention $2,000 -Part Time and Full time hours available, from approximately 7:00 am to 7:00 pm, Sunday thru Saturday... 

Gainor Staffing

Litigation Paralegal Job at Gainor Staffing

 ...Description A results-driven law firm is seeking a Litigation Paralegal to contribute to its mission of delivering exceptional legal...  ...gender identity and expression), age, national origin, immigration status, marital or familial status, citizenship status, ancestry... 

Longwood Collective, Inc.

Answering Service Operator (Boston, MA) Job at Longwood Collective, Inc.

Position OverviewWe are currently hiring for Full-Time, Answering Service Operators!In this role, you will take phone calls for several large hospitals...  ...MASCO Services Call Center is a rewarding but challenging work environment where you can make a difference. This is a... 

Epic Special Education Staffing

Sign Language Interpreter School Job at Epic Special Education Staffing

 ...Epic Special Education Staffing is partnering with an exceptional school district who is looking for a contract Sign Language Interpreter for the 2025 - 2026 school year. Duration: ASAP - 06/12/2026 Location: Puyallup, WA Location Type: On-Site Schedule...