| SQL BI Developer, Pittsburgh, PA (Local) at Pittsburgh, Pennsylvania, USA |
| Email: [email protected] |
| From: abhishek, StellentIT [email protected] Reply to: [email protected] SQL BI Developer, Pittsburgh, PA 12+ Months Phone + Skype Job description: RESPONSIBILITIES Plans, coordinates and administers all functions in support of the BI/DW database environments including database definitions, structures, documentation, data standards, infrastructure (HW/SW) installations and upgrades, security, backups & recovery, and performance optimization/turning Formulates and monitors policies, procedures and standards related to the management and usage of the company's BI/DW database environments Ensures compliance with corporate data management processes & policies across the BI/DW implementations/environments Collaborates with the business units and other IT teams in delivering robust, high quality and effective BI/DW solutions Develops conceptual, logical and physical data models to meet requirements and strategies Provides coaching and mentoring to business users, team members and other IT staff on BI/DW database design and data management best practices, tech QUALIFICATIONS 4 years of experience as a SQL Developer focused on the BI aspects of SQL Server, supporting data warehousing and business intelligence solutions Expertise in logical and physical data warehouse database design (SQL Server), and performance optimization; Should have excellent database design, data modeling knowledge and experience related to large scale, multi-dimensional BI/data warehousing implementations Experience and demonstrated competencies with multi-dimensional design, star schemas, facts and dimensions Comprehensive understanding of data management best practices including demonstrated experience with data profiling, sourcing, and cleansing routines utilizing typical data quality functions involving standardization, transformation, rationalization, linking and matching Familiarity with MDX and DAX query languages Deep knowledge and operational experience with Microsoft BI/DW tools, technologies and products (SQL Server, SSIS, SSAS, SSRS, etc) Proficient in SQL 2012, Office 2010/13, Sharepoint 2010/13, Performance Point Knowledgeable in Microsoft's self-service Power BI technologies Proficient in SSAS concepts such as Tabular, Multidimensional, Power-Pivot, etc. Keywords: business intelligence information technology Pennsylvania |
| [email protected] View all |
| Fri Sep 08 03:20:00 UTC 2023 |