Senior Data Analytics Engineer
CurrentHired to be a liaison between data engineering and business intelligence to provide data solutions to internal stakeholders and customers. Work closely with Customer Service, Finance, Product and Engineering teams to deliver data assets and Dashboards for actionable insights.Notable Contributions:• Design, develop and maintain data warehouse and analytics architecture.• Create reports using Power BI and Tableau as well as develop underlying T-SQL logic.• Migrated reports to new data warehouse and created separate reports by instance/service providers maintaining data security.• Build complex SQL queries on large datasets and performance tune as needed.• Maintain ETL packages and supporting data objects for the growing BI infrastructure.• Communicate clearly and effectively with stakeholders providing a better understanding of key factors in Business and Analytics.• Drive increased efficiency across the teams, eliminating duplication, leveraging product and technology reuse.• Work on core data structures and algorithms and implement them using technology chosen.• Conduct data quality profiling analysis, recommend data quality rules and processes.• Lead and provided knowledge transfer to peers on standards of the company and specifics on each report.• Develop dashboards and reports that maximize use of stakeholder time and effort by providing high-value information quickly and easily.• Created standard views in SQL that can be leveraged by multiple reports reducing refresh times and decreasing server overload.• Created a standardized report that lets the stakeholders view metrics of app adoption helping them to work on factors that could most effectively drive an increase.• Solely responsible for month-end finance operational tasks that provides KPIs for ELT.