What are the responsibilities and job description for the BI Engineer position at Jobs via Dice?
Dice is the leading career destination for tech experts at every stage of their careers. Our client, Cynet Systems, is seeking the following. Apply via Dice today!
We are looking for a BI Engineer for our client in San Jose, CA
Job Title: BI Engineer
Job Location: San Jose, CA
Job Type: Contract
Job Overview:
Pay Range: $71.16hr - $74.90hr
Requirement/Must Have:
We are looking for a BI Engineer for our client in San Jose, CA
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.
- 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.
- 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.
- Experience with source systems such as Salesforce (SOQL), NetSuite, or other CRM platforms.
- Experience with scripting languages such as Perl, Unix shell, or Python.
- 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.
- Relevant degree in Computer Science, Information Systems, Data Engineering, or a related field preferred.
Salary : $71 - $75