Job Description
Must Have Technical/Functional Skills
• Strong with data modeling concepts (star schemas, snowflake schemas, highly normalized data models).
• Data modeling tools – Erwin.
• Data Warehouse database platforms – Snowflake, BigQuery, Databricks.
• Knowledge and experience of at least one data profiling tool.
• Familiar with ETL tools like DataStage/Informatica.
• Experience with AWS services including S3, Lambda, Data-pipeline, and other data technologies
• Conceptual knowledge of BI tools like Business Objects/Tableau is a plus.
• Deep understanding of principles in data warehousing and cloud architecture with principles of SQL
optimization for building very efficient and scalable data systems.
• Excellent SQL programming skills.
• Excellent problem solving skills.
• Excellent communication skills with both business and technical customers.
• Demonstrate a high level of integrity and maturity.
• Work on multiple projects and deliver consistently on time.
• Escalate issues appropriately to management and project team.
• Take a proactive approach to cross-functional communication.
• Actively seek out feedback from management and peers, to improve own performance based on that feedback
Roles & 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
Generic Managerial Skills:
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. Shoul d 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.
Salary Range: $85,000-$120,000 a year
Description: For almost 100 years, Arnold Motor Supply has been a leading distributor and retailer of automotive replacement parts and accessories with 70 locations across the Midwest. We are recognized as a Top Workplace year after year because we keep it simple ...
...efficient examination, investigation and settlement or declination of insurance claims through effective research, negotiation and interaction... ...workers compensation claims by contacting injured workers, medical providers, and employer representatives. Determining if claims...
...equitable treatment for all. Trident United Way Participates in the Employers of National Service Network, alumni of AmeriCorps, SeniorCorps and PeaceCorps programs are encouraged to apply! Trident United Way is an Equal Opportunity Employer with an employee...
...Looking for a Staff Data Role where you will head up a major infrastructure migration... ...Ed-Tech firm is looking for a Staff Data Engineer to join their team and do just that.... ...business. Work arrangement - Fully remote position No sponsorship - GC or U.S citizens...
...Title: Medical Device Cleaning Associate Start Date : ASAP End Date : May 31st, 2025 (chance of extension) Hours: 3rd shift: 11pm-7:30am Location : Wilmington, DE Responsibilities: You will be responsible for cleaning, sterilizing, and maintaining...