Infinite Resource Solutions, LLC Georgia, USA
Jan 22, 2020
NO C2C Or 3rd Party or Sponsorship Contract to hire 99% Remote Collaborate with operations and business units to gain an understanding of data needs and further translate those needs to data and reporting requirements. Follow industry standards and advances on data driven technologies and tools and further recommend those that will help further advance our clinets data and reporting roadmap. Provide oversight and guidance when required for less senior data and report development staff members. Transform business and client data requirements into meaningful data extracts, reports and data visualizations while meeting our clinets marketing and client user experience standards. Develop SQL, T-SQL scripts, and SQL stored procedures for various reporting and data development projects. Conduct reviews of peer data and reporting development to ensure solutions meet PCI and other regulation standards, are built for performance and meet development best practices. Using multiple data sources, develop advanced reporting solutions in SSRS, Tableau Desktop Pro and Tableau Server. Design and create report delivery solutions within SSRS Report Server and Tableau Server. Document development efforts as required by our clinets change management practices. Develop and design solutions with security as a critical design requirement for data, systems, and applications. Ensure all development work is reviewed by a senior peer or technical lead. Responsible for reporting risks that are identified to the appropriate team and/or management. Additionally, responsible for managing, monitoring and reporting risks within the scope of your work area, to include, but not limited to Information Security risks. BS in CIS, Data Management, Data Analytics, or similar, or equivalent job experience. 5+ years' experience where primary responsibility involves advanced report design and development in SSRS and Tableau. In addition, will have experience leading small to medium size data driven or reporting projects. Data development within a PCI environment. Ability to analyze enterprise level data sources and determine relationships between those sources. Expert knowledge of data query languages and reporting software. Expert knowledge of SQL, T-SQL scripting languages. Expert knowledge of SQL Server Data Tools, SSRS, MS Access, MS Excel Power Pivot, and Tableau Desktop Pro (version 2018+). Advanced knowledge of SSRS Report Server platform (version 2012+). Advanced knowledge Tableau Server configuration, user administration, and backups. Proficient knowledge of Agile methodologies and Jira. Advanced knowledge of MS office tools Word, Excel, PowerPoint, Visio and Outlook. Ability to utilize ODBC connection tools within tools such as SSRS and Tableau to connect to a variety of data sources including SQL database tables, Excel files, Oracle, MS Access databases. Ability to connect and join different data sources for the purpose of creating impactful reporting in SSRS, Tableau and SQL data extracts. Expect skill level with Tableau Desktop Pro including ability to use calculations, parameters and table calculations in tandem. In addition, expert knowledge of clustering, distributions, forecasting, animation, sheet swapping, background images, actions and advanced mapping features. Ability within SSRS to build advanced reports utilizing a data set consisting of multiple data sources, data sets using joins, recursive queries, report matrices, advanced parameters, textual hierarchal reports and graphical and mapping reports. Ability to design reporting with performance at the forefront by recommending database indexing solutions. Ability to troubleshoot more complex data integrity issues involving multiple data sources including 3rd party data, and further analyze data for validity and completeness then document findings with recommendations. Ability to configure report delivery solutions in both SSRS Report Server and Tableau Server, including user administration where platform is exposed externally to network. Excellent communication skills and ability to translate the complex to simple and easier terms for business leaders and users of data. Must be detail focused.