Responsibilities
- Architecting, designing, and implementing sustainable and scalable solutions
- Building pipelines to feed downstream data
- Analyzing data, interpreting business requirements, and establishing relationships between data sets
- Familiarity with different encoding formats and file layouts such as JSON and XML
- Onboarding new clients onto the ZMP/CDP+
- Solidifying business requirements
- Performing ETL file validation
- Establishing users
- Performing complex aggregations
- Syndicating data across platforms
- Taking a test-driven approach towards development
- Documenting processes and workflows
- Analyzing change requests and determining the best approach towards implementation and execution
- Implementing and testing change requests in a development environment to ensure no negative impact on downstream processes
- Adhering to change data management procedures
- Actively participating in CAB meetings where change requests are presented
- Ensuring processes are running in a development environment prior to introducing change
- Performing peer-to-peer code reviews and solution reviews before production code deployment
- Participating in knowledge share sessions
- Engaging with peers to discuss solutions, best practices, and overall approach
- Looking for opportunities to streamline processes with an eye towards building a repeatable model to reduce implementation duration
Requirements
- Relational data modeling
- ETL and FTP concepts
- Advanced Analytics using SQL Functions
- Cloud technologies - AWS, Snowflake
- Able to decipher requirements, provide recommendations, and implement solutions within predefined
- The ability to work independently, but at the same time, the individual will be called upon to contribute in a team setting
- The engineer will be able to confidently communicate status, raise exceptions, and voice concerns to their direct manager
- Participate in internal client project status meetings with the Solution/Delivery management
- When required, collaborate with the Business Solutions Analyst (BSA) to solidify
- Ability to work in a fast paced, agile environment; the individual will be able to work with a sense of urgency when escalated issues arise
- Strong communication and interpersonal skills, ability to multitask and prioritize workload based on client demand
- Familiarity with Jira for workflow, and time allocation
- Familiarity with Scrum framework, backlog, planning, sprints, story points, retrospectives
- ETL – ETL tools such as - Talend (Preferred, not required)
- Database - Hands on experience with the following database Technologies - Snowflake (Required)
- Programming Languages – Can demonstrate knowledge of any of the - PLSQL
- AWS – Knowledge of the following AWS services: - S3
- AWS – Knowledge of the following AWS services: - EMR (Concepts)
- AWS – Knowledge of the following AWS services: - EC2 (Concepts)
- AWS – Knowledge of the following AWS services: - Systems Manager / Parameter Store
- Understands JSON Data structures, key value
- Working knowledge of Code Repositories such as GIT, Win CVS
- Workflow management tools such as Apache Airflow, Kafka, Automic/Appworx
- Jira
Nice to Have
- ETL – ETL tools such as - DMExpress – Nice to have
- ETL – ETL tools such as - Informatica – Nice to have
- Database - MYSQL/PostgreSQL – Nice to have
- Database - Familiar with NOSQL DB methodologies (Nice to have)
- Programming Languages – Can demonstrate knowledge of any of the - JavaScript Strong Plus
- Programming Languages – Can demonstrate knowledge of any of the - Python - Strong Plus
- Programming Languages – Can demonstrate knowledge of any of the - Scala - Nice to have
Work Arrangement
Remote (Worldwide) — US, India, Costa Rica
Additional Information
- Familiarity with Jira for workflow and time allocation
- Familiarity with Scrum framework, backlog, planning, sprints, story points, retrospectives
