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).