Report developer

Title: Sr Report Developer

Location: Houston, TX

Job Type: Permanent

OVERVIEW:

As an integral member of our delivery team, the Report Developer is responsible for the development, implementation, QA and support of our enterprise reporting. Working with various departments throughout company, you will review provided documentation relevant to the reporting requirements and develop the needed components to meet the business needs. This may include creating TSQL reports (fed into Excel) and/or leveraging Tableau Desktop to deliver data.

MAJOR RESPONSIBILITIES:

• Interact with Business SME's for analyzing business requirements and develop technical specifications for reporting
• Create mockups, prototype reports, and develop visualization requirements by working business teams & users
• Visualize the data by working analytical, operations and business teams in a meaningful way that allows the business to quickly draw conclusions and make decisions.
• Develop and format stored procedures in T-SQL,
• Create and manage reports & dashboards in Excel based on customer and Company’s standards.
• Create and manage reports & dashboards in Tableau based on customer and Company’s standards
• Build self servicing interactive drill down reports based on customer and Company’s standards
• Use Word to create automated letters for clients using macros, etc.
• Identify and solve data integrity questions within T-SQL.
• Quickly address T-SQL/Excel/Tableau issues not tied to data (formatting, aesthetics, etc.)
• Communicate with non-technical employees to define report request and limitations.

QUALIFICATIONS & REQUIREMENTS:

Education: Bachelors degree in IT or related business discipline. Relevant experience may be substituted for education requirement.

Experience: Minimum of 5 years working in the report development position, with increasing roles of responsibility.

Skills:

• Should have advanced level TSQL experience. MDX scripting experience is a big plus.
• Should have excellent hands-on development experience with Tableau & Excel
• Should have strong Business Analyst skills to interact with Business SME's for analyzing business requirements and develop technical specifications for Tableau reporting.
• Should have experience on working with business teams/end users to create mockups, prototype reports, and develop visualization requirements.
• Tested, cleaned and standardized data to meet the business standards using Execute SQL task, Conditional Split, Data Conversion and Derived columns in different environments.
• Developed Tableau workbooks from multiple data sources using Data Blending.
• Generated Tableau Dashboard with quick/context/global filters, parameters and calculated fields on Tableau reports.
• Created Tableau Dashboards with interactive views, trends and drill downs along with user level security.
• Fine-tuned SQL Queries in Tableau Desktop for maximum efficiency and performance.
• Created Batch Stored Procedures for Tableau Server in the Report Scheduler according to the monthly, weekly or daily refresh schedules.
• Thorough analysis, unit testing and integrated testing with other applications of database objects before deployment to the Tableau production server.
• A broad exposure to various Business Intelligence platforms. Position requires excellent technical and communication skills. The ability to manage multiple projects/tasks simultaneously is a requirement of this position.. Very detailed oriented.

"e-Business International is a company we count on to understand the scope and requirements of a project then develop an efficient plan, complete development, implement and train the users with an affordable approach throughout the whole process.