Business Intelligence Engineer
Remote
Using my existing BI - and other IT roles - experience to architect, design, build, and test a greenfield BI solution for a cloud-based healthcare-legal application in the AWS environment - in my first AWS engagement.By leveraging AWS documentation, self-paced training, and my previous knowledge I performed the roles of:BI architect to design a solution that connects to all data sources in the application environment - both structured and unstructured - to create a data catalog; uses crawlers to keep the data catalog schemas updated, a data warehouse cube for structured data; natural language querying for unstructured data; aggregations, calculations, parameters, and filters for visualizations, and embeddable dashboards for existing and future app inclusion.Network engineer to connect AWS Glue, RDS, OpenSearch, S3, RedShift Serverless, Athena, and QuickSight through an already existing VPC by creating and configuring IAM roles, EC2 security groups, and ingress/egress rules.Systems engineer to install/configure each of the above-mentioned AWS services, and standardize/automate their deployment across environments and regions through the use of AWS Cloud Formation Service.Security engineer to securely configure the above services in a best-practices and HIPAA compliant way, and recommend HIPAA compliant RBAC and other security configurations to the app development teams.BI engineer to design and build the ETL jobs, aggregations, calculations, filters, visualizations, and dashboards needed - via QuickSight and Power BI - to securely deliver the right actionable information to the right user(s) at the right time.All while navigating a complex, multi-vendor, multi-team engagement structure and becoming a resource to multiple teams across that structure.