ShiftCode Analytics
Business Intelligence Developer/Analyst
ShiftCode Analytics, Long Beach, California, us, 90899
We need a
Business Intelligence Developer/Analyst
for a 9+ month contract for a client in Long Beach, CA.
This role will be ONSITE in Long Beach, CA from Monday to Wednesday each week, and then REMOTE for Thursday and Friday. Thus, our client wants a person who lives in Southern CA.
A VIDEO interview will be required.
This position transforms time-critical data extracted from complex, multi-sourced locations into simpler, unified and aggregated information suitable as input for executive business reporting, presentation summary and decision making purposes. The position will leverage the individual's knowledge of
design and development capability of Business Intelligence (BI) tools
to establish data relationships, validate data integrity, and build data models and visualizations of operational, analytical, historical, and forecast information. The candidate must convey mastery of timely data investigation and analysis concepts (identify data sources, data definitions, and business process usage and lifecycle flow of data) with time frame estimates along with the ability to collaborate with team members, and communicate with team, management, and peer stakeholders effectively and concisely to set proper expectations. He/she will be responsible to envision, determine, manage and provide information insight, improvement and effectiveness opportunities, workarounds, or alternatives based on data content expertise for peer and senior stakeholder consideration in a professional manner.
Essential Duties and Responsibilities1. 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 Attributes1. 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 Experience1. Bachelor's degree in Computer Science, or equivalent work experience required.2.
3+ years business intelligence development .3.
3+ years 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 of Microsoft SQL Server 2017/2019/2022 database tables
and connectivity.8. Experience with other BI tools such as
PBIRS, SSRS, SSAS and Tableau.9. Analytic skills a must 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 a must. Problem solving skills with the ability to look for root causes and implementable, workable solutions.11. Proven ability to perform high quality technical documentation and presentations.
Business Intelligence Developer/Analyst
for a 9+ month contract for a client in Long Beach, CA.
This role will be ONSITE in Long Beach, CA from Monday to Wednesday each week, and then REMOTE for Thursday and Friday. Thus, our client wants a person who lives in Southern CA.
A VIDEO interview will be required.
This position transforms time-critical data extracted from complex, multi-sourced locations into simpler, unified and aggregated information suitable as input for executive business reporting, presentation summary and decision making purposes. The position will leverage the individual's knowledge of
design and development capability of Business Intelligence (BI) tools
to establish data relationships, validate data integrity, and build data models and visualizations of operational, analytical, historical, and forecast information. The candidate must convey mastery of timely data investigation and analysis concepts (identify data sources, data definitions, and business process usage and lifecycle flow of data) with time frame estimates along with the ability to collaborate with team members, and communicate with team, management, and peer stakeholders effectively and concisely to set proper expectations. He/she will be responsible to envision, determine, manage and provide information insight, improvement and effectiveness opportunities, workarounds, or alternatives based on data content expertise for peer and senior stakeholder consideration in a professional manner.
Essential Duties and Responsibilities1. 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 Attributes1. 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 Experience1. Bachelor's degree in Computer Science, or equivalent work experience required.2.
3+ years business intelligence development .3.
3+ years 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 of Microsoft SQL Server 2017/2019/2022 database tables
and connectivity.8. Experience with other BI tools such as
PBIRS, SSRS, SSAS and Tableau.9. Analytic skills a must 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 a must. Problem solving skills with the ability to look for root causes and implementable, workable solutions.11. Proven ability to perform high quality technical documentation and presentations.