Power BI/Databricks Enterprise Architect -- 100% Remote -- Only W2 Profiles

Job Role: Senior Consultant - BI/Databricks (Senior Enterprise Architect)

Location: Downey, CA (Remote)

 

Position Description:

A Senior Enterprise Architect applies their management skills and specialized functional and technical expertise to support complex projects in applying organizing principles and methods of enterprise architecture. Methods of enterprise architecture include IT business systems development and technical solutions that align with the business process. This is accomplished through requirements analysis, needs assessments, and selection and implementation of integration strategies including lifecycle sustainability. The Senior Enterprise Architect will provide subject matter expertise in industry, and have specific knowledge of methods including architect enterprise strategy, enterprise architecture development and management; business process design and re-engineering; investment decision making and support for solution architecture development/management; and support the attainment of business strategy and its alignment with processes and information technology strategy.  

 
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.          

 
Additional Skills Required:

Possess strong Knowledge and Technical Expertise in Power BI Services, including Dashboards/Reports development, Paginated Reports development, Power BI Gateway Server Management, and Power BI Row Level Security. Skilled in SQL Server and Oracle Database; T-SQL (Version 2014 & later): SQL queries development, store procedures, and jobs management. Skilled in Azure Data Factory; Azure Databricks; Data pipeline design, development and support; SQL Server Integration Services (SSIS); SQL Server Reporting Services (SSRS); Data warehouse solutions on SQL Server and Oracle. Proficient in Azure DevOps, Git/GitHub, Python; , C#, Control-M, and JSON programming skills; Familiar with Agile Methodologies; Demonstrate strong debugging Skills; along with excellent Interpersonal, oral and written communication skills, customer services and problem-solving skills, supported by a collaborative team mindset.          

 

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.  


Additional Experience Required:

• Minimum Five (5) years of experience in PowerBI, Azure Environment from inception to support.

• 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 Data Warehouse experience in the last six (6) years with Azure Databricks, SQL Server and Oracle.

• Minimum Two (2) years 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 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.

• Minimum 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.