Business Intelligence Developer (BI)

Business Intelligence Developer (BI)

16 Dec 2024
California, Southgate, 90280 Southgate USA

Business Intelligence Developer (BI)

Vacancy expired!

Title:

Sr. BI Developer
Location: South Gate, CA (90280 zip code)
Salary: up to $135k + full benefits.
Hours: 8-5PM (full-time shift)
Full benefits (medical, vacation, PTO, 401k)
Remote for covid but after covid settles down they will need to be on-site full-time.

Essential Duties and Responsibilities:
  • Coordinate with Business Analysts and internal customers to develop business requirements and specifications documents.
  • Develop standard reports and functional dashboards based on business requirements.
  • Maintains business intelligence models to design, develop and generate both standard and ad-hoc reports.
  • Create technical documents that documents SQL Server, Oracle and DB2 or other database contents, concepts, and mapping between databases.
  • Participate in the design, development and analysis of data architecture and warehousing approaches.
  • Create business intelligence tools and reports, such as physical data models and dimensional analyses.
  • Design, code, test, and aggregate results from SQL queries to provide information to users.
  • Identify and resolve data reporting issues in a timely fashion
  • Build Data Modeling BI and Data Warehousing solutions
  • Create and support database schemas that offer the highest standard of performance and availability.
  • Assist in implementing effective business analytics practices that drive improved decision making, efficiency and performance.
  • Develop and implement databases, data marts/analytics and other strategies that optimize efficiency and data quality
  • Configure and maintain database integrity, security and optimized performance at the application and database levels.

Qualifications:
  • 10+ years of experience developing and implementing enterprise-scale reports and dashboards.
    • Working with Project Managers and users in a requirements analysis role
    • Experience with data warehouse implementations
    • Knowledge of logical and physical data modeling concepts (relational and dimensional)
  • Microsoft SQL Server, Integration Services (SSIS), and Reporting Services (SSRS) as well as System Analysis Services (SSAS)
  • Strong T-SQL scripting abilities and understanding of complex stored procedures, views, data aggregation and manipulation through table joins and queries, database design, normalization and de-normalization techniques, database analytical functions, In-Line queries, and Sub-Queries.
  • Demonstrated experience in data extraction and manipulation, ETL techniques required using Visual Studio 2013 and above
  • Proficiency with Crystal reports any version.
  • Knowledge of SQL and data warehousing concepts.
  • Strong knowledge of TSQL, PL/SQL for SQL Server and Oracle
  • Performance tuning experience
  • Understanding of data integration issues (validating and cleaning) familiar with complex data structures.
  • Requires strong analytical, conceptual and problem solving abilities
  • Possesses strong oral and written communications skills, clearly and accurately communicating complex and or technical information to both technical and non-technical audiences
  • Ability to manage multiple priorities, and assess and adjust quickly to changing priorities
  • Ability to work in a team environment

Additional Preferred Skills and Experience:
  • Knowledge of Warehouse Management Systems
  • Knowledge of Transportation Management Systems
  • Knowledge of DB2 10.x development
  • Knowledge and use of Team Foundation Server (TFS)

Education Required:
  • BA/BS in Computer Science or related field is preferable. Equivalent combination of experience, education and training will be considered.
  • DBA/Database BI certifications desirable, preferably related to Microsoft Platform and Oracle

if you are interested, Please send me resume at Sivaprasad.meesala AT Rencata . com

Job Details

  • ID
    JC7023642
  • State
  • City
  • Job type
    Permanent
  • Salary
    $100,000 - $130,000
  • Hiring Company
    Rencata
  • Date
    2020-12-15
  • Deadline
    2021-02-13
  • Category

Jocancy Online Job Portal by jobSearchi.