BI Developer
Collab Consulting Group
Irvine, CA

Job Summary
Hi,
Hope you are doing good.
Please have a look on below JD and let me know if you’re comfortable.
*
*
Role: BI Developer
Location: Irvine, CA
Duration: long term
Client: National Financial Services
*
*
Duties and Responsibilities:

KEY essential duty- Responsible for the aggregation of data from multiple sources into an efficient data warehouse and designing reporting solutions for very large multidimensional databases. Partner and collaborate with technical and non-technical stakeholders to solve complex business problems by gathering requirements, prototyping and testing, or enhancing existing solutions to meet new requirements.

  • Translate business needs to technical specifications
  • Maintain and support data analytics platforms
  • Conduct developer testing and troubleshooting
  • Evaluate and improve existing BI systems and processes
  • Collaborate with teams to integrate systems
  • Develop and execute database queries and aid in development
  • Develop standard reports and functional dashboards based on business requirements
  • Develop and update technical documentation
  • Adhere to documented SDLC steps and deliverables
  • Escalate open issues and proactively ask questions in an agile manner
  • Understand priorities and be able to prioritize work appropriately

Minimum Skills and Competencies:

  • Bachelor’s Degree or in-lieu of degree equivalent education, training and work-related experience
  • 4+ years Structured Query Language (T-SQL)
  • 2-3+ years of one or more of the following skill sets: SSIS, SSRS, SSAS
  • 2-3+ years’experience with relational database management systems, online analytical processing (OLAP) and ETL (Extract, transform, load) framework
  • Knowledge of data warehouse design (e.g. dimensional modeling) and data mining
  • Development knowledge of all phases of Software Development Lifecycle
  • Proficient in Microsoft Office (Word, Excel, Outlook, PowerPoint)
  • Works independently with little supervision
  • Effective organization and time management skills with the ability to work under pressure and adhere to project deadlines
  • Ability to work in an open team environment, to take initiative and be innovative
  • Analytical mind with a problem-solving aptitude
  • Desire to learn the business, continuously striving to improve efficiency, reduce costs, and ensure compliance with regulations, and work cooperatively and jointly to provide clients and internal customers with quality service

Desired Skills:

  • Effective time management skills with the ability to work under pressure and adhere to project deadlines
  • 4+ years in SSRS, SSIS
  • SSAS and/or other OLAP tool experience

Job Type: Contract

Salary: $45.00 to $50.00 /year

Experience:

  • relevant: 1 year (Preferred)

Contract Length:

  • More than 1 year