In this role, you will support the NAVAL Information Warfare Center Pacific’s Business Intelligence and Reporting organization to design and implement the strategy to parametrize code in the Navy’s ADVANA Jupiter environment. The candidate will also use Databricks and Qlik Sense to create visualizations, dashboards, and analytics applications.
Duties and Responsibilities:
· Design and automate processes to facilitate the manipulation and analysis of data.
· Develop Data Visualization reports, metrics, dashboards, and other techniques to communicate information.
· Perform user requirements analysis and stakeholder interviews.
· Perform Data transformation and migration.
· Manage Data warehouses and data lakes, ensuring data accuracy, completeness, and consistency
· Data and access control modeling
· Participate in code reviews to ensure code quality, adherence to standards, and sharing of knowledge.
· Maintain and optimize database objects, including tables, views, and notebooks, containing complex SQL queries and Python code
Experience:
· Four (4) years of experience designing developing & maintaining Business Intelligence solutions to support business requirements
· Experience in design, development, and maintenance of ETL processes for data warehouses
· Understanding of database & data warehouse concepts including schemas and data modeling
· Experience with Agile development methodology
· Experience with the Navy’s ADVANA Jupiter environment
· Experience with one or more of the following: Databricks, Qlik, Python, Scala, SQL
· Active SECRET security clearance.
Desired Education:
- Bachelor’s degree in a technical major; IT, Engineering, Computer Science, or a related field.