Business Intelligence And Data Warehouse Specialist

Nassco San Diego , CA 92140

Posted 3 weeks ago

Job Posting End Date: 3/24/2020

Shift: 1st

Security Clearance: No Clearance

SUMMARY

Responsible for the development and execution of NASSCO's data warehousing strategies.

ESSENTIAL FUNCTIONS AND DUTIES

  • Works directly with the business community to understand the functional requirements and translates them into technical requirements.

  • Designs and develops recurring and ad-hoc business intelligence solutions such as cubes and dashboards using industry best practices for presentation, efficiency, and user friendliness.

  • Extracts operational, performance, statistical and other data from various information systems.

  • Designs reports to aid in the efficient assimilation of information by engaging exception reporting, traffic lighting, heat mapping, etc.

  • Troubleshoots/enhances existing SQL reports.

  • Develops and maintains security for the end-to-end solution (warehouse to presentation layer).

  • Leads the analysis, diagnosis and documentation of problems related to Business Intelligence and leads their resolution.

  • Collaborates with PMO to develop sound project plans and participates in the execution of each phase of SDLC.

  • Leads the development of user and system application documentation.

  • Supports colleagues with guidance related to warehousing and/or BI development.

  • Actively participates in implementing and monitoring continuous improvement initiatives to improve safety, improve quality, reduce cycle time, and reduce costs.

  • Additional responsibilities and duties as assigned.

SKILLS AND QUALIFICATIONS

  • A Bachelor's degree in Computer Science or equivalent combination of education/experience is required.

  • Minimum of 7 years of working experience with data warehouse design, multi dimension cubes construction, and business intelligence solutions development is required.

  • Experience with building dashboards with Tableau and/or Microsoft Power BI is required.

  • Experience with architecting and developing ETL processes that integrate data from multiple sources and format is required.

  • MCSA SQL 2016 BI Development certification is preferred.

  • Experience with Alteryx or similar tool is preferred.

  • Ability to work effectively with various groups in developing solutions to problems.

  • Demonstrates strong analytical and organizational skills, with excellent verbal and written communication skills.

  • Must be self-motivated and take a proactive approach to responsibilities.

PHYSICAL DEMANDS

Specific vision abilities required by this job include close vision, distance vision, peripheral vision, depth perception, and the ability to adjust focus. The employee is regularly required to sit, use hands to fingers, handle or feel objects, or controls, and to talk and hear. Must be physically able to walk to all yard locations. The noise level in the work environment is usually moderate.

General Dynamics NASSCO is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or veteran status, or any other basis protected by local, state, or federal law.

To learn more about applicant rights under federal law, click here:

EEO is the Law Poster

EEO is the Law Supplement

Pay Transparency

If you have a disability that impacts your ability to complete the job application process and would like to request an accommodation, please contact our Human Resources Department.

Call (619) 544-8511 or email nasscohr@nassco.com. This contact information is for accommodation requests only, not to inquire about the status of applications.

Nearest Major Market: San Diego

Job Segment: Warehouse, Security Clearance, QA, Manufacturing, Government, Quality


icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Business Intelligence And Data Warehouse Specialist

General Dynamics

Posted 2 weeks ago

VIEW JOBS 3/19/2020 12:00:00 AM 2020-06-17T00:00 Date: Mar 16, 2020 Location: San Diego, CA, US, 92108 Company: National Steel and Shipbuilding Com Job Posting End Date: 3/24/2020 Shift: 1st Security Clearance: No Clearance SUMMARY Responsible for the development and execution of NASSCO's data warehousing strategies. ESSENTIAL FUNCTIONS AND DUTIES * Works directly with the business community to understand the functional requirements and translates them into technical requirements. * Designs and develops recurring and ad-hoc business intelligence solutions such as cubes and dashboards using industry best practices for presentation, efficiency, and user friendliness. * Extracts operational, performance, statistical and other data from various information systems. * Designs reports to aid in the efficient assimilation of information by engaging exception reporting, traffic lighting, heat mapping, etc. * Troubleshoots/enhances existing SQL reports. * Develops and maintains security for the end-to-end solution (warehouse to presentation layer). * Leads the analysis, diagnosis and documentation of problems related to Business Intelligence and leads their resolution. * Collaborates with PMO to develop sound project plans and participates in the execution of each phase of SDLC. * Leads the development of user and system application documentation. * Supports colleagues with guidance related to warehousing and/or BI development. * Actively participates in implementing and monitoring continuous improvement initiatives to improve safety, improve quality, reduce cycle time, and reduce costs. * Additional responsibilities and duties as assigned. SKILLS AND QUALIFICATIONS * A Bachelor's degree in Computer Science or equivalent combination of education/experience is required. * Minimum of 7 years of working experience with data warehouse design, multi dimension cubes construction, and business intelligence solutions development is required. * Experience with building dashboards with Tableau and/or Microsoft Power BI is required. * Experience with architecting and developing ETL processes that integrate data from multiple sources and format is required. * MCSA SQL 2016 BI Development certification is preferred. * Experience with Alteryx or similar tool is preferred. * Ability to work effectively with various groups in developing solutions to problems. * Demonstrates strong analytical and organizational skills, with excellent verbal and written communication skills. * Must be self-motivated and take a proactive approach to responsibilities. PHYSICAL DEMANDS Specific vision abilities required by this job include close vision, distance vision, peripheral vision, depth perception, and the ability to adjust focus. The employee is regularly required to sit, use hands to fingers, handle or feel objects, or controls, and to talk and hear. Must be physically able to walk to all yard locations. The noise level in the work environment is usually moderate. General Dynamics NASSCO is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or veteran status, or any other basis protected by local, state, or federal law. To learn more about applicant rights under federal law, click here: EEO is the Law Poster EEO is the Law Supplement Pay Transparency If you have a disability that impacts your ability to complete the job application process and would like to request an accommodation, please contact our Human Resources Department. Call (619) 544-8511 or email nasscohr@nassco.com. This contact information is for accommodation requests only, not to inquire about the status of applications. Nearest Major Market: San Diego Nearest Secondary Market: Job Segment: Warehouse, Security Clearance, QA, Manufacturing, Government, Quality General Dynamics San Diego CA

Business Intelligence And Data Warehouse Specialist

Nassco