BI Data Modeler

BCforward is currently seeking a highly motivated "BI Data Modeler" for an opportunity in - Plano, TX 75024.

Position Title : BI Data Modeler

Location: Plano, TX 75024
Job Posting Expected Start Date: ASAP
(Please note this is the target date and is subject to change. BCforward will send official notice ahead of a confirmed start date.
Expected Duration: 12 Months
Job Type: 40 hours work week
Pay Rate: $65/hr to $70/hr

Position Summary

BI Data Modeler resource to design, develop, maintain and test software, collaborating with the development team and business partners to ensure successful delivery and implementation of application solutions in an agile environment. Should be hands on and able to successfully deliver on time without defects. Ability to analyze, design and support implementation of Oracle PL/SQL, Views, create/modify database tables based on business requirements and specifications

Required (hard) skills/experience
1. Tableau
2. Oracle SQL
3. Cognos

Preferred skills/experience
1. Good Written and communication skills
2. Agile Methodology
3. Performance tuning of reports and SQL

Responsibilities
* Tableau / Cognos
* Responsible to develop/modify PL/SQL, SQL Views in Oracle
* Responsible to create a new tables/modify existing table structure.
* Performance tuning and good understanding of explain plan
* Normalization, renormalization and star schema
* Develops stored procedures, database triggers and SQL queries
* Must be able to work independently with minimum supervision.
* Responsible to develop test cases and perform unit testing.
* Must be able to interact and co-ordinate with distributed team.
* Must be good in communication skills.
* Responsible to provide regular task status update to the management
* Tableau / COGNOS / Data warehousing
* Strong in Oracle version 11.x above
* Experience in Procedures, Functions, Packages, views, Materialized Views, Indexes, Triggers, Constraints, Snapshots, Synonyms, Sequences, Database Links, Bulk collect, Forall, ref cursor, partition tables, Analytical functions, collections, objects and writing complex queries
* Any version control tool (SVN/Bitbucket)
* Informatica, Autosys
* Unix Concepts
* Experience on SDM Adoption / Horizon onboarding tools (Bit Bucket, Datical, Jenkins)
* Agile best practices

Key Competencies:

Benefits:
BCforward offers all eligible employees a comprehensive benefits package including, but not limited to major medical, HSA, dental, vision, employer-provided group life, voluntary life insurance, short-term disability, long-term disability, and 401k.

About BCforward:
Founded in 1998 on the idea that industry leaders needed a professional service, and workforce management expert, to fuel the development and execution of core business and technology strategies, BCforward is a Black-owned firm providing unique solutions supporting value capture and digital product delivery needs for organizations around the world. Headquartered in Indianapolis, IN with an Offshore Development Center in Hyderabad, India, BCforward's 6,000 consultants support more than 225 clients globally.
BCforward champions the power of human potential to help companies transform, accelerate, and scale. Guided by our core values of People-Centric, Optimism, Excellence, Diversity, and Accountability, our professionals have helped our clients achieve their strategic goals for more than 25 years. Our strong culture and clear values have enabled BCforward to become a market leader and best in class place to work.
BCforward is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, or protected veteran status and will not be discriminated against based on disability.
To learn more about how BCforward collects and uses personal information as part of the recruiting process, view our Privacy Notice and CCPA Addendum. As part of the recruitment process, we may ask for you to disclose and provide us with various categories of personal information, including identifiers, professional information, commercial information, education information, and other related information. BCforward will only use this information to complete the recruitment process.
This posting is not an offer of employment. All applicants applying for positions in the United States must be legally authorized to work in the United States. The submission of intentionally false or fraudulent information in response to this posting may render the applicant ineligible for the position. Any subsequent offer of employment will be considered employment at-will regardless of the anticipated assignment duration.

Interested candidates please send resume in Word format Please reference job code 231135 when responding to this ad.