Job Location : Florham Park,NJ, USA
The Sr Analytics DW Developer reflects the mission, vision, and values of Client, adheres to the organization's Code of Ethics and Corporate Compliance Program, and complies with all relevant policies, procedures, guidelines and all other regulatory and accreditation standards. Looking for a data driven, business-minded; results oriented Sr Analytics Developer to join our team. The Sr Analytics Developer uncovers insights that drive strategy and optimal decision making for the executive team and leaders across the organization. In this role, you will be charged with understanding the 'who, what, and whys' of our business - working cross-functionally to realize the value of client data assets. To succeed in this role, you must be innately curious, deeply analytical, highly driven, and a strong communicator. Some of those qualities include but are not limited to: Be a Data Champion! Effective analysis is only possible with good data - be an advocate of data accessibility, accuracy and quality. Be Curious! Find data nuggets, trends and other analytical goodies that help support our mission, vision, and values and advance our department as a whole. Be a Team Player! Collaboration is what makes us great - come prepared to work with a diverse cross-section of technical and business professionals. The Sr Analytics DW Developer should have hands on ELT into Redshift. Setup and implement Redshift. Strong Experience in implementation using Redshift; should have worked on various projects to store data from on premise databases to Redshift, RDS and S3 Experience in migration of Data from Excel, Flat file etc. Experience and knowledge in various data interchange and representation formats such as JSON, HL7, and FHIR etc. Will also be responsible to build Dev Ops data pipelines data warehouse and analytic solutions by writing packages, developing visualizations, performing data and statistical analyses, and administering systems to deliver information to the health system. Serves as a functional and content expert of pipelines to synthesize raw data into actionable information. Applies knowledge of relational database skills including advanced SQL knowledge and the ability to create complex queries and stored procedures. Assists with the design and development of information delivery components including dashboards, reports, and cubes. Assists with database design and development including data analysis, source-target mapping, quality profiling, change data capture, program performance. Evaluates data quality and interprets results in a clear, concise manner. Develops documentation on requirements, decisions, design, modifications, and any associated maintenance. Owns analytics projects and is accountable for collaborating with the business to gather and execute on requirements, which exceed customer expectations. Works collaboratively with and supports multi-departments efforts and projects. Shares skills, experience, knowledge, and expertise with staff on analytic tools and solutions and serves as subject matter expert within the department. Participates and contributes to overall training development, maintenance, and facilitate trainings both internally and externally as needed. Performs other duties and functions as assigned. Qualifications Required: Bachelor's degree 7+ years of experience in a role querying and/or analyzing data Strong Experience in implementation using AWS Redshift; should have worked on various projects to store data from on premise databases to Redshift, RDS and S3 Experience in migration of Data from Excel, Flat file etc. Experience and knowledge in various data interchange and representation formats such as JSON, HL7, FHIR etc Strong knowledge of relational database skills including advanced SQL knowledge and the ability to create complex queries and stored procedures Independently work with business users to gather and scope requirements and recommend analytical solutions to meet business needs Experience sharing skills, experience, knowledge, and expertise with junior level staff on analytic tools and solutions and serve as subject matter expert within team and department Previous experience working in an Agile environment Experience with report writing and data visualization tools such as: Tableau, Qlikview, Qliksense, Thought spot, Crystal Reports, SSRS, Microsoft Power BI, etc. Experience in all areas of development including analysis, design, development and support with particular emphasis on structured programming Excellent verbal and written communication skills Ability to manage multiple-priorities Effective problem solving and critical thinking skills