Sr. Data Engineering Analyst will be responsible for expanding and optimizing our data and data pipeline architecture, as well as optimizing data flow and collection for cross functional teams. The Sr. Data Engineering Analyst is gaining experience by building data pipeline and standardized processes. They enjoy optimizing data systems and building them from the ground up. The Sr. Associate Data Engineer will support data analysts and data scientists on data initiatives and will ensure optimal data delivery architecture is consistent throughout ongoing projects.

• Deliver quality work on defined tasks with infrequent oversight and on undefined tasks with frequent oversight from senior level data engineer.
• Implementing and maintaining relational and columnare databases like BigQuery, Redshift, and Azure. Responsibilities could include database clustering, partitioning, etc.
• Implementation of tables, indexes, stored procedures, functions, or ad-hoc query support.
• Implementation of other data related activities such as standardized automated ETL processes, reports, dashboards, models, etc.
• Provide status updates to team members on a regular basis and clearly escalate issues and risks to project management as needed.
• Serve as technical resource during software development life cycle to solve business issues through the process of identifying and analyzing detailed requirements that translate into system designs.
• Ability to estimate own work when provided with sufficient task definition.
• Focus daily on best practices to ensure a quality deliverable.
• Troubleshoot, diagnose and quickly respond to database and application issues minimizing disruption to services and escalate to third parties vendors for support as needed.
• Proactively monitor and report on database performance and capacity and provide trend analysis for all environments

Key Differentiators

• Understands Razorfish data capabilities and how data fits into a client's overall strategy
• Understands the breadth of data services and crafts
• Able to manage data team responsibilities within cross-capability projects
• Understanding of SQL
• Understanding of Python coding best practices.
• Architect Data Structures
• Understand Cloud Platforms (AWS, GCP, Azure)
• Mentor Associate Data Engineers

• Experienced database administrator/developer role, preferably in a professional services environment.
• Experience working with or general knowledge of RDBMS (DB2, Oracle, MySQL, SQL Server, etc).
• Experience working with or general knowledge of Big Data or NoSQL database system (DynamoDB, MongoDB, Redshift, BigQuery, Azureetc) a plus.
• Understanding of cloud infrastructure services like Amazon Web Services and Google Cloud Platform a plus.
• Experience working with data modeling and normalization concepts.
• Experience or Knowledge of different query languages (i.e. PL-SQL, T-SQL).
• Knowledge and experience with ETL toolsets (i.e. SSIS, Talend, etc.)
• Knowledge and experience writing ETL processes.
• Understanding of application programming and interactions with database technologies.
• Ability to estimate level of effort for tasks.
• Ability to learn new languages, tools, and techniques as needed to meet project requirements.
• Ability to work collaboratively in teams with other individuals.
  Able to work in a fast-paced, technical environment.
• Good verbal and written communication skills.
• Attention to detail and quality.
• Excellent problem solving skills