Data Engineer

  • location: New York, NY
  • type: Permanent
  • salary: $80,000 - $115,000 per year
easy apply

job description

Data Engineer

job summary:




In this role, you will be responsible for data management and engineering in support of the Actuarial Informatics team of data scientists who deliver reporting, statistical modeling and advanced analytics for each of the diverse business areas. The role will also be supporting, enhancing an enriching the existing claims data warehouse for supporting the data scientist team with various projects and stakeholders.





 
 
location: New York, New York
job type: Permanent
salary: $80,000 - 115,000 per year
work hours: 8 to 5
education: Masters
 
responsibilities:




Effectively collaborate and communicate with your stakeholders and customers to understand their needs and ensure all data management requests are properly triaged, recorded and tracked.

· Work with enrollment, eligibility, medical claims, pharmacy claims, utilization, clinical, medical management, financial, administrative and other corporate or third party data from raw, modeled and disparate internal and external sources.

o Work with departmental staff to identify business requirements for data intake, reporting and / or business intelligence tools.

o Ensure all data intake leverages approved enterprise methods for data exchange and transfer, including setup and utilization of secure FTP.

o Identify necessary data, data sources and methodologies to meet the business need.

o Work with IT or independently to collect, organize, integrate, profile and curate data, in both our Oracle RDMS or new Big Data platform Microsoft Azure Hadoop.

o Identify and address expected and unforeseen data complexities to mitigate their impact on the analytic outcome and associated business decisions. Clearly communicate data issues to the recipients and work to improve data quality where possible within the data marts you create.

o Feed data quality issues back to IT or identified data stewards (inside and outside the team) to assist in our quest for the highest quality data.

o Assist in building reports or dashboards that profile or express the quality of data to your stakeholders.

· Design and build complex Extract, Transform & Load (ETL) routines to ensure that data intake is consistently processed and integrated in accordance with approved business logic.

· Design and build data marts to specification to enhance efficiency of standard reporting and analyses being built by data science analysts.

· Execute production programs on daily, weekly, monthly and quarterly schedule for standardized reporting and other data processes that have been built by data science analysts.

· Adhere to corporate standards for performance metrics, data collection, data integrity, query design, and reporting format to ensure high quality, meaningful analytic output.

· Help identify and understand data from internal and external sources for competitive, scenario and performance analyses, and financial modeling to gain member/provider insight into new and existing processes and business opportunities.

· Work closely with IT on the ongoing improvement of client's integrated data warehouse, driven by strategic and business needs, and designed to ensure data and reporting consistency throughout the organization.

· Develop and maintain project work plans, including critical tasks, milestones, timelines, interdependencies and contingencies. Track and report progress. Keep stakeholders apprised of project status and implications for completion.







· Provide technical support to data analytics functions as they relate to varied business units, and technical expertise on the selection, development and implementation of various reporting and BI tools tied to business unit reporting requirements.

· Prepare clear, well-organized project-specific documentation, including, at a minimum, data dictionaries, analytic methods used, key decision points and caveats, with sufficient detail to support comprehension and replication.

· Ability to coordinate with offshore development resources on various requests and projects.

· Assist and teach others within the organization on how to define meaningful process and performance measures

· Share development and process knowledge with other staff to assure redundancy and continuously build a core of technical strength within the organization.

· Demonstrate proficiency with the principles and methodologies of process improvement. Apply these in the execution of responsibilities in support of a process focused approach.

· Perform other data management duties as necessary or assigned.





 
 
qualifications:
  • Minimum of BA/BS degree in a relevant field of study; Master's degree preferred.
  • At least four (4) years of data mart or data warehouse development experience for a health provider, health plan or accountable care organization including either:

    • Basic understanding of health care EMR or claims systems such as Epic/Clarity, eCW, Facets, Amisys, or similar systems.
    • Knowledge of New York State Medicaid and CMS Medicare regulations and related reporting requirements such as STARS, QARR, MMCOR, MEDS, RAPS and HEDIS.
    • Experience working in healthcare provider analytics related to revenue modeling, managed care contracting, population management, case management, clinical or financial decision support,
    • PhD, MD or DO program may be substituted for 3 years of experience
  • Strong technical skills working with SQL (Oracle's PL/SQL preferred) developing and trouble-shooting stored procedures and developing adhoc scripts.
  • Strong data mining skills using tools like SQL, R, Python, SAS, Java/MapReduce, Aster, etc
  • Ability to learn Business Intelligence products such as Tableau, Information Builders, Dimensional Insights, SAP/Business Objects, SAS, MicroStrategy, etc.
  • Ability and passion to learn data acquisition, orchestration and provisioning techniques with rapidly evolving technologies like Sqoop, Flume, Impala, etc
  • General understanding of ETL tools like SSIS, Data Stage, PowerCenter, etc.
  • Ability to exercise critical thinking and logical reasoning, and understand the conceptual framework and database relationships underlying health care data.
  • Ability to think creatively; demonstrated excellent problem solving skills.
  • Excellent oral and writing skills characterized by the ability to communicate effectively with varying audiences.
  • Demonstrated ability to articulate goals, plan and implement processes to achieve those goals, recognize and assess the implications of confounding variables, anticipate consequences, and meet deadlines.
  • Advanced interpersonal (e.g., mediating, mentoring, teaching) skills required to service internal and external clients effectively, and manage relationships and activities that are diverse and complex.
  • Self-motivated and resourceful, with a demonstrated ability to think and work independently, and to exercise independent judgment in originating or developing complex techniques or programs in a complex and dynamic environment.
  • High level of integrity as demonstrated by 1) appropriate treatment of confidential or protected health information, 2) adherence to policies, procedures, rules, and regulations, 3) professional conduct in dealing with persons internal and external to the organization, and 4) sensitivity to populations served by the organization.
 
skills:
  • Strong data mining skills using tools like SQL, R, Python, SAS, Java/MapReduce, Aster, etc
  • Ability to learn Business Intelligence products such as Tableau, Information Builders, Dimensional Insights, SAP/Business Objects, SAS, MicroStrategy, etc.
  • Ability and passion to learn data acquisition, orchestration and provisioning techniques with rapidly evolving technologies like Sqoop, Flume, Impala, etc
  • General understanding of ETL tools like SSIS, Data Stage, PowerCenter, etc.

Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.

easy apply

get jobs in your inbox.

sign up
{{returnMsg}}

related jobs

    Data Analyst

  • location: New York, NY
  • job type: Contract
  • salary: $40 - $50 per hour
  • date posted: 1/14/2019

    Data Analyst

  • location: Teaneck, NJ
  • job type: Permanent
  • salary: $52,000 per year
  • date posted: 1/14/2019

    Business/Data Analyst

  • location: New York, NY
  • job type: Contract
  • salary: $25 - $30 per hour
  • date posted: 1/17/2019