Business Intelligence Developer/Analyst - Shiftcode Analytics, Inc
Long Beach, CA
About the Job
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 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. 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.
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 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. 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.
Source : Shiftcode Analytics, Inc