Plan and conduct development work on complex projects necessitating the origination and application of new and unique approaches. Translate business requirements into data models that drive data warehouse or data mart design and configuration. Act as the technical lead on projects. Work with cross-functional teams to gather, document, and approve business requirements for data analysis and reporting projects. Use BI and database tools to develop reporting solutions to meet business needs. Design, develop and implement the reporting and analysis environment, including canned and parameterized reports. Design, develop and implement data integration processes to transform unstructured and disparate source data into the target data warehouse or data marts. Oversee implementation and maintenance of BI systems that support feature development and testing. Provide 24x7 support to ensure availability of BI environments for internal and external users. Role Competencies BS in Computer Science or related field; or equivalent combination of education and experience. Strong knowledge of SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS) preferred. Minimum 4 years overall work experience as a technical contributor in an IT setting. Minimum 2 years experience implementing enterprise-scale reporting systems using business intelligence tools such as Cognos, Business Objects, Microstrategy, etc. Minimum 2 years use of SQL and RDBMS systems (Oracle, SQL Server, etc.) Knowledge of logical and physical data modeling concepts. Knowledge in dimensional data modeling designs and techniques. Advanced knowledge of Data Warehouse/BI project lifecycle, tools, technologies, best practices. Strong skills to develop complex SQL queries (ex: using various joins and sub-queries) and stored procedures. Strong knowledge of how to create complex reports (ex: drill down reports) using cursors and multi-dimensional objects. Strong communication skills - strong presentation, communication, and facilitation (both oral and written). Ability to thrive in a fast paced remote environment with minimal direction, extreme pressure, and tight deadlines Strong problem-solving skills, troubleshooting, and root cause analysis. Provides expertise and guidance to other developers in the use of the toolset.
Key Skills: