Job Title: Data Warehouse Programmer (SQL , POWER BI)
Location Irvine , CA
Duration: Long Term
Job Description:
The Senior Data Warehouse Programmer Analyst participates in the design, development, implementation, review, and monitoring of all analytical database environments. The Programmer Analyst works closely with the OLTP team , and the QA team to ensure best practices are followed. The candidate will maintain and enhance the data warehousing environment and to take it through the future iterations. In carrying out the key priorities of the role, they will contribute to# # Consolidate and optimize available data warehouse infrastructure # Conceive analytics and business intelligence platform architecture for internal clients # Collaboration with colleagues and advising senior management on opportunities to improve su ch as implementing new processes and emerging technologies # Building capacity within and across the team through a strong focus and support of data engineering learning and development activities # Database architecture and design of data warehouses ubject areas and OLAP cubes # Hands on SQL development and support of current ETL processes, sharing in responsibilities for monitoring the data warehouse loading process # Design and implement ETL procedures for intake of data from both internal and outside sources as well as ensure data is verified and quality is checked # Design data architecture to ensure proper, efficient functioning of reporting, as well as reporting environments and dashboards # Collaborate with business and technologyst akeholders in ensuring data warehouse architecture development and utilization # Carry out monitoring, tuning, and database performance analysis # Perform the design and extension of data marts, meta data, and data models # Ensure all data warehouse architecture codes are maintained in a version control system # Design, development, and implementation of ETL jobs based on business requirements Specific Skills Knowledge # Strong knowledge of data warehousing principles and concepts # Strong codi ng experience using SQL, Power BI and SQL Server preferred. # Development experience with BI and ETL ELT tools such as Power BI, SSIS, SSAS # Ability to be client facing and be able to help internal customers determine their requirements and set.
Job Requirements: PowerBI, MS SQL Server, MS SQL Query Language, Azure Data Factory, SSIS, Querying SQL Database, Data Analysis, Architecture Design Mapping, SQL Query Script, Data Analysis
Location: Los Angeles
Experience: 10 to 12 Years
Skills Required: MS SQL Server
Sagaya Raj (Raj) | Technical Recruiter
Nityo Infotech Corp.
Suite 1285, 666 Plainsboro Road
Plainsboro, NJ, 08536
Direct: |
“If you feel you received this email by mistake or wish to unsubscribe, kindly reply to this email with “UNSUBSCRIBE” in the subject line”