Need BI Technical Lead / Dublin, Ohio/ US Citizens and Green Card only/F2F interview required
Location: Dublin, Ohio
Duration 6-12 months
US Citizens and Green Card holders only
Will have to do face to face interview, candidate must be local or
willing to come for interview.
BI Technical Lead
Job Summary
We leverage Agile and Lean techniques, such as acceptance test-driven development, continuous integration, and story-based iterative development. As a BI Technical Lead, you will be involved in all phases of report, ETL, database, and cube development from requirements definition to production releases. Reporting to the Information Management Manager, you will be leading a cross-functional team that collectively strives to deliver high-quality, high-value information to customers and business stakeholders. To be successful at IGS, you must be internally motivated, innovative, self-directed, and service-oriented.
Responsibilities:
· Direct and facilitate functional and technical designs of systems to ensure sound decisions are being made in alignment with current and future business and IT strategies and opportunities
· Architect business intelligence solutions and direct ETL and report developers in the solution creation
· Support reduction of data redundancy and fragmentation, elimination of unnecessary movement of data, and improvement of data quality
- Champion developing, implementing, and continuously updating "best practices" and standards as they relate to ETL strategy and data quality management
· Interact with technical and business resources on a daily basis to define, develop, and test solutions as they pertain to Business Intelligence development and information retrieval.
· Develop scalable cross tabular reports, charts, dashboard displays, sub reports including drill down functionalities with static and dynamic parameters using Excel 2013 and Microsoft SSRS
· Designs conceptual, logical, and physical data models to support Business Intelligence data warehousing and operational reporting strategy in a real-time, near real-time, and batch environment
· Provide hands on Development, Unit Test, and Support for ETL processes
· Publish and deploy SSRS reports in Share Point Server 2010.
· Respond to production support and implement immediate resolution.
· Ensuring accuracy and integrity of data & applications through analysis, (ETL) modeling, coding, writing clear documentation and problem resolution.
· Consults with Quality Assurance and business analysts in the development and execution of test plans and full testing cycle for ETL processes, including bug fixes
· Architect and monitor Report servers and make sure all jobs are up and running
· Collaborate with DBA team to optimize ETL performance, tune reports and optimizing SQL queries, T-SQL, and stored procedures.
· Collaborate with Systems and Business Analyst in problem identification and requirements gathering and documentation, as well as system design activities
Required Skills:
• Excellent communication skills, both written and verbal
• Dimensional and transactional data modeling
• ETL and data integration development
• Strong background in Microsoft BI development
o SQL Server 2012 development, stored procedure development and change tracking.
o Integration Services (SSIS)
o Reporting Services (SSRS)
o Analysis Services (SSAS)
Desired Skills:
• Provide corrective perfective maintenance and enhancement support for Crystal Reports server
• Experience with integrating Crystal Reports with .Net application
• Agile/Lean/Kanban development methodologies
• Microsoft SharePoint 2010
Minimum Education and Experience:
• A college degree in computer science, information systems, engineering, business or related discipline or equivalent
• 4+ years of experience in Business Intelligence development and analysis