Job Description

Position type: ETL Developer

Location: Mostly remote, in office 3 to 5 days per month at most Tampa, FL

Type: 6 mon CTH

Position Purpose:

Highly technical position that works closely with the entire data analytics team and data stakeholders to develop and mature JWB's enterprise level data warehouse and develop reports and interactive visualizations for decision makers.

Key Responsibilities:

• Develops and deploys data integration (ELT) jobs to migrate data from filesystems, external systems, data lake, and databases using SQL, Synapse , Python or other solutions.
• Develop and maintain tables, stored procedures and other data structures in the data warehouse.
• Create data models and data visualizations using Power BI
• Schedule execution of ETL jobs and delivery of automated reports using scheduling tools.
• Designs and develops reports and dashboards using Power BI.
• Implement interactive and dynamic visualizations.
• Make ETL modifications to support data requests in a timely accurate manner.
• Assist with data governance, quality and measurement through quality assurance testing and documentation.
• Gather and document report requirements for new and existing reports from business users.
• Create and maintain static and interactive maps, as the backup, utilizing JWB's advanced mapping software.
• Create documentation for technical and related business processes.
• Other duties as assigned.

Specifications:

• Bachelor's degree in computer science, Programming, or other technical or information technology areas or comparable experience with certifications
• A minimum of three years' experience working in database integration and development
• Strong SQL skills
• Experience with creating data visualization with Power BI
• Experience working with a Cloud data warehouse platform, preferably Microsoft Azure
• Experience with the use of Synapse for ELT processes
• Experience with scripting languages (Python, Shell Scripts, etc)
• Proficient in mapping visualizations
• Strong testing discipline
• Experience with code repositories
• Ability to write stored procedures and functions for SQL Server
• Ability to create and schedule SQL Agent jobs
• Proficient in Microsoft Office Suite
• Ability to create detailed documentation
• Strong written and verbal communication skills
• Excellent problem solving/analytical skills
• Ability to effectively interface with technical and nontechnical staff at all organizational levels.
• Ability to manage multiple projects at the same time in a fast-paced environment and learn new content areas or acquire skills quickly when required
• Display a professional attitude and work habits while working in teams and collaborating with others

Job Tags

Similar Jobs