Job Title - Sr. Data Modeler
Duration - Long Term
Work Mode- Onsite
Work Location- Dallas, Tx
Position Summary:
We are seeking a Sr. Data Modeler to support the many exciting data modeling initiatives for DFW projects, including Resilience Analytics, AOA, PIMS, X1FBO, SmartSuite (Skylink) and more to come.
PRINCIPAL DUTIES AND RESPONSIBILITIES (May perform any or all of the following):
- Design, develop, and maintain enterprise data warehouse architectures and data models, including Star Schemas, Snowflake Schemas, Slowly Changing Dimensions (SCD), and aggregation strategies to support enterprise analytics and reporting initiatives.
- Deploy, administer, and support enterprise Business Intelligence and analytics platforms including Tableau, Tableau Desktop, Tableau Cloud, Power BI, Dataiku, and other commercial data modeling and visualization tools.
- Lead and support architecture, development, and implementation of enterprise data warehousing and analytics solutions using Agile/Scrum methodologies and cloud-based technologies.
- Create, maintain, and support MicroStrategy and Tableau projects, Enterprise Data Warehouses, SQL scripts, and ETL routines to support enterprise Business Intelligence and reporting solutions.
- Participate in the conceptual planning and analysis of business, operational, and data initiatives by serving as a Business Intelligence and Analytic subject matter expert.
- Develop and maintain documentation for functional requirements, business system applications, and related planning, budgeting, and monitoring processes.
- Analyze, develop, and evaluate data within data lake and data warehouse environments, including data design, database architecture, metadata management, and repository development.
- Analyze and interpret statistical and enterprise datasets to identify trends, patterns, and relationships across multiple data sources to support business decision-making.
- Prepare, structure, and optimize data warehouses, data marts, and data lakes to serve as scalable analytical infrastructure for business users and enterprise data catalogs.
- Collaborate with System Administrators, Database Administrators, Business Analysts, and Quality Assurance teams to test, troubleshoot, optimize, and tune development solutions and data processes.
- Develop and optimize SQL and PL/SQL code, including stored procedures, triggers, Oracle functions, and partitioning strategies to support high-performance enterprise data solutions.
- Design and develop logical and physical data models for enterprise data marts, data lakes, and data warehouses to support scalable analytics, reporting, and business intelligence solutions.
Qualifications & Experience Required - Experience with Data Warehousing architectures, data modeling methodologies, and analytical design techniques including Star Schemas, Snowflake Schemas, Slowly Changing Dimensions (SCD), aggregation strategies, and logical/physical data modeling for data marts, data lakes, and enterprise data warehouses.
- Experience designing, developing, and maintaining enterprise data warehouse and business intelligence solutions, including SQL scripts, ETL routines, metadata management, repository creation, and analytical infrastructure for business users and data catalogs.
- Significant experience delivering enterprise data analytics, business intelligence, and cloud-based data warehouse solutions to production environments using Agile/Scrum methodologies.
- Experience with enterprise BI and analytics platforms including Tableau, Tableau Desktop, Tableau Cloud, Power BI, MicroStrategy, and Dataiku.
- Experience analyzing, interpreting, and evaluating complex statistical and enterprise datasets to identify trends, patterns, and relationships among multiple data sources.
- Experience with SQL, PL/SQL, stored procedures, triggers, Oracle functions, and database partitioning.
ABOUT ISHIR
ISHIR is a digital innovation and enterprise AI services provider. We work with startups and enterprises to shape the future through accelerated innovation, deep technical expertise, access to global digital talent and a passion for complex problem-solving. With our help, our clients overcome their most difficult digital challenges leveraging AI.
We are not just consultants, we are partners in our clients' success, assisting them with re(gaining) competitive edge by identifying opportunities for differentiation, industry disruption, scalable innovation, and go-to-market strategies that deliver successful outcomes.
At ISHIR, we help bold businesses accelerate innovation through Talent, Speed-to-Market, and AI. We help make an impact by solving real problems using innovation, improved customer experiences and the right technologies.
As an ISHIR employee, you will get the advanced training you need to be successful, and the opportunity to apply it. You must be passionate about technology, crave responsibility, and be eager to apply your knowledge to real business solutions for our startup and enterprise customers. These are the qualities of a person destined for success at ISHIR.
ISHIR attracts a special type of individual—someone who is proactive, thrives on challenges, feeds off success, and looks at moving targets not as obstacles but as opportunities. ISHIR is an exciting place to work. It is imbued with an entrepreneurial spirit and promotes self-reliance, open communication, and collaboration.