SQL Data Developer

Collaborate Solutions Inc

Columbia, TN, United States

1 day ago

Apply on www.dice.com

Prepare application

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Working hours

Regular working hours

Job source

www.dice.com

Tech stack

Cloud Computing Data Architecture Data Governance Data Integration Extract Transform Load (ETL) Data Systems Data Vault Modeling Data Warehousing Database Development Database Storage Structures PRINCE2 Scrum Methodology

+7 more

Standard Sql SQL Stored Procedures SQL Server Integration Services Data Streaming Talend Informatica Powercenter Data Management

Job description

Develop and support efficient and reliable processes to extract, transform, clean, and move data from a variety of sources into a data warehouse or data extracts using ETL Tools (SSIS, Data Migrator, etc.) and/or stored procedures
Support the operation of the Data Warehouse during business hours and as part of an on-call rotation as needed.
Work in tandem with business and IT subject matter experts to define data extracts as well as process scheduling and issue resolution
Develop solutions which adhere to development, architecture standards, and best practices as set by the Data Architect and Data Governance committee.
Optimize database structures and SQL code for maximum performance and reliability
Document new applications, review and update existing documentation related to data processes and structures
Provide back-end support and data integration development assistance to other teams and application developers
Operationalize prototype data solutions developed by other team members or data analysts
Perform peer review and occasional QA support for solutions developed by other associates within the Data Management group or other functional areas
Investigate and document current data flow processes between corporate systems, business partners, and downstream data consumers
Participate in the design and development of target-state analytics ecosystem using traditional and big data tools, as well as a mix of on-premises and cloud infrastructure
Other duties assigned by management

Requirements

Experience developing high-performing data flows, adhering to established best-practices
Experience in SQL development - creating complex queries, views, and stored procedures
Experience interfacing with business stakeholders to understand data and analytics needs and deliver solutions
Understanding of relational and dimensional data structures
Experience with ETL tools such as SSIS, Informatica, Talend, Data Migrator is preferred
Experience in data warehousing patterns such as Kimball, Inman, Data Vault is preferred
Experience in Agile Scrum and / or Kanban project management frameworks is preferred
Knowledge of applicable data privacy practices and laws is preferred