Data Modeler

Karsun Solutions, LLC
Herndon, VA
Jan 27, 2022
Jan 29, 2022
Accountant, IT
Full Time
Overview: The Data Modeler is responsible for working with clients and team leads to understand business requirements, and support the application and data teams to document data sources, understand data domains, map the data sources to appropriate data domains and work with teams to create logical and physical data models. The role is responsible for creating and maintaining all required documentation for data mappings, lineage, systems of record and data designs. The role requires collaborative work with multiple teams, data analysts, business SMEs and Data Engineers to establish, promote and govern best practices for data modeling and data model maintenance. Expertise in data modeling tools such as ERWin or Redgate with experience in transactional data models, is essential.All employees must be able to pass a Federal Suitability Check for a position of public trust. Responsibilities: What You Will Do:The successful candidate will be able to rapidly develop logical domain data models and logical and physical subject area and application data models working closely with the integrated product teams, data engineers and developers with minimal direction and substantial self-initiativeUnderstand each applications data needs, mapping them to the subject area and provide clarity on system of record level ownership of data elementsBe able to establish and demonstrate best practices for data modeling and work with data engineers to ensure appropriate implementation rigor is maintained for model integrityLead the metadata catalog efforts and work with SMEs to enrich business and technical metadata definitions on an ongoing basis, utilizing appropriate services and tools are will be part of the technical landscapeCreate and maintain data standards and best practices for complex data models & design and data pipelinesFamiliarity with ORMs such as sequelize and database version control tools like Flyway is advantageousThe candidate must have a successful track record in identifying, applying and maintaining standards and backward database compatibility in medium to high complexity data models, in a data and application modernization scenarios. The candidate will be expected to support a variety of structured and semi-structured data sources and targets. The candidate must possess working knowledge of AWS, specifically for the RDS and DMS services. Troubleshoot, monitor and coordinate defect resolution related to data models & data pipelines; Responsible for the creation and support of all data models, data standards and their implementation within the current scope of the system. Qualifications and Education: What You Bring to Karsun:5+ years of hands-on experience in data modeling for transactional systems with SQL Server and MySQL technologies using tools like ERWin and Redgate suite of data tools4+ year of experience and ability to create complex SQL queries and functions2+ years of hands-on experience in data profiling and benchmarking data quality1+ year of experience in java and linux scripting is essential1+ year experience working with CI/CD tools including Git for data models, ETL and scripts repositoryBachelor's degree in Computer Science or related disciplineDesired Skills:Experience of working in AWS environments and with AWS RDS is highly desirableExperience working with SQL Server and tools like SSRS is advantageousExperience with Streamsets Data Collector is adantageousExperience in Ansible and Jenkins scripting is an advantageWhat Karsun Offers YouA career, more than just a jobPlay a key role in the success and growth of KarsunDo extraordinary and receive extraordinaryWork alongside seriously talented colleagues and who enjoy challenging each otherWork with integrity, honesty and fairness for customers and colleaguesExcellent Benefits from PTO, Medical Benefits, 401K Match, Health and Wellness Programs, Company Events and an overall Collegial Environment, and much moreAbout KarsunAt Karsun, we are committed to providing an environment of mutual respect where equal employment opportunities are available to all applicants and teammates without regard to race, color, religion, sex, pregnancy (including childbirth, lactation and related medical conditions), national origin, age, physical and mental disability, marital status, sexual orientation, gender identity, gender expression, genetic information (including characteristics and testing), military and veteran status, and any other characteristic protected by applicable law. Karsun believes that diversity and inclusion among our teammates is critical to our success, and we seek to recruit, develop and retain the most talented people from a diverse candidate pool.TheVirginia Chamber of Commerce,Washington Business JournalandInc.all recognize Karsun Solutions among the fastest-growing companies in the Washington, DC region. Its teams deliver modern software development, cloud solutions, and data and analytics solutions to customers at government agencies including the Department of Homeland Security, Federal Aviation Administration, and General Services Administration. It possesses a DCAA Approved Accounting System, CMMI Level 5 DEV appraisal, and AWS Government Competency.

Similar jobs