Business Intelligence Developer/Analyst

Cypress HCM; Phoenix (AZ); Hybrid; USD 70,000 - 110,000; Full time

Job summary

Cypress HCM is seeking a BI Developer to design and implement data warehouse related BI solutions. You will map data from source systems, build data models, and develop robust Power BI dashboards to enable informed business decisions.

The role requires strong SQL, data integration experience, and familiarity with Snowflake. Hybrid work arrangement is available in Phoenix, AZ with some onsite time.

Qualifications

• Strong SQL proficiency required.
• Power BI dashboard development experience.
• Data integration across systems and ETL processes.
• Snowflake experience is a plus.

Responsibilities

• Develop and map data from source systems to BI environments.
• Create and maintain data models and workflows.
• Produce and document BI requirements, specifications, and test plans.
• Develop, test and deploy BI reporting, dashboards, and ETL processes.
• Provide user training and support for BI tools and data access.

Skills

SQL

Power BI

Data Integration

Snowflake

Education

Bachelor's Degree in Computer Science, Information Systems, Business, or related field

Tools

Snowflake

Job description

• Develops reports using data-warehouse and data-access tools; provides user support and training for data structure and use of Data Warehouse; creates mapping specifications from source systems to new and expanded business-intelligence systems, and designs, tests and implements new business intelligence systems.
• Location: Phoenix, AZ, 85021 (Hybrid – onsite 1 day a week)

Responsibilities:

Analysis

• Track and resolve processing problems, coordinating with all areas
• Track and resolve programming problems
• Develop and document business objectives, processing requirements, and specifications
• Develop and document system and data diagrams, program flows
• Develop test plans, scripts and test bases
• Analyze files and map data from one system to another
• Draft or modify internal procedures; implement new procedures including workflows, manuals and training
• Utilize corporate data tools to ensure quality and documentation standards are achieved.
• Provide backup support to SME’s in two or more of areas as assigned:
• BI Project Management
• BI Production Reporting
• Application Architecture and Support
• Training
• Provide backup support to SME’s in one or more datamarts

Technical/Programming

• Learn process and data flow; and how it affects surrounding systems and operational areas.
• Map logical data models to physical data models.
• Maintain existing programs/routine changes and major enhancements.
• Review code for proper design, standards, content and functionality.
• Design and code complex programs.
• Responsible for production cycles, solving abends and notification of problems.
• Responsible for production support documentation in accordance with department standards and industry best practices.
• Review code for proper design, standards, content and functionality.
• Program in multiple programming languages (SQL, VB.net, 3GL/4GL).
• Translate business needs into technical solutions with knowledge of Bl Tools (SQL, ETL, and OLAP).
• Implement and maintain operational and disaster-recovery procedures.
• Manage Metadata
• Conduct capacity planning
• Write or modify procedures for internal use, user operational areas, and computer operations, as applicable.
• Utilize ODBC and OLE DB methodology.

Business Intelligence / Database

• Educate users on data warehouse capabilities; gain consensus among users on common data definitions
• Understand business opportunities for information usage
• Schedule data updates and report generation
• Develop business intelligence and EIS applications
• Convert existing reporting applications to use the data warehouse and datamarts
• Develop periodic reporting systems
• Develop monitoring systems to ensure data has been updated as expected
• Implement data access tools
• Develop metadata management processes and/or systems

Project Management

• Develop programs, time estimates and project schedules based on prioritization and business requirements.
• Use sound project management methodology and demonstrate solid time management skills.
• Creates and delivers presentations.
• Monitor and create priority list(s) that are agreed to by user management

User Support

• Assist users with data requests and end-user support
• Create basic ad-hoc reports for internal usage and external usage

Performs job functions with general supervision

• Train data warehouse users
• Ensure the department leverages internal tools and applications effectively
• Build, support, and maintain moderately complex processes, programs, and data
• Participate or lead small to medium scoped projects
• Create moderately complex ad-hoc reports for internal usage and external usage
• Research and become proficient in two or more of areas as assigned:
• BI Project Management
• BI Production Reporting
• Application Architecture and Support
• Training
• Research and become proficient in one or more data marts

Requirements:

• Bachelor’s Degree in Computer Science, Information Systems, Business, or related field (Preferred)
• 2-5 years of experience as a BI Developer
• Strong SQL
• Power BI - ability to build out Power BI Dashboards
• Data Integration Experience
• Experience in Snowflake (nice to have)
• Ability to build out agents in Snowflake (nice to have)