Sr. Data Architect - PBI Developer

Company: Ekman Associates
Location: Newport Beach
Posted on: January 12, 2021

Job Description:

Ekman Associates, Inc. is a Southern California based company focused on the following services: Management Consulting, Professional Staffing Solutions, Executive Recruiting and Managed Services. Summary: The ideal candidate will be an experienced Lead Developer in the role of Solution Architects with excellent technical knowledge of Dynamics 365 Customer Engagement and rest of modules, Business Central, and related Microsoft cloud solutions and related technologies (e.g., Office 365, Power BI, etc.). Responsibilities: * Own, support and aggressively drive forward Azure DW and Power BI implementations. * Drive Azure cloud data platform architectural decisions and development standards. * Work with Product Owner/Business Analysts to understand functional requirements and interact with other cross-functional teams to architect, design, develop, test, and release features. * Develop and maintain documentation of schemas, data flows and processes related to Azure DW * Develop Proof-of-Concept projects to validate new architectures and solutions. Job Requirements:Qualifications:* 8+ years of Microsoft Dynamics Customer Engagement applications (CRM) product experience and processes along with experience in other MS Dynamics modules* The position requires a Bachelor Degree with 5+ years' experience in Information Technology or BI related fields with progressively increased levels of responsibility with SQL and data analysis/data modeling expertise including a strong understanding of data sources, relational and dimensional modeling, effective uses of business data (validity, timeliness, and benefit)* Azure Datawarehouse* Strong hands on experience in Azure data platform including Azure SQL, Azure Data Factory, Azure SQL Data Warehouse (Synapse Analytics), Azure Data Lake Storage. Knowledge in Azure Data bricks and Cosmos DB is a plus but not essential.* Monitor and create robust ETL processes specifically in the Azure DW using Azure data pipelines, Azure functions, SSIS, SQL, APIs, and industry best practices.* Mastery of SQL, specifically MS SQL Server 2012 and higher.* Troubleshoot ETL process as needed. Ability to identify bugs and apply fixes. Check data sanity and integrity by means of process audits.* Develop best practices and frameworks for unit, functional and integration tests around data pipelines.* Ability to analyze and understand data sources and design data models for capturing data and ETL.* Power BI* Strong knowledge in Power BI. Experience in Azure Analysis services is not essential but a plus.* Hands on experience in developing visual reports, dashboards and KPI scorecards using Power BI desktop and DAX queries* Sound knowledge in security standards. Able to implement row level security on data and understand application security layer models in Power BI.* Able to properly understand the business requirements and develop data models * accordingly by taking care of the resources.Qualified Candidates Only: If you wish to learn more about this opportunity and additional qualifications/responsibilities, please submit your resume. To learn more about Ekman Associates, Inc. please visit our website at www.ekmanassociates.com.

Keywords: Ekman Associates, Newport Beach , Sr. Data Architect - PBI Developer, Other , Newport Beach, California