Senior Denodo Platform Developer (Software Developer 4)
Job Description
The Software and Applications Engineering (SAE) Division supports Los Alamos National Laboratory’s (LANL) enterprise applications and performs software application development support, database development and administration, software quality management, and enterprise application consulting. The Enterprise Business Software Group (SAE-2) provides custom application development, commercial off-the-shelf application implementation, database administration, and adoption/integration with Software as a Service solution. SAE-2 supports business processes for financial, personnel, procurement, and human resources IT systems.
Software Developer 4
Working alongside some of the brightest minds, you will work with a team using agile development methodologies that support existing custom and COST applications. The selected candidates will work as a Senior Denodo Platform Developer on EDS(Enterprise Data Service) team in the Enterprise Business Software group (SAE-2) supporting the development and maintenance of the Denodo Platform.
A selected candidate will be responsible to:
- Develop and maintain Enterprise Data Models for Enterprise Class Data Initiatives
- Improve efficiency and performance tuning of existing and new views in the Denodo Platform.
- Create new and modify existing SQL reports utilizing the Denodo Platform per customer specifications.
- Develop conceptual and logical information data models within the context of the Denodo and MicroStrategy Platforms
- Develop efficient mapping of data sources, data movements, and analytics ensuring data quality and integrity.
- Develop and enforce data modeling standards and best practices.
- Deliver progress reports to project leaders and sponsors, and help define project plans and milestones.
- Contribute to the designing, developing, modifying, testing, and debugging of various reports within Denodo or MicroStrategy Platforms to meet customer requirements.
- Collaborate with customers and colleagues.
- Provide knowledge transfer to technical staff.
What You Need
Minimum Job Requirements:
- Extensive knowledge and experience in reading and writing complex SQL queries.
- Extensive understanding and experience with performance tuning of complex SQL queries.
- Extensive experience and expertise in creating complex customer queries utilizing Denodo Platform 8.x and/or MicroStrategy 2021u4 or newer.
- Experience with performance tuning of existing queries utilizing Denodo Platform 8.x and/or MicroStrategy 2021u4 or newer.
- Knowledge and understanding of row/column level security in Denodo Platform 8.x and/or MicroStrategy 2021u4 or newer.
- Ability to read, understand and map EBS SQL queries.
- Knowledge and experience with mapping of SQL queries in Oracle EBS into Denodo Platform 8.x and/or MicroStrategy 2021u4 or newer.
- Experience and extensive knowledge of data architecture, data mapping and integration between systems and various data sources.
- Experience with designing and implementing complex data architectures.
- Experience with mapping of data sources, data movement, interfaces, and analytics, with the goal of ensuring data quality and efficiency of reports
- Should have good communication skills to interact with business users and work on enhancement requests
Desired Qualifications:
Additional Skills
- Experience and knowledge of MicroStrategy Platform 2021u4 or newer, specifically with the schematic model, data model, and report development.
- Knowledge of software development methodologies including Agile, Kanban, and Scrum.
Additional Details
Directive 206.2 - Employment with Triad requires a favorable decision by NNSAindicating the employee is suitable under NNSA Supplemental Directive 206.2. Please note that this requirement applies only to citizens of the United States. Foreign nationals are subject to a similar requirement under DOE Order 142.3A.
Clearance: Q (Position will be cleared to this level). Applicants selected will be subject to a Federal background investigation and must meet eligibility requirements for access to classified matter. This position requires a Q clearance which requires US Citizenship except in extremely rare circumstances. Dependent upon position, additional authorization to access nuclear weapons information may be required that may or may not be available to dual citizens depending upon the circumstances.
Eligibility requirements: To obtain a clearance, an individual must be at least 18 years of age; U.S. citizenship is required except in very limited circumstances. See DOE Order 472.2 for additional information.
