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