BI Developer

Job Description

Job Designation BI DeveloperPart II Role ResponsibilitiesRole ObjectiveThis role is primarily responsible to extract the data and create automated dashboards using AWS Quick sights, improving performance of existing DB and maintain & manage the historical dataPrincipal Accountabilities
• Develop stable, secure, scalable, and highly performing Code /Components which are easy to inspect, test, service, and support.
• Delivery within time commitments adhering to approved designs, Deployment standards and meeting set quality goals confirming to coding standards & best practice with minimal defects.
• Drive customer communication for the project. Participate in regular client meetings that led to useful feedback and create project plans that deliver solutions to client problems.
• Learn to Influence team and stakeholders to proactively resolve issues
• Perform unit/module testing of software to find errors and confirm programs meet specifications.
• Write dev plan covering all scenarios based on information provided by customers and functional specs.
• Provide accurate time and resource estimates result in on-schedule delivery
• Mentor juniors in the team and take accountability for their delivery like reviewing deliverables, providing solutions and providing technical support and training.
• Contribute to solutioning and ensuring solutions adhere to established technological standards
• identify the scenarios/functionality that are missing or do not meet the customer needs or usability and take proper action
• Independently handle component level design
• Analyze and permit impact of change
• Independently handle component level design
• Recognize broader relationships between the solution and customer needs, iron out dependencies and deliver code that produces value
• Designs and implement proof of concept as needed for solutions as an individual contributor
• Expand software engineering knowledge beyond what is needed to complete the work. Learn new technologies/platforms during the spare time and present the learnings to others in the company
• Expertise and execute in Agile & other Delivery methodologies followed in the organization
Part III Role Requirements Education B.E/ B. Tech, MS, M. Tech, MCA Experience4-6 YearsPrimary Skills
• Should be aware of reporting models, developing dashboards, reports using AWS visualization tools
• Expertise in writing complex SQL queries
• Hands on experience on writing complex SQL queries using joins, aggregate/analytical functions, CTE etc.,
• Hands on experience in fine tuning the long running SQL Queries
• Expertise in developing Database components including creating views, stored procedures, triggers etc.
• Experience on RDBMS systems and concepts (Postgres Preferable)
• Knowledge on AWS BI services, Quicksights, visualization services
• Knowledge on Dynamo Db or any no SQL databases
• Knowledge on Functions, query optimizations, indexing.
• Best practices to manage historical data etc.
• Knowledge on row level security is a plus
• Ability to automate and build reusable executables for better delivery efficiency
• Analytical mind with a problem-solving and debugging skills.
• Excellent Communication Skills
• Awareness of Replication, Synchronization and Disaster Management techniques
• Awareness of Data Quality Management
• Hands on experience on creating table partitions, indexes, views, materialized views etc.,
• Having good knowledge with Jira process.
Secondary Skills
• Extensive Experience in Data validation and Data Profiling
• Good to have knowledge and hands-on experience with ETL development
• Good to have knowledge of Agile Methodology.
Certification
• Tableau/Power BI Certification is a plus
Industry: IT Services & Consulting Functional Area: Data Science & Analytics Role Category: Business Intelligence & AnalyticsRole: BI DeveloperEmployment Type: Full Time, Permanent ,

Keyskills :
sql serversqlssisssrsetlproof of conceptdynamo dbit servicessql queriesdata sciencedata qualitylevel designmusic makingproject plansdata profilingproblem solvingdata validationcoding standardstechnical support