the smart solution for Seattle jobs

Data Analytics Developer (IT Pro B-BU)

Company: City of Seattle
Location: Seattle
Posted on: July 12, 2018

Job Description:

Position Description Position Overview The Applications division of Seattle Information Technology (Seattle IT) is seeking qualified candidates for the Data Analytics Developer position to develop and implement data warehouses to support data analytics and reporting.-- This position is part of the Data Services team and will be primarily responsible for providing analysis, architecture, design, development, testing, deployment and automation of various data warehouse components. -- The ideal candidate will have demonstrated experience in integrating data from various source systems, good understanding of quality, validation and management of data.-- This individual will closely work with business analysts, functional leads, data owners and other team members to create and maintain Extract Transform and Load (ETL) interfaces between systems using Microsoft Business Intelligence tools.-- Please note that position is eligible for overtime or compensatory time--for hours worked over 40 in a workweek. Job Responsibilities Key Accountabilities/Responsibilities Develop ETL solutions using SQL Server Integration services (SSIS) Develop multidimensional cubes using SQL Server Analysis Services (SSAS) Create T-SQL scripts for database objects Create MDX and XMLA scripts for OLAP database objects Meet with business analysts and subject matter experts to understand and document business requirements Translate customer requirements into unambiguous, scalable, robust and flexible technical solutions for implementation Create and maintain architecture diagrams, data models, mapping documents, business rules, data flow diagrams--and other design related artifacts Develop ETL processes per technical design specification and the established design standards Perform impact analysis on change requests Analyze and troubleshoot production issues quickly to ensure system uptime meets service level agreements Assist the data warehouse team in designing efficient processes to load and manage data, including assessment of data quality in the source systems and implement appropriate business rules, data mappings, and transformation rules Actively participate in code reviews, unit testing, system integration testing and remedy solution defects Clearly and concisely communicate status of all assigned tasks to the project team, stakeholders and management Perform a variety of job tasks commensurate with IT Professional B level Qualifications Required Qualifications Note : Equivalent combinations of education and experience will be considered. Bachelor's degree in computer science or computer technology or a closely related field Solid understanding of data warehouse principles and multi-dimensional data modeling concepts, source to target mapping and data integration architecture-- A minimum of 3 years of experience in the development of ETL to build data warehouses using Microsoft SSIS and SSAS Excellent SQL skills and ability to create T-SQL/stored procedures-- Ability to develop reports and visualizations using Tableau, Microsoft Power BI or one of the widely adopted data discovery, analysis and visualization software like Cognos, OBIEE, etc. Demonstrated ability to meet tight deadlines, follow development standards and effectively raise critical issues with the team-- Must be a self-starter who can work independently yet be a strong team player with excellent attention to detail and customer service skills Experience in creating and maintaining requirements specifications and technical design documents Ability to prioritize and complete technical tasks with minimal instruction and supervision Aptitude for learning new development tools and technologies quickly Establish strong working relationships with coworkers, customers, project team, vendors and across all levels of the organization Strong oral and written communication skills to convey technical details to non-technical staff and customers Desired Qualifications Proficiency in developing applications using standard languages and platforms, including the .NET framework, Visual Studio and C# Working knowledge in data migration/integration with off-premise / cloud data services. Experience building, administering and managing scalable analytical platforms containing both structured and unstructured data. Knowledge in version control and change management processes. Experience with source control mediums such as Team Foundation Server (TFS), Visual Studio Team Services (VSTS) or Git Experience in release management lifecycle including scheduling and managing releases and updates Experience with Agile development methodologies Additional Information NOTE: -- Submit cover letter and resume along with NeoGov application. NOTE: This position is covered by a collective bargaining unit; International Brotherhood of Electrical Workers, Local 77. You will be required to join the union within 30 days of employment, and pay monthly union dues through automatic payroll deduction. NOTE: -- Employment contingent upon successful completion of comprehensive criminal background investigation in compliance with Seattle's Fair Change Employment Ordinance SMC 14.17The City of Seattle offers a comprehensive benefits package including vacation, holiday and sick leave as well as medical, dental, vision, life and long-term disability insurance for employees and their dependents. More information about employee benefits is available on the City's website at:

Keywords: City of Seattle, Seattle, Data Analytics Developer (IT Pro B-BU), IT / Software / Systems, Seattle, Washington

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

Cognos Senior Developer/Architect -Rahul
Description: Technical Skills -- 10 Years' experience in BI
Company: Nityo Infotech Corporation
Location: Seattle
Posted on: 07/21/2018

Teradata Developer
Description: Hi, If interested please email me on or give me a call at 904-425-1566 . Job Title Teradata Developer Work Location Bellevue, WA Relevant Experience Yrs 5 Years of experience (more...)
Company: Next Level Business Services, Inc.
Location: Bellevue
Posted on: 07/21/2018

Technical Lead
Description: Role name: Technical Lead Location: Seattle WA Duration: 8 Months Role
Company: FDS LLC
Location: Seattle
Posted on: 07/21/2018

Scrum master
Description: Title: Scrum Master Location: Seattle, WAQUALIFICATIONS/REQUIREMENTS ul li Help drive best practice use of the agile methodology as a core to the development life cycle. li Organize
Company: Prokarma, Inc.
Location: Seattle
Posted on: 07/21/2018

Oracle Database Integrator (ODI)
Description: Hi, Hope your doing well Role name : Oracle Database Integrator ODI Location: Seattle,WA Job Description: Bachelors Degree or equivalent work experience required- 4 years of prior professional experience (more...)
Company: Teamware Solutions
Location: Seattle
Posted on: 07/21/2018

Anderson Frank is looking for Netsuite Technical Consultant 95115 Per
Description: Netsuite Technical Consultant 95115 Per Hour - Anderson
Company: Anderson Frank
Location: Seattle
Posted on: 07/21/2018

Senior Front end developer (W2 only)
Description: Must Have: 1. 7y Front End Development 2. Node 3. Javascript 4. TypeScript 5. Jira 6. Git Job Description: Experience with front-end web development
Company: InfoObjects Inc
Location: Seattle
Posted on: 07/21/2018

Panasas System Administrator
Description: Job Title: System Administrator Panasas Location: Bellevue, WADuration: Long Term Contract Job Description:Experience in Panasas. Lead operational
Company: e-IT Professionals Corp.
Location: Bellevue
Posted on: 07/21/2018

Java Developer - Redmond
Description: Java Developer - cana H2RThis Position is with one
Company: Cana H2R
Location: Redmond
Posted on: 07/21/2018

Hot!! Software Engineer with C++ and Linux
Description: Job Title: Software EngineerLocation: Redmond, WAPosition: 12 months contractSkills: ul li Build software to facilitate routine operations
Company: Trinamix
Location: Redmond
Posted on: 07/21/2018

Log In or Create An Account


Forgot password?

Find us on Facebook

Find us on LinkedIn

Get the latest Washington jobs by following @recnetWA on Twitter!

Seattle RSS job feeds