StPetersburgRecruiter Since 2001
the smart solution for St. Petersburg jobs

Data Warehouse/Business Intelligence Specialist II

Company: Valpak
Location: Saint Petersburg
Posted on: September 13, 2019

Job Description:

Are you an experienced, passionate, business-oriented, Business Intelligence software developer with a roll-up-your-sleeves, hands-on, get-it-done mentality? Are you wanting to work in a fun, diverse, fast-paced agile BI shop, that has minimal red tape, cool tools, and lots of freedom to gather, process, deliver, analyze, and utilize data? If so, the Valpak Data Warehouse (BI) Specialist II position just might be the perfect fit for you! GREAT, SO WHAT S THE JOB? Our Data Warehouse (BI) Specialist II will be responsible for working in a small Agile BI team to develop top-to-bottom BI system solutions, with a specialty in ETL development and support using Microsoft SSIS and T-SQL. You will perform all development tasks for ETLs, including gathering ETL requirements; doing ETL design, coding, and testing; creating any necessary documentation; performing ETL deployments; and supporting live ETLs. You will also work with other BI specialists on the agile team, including analysts, BI architects, and front-end tool/report developers. ISN T THAT EXCITING? The role involves working directly with business stakeholders to create and gather BI requirements and negotiate BI solutions, while focusing on putting working reporting and stimulating solutions into the hands of our stakeholders. NO REALLY, WHAT WOULD I DO? A successful Data Warehouse (BI) Specialist II will:

  • Work directly with business stakeholders and other agile IT team members, to create/gather BI requirements and negotiate BI solutions.
  • Design and develop complex BI solutions in an mid-size enterprise IT environment, from back-end components and processes, through-and-including front-end user-interaction components.
  • Work with other IT specialists as necessary, including other IT analysts, developers, database architects, and systems engineers.
  • Work with other BI architects and enterprise architects, to develop an overall BI technical strategy.
  • Perform thorough analysis of database, service, and file-based data sources, as a critical input to ETL design.
  • Create and modify SQL Server database artifacts, including tables, views, indexes, and stored procedures, using DDL. Create deployment scripts.
  • Create, manage, monitor, and optimize SSIS ETL packages. Manage and monitor job schedules.
  • Record BI requirements and design, utilizing industry-standard documentation techniques such as modeling.
  • Support live BI processes, including: a) creating/changing BI process schedules, and b) monitoring and troubleshooting BI processes, such as data loads, transformations, rollups, and reorganizations. SO, WHAT KIND OF EXPERIENCE ARE YOU LOOKING FOR? Required Experience includes:
    • Design and implement complex, multi-step ETLs using SSIS, pulling from multiple source systems and source types
    • Perform data profiling, data mapping, and data quality validation
    • Monitor live ETLs; tune and optimize ETL performance
    • Write SQL and develop stored procedures rapidly, using T-SQL
    • Troubleshoot and correct SSIS packages
    • Knowledge of data warehouse design concepts such as star and snowflake schema design, and slowly-changing dimensions
    • Utilize 3rd party products to facilitate ETL analysis and monitoring (preferred) ANYTHING ELSE? Professional Knowledge and Skills
      • Ability to clearly explain both business and technical concepts related to business intelligence management, verbally and in written and/or diagrammed form; strong motivation to negotiate, design, and implement practical BI solutions for all stakeholders
      • Ability to effectively manage BI work assorted with multiple projects going on in parallel, including working with many individuals in both varying technical and business roles; strong ability to work productively and happily in a typically stressful, modern corporate environment Education/Experience: -Bachelor's degree, with a minimum of 5 years industry experience in IT systems development. -3 years of ETL development and support experience with SQL Server -Multiple iterations of ETL, data store, and data cube development. - provided by Dice

Keywords: Valpak, St. Petersburg , Data Warehouse/Business Intelligence Specialist II, IT / Software / Systems , Saint Petersburg, Florida

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category

Other IT / Software / Systems Jobs

Automation Tester
Description: Automation Tester - Tampa, FL - 2 Positions Role: Analyzing the requirements
Company: Galaxy i Technologies, Inc
Location: Tampa
Posted on: 09/24/2019

Software Engineer Level 2 with Security Clearance
Description: Software Engineer Location: Orlando, FL Duration: 6 - 12 mos Pay Rate: DOE - ph W2 Active SECRET clearance preferred. Will consider Interim SECRET
Company: Butler Aerospace & Defense
Location: Orlando
Posted on: 09/24/2019

Sr. Salesforce Developer
Description: Company Description Are you seeking an opportunity to work for an innovative company with their eyes on the future A leader in its field A company who strives to build longstanding relationships with (more...)
Company: Rand Worldwide, Inc
Location: Tampa
Posted on: 09/24/2019

Active Directory Consultant
Description: Job Title : Active Directory Consultant Location: Tampa, FL Duration : 12 Months
Company: K Anand Corporation
Location: Tampa
Posted on: 09/24/2019

Associate Technical Producer
Description: BUSINESS UNIT: br br Cubic Global Defense br br COMPANY DETAILS: br br Cubic offers an opportunity to provide innovative technology for government and commercial customers around the globe, (more...)
Company: Cubic Corporation
Location: Orlando
Posted on: 09/24/2019

Websphere Portal Developer
Description: Websphere Portal Developer in Saint Petersburg, FL I have an available position for a Portal Developer in Saint Petersburg, FL Our client is willing to sponsor Here are the details on the position - (more...)
Company: Witnoa Technologies
Location: Saint Petersburg
Posted on: 09/24/2019

Network Administrator with Security Clearance
Description: Job Title: Network Administrator br Location: Tampa, FL SUMMARY br Setup, support, and monitor local global LAN, WLAN, WAN, and VoIP Infrastructure. Perform a variety of network maintenance, installation, (more...)
Company: Anonymous Employer
Location: Tampa
Posted on: 09/24/2019

Network Ops Admins and Engg, System Administrators, with Security Clearance
Description: ASD is seeking Intel Analysts, Network Engineers, Sr System Administrators, Sr. System Engineers, NOSC Monitoring and System Analysts
Company: Advanced Software Design
Location: Tampa
Posted on: 09/24/2019

Embedded Software Engineer with Security Clearance
Description: Title: Embedded Software Engineers Location: Orlando, FL Job Description: Butler Aerospace and Defense is a partner of choice providing superior technical outsourcing and staff augmentation services to (more...)
Company: Butler Aerospace & Defense
Location: Orlando
Posted on: 09/24/2019

Mobile Automotive Technician - Level A
Description: Job Description Protech Automotive Solutions is looking for highly talented, dedicated and quality-focused teammates to provide top tier service to our customers. Location: Miami/Ft. Lauderdale Job Summary (more...)
Company: Protech Automotive Solutions
Location: Orlando
Posted on: 09/24/2019

Log In or Create An Account

Get the latest Florida jobs by following @recnetFL on Twitter!

St. Petersburg RSS job feeds