SSIS Developer
Job Opportunity at Distinctive Staffing Solutions

Posted on Jan 7

Location: Stevens Point, WI
Job Type: Temporary
Job ID: W4171199

The Data Warehouse Developer’s role is to provide advanced technical skills in the design, build, maintenance, control, and use of enterprise data. This role will understand the company’s data model and design solutions and processes which combine disparate data into meaningful reporting and analysis that can be easily understood by customers and internal audiences and will oversee efficient and reliable solutions to difficult problems as well as share experience in end-to-end design and implementation of an Enterprise Data Warehouse (EDW).


  • Implement improvements to support the future technical direction of the EDW in support of corporate needs as new technologies become available and/or as data needs expand
  • Investigate new data sources and design an integration strategy to include them in the EDW
  • Develop and implement EDW / Business Intelligence solutions
  • Develop data architecture (data modeling, database design) including ETL development, dimensional data models (logical and physical) and Universe development that allows for scalability and performance of the EDW platform
  • Develop technical documentation and quality assurance processes, including requirements documentation, process overviews, data models and data flows, developing use cases, test plans and test scripts, coordinating testing activities, documenting results, and driving issue resolution throughout the testing process
  • Analyze business needs and requirements, define optimum system requirements to meet the business needs and prioritize and manage new requirements
  • Build, test, and deploy an environment that supports a single source of reporting, actionable results, and flexibility for the future, performance, data quality and data governance
  • Build systems with appropriate levels of protection for business continuity, security, and data privacy
  • Translate functional requirements into technical requirements and solutions
  • Conduct performance tuning / analysis / optimization of reports and SQL
  • Implement solutions to streamline business processes to achieve departmental and company-wide goals more effectively and efficiently
  • Monitor project schedules, timelines, and key metrics, and assure projects are prioritized and meet required deadlines
  • Analyze and be accountable for key metrics and budget results
  • Special projects and duties as assigned

Education/Experience/Personal Requirements

  • Associate Degree in computer science or related field and a minimum of 5 years equivalent work experience. Bachelor’s degree preferred
  • Minimum of 3 years data modeling within an EDW environment
  • Strong proficiency in dimensional modeling and relational database design, including star schema data warehousing concepts and methodologies
  • Strong proficiency in cube development, multidimensional and tabular
  • Strong fundamental SQL programming skills, including SQL queries and the ability to tune complex queries for maximum performance, functions, and stored procedures; leveraging transactional databases, relational data marts and data warehouses
  • Experience with Microsoft database technologies, including MS SQL Server 2012/2008. SQL Server 2016 experience preferred
  • Minimum of 3 years SQL Server Integration Services (SSIS)
  • Proficiency in Microsoft Excel, SQL Server and SAP Business Objects tools: Information Design Tool, Data Services, Web Intelligence, BI Launch Pad and Crystal Reports Enterprise
  • Experience in Business Objects administration
  • Understand complex data relationships and business requirements
  • Understanding of project management and experience in gathering and analyzing business requirements
  • Strong written and oral communication skills; ability to communicate effectively with non-technical staff and with members of interdisciplinary teams
  • Self-motivated and directed
  • Ability to review and critique technical implementation produced by other technical resources
  • Analytical and problem-solving abilities
  • Ability to effectively prioritize and execute tasks
  • Strong customer service orientation
  • Experience working both independently and in a team-oriented, collaborative environment
  • Ability to operate a computer keyboard, mouse, and other office equipment
Facebook TwitterLinkedIn
CareerMarketplace.com is owned, operated, and copyrighted by Career Marketplace (© 2002-2020, All Rights Reserved)