Data Modeling SME

Lightfeather Io - Alexandria, VA

Full-time

Alexandria, VA

Professional, Scientific, and Technical Services

About the position

The Data Modeling SME role is designed for a highly skilled professional with expertise in various data modeling and analytics tools. This position focuses on developing and documenting data models that support predictive models and AI solutions, while also spearheading data migration strategies and establishing data governance frameworks. The ideal candidate will work primarily in a remote capacity but must be based in or near the D.C. Metro area, with occasional travel to the office.

Responsibilities

• Spearhead the analysis and strategy for migrating data warehouse systems to Oracle Cloud, establishing a robust Master Data Management (MDM) framework.
• Innovate reporting system designs from data warehouse outputs to actionable insights, supporting critical decision-making processes.
• Advocate for and implement data quality governance and standardization across enterprise systems.
• 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 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.
• Lead the design and modeling of data repositories in ServiceNow for enterprise reporting and analytics.
• 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.

Requirements

• Bachelor's or Master's degree in Computer Science, Data Science, Information Systems, or a related field.
• Proven experience as a Data Modeling SME or similar role with a focus on Databricks, Tableau, GA4, Looker, and PowerBI.
• Proficiency in Python for developing and implementing analytics solutions.
• Strong knowledge of SQL and experience with relational and non-relational database technologies.
• Advanced skills in PowerBI for developing analytics reports and dashboards.
• Experience with cloud platforms (AWS, Azure, Google Cloud) for deploying and managing AI solutions.
• Expertise in data modeling tools like Erwin or similar for designing, building, and documenting data models.
• Demonstrated experience in leading data migration projects, implementing data governance, and enhancing data quality across enterprise systems.
• Strong analytical and problem-solving skills with a keen attention to detail.
• Excellent communication and collaboration skills to work effectively with cross-functional teams.

Nice-to-haves

• Experience in developing AI-driven analytics solutions.
• Familiarity with additional data visualization tools.
• Certifications in cloud platforms (AWS, Azure, Google Cloud) or data modeling tools like Erwin.