Home > Fort Lauderdale jobs > Fort Lauderdale computer/technical

Posted: Thursday, February 1, 2018 10:54 PM

Job Description
SUMMARY/OBJECTIVE The Data Integration Developer role is to design, plan and develop the internal Data Warehouse solution. This role is responsible to lead the ETL development, design and creation of procedures to acquire, harmonize, and consolidate various data assets from multiple sources into a centralized data warehouse. Work effectively with the technology team and external contractors to establish requirements and meet project deadlines as we upgrade to more efficient data structures to empower all business intelligence and reporting platforms.
ESSENTIAL JOB FUNCTIONS Design, develop and lead data warehouse Extraction, Transformation and Loading (ETL) solutions residing in Amazon Web Services infrastructure utilizing Amazon RedShift, mySQL, and NoSQL databases Design, develop and implement data collection processes in conjunction with the data warehouse. Source data from external legacy systems supporting a centralized data warehouse and reporting platform Create high throughput historical and incremental ETL jobs. Enhance existing business intelligence data processes and reporting platforms Collaborate and contribute to data integration strategies and visions Enforce standards on data modeling, data profiling, database design and metadata management Ensure that all deliverables are thoroughly documented for the Data Warehouse and ETL processes Report to the Business Information Manager In conjunction with data owners and business units, develop models, procedures, and protocols for business intelligence in alignment with company goals.
OPERATIONAL JOB RESPONSIBILITIES Interact with IT contractors and vendors, as well as internal IT leaders related to data warehouse requirements, solutions and deliverables on a regular basis Ensure work/tasks assigned are completed on budget and with defined timeframes Support the data warehouse infrastructure for the organization Communicating and collaborating with the technology teams ESSENTIAL SKILLS Ability to design and implement effective ETL solutions for data warehousing Strong understanding of business concepts and IT methodology High energy, flexible, innovative and the ability to manage responsibilities and priorities in a fast:paced and time:critical environment May be required to work early morning, evening or even weekend shifts May be required to work in a mobile capacity
EDUCATION/EXPERIENCE Proficient in ETL/Database Schema design concepts and implementations Knowledge of multiple data interfacing methods for a variety of data sources and their best use cases Experience interfacing with disparate data sources into non:SQL Server data stores (MySQL, Amazon RedShift, Dynamo DB) Understanding of API calls and coding data interfaces between external systems into AWS databases Working knowledge of Linux operating systems and Amazon Web Services (AWS) is a plus Experience with bash scripting and/or Python programming is a plus Bachelors Degree in
Engineering/Computer related discipline, or equivalent experience required 5+ years experience with data warehouse design and implementation 5+ years experience with T:SQL, scripting languages and/or ETL tools, and coding ETL interfaces 5+ years experience in logical, rational, dimensional, and physical data modeling Working knowledge of the software development lifecycle, deployment, and maintenance Ability to efficiently manage multiple work streams and analyses Experience cleaning and validating data
Company Description
TekPartners has been a trusted and proven technology solutions firm for 15 years. As an information technology partner we offer our clients proven talent through professional staffing, managed services, and IT project solutions. We understand and value the unique needs of the industry and always strive to stay above the curve. The company was founded on the following core values: Be the Best, Understand the Urgency, Never Ever Give Up, Have the Courage to Excel, and Make


• Location: Ft Lauderdale

• Post ID: 78527982 ftlauderdale is an interactive computer service that enables access by multiple users and should not be treated as the publisher or speaker of any information provided by another information content provider. © 2018