SMX is seeking a Data Visualization / Business Intelligence Analyst primarily responsible for the analysis, design, development, maintenance and support of database-driven applications.

This is a hybrid position with time required onsite at the client location in Port Hueneme, CA.
 
The Data Visualization / Business Intelligence Analyst will: 

• Develop reports, dashboards, and advanced visualizations by working closely with stakeholders
• Help define and design reporting data structures and tables; Ensure the integrity of the data and the data structures
• Write SQL queries as needed including for extract and loading, data comparison, validation, and cleaning; This could include creating stored procedures, functions, views, etc.
• Help administer the Power BI deployment, workspaces, applications, and permissions
• Participate in the complete software development lifecycle from requirements, prototyping, production, deployment, and support
• Research technologies, standards and services and integrate them into the ecosystem
• Ensure compliance with all security, availability, confidentiality, and privacy policies and controls
• Create and maintain best practices, coding standards, technical system and end-user documentation; Provide training and assistance to end users as required
• Assist with the preparation of detailed specifications and will be responsible for the technical design, development, documentation, testing, implementation and support of various data models
• Support presentations to stakeholders, partners, and customers as needed

Required Skills and Experience:

• Clearance Required: Secret
  • Or ability to obtain; candidate can start work with an interim clearance but must be eligible for sponsorship
• Bachelor’s degree in Computer Science, Information Systems, Electronics / Computer Engineering, or Mathematics related areas of study
  • 4+ years of related professional experience can be substituted in lieu of a bachelor’s degree
• 1+ year of BI development using Power BI or equivalent tool. Proficient in making DAX queries in Power BI and using advanced calculations
• 1+ year of SQL and databases with emphasis on Transact-SQL, OLTP, and OLAP. Understands complex joins and time segment data
• Knowledge of ETL/ELT techniques and methodologies along with best practices
• Knowledge and professional experience in writing Python scripts for automating of processes
• Knowledge of Microsoft Excel
• Exceptional analytical, critical thinking and problem-solving abilities
• Highly self-directed, takes initiative, can work independently while being a strong contributor to a team
• Effective prioritization and time management skills. Can thrive in a dynamic environment in which priorities might change frequently
• Excellent communication and interpersonal skills. Strong documentation and presentation skills
• Work requires CSWF certification in accordance with DoD 8570 and SECNAV 5239.2. (such as Security+ or CISSP prior to start date)

Desired Qualifications: 

•    3+ years of BI development professional experience using Power BI or equivalent tool
•    3+ years of SQL and databases with emphasis on Transact-SQL, OLTP, and OLAP

#cjpost #LI-BP1 #LI-Hybrid