Software Engineer 2
About The Position
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. Telecommuting within the State of Texas permitted. Residency in state of Texas required. 20% Domestic travel required.
Requirements
- Bachelor’s degree in Information Technology or related field
- 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
- Experience with data transformation using ETL tools and technologies
- Experience with related concepts such as data catalog
- Experience translating and mapping relational data models into Data Base Schemas
- Experience capturing technical metadata through data modeling tools
- Residency in the state of Texas required
Responsibilities
- Modeling and documenting data assets
- Implementing reporting and analytics
- Defining and managing critical data structures
- Gathering business requirements and translating them into logical data models
- Creating technical design specifications including data classifications
- Sourcing target mapping documentation for data integration and warehousing engineers
- Leading data discovery discussions with stakeholders in JAD sessions
- Mapping business requirements to logical and physical data modeling solutions
- Creating entity level data models from a business perspective
- Providing logical data models using a business perspective
- Translating logical data models for implementation in specific data base technologies
- Providing technical expertise in support of detailed database designs and design documentation production
- Planning and coordinating conversion and migration of existing or legacy databases
- Performing technical evaluation of existing models for legacy applications
- Creating new models in support of reusable and composable integration architecture
- Performing data analysis and data modeling for operational and analytical needs
- Developing entity relationships (ER models) for normalized and dimensional models
- Capturing technical metadata through data modeling tools
- Providing technical consulting for application teams for data naming, classification, design, and handling
- Collaborating with Data Architects for data model management, documentation, and version control
- Conducting data model reviews with other project team members
- Developing data catalog capabilities
- Facilitating data stewardship and data management best practices
- Working closely with data integration, warehousing, BI and other teams to develop appropriate data models
- Determining security procedures for system databases and central data stores
- Utilizing Tableau or other data visualization tools
- Utilizing BI tools such as Power BI
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
