The main function of a Data/Big Data/BI Developer is to be responsible for the development and optimization of corporate BI solutions and data warehouse to include database design, development, and enhancement.
Job Responsibilities:
Analyze, develop and implement database designs, data models and logical data specifications
Review and improve existing databases/data warehouse designs Contribute to systems architecture analysis and design.
Provide comprehensive consultation to infrastructure administrators and business analysts in resolving issues
Perform data modeling studies and develop detailed data models
Work with Business Analysts and staff to establish and maintain consistent data element definitions Participate in the development and maintenance of corporate data architecture, data management standards and conventions, data dictionaries and data element naming standards Research and evaluate alternative solutions and recommend the most efficient and cost effective data related solutions for improved data integrity
Performance tune ETL jobs and data models
Migrate ETL code from development to production environments
Assist in the design and development of BI dashboards
Perform DW training as needed
Qualifications:
Bachelor's degree in a technical field such as computer science, computer engineering or related field required8+ years experience required
Experience with ETL tools such as Informatics Strong BI Analytics concepts experience
Experience with BI modeling tools such as Oracle OBIEE Repository(RPD) and IBM Cognos Framework Manager
Experience in creating dashboards and reports
Strong data analysis and data profiling skills Strong database management skills Oral, written and interpersonal communication skills; Organizational and prioritization skills; Analytical and problem-solving skills
Job Requirements: • Extensive Experience with cloud based Big Data technologies like Hadoop, Hive, Spark, AWS EMR and Airflow. • Experience in one or more programming languages like Java, Scala, and Python. • Experience in solving complex problems using SQL. • Experience with developing enterprise grade solutions in an iterative or Agile environment. • Clear, effective communication with strong interpersonal skills. • Ability to push the frontier of technology and independently pursue better alternatives. • Ability to maintain focus and develop proficiency in new skills rapidly. • Ability to utilize problem solving skills in a fast-paced environment • Experience in AWS Cloud is required.