| BI Data Modeler at Culver City, California, USA |
| Email: [email protected] |
|
From: Pradeep, Scalable Systems [email protected] Reply to: [email protected] Hi, Greetings of the day I wanted to connect with you about an exciting role that aligns with your expertise and could be a fantastic start. Please find the job details below: Job Title: BI Data Modeler/ Architect Location: Culver City, CA (Work from Office) Duration: Long Term Contract Job description: The BI Data Modeler will collaborate with various stakeholders from Business and other partners to understand data requirements and business needs. Should be able to design solutions in the form of Conceptual and Logic data models to meet business needs. Should have an ability to optimize data models for performance, scalability and ease of use. Should have the ability to maintain accuracy, completeness and consistency of the data models with up-to-date documentation and metadata. Should be an expert in various BI tools, capture analytical and reporting requirements from the Business, analyze various data sources and provides BI solutions that helps to facilitate reporting and dashboarding. Should have extensive expertise on data profiling using data profile tools and modeling tools like Erwin. Should be able to build data models by reverse engineering the database structures. Should have experience in analyzing and handling unstructured data sources. Should have an ability to communicate complex data concepts to non-technical stakeholders. Design solutions based on the data lake concepts, use of data by consumers and provide solutions weighing in pros and cons of cons ETL Vs ELT approach. Ideal candidate is a hands-on type problem solver who will work directly with the data engineering and business data management teams to help profile, catalog and design views and conceptual data model, catalog data sources and define data quality rules based on business use cases. Responsibilities: Interacting with Business Users/ Business Relationship Managers to understand the BI and analytical needs Identify the right data sources / data completeness to meet the BI needs. Data profiling to build the entity relationships across multiple sources. Develop and maintain data dictionary for all the data sources (existing and new ones). Build conceptual and logical data models considering the BI needs. Develop optimized database design to achieve acceptable performance by tuning views, tables for proper response time. Work with database administrators to implement data models into database platforms, ensuring data integrity and consistency. Monitor database performance, identify bottlenecks, and optimize data models to improve query efficiency and data access speed. Work closely with the IT teams in ETL design discussions adopting best practices of data load strategy. Identify effective reporting techniques, identify the best data sources for each report, identify risks and constraints, and design reporting formats. Create and maintain metadata describing the data model, including data lineage and definitions. Data analyst skills to determine root cause problems for data integrity and data quality issues identified through QA or by business report owners. Define data storage strategy Thanks & Regards, Pradeep Sharma Email: [email protected] "Scalable Systems is an Equal Opportunity Employer. We are committed to creating an inclusive environment for all employees and do not discriminate based on race, color, religion, sex, national origin, age, disability, or any other legally protected status." Keywords: quality analyst business intelligence information technology California BI Data Modeler [email protected] |
| [email protected] View All |
| 05:07 PM 07-Mar-25 |