Role: Enterprise architect / power bi architect
location: Downey CA (telework is allowed)
Note: need local to California or near by States.
Skills Required
The Senior Enterprise Architect will possess knowledge and technical expertise in standards and technologies to support complex business analysis, solution selection, systems design, and application integration.
Skills Preferred
Possess Knowledge and Technical Expertise in SQL Server and Oracle Database; T-SQL (Version 2014 & later): SQL queries development, store procedures, jobs; SQL Server Integration Services (SSIS); SQL Server Reporting Services (SSRS); Data warehouse (SQL Server/Oracle); Power BI Services, Power BI Dashboards, Reports, and Power BI Paginated Reports development and maintenance, Power BI Gateway Server Management, Power BI Row Level Security; Azure DevOps, Git/GitHub, Python; Azure Data Factory; Azure Databricks; Data pipeline design; development and support ASP.NET Web Forms and ASP.NET MVC; VB.Net, C#, Python, Control-M, and JSON programming skills; Agile Methodologies; Knowledge in Human Resource Domain; Debugging Skills; and have Interpersonal, oral and written communication, customer services, and problem solving skills with a teamwork attitude and aptitude.
Experience Required
This classification must have a minimum of seven (7) years of applying Enterprise Architecture principles. At least five (5) years of that experience must be in a lead capacity.
Experience Preferred
Minimum Eight (8) years of data engineering experience in IT application integration designing, developing, and maintaining database/BI applications with SQL Server and BI stack (Power BI, SSIS, SSAS, and SSRS). 5+ years of experience in PowerBI, Azure Environment from inception to support. Minimum Two (2) years of experience in the last six (6) years in designing and developing Applications using VB.Net, C#, and ASP.Net. Minimum Three (3) years of Data Warehouse experience in the last six (6) years with SQL Server and Oracle. Minimum Two (2) years of Human Resource Domain Knowledge in the last six (6) years designing and developing Data Models in Power BI/SQL Server Analysis (SSAS)/Databricks/Azure Synapse using DAX and MDX. Minimum Three (3) years of experience in the last six (6) in designing and developing Power BI Paginated reports using Power BI Report Builder. Minimum Three (3) years of experience in the last six (6) in implementing advanced Row-Level Security (RLS) and Object Level Security (OLS) to Power BI Dashboards and Report Builder reports. Minimum Four (4) years of experience within the last six (6) years in designing & developing SQL queries, debugging & tunning complex queries for optimal performance. Experience in designing and developing WebFocus BI Portals/Dashboards/Reports and Models. One (1) year of experience in the last six (6) years with Cognos programs, Report Studio, Query Studio, Active Reports, Workspace Advanced, Dashboards, Analysis Studio, Framework Manager, Cognos Connection. Minimum one (1) year of experience in the last six (6) years in SQL, Azure Cloud, Azure Data, DevOps, Configuration Management, Infrastructure Automation, Continuous Integration and Deployment (CI/CD), C#, Web API, Agile, Scrum, Waterfall, Spiral.
Additional Information
Telework is allowed for this position. Knowledge in Human Resource Domain, the role will involve direct interaction with clients including but not limited to requirements gathering, weekly status meetings, and presentations.