SQL Developer Invenio Marketing
THIS JOB HAS EXPIRED JOB DESCRIPTION
The SQL Developer with SSRS specialization is responsible for delivering high-level reports, dashboards and visualizations based on metrics and data elements. A key aspect of the role is the ability to gather requirements for technical specifications, produce development specifications, reports, visualizations and dashboards based on business specifications, and ensure the reports and dashboard have been produced according to company procedures and have been tested to the highest standard. You will work directly with stakeholders, Business Analysts and BI Architects to develop enhancements to the BI platform which will deliver insights to the business and measure metrics critical to Invenio.
Advance working knowledge of Microsoft SQL Server Stack 2008 R2 or later.
Expert level knowledge of SSRS, SSAS, SSIS, SQL, T-SQL & MDX.
Experience in OLTP, OLAP, and Data Warehousing.
Visual Studio IDE
Excellent listening, interpersonal, written, and oral communication skills.
Highly self-motivated, self-directed and able to exercise independent judgment.
Strong problem solving and analytical abilities.
Ability to effectively prioritize and execute tasks while under pressure.
Builds and maintains relationships with users to ensure adoption and buy-in of reporting solutions.
Design, development, testing and deployment of reports, visualizations & dashboards using Microsoft SQL Server Reporting Services (SSRS) 2008 R2 or later.
Ad hoc reporting and data extraction for requests that cannot be accommodated by existing reports/extract packages.
Provide support to Business Analyst(s) in gathering and/or clarifying data and reporting requirements from business owners.
Develop write SSIS packages, Stored Procedures, and SQL & MDX queries to that support SSRS reports.
Identify and troubleshoot business process or data quality issues that show up in the reports and subsequently communicate to resolve and eliminate problems.
Serves on business intelligence team to drive improvements in reporting and decision making
Assist in the administration of the SSRS instance
A bachelor?s degree in computer science, information systems or related field or equivalent combination of education and experience
3-5 years of experience with MS SQL Server 2008/2008 R2 or later
3 years of experience in developing complex reports and dashboards using SSRS.
1 years of experience in developing SSAS solutions or querying using MDX
2 years of experience in developing ETL using SSIS.
3 years of experience in writing complex T-SQL and PROCS
Experience in developing reports both against OLTP and DATA MART
||Austin, TX |
THIS JOB HAS EXPIRED