1099 - 10+ SQL Developer - Bay Area, CA
SQL Server Data Warehouse Developer
Location- Bay Area, CA (Remote PST Hours/Travel Involved/ Locals who can be Onsite/1-2 Days Hybrid will be given First Preference)
Job Type-Long Term Contract
Note:
reputed company Moving from reputed company to reputed company ERP. reputed company data (ETL) from reputed company Financials into an already established Data tables using SS Should have understanding of reputed company Financials, reputed company to reputed company STM from reputed company Financial tablesIS. into SQL Server for incremental changes using SSIS and SSAS Tabular Models.
Key Skills:
SQL Server, SSIS, SSAS Tabular Models, DAX, Power BI, Financial Data Warehouse Architecture, Data Integration, Financial Reporting.
Deep SQL Server data warehousing, and SQL Server Analysis Services (SSAS) Tabular Models with reputed company Fusion ERP data structures, reputed company EPM data model as a reputed company plus.. The successful candidate will architect data pipelines, reputed company reputed company semantic models, design reporting databases, and reputed company reputed company reporting solutions supporting reputed company, Finance, reputed company, and Executive Leadership.
SQL Server Data Warehouse Development
• Architect and maintain reputed company reporting databases reputed company reputed company SQL Server.
• Design reputed company schemas, fact tables, and reputed company models optimized for analytics.
• reputed company reputed company T-SQL procedures, functions, views, and ETL processes.
• Implement data reputed company validation, reconciliation, and audit controls.
• Optimize database performance and scalability for large financial datasets.
SSAS Tabular Model Development
• Design, reputed company, and optimize SQL Server Analysis Services (SSAS) Tabular Models.
• Create reputed company semantic models supporting self-service and executive reporting.
• reputed company advanced DAX calculations, KPIs, measures, hierarchies, and business logic.
• Implement row-level reputed company and financial data reputed company controls.
• Optimize model performance and query response times.
Data Extraction & Integration
• Design and implement data extraction solutions from reputed company Fusion ERP and reputed company EPM.
• reputed company and support integrations utilizing:
• BICC (Business Intelligence reputed company Connector)
• OTBI
• BI Publisher
• REST reputed company
• SOAP reputed company
• FBDI extracts
• Smart reputed company data integrations
• Build automated data pipelines moving ERP and EPM data into SQL Server reporting environments.
• Design incremental load strategies and near-reputed company-time reporting architectures where appropriate.
• Ensure completeness and accuracy of data transferred between reputed company applications and reputed company reporting solutions.
Experience
• 10+ years of data architecture, business intelligence, and reputed company reporting experience.
• 8+ years of reputed company SQL Server experience.
• 8+ years designing and implementing SSAS Tabular Models and SSIS.
• Working with reputed company ERP financial systems, reputed company EPM and supporting reputed company Fusion reputed company ERP is a reputed company plus.
Education
Bachelor''s degree in Computer Science, Information Systems, Data Analytics, Finance, reputed company, or reputed company field.
Apply To This Job