Vacancy expired!
BUSINESS INTELLIGENCE ANALYST / DEVELOPER – LONG BEACH, CALIFORNIA
Sierra Cybernetics is seeking a BI Analyst/Developer to work for us supporting our Port of Long Beach (POLB) client.
This is a contract assignment, expected to be a one year or more, remote and on-site as needed.
Open only to US citizens or green card holders; no sponsored candidates are eligible.
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.
TASKS 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.
SKILLS
1. Analytic to understand business processes, financial calculations, capacity and demand forecasting, data flows, host systems, applications and stakeholder involvement and interaction with data.
2. Experience working with multiple data analysis, reporting tools and technologies, and BI tools like Tableau, Power BI, etc.
3. Strong skills with the Microsoft Office product suite, including Word, Excel, Visio and PowerPoint.
4. 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.
5. Knowledge of SQL, Python, R, or similar programming languages.
6. 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.
7. Critical thinking a must. Problem solving skills with the ability to look for root causes and implementable, workable solutions.
8. Proven ability to perform high quality technical documentation and presentations.
EDUCATION AND EXPERIENCE
1. Bachelor’s degree in Computer Science, or equivalent work experience required.
2. 3+ years business intelligence development.
3. 3+ 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.
