Data Modeling Subject Matter Expert

Summary

Join our team as a highly skilled Data Modeling SME with expertise in Databricks, Tableau, GA4, Looker, and PowerBI. You will develop and document data models supporting predictive models and AI solutions, using tools like Erwin. This role involves leading data migration strategies, establishing data governance, and innovating reporting system designs. The position requires a strong background in data modeling and experience with various technologies. Primarily remote, the role requires U.S. citizenship and a current security clearance, with a location in or near the D.C. Metro area. You will collaborate with cross-functional teams and contribute to critical decision-making processes.

Requirements

• Possess a Bachelor’s or Master’s degree in Computer Science, Data Science, Information Systems, or a related field
• Have proven experience as a Data Modeling SME or similar role with a focus on Databricks, Tableau, GA4, Looker, and PowerBI
• Demonstrate proficiency in Python for developing and implementing analytics solutions
• Possess strong knowledge of SQL and experience with relational and non-relational database technologies
• Have advanced skills in PowerBI for developing analytics reports and dashboards
• Have experience with cloud platforms (AWS, Azure, Google Cloud) for deploying and managing AI solutions
• Possess expertise in data modeling tools like Erwin or similar for designing, building, and documenting data models
• Demonstrate experience in leading data migration projects, implementing data governance, and enhancing data quality across enterprise systems
• Possess strong analytical and problem-solving skills with a keen attention to detail
• Have excellent communication and collaboration skills to work effectively with cross-functional teams
• Be a U.S. Citizen with a current security clearance

Responsibilities

• Spearhead the analysis and strategy for migrating data warehouse systems to Oracle Cloud, establishing a robust Master Data Management (MDM) framework for enhanced data exchange and governance
• Innovate reporting system designs from data warehouse outputs to actionable insights, supporting critical decision-making processes across the enterprise
• Advocate for and implement data quality governance and standardization across enterprise systems, significantly enhancing data integrity and reliability
• Advise and support the development of core analytics data models, ensuring alignment with business objectives and technical requirements
• Develop, document, and maintain data models that support predictive models and AI solutions
• Utilize tools like Erwin or similar to deliver .DDL files and design logical and physical data models
• Collaborate with cross-functional teams to identify and implement analytical models and data platform architectures
• Deliver logical and physical architecture design solutions for analytics data, predictive models, and integrations
• Develop and execute architecture strategies for migrating to AWS data lakes and Data Warehouses, setting new benchmarks in data management and utilization
• Lead the design and modeling of data repositories in ServiceNow for enterprise reporting and analytics, enhancing data accessibility and insight generation
• Develop analytics solutions using Python, leveraging best practices in coding, testing, and deployment
• Create and manage advanced analytics reporting and dashboards using PowerBI
• Work with various database technologies to support and optimize data models
• Deploy and manage predictive models and AI solutions on cloud platforms such as AWS, Azure, or Google Cloud Platform
• Ensure data model integrity, performance, and scalability in a dynamic and fast-paced environment

Preferred Qualifications

• Have experience in developing AI-driven analytics solutions
• Be familiar with additional data visualization tools
• Possess certifications in cloud platforms (AWS, Azure, Google Cloud) or data modeling tools like Erwin

Benefits

• Primarily remote work
• Must be based in or near the D.C. Metro area, or able to commute/travel to the office at least once a week