Role: SSIS + POWER BI

Experince: 5+ Years

Location: Manikonda SEZ, Hyderabad

Job Description:

• This technically focused position with the team is responsible for designing, developing, testing and deploying our business intelligence solutions across the enterprise.

• BI Developer is responsible for application creation, administrative tasks, and supporting dashboard and report solutions development.

• The Senior BI Developer will collaborate with Business Analysts, Data Scientists, and Project Managers, provide leadership regarding reporting and BI, as well as support and develop subject matter knowledge for reporting within the ITG space.

• The Senior BI Developer will ensure the effective design, build, deployment, documentation and maintenance of reports against relational and multidimensional databases to support end-user processes.

Description of Responsibility:

Technical:

• This individual will lead all aspects of the BI development lifecycle from requirements gathering to data modeling to report development.

• The team member will assume subject matter expert responsibilities in developing appropriate strategies, plans, tools and approaches to ensure successful adoption of BI reports, dashboards and scorecards.

• Think analytically and critically to lead reporting standardization and automation efforts.

• Present data formally and informally and facilitate discussion regarding data outputs.

• Generate and prepare reports, scorecards, and dashboards to support business objectives.

• Develop BI Reporting architecture, reports, dashboards, guided analytics, and other BI solutions.

• Produce technical solution designs that will meet business requirements in a manner consistent with Company and industry standards.

• Produce technical solution designs that will meet business requirements in a manner consistent with Company and industry standards.

• Participate in the development and support of reporting solutions including program modifications, performance tuning, problem solving, debugging, and unit testing.

• Learn and abide by corporate data governance guidance.

• Participate in data modeling and loading as required by the BI Tool in use

Education:

• Grow professionally and lead developer in all activities listed above and Provide hands-on technical leadership for development projects.

• Establish learning curriculum or examples to serve as the basis for mentoring other teams.

Relationship and Team Building:

• Exchange detailed information across department, organization/enterprise;communicates independently, thorough understanding of organizational data, sharing technical and clinical expertise or providing direction/instruction.

• Provide assistance for BI reporting solutions to the rest of the IT&S organization.

• Provision of the guidance takes a number of forms, including: engaging in joint- development with various application development teams, providing second-level to Customer Service and primary support to the rest of the IT&S organization, documenting and communicating standards and procedures, developing and delivering internal training & certification programs, and assisting problem analysis/resolution.

• Develop and drive the implementation of management reporting best practices and standards for the team.

• Collaborate with other teams to integrate solutions where additional data and subject expertise is required.

• Contribute to multi-disciplinary teams using data to improve usage and operational workflow.

Educational Requirements & Technical Experience:

• Requires a Bachelors degree.

• 5+ years data/process/ analysis experience.

• Fully competent professional with in-depth knowledge of clinical data, analytics and data science.

• Healthcare operations and clinical process workflow experience preferred.

Desired Technical Skills:

• Demonstrated extensive experience in large-scale reporting development projects (ad hoc and standard queries).

• Demonstrated broad SQL development experience with solid understanding of relational and multi-dimensional designs.

• Experience with Teradata and SQL Server.

• Prior certification in at least one (1) of BI Tools.

• Expert knowledge of Microsoft Office.

• Experience in an Agile BI Reporting development self-service environment is required.

• Experience with BI tool architectures, functions, and features desired.

• Detailed working knowledge with clinical and operational data within a healthcare system

Desired Professional Skills:

• Preferred detailed working knowledge of the health care industry, applications, clinical workflow issues, regulatory compliance and federal mandates preferred.

• Possesses interpersonal skills to work in a high profile and fast paced team.

• Technical aptitude to learn and adapt to new industry applications and tools.

• Works independently, receives minimal guidance and acts as a mentor and provides direction to colleagues with less experience.

• Ability to communicate and facilitate topics clearly and effectively across department lines; working inside peer groups and receiving guidance from supervisor.

• Demonstrated oral, written and technical communication skills required.

• Demonstrated presentation/public speaking skills and experience required. Possesses good organizational as well as visual and verbal presentation skills.

• Ability to establish and consistently meet delivery dates.

Mandatory Skills: SSIS, Power BI, SQL Development, BI Reporting Development, Data Modeling, Relational and Multidimensional Databases, Report Deployment, Agile Methodologies, Performance Tuning, Business Intelligence (BI) Tools (Experience with BI tools architecture and features), Data Governance

Secondary Skills:Teradata, Data Science, Clinical Workflow Knowledge, Operational Data within Healthcare Systems, Agile BI Environment, BI Tool Certification (e.g., Power BI Certification, SSIS, etc.), Team Leadership & Mentorship, Process Improvement, Client Interaction, Interpersonal Skills, Microsoft Office Suite, Healthcare Regulatory Compliance & Federal Mandates Knowledge

Keywords:SSIS, Power BI, BI Developer, SQL Server, Teradata, Data Modeling, Reporting Solutions, BI Dashboards, Agile BI, Data Governance, SQL Reporting, Data Science, Healthcare Operations, BI ToolsPerformance Tuning, Data Integration, Clinical Data, Reporting Automation, BI Architecture, Mentorship & Leadership, Healthcare Compliance