Data Integration and Business Intelligence Specialist

Job description

Norfolk, VA, USA | Full Time

Data Integration and Business Intelligence Specialist

DEFTEC delivers mission-critical solutions through skillfully delivered services and innovative products.

We are inspired by our clients' critical missions and driven to provide the most effective solutions to execute their missions, operational challenges, and requirements.

Our dedicated, experienced, and talented employees work closely with our clients to ensure the delivery of exceptional services and products.



POSITION OVERVIEW

The Data Integration and Business Intelligence Specialist is responsible for designing, implementing, and maintaining enterprise data systems and reporting solutions to support strategic decision-making, operational efficiency, and compliance with organizational and regulatory standards.

This role combines deep technical expertise in data modeling, system interoperability, and business intelligence with strong analytical, communication, and stakeholder engagement skills.

.



JOB RESPONSIBILITIES:


+ Data Modeling and Repository Architecture: Design, implement, and maintain logical and physical data models, database schemas, tables, and relationships to support enterprise-level information systems.

Primarily IBM Engineering Lifecycle Management (ELM)

+ Data Integration and Interoperability: Develop processes for importing, exporting, migrating, linking, and merging data from multiple repositories, ensuring compatibility and interoperability (e.g., via Requirements Interchange Format).



+ Metadata and Data Dictionary Management: Maintain comprehensive metadata repositories, data dictionaries, and naming conventions to ensure consistency, accuracy, and discoverability of enterprise data.



+ ETL Development: Design and execute ETL workflows to extract, transform, and load data from multiple sources-including spreadsheets, legacy systems, and modern applications-into structured repositories.



+ SQL Optimization: Conduct SQL tuning, query optimization, and performance diagnostics to ensure efficient operation of Oracle and MS SQL Server environments.



+ Business Intelligence Development: Develop, customize, and maintain BI reports, visualizations, and dashboards using Microsoft Power BI, Oracle BI, and other approved tools to provide actionable insights to decision-makers.



+ Custom Application Development: Create small-scale, fit-for-purpose database applications using platforms such as Microsoft Access, FileMaker Pro, or web-based solutions to meet specific stakeholder needs.



+ Change and Configuration Management: Support the change and configuration management of data assets, ensuring version control, documentation, and compliance with lifecycle management processes.



+ Testing and Quality Assurance: Perform testing, validation, and troubleshooting of database structures, BI solutions, and data pipelines to verify accuracy and functionality.



+ Data Governance and Compliance: Ensure compliance with organizational, NATO, industry, and regulatory standards for data storage, reporting, and access control.



+ Stakeholder Engagement: Collaborate with business analysts, developers, system administrators, and end users to capture requirements and translate them into technical specifications.



+ Process Automation: Identify opportunities for automating repetitive data preparation, reporting, and integration tasks to improve efficiency and reduce manual effort.



+ Cross-System Reporting: Integrate data across multiple systems to deliver unified, cross-domain analytics and reporting solutions.



+ User Training: Deliver training sessions, documentation, and user guides to ensure effective adoption and utilization of BI tools, database systems, and reporting solutions.



+ Technical Support: Provide ongoing technical support and troubleshooting for data systems, BI tools, and associated applications.



+ Capability Lifecycle Analysis Support: Contribute data modelling and analytics expertise to support requirements-based strategic planning, capability development, and operational decision-making processes.



+ Performs additional tasks as required by the COTR related to the labor category.




Required Qualifications:


+ 10+ years of progressive experience in data modelling, database administration, and BI development.

2+ years of experience performing these tasks in IBM-ELM and the IBM database environment (Db2), including the relational database management system (RDBMS).



+ Demonstrated Expertise with Enterprise Data and Analytics and Publishing tools: IBM ELM, IBM Rational Publishing Engine (RPE), Oracle, MS SQL Server, and BI tools such as Power BI and Oracle BI.



+ Bachelor's Degree in Computer Science, Information Systems, or related field.



+ Advanced technical certifications (e.g., CCNA, vendor-specific DBMS certifications) preferred.



+ Demonstrated experience with data integration, ETL processes, and system interoperability in enterprise environments such as Open Services for Lifecycle Collaboration (OSLC) (API development and management), and experience with Requirements Interchange Format (ReqIF) for information exchange across the NATO enterprise.



+ Demonstrated experience supporting full SDLC activities, including requirements analysis, system design, testing, and deployment.



+ Demonstrated proficiency in SQL, data analysis, and customization of enterprise applications.



+ Demonstrated professional experience with DevSecOps practices, CI/CD pipelines, and configuration management processes.



+ Demonstrated minimum NATO or National SECRET clearance with the appropriate national authority for the duration of the contract.



+ Demonstrated proficiency in English as defined in STANAG 6001 (Standardized Linguistic Profile (SLP) 3333 - Listening, Speaking, Reading and Writing) or equivalent.



+ Demonstrable proficiency in effective oral and written communication, including briefing and coordinating with business stakeholders.




DEFTEC offers a comprehensive whole-life benefits package that includes medical, dental, vision, holiday, paid time off, 401K with a match, life insurance, short/long-term disability, and educational reimbursement.

The DEFTEC team comprises professionals who make a difference daily in crucial national security missions.

Our leadership knows that this happens by employing a diverse team that is well cared for.

Our top priority is our employees, making DEFTEC an ideal workplace.



Reasonable accommodations may be made to enable individuals with disabilities to perform essential functions.

Please get in touch with HR@deftec.com if you require reasonable accommodations.



DEFTEC is a Drug-Free Workplace where post-offer applicants and employees are subject to testing for marijuana, cocaine, opioids, amphetamines, PCP, and alcohol when criteria are met as outlined in our policies.



AAP/EEO Statement

DEFTEC Corp is an Equal Opportunity and Affirmative Action Employer and prohibits discrimination and harassment of any type based on actual or perceived race, color, national origin, ancestry, sex (including pregnancy, childbirth, breastfeeding and medical conditions related to pregnancy, childbirth or breastfeeding), gender, gender identity, and gender expression, religious creed, disability (mental and physical) including HIV and AIDS, medical condition (cancer and genetic characteristics ), genetic information, age, marital status, civil union status, sexual orientation, military and veteran status, denial of family and medical care leave, arrest record and/or any other characteristic(s) protected by federal, state or local law.



This policy applies to all terms of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, training, compensation, benefits, employee activities, and general treatment during employment.



Other Duties

Please note that this job description is not designed to cover or contain a comprehensive listing of the activities, duties, or responsibilities that are required of the employee for this job.

Duties, responsibilities, and activities may change at any time, with or without notice.

Required Skill Profession

Other General