Position: Senior Data Engineer
Company: N-iX
Category: Data Engineer
Experience required: 3y
English level: intermediate

We build technology platforms and data solutions that enable our customers to manage pharmacy benefits on behalf of their members, employees, or clients (e.g. health plans, employers, health systems, etc.). We also provide prescription benefit solutions directly to millions of people through our consumer brand. We have saved our customers over $4B on prescription medications since 2015.

Responsibilities:
- Analyze and interpret complex data sets. Ability to identify data anomalies and resolve data issues
- Understand specific business processes and domain concepts and relate them to data subject domains
- Collaborate with Data Leads, Data Analysts, and QA analysts to validate requirements, participate in user requirement sessions
- Perform tests and validate data flows and prepare ETL processes according to business requirements
- Perform ETL tuning and SQL tuning
- Ability to document data flows representing business logic in ETL routines
- Design and implement data conversion strategy from legacy to new platforms
- Perform design validation, reconciliation, and error handling in data load processes
- Design and prepare technical specifications and guidelines including ER diagrams and related documents

Requirements:
- 5+ years working in ETL/Data transformation projects with one or more related products such as Informatica and Microsoft SSIS
- 4+ years working in business intelligence, data warehousing initiatives
- 1+ years working with Matillion ELT tool and Snowflake Database
- Knowledge of AWS Infrastructure including S3, SNS, Ec2, CloudWatch, and RDS
- Well-versed with Data warehousing concepts including design patterns (Star schemas, Snowflake design schemas). Be aware of data modeling concepts including the data modeling Normal forms
- Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases
- Experience in building AWS Data Pipelines using Python/Scala, Apache Spark, SparkSQL, S3 Data Lake, Snowflake, Redshift
- Good to have - Experience with any of the NoSQL data stores such as ElasticSearch, MongoDB, DynamoDB, Cassandra
- English level Upper-intermediate or above

We offer:
- Flexible working format - remote, office-based or flexible
- A competitive salary and good compensation package
- Flexible and personalized career growth
- Professional development tools (mentorship program, tech talks and training, centers of excellence, and more)
- Active tech communities with regular knowledge sharing
- Education reimbursement
- Paid vacation days, sick leaves, and days off
- Healthcare & Sport program
- Medical insurance
- Memorable anniversary presents
- Corporate events and team buildings