Data Scientist BI Developer

This role will be hybrid ONSITE/REMOTE with onsite presence in Long Beach CA at least 3 days each week. Thus our client would prefer a person who lives in Southern CA.

Essential Duties and Responsibilities:

1. Participate in a full solution development lifecycle including: business case prioritization planning design development testing migration and production support.

2. Strong analytical skills with the ability to collect organize analyze and disseminate significant amounts of information with attention to detail and accuracy.

3. Collaborate with users to develop effective and efficient metadata.

4. Identify reporting and dashboard requirements.

5. Assist in strategic placement of business logic within the ETL and/or metadata models.

6. Build a highly integrated enterprise data warehouse metadata or semantic models.

7. Design and build unified reports dashboards and data extractions across multiple business units and data sources.

8. Develop and execute testing methods and processes for reports and metadata models.

9. Organize documentation to support project report requirements business intelligence architecture and data.

10. Provide design specifications and data lineage and definitions to the enterprise data warehouse data dictionary.

11. Apply analytic skills to understand business processes data flows host systems applications and stakeholder involvement and interaction with data.

12. Identify lead communicate and implement improvements workarounds and options related to data ETL to local data store/database for constructing data model and meeting dynamic output requirements and schedules while ensuring data integrity and effectiveness.

13. Creation of User Interface (UI) portal/website components to display information in static dynamic or interactive mode for consuming stakeholders. This may be in conjunction with SharePoint or similar technologies.

14. Ability to download information in SQL DB and generate reports using Power BI or Tableau from a training tool utilized for periodic cybersecurity awareness campaigns.

15. Knowledge of SQL Python R or similar programming languages.

Required Knowledge and Attributes:

1. Must be self-motivated; possess strong organizational skills and the ability to manage multiple assignments verbally given; possess exceptional interpersonal collaborative and communication skills; have the ability to assimilate business objectives and transform them into actionable Engineering initiatives.

2. Experience working effectively across organizational and functional boundaries to gather information related to data sourcing usage or technologies.

3. Analytic to understand business processes financial calculations capacity and demand forecasting data flows host systems applications and stakeholder involvement and interaction with data.

4. Experience working with multiple data analysis reporting tools and technologies and BI tools like Tableau Power BI etc.

5. Demonstrates good coping skills and analytical problem-solving skills.

6. Strong skills with the Microsoft Office product suite including Word Excel Visio and PowerPoint.

7. Demonstrates ability to perform detail-oriented work with a high degree of accuracy.

8. Self-directed and self-motivated individual who takes complete ownership of the data processes and its outcome.

9. Strong organizational skills planning skills and must work effectively within teams.

10. Excellent verbal written and interpersonal communication skills.

11. Well aware that data integrity and consistency are key to trust and adoption of produced information.

12. Ability to adjust to multiple demand and constituencies by shifting priorities and through rapid change and flexibility.

Required Education and Experience:

1. Bachelors degree in Computer Science Mathematics or Statistics (with a minor in Computer Science or equivalent work experience required).

2. 3 years of business intelligence development.

3. 3 years of Microsoft Power BI experience (SharePoint 2019 PBIRS/SSRS Excel 2019/2021).

4. 3 years of experience working with the project management lifecycle or software development lifecycle.

5. 3 years of experience working with warehousing methodologies/designs and processes (ETL Data Modeling).

6. 3 years of experience working with VBA programming in Excel and Access.

7. Demonstrated ability to write SQL queries and use Microsoft SQL Server 2017/2019/2022 database tables and connectivity.

8. Experience with other BI tools such as PBIRS SSRS SSAS and Tableau.

9. Strong analytic skills to understand business processes financial calculations capacity and demand forecasting data flows host systems applications and stakeholder involvement and interaction with data.

10. Critical thinking and problem-solving skills with the ability to identify root causes and develop implementable workable solutions.

11. Proven ability to perform high-quality technical documentation and presentations.

12. Excellent presentation and communication skills-ability to clearly explain data insights use cases and results to leadership and business stakeholders