Sign in

Sr Data Warehouse Developer - BI / ETL - CONTRACT

Company:
Katrine Recruiting Services
Location:
Superior, Colorado, United States
Salary:
Open DOE
Posted:
December 04, 2018

Description:

Title Sr Data Warehouse Developer - BI / ETL

Position Type Contract/Temp

Industry IT - All

Start Date Early January

Target Hourly Rate DOE/hour

Location Superior, CO United States

Relocation Assistance N/A

Degree preferred

Years Experience 5

Job Description Key components for a successful candidates will be:

- Enterprise Data Warehouse / EDW

- ETL

- SSIS (SSAS, SSRS) or Informatica

- TSQL or PL/SQL

* Large Data background will be helpful with experience in performance tuning, load balancing, partition management, indexing strategies

* Cube development and maintenance

* Experience in a complex high-transaction environment

* Ability to work across multiple lines of business

* Work will be done primarily in the Microsoft Stack.

***Pluses would be Alteryx, Tableau, C++, Java

Job Responsibilities

• Data Warehouse development

• Work with the database administration, infrastructure, and security teams to develop architectures allowing for scalability and performance of the EDW platform.

• Responsible for creation of complex data sets within an Enterprise Data Warehouse to meet growing customer demand.

• Create complex data models – logical and physical - that meet demanding business requirements is a key responsibility.

• Responsible for translating functional requirements into technical requirements and solutions.

• Execute and document Quality Assurance processes by developing use cases, test plans and test scripts, coordinating testing activities, documenting results, and driving issue resolution throughout the testing process.

Must Haves Requirements:

• Experience in a complex Data Warehousing Environment building data warehouses and/or data marts

• Database dimensional modeling and development

• Strong understanding of data warehousing concepts & technologies such as data marts, star schemas, facts and dimensions

• 3 or more years data modeling within an EDW environment

• Experience translating complex functional requirements into technical solutions

• Experience with Microsoft database technologies, including MS SQL Server 2012/2008 – SQL Server 2016 a plus

• 7 or more years experience with SQL Server Integration Services, or related ETL tools

• Extensive knowledge of star schema data warehousing concepts and methodologies

• Ability to tune complex SQL queries for maximum performance

• Intimate understanding of cube development – multidimensional and tabular

• Skilled in writing SQL queries, functions, and stored procedures; leveraging transactional databases, relational data marts and data warehouses