Responsible for the implementation and administration of the SQL Server databases and data management functions in support of the company’s BI/DW projects and initiatives.
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, techniques, standards and approaches.
Required Experience & Skills:
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.
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.
Demonstrated excellence in verbal and written communication at all organizational levels.
Experience in working with distributed development teams; offshore, onshore, and near-shore.
B.S in Computer Science, a related field or equivalent business experience.
At Consulting Professional Resources (CPR), we provide staffing and placement services in the information technology industry for corporations that require skilled personnel for managing and executing projects. We experience rapid growth and continue to expand in the IT market.
Our goal is to provide a more profitable connection between information technology services and the companies that ut...ilize them. We focus on providing measurable results and are fully committed to the success of our clients and employees alike. We stand behind our commitment with a performance guarantee to do whatever is necessary to meet this goal.
Continuous improvement is the standard that we apply to everything from employee compensation to customer satisfaction. Pursuing this philosophy, we have built a strong reputation for quality and professionalism, becoming the long-term IT solution for many premier clients.