SQL Experience a must Including reading, writing, and troubleshooting stored procedures for ETL and data processing Using SQL with JSON and XML Data format management
Proficiency in Data modeling, building data warehouses, marts and databases
Experience building reports and dashboards by consolidating data from multiple data sources
Hands on experience in the Business Intelligence technologies like Looker and Power BI
Experienced at scripting in LookML and or writing DAX queries and expressions
At least 3 years of experience in development of data solutions for client end user Experience with large volume datasets Big Data, and implementing performance optimization techniques in reporting and presenting data
Understanding of Embedded analytics, iFrames, and parsing data via API's
Worked with Product team to identify and scope requirement for development
Create Technical specification and document development flow and metadata of reports and dashboard
Created dynamic data models acrossvarious data entities using LookML or with Power BI Develop new explores, views, Native Derived Tables NDT to be utilized by dashboards
Perform extensive unit testing on both codes and content created in Looker or Power BI using SQL Runner, Snowflake or Big Query SQL, Power BI DAX queries and Looker content validator Fix code and User Interface defects identified during Product Owner Revieaw, Quality Analysis and User Acceptance Testing Move developed content between multiple tenets using CI CD Pipelines.
Interface with external teams to understand and document reporting needs and move development work as quickly as possible.Participated in digital solutions Planning events and sessions to incrementally lay out roadmap and sequence of work.