Data Engineer : Premera Blue Cross

Interview : VideoVisa : All ( Must be genuine and should have excellent comm skills )Description :Location: Remote, PSTTop 3 skills: Strong SQL skills in a Snowflake Data Warehouse platform, strong Python scriptingIntake Call Notes:· The roles are open because a product they use to outsource the support on is being brought in house (individual market transition is the name of the product line).· Python, strong SQL, and Snowflake are the must haves. They'd love if candidates have exposure to Snowflake Context AI (or any AI), but it's not required.· It is also important to have healthcare experience. They should know what claims are, providers, etc.· Data Env: 400-500 TB's, but there are also smaller subsets they will work within. A majority of it is structured, some is semi structured (which is where JSON comes in).· They don't use Mulesoft anymore, its Azure function apps rewritten with Python· They can be anywhere as long as they will work PST.· Committed to feedback within 24 hours and looking to hire quickly.Job Description:Manager is looking for: Data Engineering with strong SQL experience in Snowflake Data Warehouse platform and knowledge in Python scripting.As a Data Engineer III for our Data & Analytics team, you will get the opportunity to work on a large variety of projects including building a state-of-the-art data platform and pipeline to tackle some of the most challenging problems in the industry and contribute to the vision of data infrastructure. You will work with a team that is passionate about changing the healthcare industry and love what they do. Lastly, you will build scalable services that help millions of people and help to change how they think about healthcare as a wholeWhat you will do:Solve business and data engineering problems using data-centric programming and scripting skills to create data models and pipelines.Consult with the business to create understanding of the needs, pace and direction for our business partners, translate these needs into requirements and specifications, and maintain contact with the customers through project completion.Lead all phases of architecture, conceptualization, design, development, testing, and production support of BI solutions.Architect, design, and build best-of-class production processes that ensure security, efficiency, and availability of analytic tools and data.Collaborate with data scientists and analyst to further understand business problems.Program and manage APIs for data exchange.Lead and conduct unit and system testing to ensure design is still relevant and implementation is producing a useful, maintainable, reliable product.Mentor and train other team members by introducing them to new technologies, methods and learning resources.Act as a resource to technical community as well as business partners.What you will bring:Bachelor's degree in computer science, computer engineering, or similar area (Required)Five-ten (5-10) years' experience in data integration, design and management. (Required)Additionally, they will have knowledge of software development life cycle, relational database theory, and skills to utilize one or more programming languages. (Required)Strong hands-on experience with Java (Preferred)Strong experience with sourcing data from JSON, BSON, XML, AVRO, YAML etc. (Preferred)Ability to build custom APIs using JAVA or JAVA based technologies like Mulesoft. (Preferred)Strong experience working with relational databases, star schemas etc. (Preferred)Strong experience with ETL/ELT tools like Wherescape, Informatica, Datastage etc. (Preferred)Strong SQL experience. (Preferred)Experience working with SPARK, SCALA and NoSQL, Hadoop, Teradata, Netezza. (Preferred)Familiarity with healthcare specific regulatory requirements for data management. (Preferred)Knowledge, Skills and Abilities:Ability to lead and participate in analytic projectsDemonstrate advanced analytical and problem-solving skills.Advanced data processing programming skills across SQL-based and Hadoop-based technologies.Strong understanding of web servicesExcellent problem definition, problem solving, and technical writing skills.Excellent written and verbal communication skills and ability to deal with management of various levels.Working knowledge of Agile and Scrum project methodologies utilizing Azure Devops, Confluence, Teams, etc.