ShiftCode Analytics, Inc. is seeking a Data Engineer III to join their Data & Analytics team. The role involves building data platforms and pipelines to solve complex problems in the healthcare industry, using strong SQL skills and Python scripting.
Responsibilities:
- 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
Requirements:
- Bachelor's degree in computer science, computer engineering, or similar area
- Five-ten (5-10) years' experience in data integration, design and management
- Knowledge of software development life cycle, relational database theory, and skills to utilize one or more programming languages
- Strong SQL skills in a Snowflake Data Warehouse platform
- Strong Python scripting
- Healthcare experience, including knowledge of claims and providers
- Strong hands-on experience with Java
- Strong experience with sourcing data from JSON, BSON, XML, AVRO, YAML etc
- Ability to build custom APIs using JAVA or JAVA based technologies like Mulesoft
- Strong experience working with relational databases, star schemas etc
- Strong experience with ETL/ELT tools like Wherescape, Informatica, Datastage etc
- Strong SQL experience
- Experience working with SPARK, SCALA and NoSQL, Hadoop, Teradata, Netezza
- Familiarity with healthcare specific regulatory requirements for data management
- Ability to lead and participate in analytic projects
- Demonstrate advanced analytical and problem-solving skills
- Advanced data processing programming skills across SQL-based and Hadoop-based technologies
- Strong understanding of web services
- Excellent 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