Data Integration and Business Intelligence Specialist

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.
• Bachelors 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 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 typebased on actual or perceived race color national origin ancestry sex (including pregnancy childbirth breastfeedingand medical conditions related to pregnancy childbirth or breastfeeding)gender gender identity and gender expression religious creeddisability (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 includingrecruiting 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 Experience:

IC