BI Engineer

Job Title: BI Engineer

Job Location: San Jose, CA

Job Type: Contract

Job Overview:

Pay Range: $71.16hr - $74.90hr

Requirement/Must Have:

• 7 to 10 years of experience with database development using packages, stored procedures, and triggers in SQL and PL/SQL.
• 7 to 10 years of experience in dimensional modeling, including Star and Snowflake schema design and maintaining dimensions using Slowly Changing Dimensions (SCD).
• 7+ years of experience in SQL performance tuning and optimization techniques.
• Strong expertise in conceptual, logical, and physical data model design.
• Experience developing Business Intelligence solutions for business functions such as Finance, CRM, Sales, Sales Operations, and Marketing.
• Strong experience with end-to-end data validation and ensuring quality data delivery.
• Experience with project tracking tools such as Jira and GitHub.
• Ability to manage ad-hoc requests and work on simultaneous projects or tasks.
• Strong communication and teamwork skills.

Experience:

• 7 to 10 years of database development experience.
• Experience with SQL, PL/SQL, and/or T-SQL query development and stored procedures.
• Experience in data modeling and data validation.
• Experience with BI solution development and proof of concept activities.

Responsibilities:

• Participate in the development of Business Intelligence solutions to meet the needs of commercial organizations.
• Design and maintain conceptual, logical, and physical data models.
• Evaluate business requirements and conduct proof of concept activities.
• Proactively identify and communicate data anomalies within source systems.
• Perform end-to-end data validation to ensure quality data delivery.
• Develop and performance tune complex SQL, PL/SQL, and/or T-SQL queries and stored procedures.
• Use project tracking tools such as Jira and GitHub to manage work effectively.
• Support batch processes using scripting languages such as Perl, Unix shell, or Python.
• Create strategic designs and map business requirements to system and technical requirements.
• Communicate, translate, and simplify business requirements to ensure stakeholder alignment and buy-in.
• Manage multiple time-sensitive assignments in a fast-paced environment.

Should Have:

• Experience with source systems such as Salesforce (SOQL), NetSuite, or other CRM platforms.
• Experience with scripting languages such as Perl, Unix shell, or Python.

Skills:

• Business Intelligence.
• Data Modeling.
• Conceptual, Logical, and Physical Data Modeling.
• SQL.
• PL/SQL.
• T-SQL.
• Stored Procedures.
• Triggers.
• SQL Performance Tuning.
• Dimensional Modeling.
• Star Schema.
• Snowflake Schema.
• Slowly Changing Dimensions (SCD).
• Data Validation.
• Jira.
• GitHub.
• Salesforce (SOQL).
• NetSuite.
• Perl.
• Unix.
• Python.

Qualification and Education:

• Relevant degree in Computer Science, Information Systems, Data Engineering, or a related field preferred.