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.
Pentaho business analytics and data integration suites. Strong Postgres SQL experience. Be a senior developer and lead a small team of developers in designing and developing reporting and analytics applications.
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 dashboardsPerform DW training as needed.
Qualifications:
Bachelor’s degree in a technical field such as computer science, computer engineering or related field required.
8+ 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
