Reporting Engineer opportunity (100 remote considered) to work with a Digital healthcare company

Reporting Engineer Full-Time opportunityOffice located in San Francisco, CA,(100% remote considered) The RoleThe Reporting Engineer will be responsible for providing timely reporting, performance monitoring and insights to our Clinical Operation Team, Executive Teams, and other key business stakeholders. You will work in close collaboration with technical stakeholders to enhance data lake and contribute the the reporting layer. In this position, you will support, maintain, and develop software using a variety of different tools, including AWS stacks, Python, Pandas and Pyspark.Responsibilities

• Model new data and maintain existing modeled data, and be able to provide feedback on these data models or data collection enhancements needed for accurate and timely reporting
• Extract, transform and load new data and create pipelines as new data sources need to be ingested
• Operate over structured and unstructured data from various sources such as DynamoDB, S3 and Postgres

• Ability to deal with ambiguity and competing objectives in a fast paced environment.
• Experience working with SQL and relational data; design data models and schemas for databases and solid skill writing queries
• Experience identifying and debugging data problems and anomalies, driving cleaner data for reporting layers; writing code in Python or SQL to explore and solve data problems where necessary
• Practical experience in creating reporting dashboard using a business intelligence application such as QuickSight, Looker, Tableau, or PowerBI; maintaining and troubleshooting existing dashboards
• Experience creating an automated ETL to process data using python, pyspark, SQL
• Experience with AWS stacks

• A team player who can also work independently.
• Problem solver
• Good communication skills
• Comfortable with frequent priority changes

• Experience processing EHR and healthcare data
• Experience in AWS EMR, Glue, Athena
• Experience with shell scripting
• Experience with GIT source control