About the Company:
Founded in 2012, IXIS is rooted in innovative processes for data-driven digital experience and strategic online planning. Our mission is to integrate and synchronize traditional and digital marketing initiatives to recalibrate and connect brands across converging media.
*
Overview*:
IXIS is seeking an energetic individual with experience in AWS data warehousing to join our team in developing cutting-edge, custom analytics and dashboarding solutions. The ideal candidate will be a systematic thinker with a solid foundation in software engineering and will also possess the data IQ, curiosity, and attention to detail needed when working with disparate enterprise-scale data systems. The core responsibilities for this role include designing and implementing modern data ingest and warehousing solutions (on-prem and AWS), maintaining legacy data infrastructure, overseeing specifications for new data integrations, and conducting ETL processing and data QA/QC in an event-oriented system.
This is a full-time, remote or onsite position in our Burlington, Vermont office. We offer competitive compensation packages including health, dental, short-term and long-term disability and vision insurance, 401(k) with company match, flexible work schedules, and exceptional growth opportunities.
*
Responsibilities*:
- Build enterprise-grade batch and real-time data processing pipelines leveraging the AWS cloud platform, with an emphasis on serverless architectures
- Work with the Data Science and Development teams to design, implement, and facilitate data ingest, extraction, and integration across multiple programming languages (primarily R, Python, and node.js) directly and via REST and GraphQL APIs
- Work with our Data Science and Development teams to facilitate automated data analysis, reporting, and dashboarding solutions in support of client deliverables and licensed SaaS products
- Design and implement automated acceptance and reliability tests based on business requirements and company standards
- Design robust, appropriately normalized schemas for warehousing a wide variety of datasets and determine when SQL vs. NoSQL solutions are preferred
- Collaborate with technical, development, QA, and operational resources
- Leverage traditional and container orchestration technologies to operate data systems
- Leverage shell scripting and Linux system operation skills to assist in the maintenance of and migration from legacy systems
Required Education and Skills:
- B.A./B.S. in Computer Science, Software Engineering, or related area; formal training in statistics/mathematics/machine learning a plus
- 1-3 years’ professional experience building resilient, scalable, and performant data warehousing solutions using AWS; CI/CD experience a plus
- 1-3 years’ real-world experience with ETL workflows and SQL
- Intermediate or better skills with one or more high-level/scripting programming languages
- Intermediate to advanced shell scripting skills
- Proficient in Linux system operation
- Advanced relational database design skills
- Advanced Excel skills
- Experience working with data “in the wild”
- Experience with record linkage, consolidation and householding in relational databases
- Core critical thinking skills, including good data intuition
- Experience multitasking and prioritizing data initiatives with minimal guidance and instruction at times
Additional Desired Skills:
- Experience with statistical programming, ideally in R or Python
- Experience with Docker containerization and orchestration
- Experience developing and working with APIs for data transfer
- Development experience in a Linux or Mac environment
Job Type: Full-time