Senior Data Developer

Company: SPECTRUM
Location: Stamford
Posted on: June 22, 2022

Job Description:

JOB SUMMARYThe Senior Data Developer is responsible for working across multiple disparate data sets to create quality leads that improve marketing and sales. Understand underlying business and data rules that create our campaign universe.
Work with marketing and sales partners to provide counts and articulate data variances.
Think of data in a creative way to solve marketing and sales issues.

Responsible for data engineering functions including, but not limited to: data extract, transformation, loading, integration in support of enterprise data infrastructures, data warehouse, operational data stores and master data management. Involved in reviewing and creating innovative solutions. Subject matter expert for a single program/system. Diagnose moderate to complex issues.

MAJOR DUTIES AND RESPONSIBILITIES
Actively and consistently supports all efforts to simplify and enhance the customer experience.

Leads the implementation of data services and data movement infrastructures.

Audit implementation of data structures/models and data movement infrastructures.

Leads the implementation programming concepts such as data structures, error handling, data manipulation and I/O processing.

Provide preventative solution and troubleshoot data job failures, including but not limited to error handling, data manipulation and I/O processing.

Leads the implementation of database concepts and practices including definition and query language.

Develop, modify, enhance, and implement requirements and architecture specifications of data warehousing systems and/or processing infrastructure.

Partner with the Insights team to design, implement, and support end-to-end data solutions across multiple platforms, environments, domains, and locations.

Develop ETL processes, programs and solutions as per established standards.

Monitor and administer automated and manual data integration and ETL jobs to verify execution and measure performance.

Lead internal staff, vendors, consultants, and external partners to quickly identify and resolve data integration and ETL job issues.

Assist stakeholders in defining requirements for data capture that answer business questions and outcomes.
Coordinate with development teams to implement data capture requirements.

REQUIRED QUALIFICATIONS
Skills/Abilities and Knowledge
Ability to read, write, speak and understand English.
Experience with building use cases and providing development support to data scientists.
Experience with building use cases and providing development support to data engineers.
Experience with data lake - all data sources - building out data sets for uses cases.
Experience with building SQL/HIVE databases and tables.
Experience with querying and designing efficient warehousing structures.
Knowledge of data access methods from relational databases using SQL.
Knowledge of and hands on with web services (WSDL Soap, Restful) to access data from various source systems.
Knowledge of FTP/sFTP.
Excellent written and verbal communication skills.
Excellent analytical and troubleshooting abilities.

PREFERRED QUALIFICATION.S
Education
Bachelor's degree or equivalent experience

Related Work Experience
5 years - ETL experience
5 years - Experience with SQL, Shell Script, Python, JSON
2 years - Data integration experience
2 years - Data visualization experience (Tableau, Alterx, Microstrategy)
2 years - Software engineering experience

WORKING CONDITIONS
Office environment - work in Stamford CT office daily. MPD392 312935 312935BR

Keywords: SPECTRUM, Stamford , Senior Data Developer, IT / Software / Systems , Stamford, Connecticut