Ssis/Etl /Power Bi Developer

WAITING TO VERIFY FULL JD FROM CLIENT & HOURLY RATE

(original description)

ETL/SSIS Developer

Currently seeking a SQL Developer with 5+ years’ experience extracting data from a variety of platforms, performing data mapping, data transformation, and loading data to the target system. The position requires strong system and process analysis, ETL (SSIS), and T-SQL skills. The SQL Developer will be responsible for building and maintaining a data warehouse, including all data modeling, ETL, and development.

Education

A bachelor’s degree in computer science, information technology, management information systems, or a related field.

Responsibilities

• Design database objects as necessary to meet ongoing business needs for reporting
• Tables, Views, Stored Procedures, Functions, Jobs, etc.
• Maintain and support existing stored procedures, functions, views, etc.
• Support Provider data repository functionality and cleanup effort
• Support QC data integration; query existing data to produce properly formatted text files based on design specs provided
• Document new ETL processes
• Design, build, test, and execute ETL packages (using SSIS)
• Automate ETL jobs for recurring imports
• Create data file extractions and scripts (using T-SQL) to perform data related imports and data related tasks
• Work with data owners to understand legacy data and gather data requirements from the business. Be able to produce detailed data mapping documents
• Perform data analysis and recommend data optimization/performance opportunities
• Development and implementation of Power BI
• Other duties assigned as needed

Qualifications:

• 5+ years of advanced experience using Microsoft SQL Server, SSAS, SSRS, SSIS, and TSQL languages. (SQL Server 2016 preferred)
• Experience with HTML, CSS & JavaScript
• Applicant must have a solid understanding of network and message processing technologies including HTTP, TCP/IP, TELNET, and Sockets
• Extensive experience developing queries, reports, and forms in database programs.
• Must demonstrate knowledge of ETL (Extract-Transform-Load) concepts
• Must have prior experience developing ETL programs using SSIS
• Experience retrieving data from various database platforms, web service APIs, flat files, etc.
• Data Modeling – understanding of normalization, transactional vs. reporting driven design, and data warehousing concepts
• Complex Query Design
• Stored Procedures, Views, Functions
• SSMS
• SQL Agent – Job creation, schedule creation
• SSIS – Design, develop, test and deploy packages
• Experience developing with Power BI a plus.

Experience:

• Microsoft SQL Server: 5 years (Required)
• Power BI: 2 years (Preferred)