Data Warehouse Engineer

Principal Duties and Responsibilities:

The Senior Engineer/Developer is part of a high-performance team of engineers responsible for ensuring critical data and information contained within the Enterprise Data Warehouse and the Oracle Business Intelligence applications are secured, available, and always operating at acceptable levels. The Senior Developer coordinates with other mid and junior level Developers and various technical resources to plan, implement, validate, and maintain expansive Oracle Database and Oracle Business Intelligence Application changes, updates, and improvements. The Senior Developer supports and oversees the Installs, upgrades, and configurations business intelligence and OBIEE tools within the Enterprise

Location: On-site initially with strong possibility of hybrid later as employee learns envt and customer is comfortable.

Datawarehouse Environments.

· Be available on Government site in Washington DC during normal hours of operations.

· Install, configure, and maintain Oracle OBIEE tools.

· Work with complex data structures to create dashboards and Ad hoc reports with the OBIEE tools.

· Design, develop, and deploy data models with the OBIEE tools.

· Develop and maintain dashboards and reports using OBIEE Plus tools.

· Identify performance and processing issues and provide recommendations to optimize the BI products.

· Troubleshoot and resolve issues in reports and dashboards.

· Work with Stakeholders to identify Key Performance Indicator (KPI) metrics and automate metric collection and reporting.

· Create and maintains documentation including data models, system design and configuration documents, and Standard Operating Procedures (SOPs)

· Coordinate with technical resources to plan and execute OBIEE systems maintenance activities.

· Ensures systems have been secured and are maintained in accordance with agency and federal security policy and regulation.

· Other responsibilities as assigned.

• Design and architect enterprise Data Warehouse following the data-vault and dimensional data modelling methodology.
• Design the architecture to perform data management activities i.e., data extraction, transformation and load (ETL) to enterprise Data Warehouse. Implement the data management solutions using SQL, SQL procedures, Unix, Python, data management tools like Informatica power center SQL on Oracle exadata database.

Designing, implementing, maintaining and supporting data stores used for reporting and analytics (such as data lake, Data Warehouse systems and related data marts).

• Design the overall architecture to Extract, Transform and Load (ETL) data into Data Warehouse or data mart and data lake
• Develop code using SQL, SQL procedures, UNIX, python, ETL tools like Informatica Power center, AWS services like S3, data pipeline, AWS Glue, Python, AWS Lambda and Athena, Azure services like Data Lake, Data factory and Databricks to Load data into Data warehouse/DataMart/Data Lake.

Coordinating with peers from other IT groups to ensure successful design, planning and completion of programs and projects.

• Understand the Upstream and downstream application process as part of requirement gathering working with peers from other IT groups.

Understanding business requirements and priorities to shape the scope and requirements of the Data Warehouse solution.

• Gather and understand business requirements and translate business requirements to Functional and technical requirements for Data Warehouse solution.

Performing data analysis and data provisioning against source systems.

• Perform analysis against source data by running complex SQLs and develop ETL code for getting more insights on source data as part of requirement gathering.
• Perform data analysis on source data to investigate and resolve production issues reported by end users.

Designing the processes to acquire and integrate disparate data from multiple sources.

• Design and develop ETL process using SQL and Informatica to load data into Data Warehouse on daily basis from various source application on SQL Server, Oracle, Cloud Sources and files
• Design and develop the process in AWS or Microsoft Azure to integrate real-time IOT data and On Premise data into Data Lake.

Assisting in the data architecture design to be used for Business Intelligence and Analytical purposes.

• Assist downstream users with Data Warehouse related requirements & architecture Questions and provide SQL’s and develop ETL code to read data from Data Warehouse for business intelligence and Analytical needs.

Documenting technical specifications for the design of data integration and data architecture.

• Document functional and technical requirements in technical specification for developing code using SQL, SQL procedure, Unix, Python and ETL tools like Informatica Power center.

Performing unit testing to assure quality repeatable, quality processes with accurate data results and Installing processes for auditing target data stores and ensuring data quality.

Providing input and experience on the architecture, design and evolution of enterprise warehouse and information delivery solutions, including tool selection, migration strategies, and risk mitigation.

Education Experience and Required Skills:

Bachelor’s degree in computer science, Business or Management Information Systems, Electronic Engineering, or other Engineering technical discipline (8 years of additional relevant experience may be substituted for degree)
Minimum of 10 of experience in Oracle BI reporting products, especially OBIEE and Data Warehousing BI solutions
Must be authorized to work for any employer in the U.S
Must be able to obtain and maintain the required security clearance

Job Type: Full-time

Pay: $143,363.98 - $155,255.54 per year

Benefits:

• Dental insurance
• Health insurance
• Professional development assistance
• Retirement plan

Experience level:

• 10 years

Schedule:

• 8 hour shift

Ability to Relocate:

• Washington, DC 20006: Relocate before starting work (Required)

Work Location: In person