Software Engineer 2

Residency in the state of Texas required. Responsible for modeling and documenting data assets, and implementing reporting and analytics. Responsible for defining and managing critical data structures for current and future needs. Gather business requirements and translate those requirements into logical data models. Create technical design specifications including data classifications. Source target mapping documentation for data integration and warehousing engineers. Lead data discovery discussions with stakeholders in JAD sessions and map the business requirements to logical and physical data modeling solutions. Create entity level data models from a business perspective for a particular scope. Provide logical data models for particular scopes using a business perspective. Translate logical data models for implementation in specific data base technologies. Provide technical expertise in support of detailed database designs and design documentation production, including data models and data flow diagrams. Plan and coordinate conversion and migration of existing or legacy databases to support the availability, usability, integrity, and security of data. Perform technical evaluation of existing models for legacy applications and create new models in support of reusable and composable integration architecture. Perform data analysis and data modeling for operational and analytical needs. Develop entity relationships (ER models) for normalized and dimensional models. Capture technical metadata through data modeling tools. Provide technical consulting for application teams for data naming, classification, design, and handling as a part of the first line of defense for data controls in designing systems. Collaborate with Data Architects for data model management, documentation, and version control. Conduct data model reviews with other project team members such as Solution Architects, Data Architects, and Integration Engineers. Develop data catalog capabilities and facilitates data stewardship and data management best practices. Work closely with the data integration, warehousing, BI and other teams to develop appropriate data models. Determine security procedures for system databases and central data stores to maintain the viability of and access to data based on organizational needs. Utilize Tableau or other data visualization tools in addition to BI tools such as Power BI.

Do you have experience in Software documentation?, Do you have a Bachelor’s degree?, Bachelor’s degree in Information Technology or related field plus 4 years of experience in data modeling supporting data solutions, integrations and design documentation production; data modeling experience in finance, commercial supply chains, sales and customer analytics; data transformation using ETL tools and technologies, and related concepts such as data catalog; translating and mapping relational data models into Data Base Schemas; and capturing technical metadata through data modeling tools required. Telecommuting within the State of Texas permitted. Residency in state of Texas required. 20% Domestic travel required.

HOLT Group is a renowned, family-owned company with a legacy spanning nearly a century. As a powerhouse across several industries, including heavy machinery, construction, consulting services, training, and technology, we prioritize people and values. Our commitment to a Values-Based Leadership® approach has led to trusted partnerships and collaborative endeavors. At the heart of our operations is HOLT CAT, the largest Caterpillar dealership in the nation, along with other companies focused on industrial & commercial selling, energy, technology, and training & development. We excel in selling, servicing, leasing, and renting top-of-the-line industrial machinery and are dedicated to powering the construction and industrial spaces with superior equipment. Moreover, we empower construction and development with advanced technology, along with bringing technical skills and Values-Based Leadership® to individuals and companies seeking sustainable growth. If you’re seeking a fulfilling career, explore our job opportunities at HOLT Group and join our values-driven team.