This position requires resource to analyze business requirement and build tool using advanced SQL, SSIS and Tableau & will be responsible for the management and manipulation of mostly structured data, with a focus on building business intelligence tools, conducting analysis, performing normalization operations, and assuring data quality. Resource would need to work on creating specifications to bring data into a common structure, creating product specifications and models, developing data solutions to support analyses, performing analysis, interpreting results, developing actionable insights, and presenting recommendations for use. Roles in this function could partner with stakeholders to understand data requirements and develop tools and models such as segmentation, dashboards, data visualizations, decision aids and business case analysis to support the organization
Primary Responsibilities:
- Uses pertinent data and facts to identify and solve a range of problems within area of expertise
- Investigates non-standard requests and problems, with some assistance from others
- Manage/create SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems
- Apply data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations
- Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end
- Refine and automate regular processes, track issues, and document changes
- Assist developers with complex query tuning and schema refinement
- Provide support for critical production systems
- Be able to fix jobs due to logic/code issues and able to do jobs modifications based on the requirements
- Be able to analyze the code, understand the purpose, modify the code to run successfully
- Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team membersSSIS, Tableau
- Work on ETL tool to either load data or run scheduled jobs
- Work on Tableau visualization to create interactive dashboards per requirements