Data Analytics Architect

Location Seattle, WA (Remote till COVID) Duration 12+ Months contrac Note Pre-sales exp is required. Job Description for Data Architect Architect with Azure and Power BI should have overall 12+ years of experience and a blend of business intelligence and data engineering experience and should be comfortable working with large-scale unstructured data from numerous data sources. Although fluent SQL is a strong requirement, being able to work with scripting and other tools is desirable. Mandatory Skills Experience in implementing Azure platform services like Azure SQL, Azure Service Bus, HD Insight, Azure Data Lake Storage, Azure Data Lake Analytics, Stream Analytics, Azure Data Factory, Synapse, CosmosDB, Azure Analysis Services, Power BI Services Experience in VisioErwin or any other tool, SQL Server, Oracle, SSAS, SSIS Documentation of source-to-target mappings, data dictionaries, and database design. Identify areas of improvement to optimize data flows. Architect and develop data models, ETL packages, OLAP cubes, and reports utilizing Power BI applying best practices to the development lifecycle. Experience on data analysis and converting functional requirements to technical Proficient on writing queries and converting business requirements into visualization Should be strong with SQL and Exploratory Data Analytics with python Pyspark Proficiency with big data and cloud technologies like Hadoop ecosystem, Spark, Scala etc Design, Performance Tuning, Monitoring of Reports and Dashboards that make complex data readily consumable Creating data pipelines that automate the flow and transformation of data between key systems Debugging and optimizing performance of queries, reports, dashboards, and data pipelines Designing, building, running, and analyzing customer segments, and personalized experiences Analyzing web traffic and usage data to identify trends and hypothesis for experimentation and personalization projects Using real-time web analytics for monitoring results and optimizing testing outcomes Advising and educating internal customers on experimentation and personalization best practices Managing expectations appropriately and keep projects on schedule and within scope Delivery, Customer Relationship Building, Quality of Deliverables in onshore offshore model Pre-sales experience Additional Responsibilities Integration of Power BI dashboards with webapps, POWERAPPS, POWER Automate Power Virtual Agents As part of the BI team, responsible in implementing the BI Strategy. Should be aware of the best in the practice of the visual effects and the latest trends in BI Analytics. Good to have excellent development skills, extensive hands-on development, coding Great communication skills and the ability to communicate inherently complicated technical concepts to non-technical stakeholders.