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

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

Infotrend Inc

Forensic Analyst Job at Infotrend Inc

 ...Infotrend Inc. is seeking a highly skilled Forensic eDiscovery Analyst. This role provides critical technical expertise in the acquisition...  ...perform forensic examinations of electronic media including computers, mobile devices, and cloud-based systems while ensuring strict... 

Sitter.com

Sitter Wanted - Experienced Sitter Needed In Burlington, Nc $10/Hr Job at Sitter.com

Are you a nurturing and responsible individual with a passion for caring for toddlers? Our family in Burlington, North Carolina is seeking a reliable and experienced nanny to provide occasional care for our energetic toddler. This is a live-out position where you can make... 

Agent Alliance Inc.

Virtual Insurance Representative Job at Agent Alliance Inc.

 ...Description Globe is seeking a Virtual InsuranceRepresentative to join their...  ...skills Ability to work independentlyin a remote setting...  ...(BlueCross BlueShield) Dental, Vision, and Hearing insurance...  ...with the ability to work from home (Our offices are open if you work... 

Domino's Franchise

Domino's Delivery Driver Job at Domino's Franchise

 ...Domino's began humbly in 1960, with a history of starting small but dreaming big, which remains at the core of our brand. Hard work, ambition, and a passion for pizza have always fed the power of what's possible at Domino's. We are a company built on innovative solutions... 

Teneo Linguistics Company

French Interpreter Job at Teneo Linguistics Company

 ...Language forms the bedrock of understanding, empathy, and connection. We are searching for a versatile French Interpreter, specifically African French, who can bridge the linguistic gap in diverse scenarios ranging from medical, legal, community, to everyday interactions...